|
Package tb_misc_header_rules Support subprograms for MISC_HEADER. |
| Program units |
| p_register_entity | Register the attribute/value pairs to the message cache. |
| p_validate | Validates all the data in the record. |
p_register_entity
Procedure p_register_entity(p_operation_type NUMBER,
p_receipt_number tbbmisc.tbbmisc_receipt_number%TYPE,
p_user tbbmisc.tbbmisc_user%TYPE,
p_name tbbmisc.tbbmisc_name%TYPE,
p_house_number tbbmisc.tbbmisc_house_number%TYPE,
p_street_line1 tbbmisc.tbbmisc_street_line1%TYPE,
p_street_line2 tbbmisc.tbbmisc_street_line2%TYPE,
p_street_line3 tbbmisc.tbbmisc_street_line3%TYPE,
p_street_line4 tbbmisc.tbbmisc_street_line4%TYPE,
p_city tbbmisc.tbbmisc_city%TYPE,
p_stat_code tbbmisc.tbbmisc_stat_code%TYPE,
p_zip tbbmisc.tbbmisc_zip%TYPE,
p_natn_code tbbmisc.tbbmisc_natn_code%TYPE,
p_data_origin tbbmisc.tbbmisc_data_origin%TYPE,
p_create_source tbbmisc.tbbmisc_create_source%TYPE,
p_document_number tbbmisc.tbbmisc_document_number%TYPE,
p_internal_record_id VARCHAR2)
Register the attribute/value pairs to the message cache.
This signature registers all parameters.
| Parameters |
| p_receipt_number |
Receipt number assigned to the miscellaneous transaction. NUMBER(8) Required Key | |
| p_user |
User ID of the cashier who created the miscellaneous transaction. VARCHAR2(30) Required | |
| p_name |
Free-form name of the person or office presenting revenue for processing as a miscellaneous transaction. VARCHAR2(30) | |
| p_house_number |
House Number of the street address for the receipt of the miscellaneous transaction. VARCHAR2(10) | |
| p_street_line1 |
First line of the street address for the receipt of the miscellaneous transaction. VARCHAR2(75) | |
| p_street_line2 |
Second line of the street address for the receipt of the miscellaneous transaction. VARCHAR2(75) | |
| p_street_line3 |
Third line of the street address for the receipt of the miscellaneous transaction. VARCHAR2(75) | |
| p_street_line4 |
Fourth line of the street address for the receipt of the miscellaneous transaction. VARCHAR2(75) | |
| p_city |
City of the address for the receipt of the miscellaneous transaction. VARCHAR2(50) | |
| p_stat_code |
State or Province of the address for the receipt of the miscellaneous transaction, valid in STVSTAT. VARCHAR2(3) | |
| p_zip |
Zip or Postal code of the address for the receipt of the miscellaneous transaction. VARCHAR2(30) | |
| p_natn_code |
Nation/country of the address for the receipt of the miscellaneous transaction, valid in STVNATN. VARCHAR2(5) | |
| p_data_origin |
Source system that last created or updated the data. VARCHAR2(30) | |
| p_create_source |
Source system that initially created the record. VARCHAR2(30) | |
| p_document_number |
Document number that references a source document for the miscellaneous transaction. VARCHAR2(8) | |
| p_internal_record_id |
Database rowid. VARCHAR2(18) |
p_validate
Procedure p_validate(p_receipt_number tbbmisc.tbbmisc_receipt_number%TYPE,
p_user tbbmisc.tbbmisc_user%TYPE,
p_name tbbmisc.tbbmisc_name%TYPE DEFAULT NULL,
p_house_number tbbmisc.tbbmisc_house_number%TYPE DEFAULT NULL,
p_street_line1 tbbmisc.tbbmisc_street_line1%TYPE DEFAULT NULL,
p_street_line2 tbbmisc.tbbmisc_street_line2%TYPE DEFAULT NULL,
p_street_line3 tbbmisc.tbbmisc_street_line3%TYPE DEFAULT NULL,
p_street_line4 tbbmisc.tbbmisc_street_line4%TYPE DEFAULT NULL,
p_city tbbmisc.tbbmisc_city%TYPE DEFAULT NULL,
p_stat_code tbbmisc.tbbmisc_stat_code%TYPE DEFAULT NULL,
p_zip tbbmisc.tbbmisc_zip%TYPE DEFAULT NULL,
p_natn_code tbbmisc.tbbmisc_natn_code%TYPE DEFAULT NULL,
p_data_origin tbbmisc.tbbmisc_data_origin%TYPE DEFAULT NULL,
p_create_source tbbmisc.tbbmisc_create_source%TYPE DEFAULT NULL,
p_document_number tbbmisc.tbbmisc_document_number%TYPE DEFAULT NULL)
Validates all the data in the record.
| Parameters |
| p_receipt_number |
Receipt number assigned to the miscellaneous transaction. NUMBER(8) Required Key | |
| p_user |
User ID of the cashier who created the miscellaneous transaction. VARCHAR2(30) Required | |
| p_name |
Free-Form name of the person or office presenting revenue for processing as a miscellaneous transaction. VARCHAR2(30) | |
| p_house_number |
House Number of the street address for the receipt of the miscellaneous transaction. VARCHAR2(10) | |
| p_street_line1 |
First line of the street address for the receipt of the miscellaneous transaction. VARCHAR2(75) | |
| p_street_line2 |
Second line of the street address for the receipt of the miscellaneous transaction. VARCHAR2(75) | |
| p_street_line3 |
Third line of the street address for the receipt of the miscellaneous transaction. VARCHAR2(75) | |
| p_street_line4 |
Fourth line of the street address for the receipt of the miscellaneous transaction. VARCHAR2(75) | |
| p_city |
City of the address for the receipt of the miscellaneous transaction. VARCHAR2(50) | |
| p_stat_code |
State of the address for the receipt of the miscellaneous transaction, valid in STVSTAT. VARCHAR2(3) | |
| p_zip |
Zip code of the address for the receipt of the miscellaneous transaction. VARCHAR2(30) | |
| p_natn_code |
Nation/Country of the address for the receipt of the miscellaneous transaction, valid in STVNATN. VARCHAR2(5) | |
| p_data_origin |
Source system that last created or updated the data. VARCHAR2(30) | |
| p_create_source |
Source system that initially created the record. VARCHAR2(30) | |
| p_document_number |
Document number that references a source document for the miscellaneous transaction. VARCHAR2(8) |