Package CUSTOMER_DATA

Project: Test Project (PLDoc)
Description: Customer Data Management
DB impact: YES
Commit inside: NO
Rollback inside: NO

customer_type

  public RECORD customer_type(id VARCHAR2(20), 
                              name VARCHAR2(100), 
                              regno VARCHAR2(50), 
                              language VARCHAR2(10))

Record of customer data.

Parameters:

id - customer ID

name - customer name

regno - registration number or SSN

language - preferred language

customer_table

  public TABLE OF customer_type INDEX BY BINARY_INTEGER customer_table()

Table of customer records.

get_customer

  public  get_customer(p_id VARCHAR2, 
                       customer_rec customer_type)

Gets customer by ID.

Parameters:

p_id - customer ID

Throws:

no_data_found - if no such customer exists

get_by_criteria

  public  get_by_criteria(p_criteria customer_type, 
                          r_records customer_table)

Searches customer by criteria.

Parameters:

p_criteria - record with assigned search criteria

r_records - table of found customers (may be empty!)

create_customer

  public  create_customer(customer_rec customer_type)

Creates a customer record.

Parameters:

customer_rec - record of customer data

update_customer

  public  update_customer(customer_rec customer_type)

Changes customer data.

Parameters:

customer_rec - record of updated customer data