TheBigApp


Package CUSTOMER_DATA

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


Type Summary
 TABLE OF customer_type INDEX BY BINARY_INTEGERcustomer_table()
           Table of customer records.
 RECORDcustomer_type(id VARCHAR2(20), name VARCHAR2(100), regno VARCHAR2(50), language VARCHAR2(10))
           Record of customer data.

Method Summary
 create_customer(customer_rec customer_type)
           Creates a customer record.
 get_by_criteria(p_criteria customer_type, r_records customer_table)
           Searches customer by criteria.
 get_customer(p_id VARCHAR2, customer_rec customer_type)
           Gets customer by ID.
 update_customer(customer_rec customer_type)
           Changes customer data.

Type Detail

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.

Method Detail

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

TheBigApp