|
Package tb_statement_rules Support subprograms for STATEMENT. |
| Program units |
| p_register_entity | Register the attribute value pairs to the message cache for delete operations. |
| p_register_entity | Register the attribute/value pairs to the message cache for create and update operations. |
| p_validate | Validates all the data in the record. |
p_register_entity
Procedure p_register_entity(p_operation_type NUMBER,
p_internal_record_id gb_common.internal_record_id_type)
Register the attribute value pairs to the message cache for delete operations.
This signature uses the ROWID only, for the delete operations.
| Parameters |
| p_operation_type |
Type of DML operation: create,update,delete. NUMBER Required | |
| p_internal_record_id |
Database ROWID VARCHAR2(18) required |
p_register_entity
Procedure p_register_entity(p_operation_type NUMBER,
p_stmt_number tbbstmt.tbbstmt_stmt_number%TYPE,
p_pidm tbbstmt.tbbstmt_pidm%TYPE,
p_bill_date tbbstmt.tbbstmt_bill_date%TYPE,
p_bill_run tbbstmt.tbbstmt_bill_run%TYPE,
p_user_id tbbstmt.tbbstmt_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_data_origin tbbstmt.tbbstmt_data_origin%TYPE,
p_type tbbstmt.tbbstmt_type%TYPE,
p_sort tbbstmt.tbbstmt_sort%TYPE,
p_term_code tbbstmt.tbbstmt_term_code%TYPE,
p_due_date tbbstmt.tbbstmt_due_date%TYPE,
p_atyp_code tbbstmt.tbbstmt_atyp_code%TYPE,
p_atyp_seqno tbbstmt.tbbstmt_atyp_seqno%TYPE,
p_sort_zip tbbstmt.tbbstmt_sort_zip%TYPE,
p_sort_id tbbstmt.tbbstmt_sort_id%TYPE,
p_sort_name tbbstmt.tbbstmt_sort_name%TYPE,
p_sort_campus tbbstmt.tbbstmt_sort_campus%TYPE,
p_email_addr tbbstmt.tbbstmt_email_addr%TYPE,
p_balance tbbstmt.tbbstmt_balance%TYPE,
p_past_due tbbstmt.tbbstmt_past_due%TYPE,
p_amount_due tbbstmt.tbbstmt_amount_due%TYPE,
p_minimum_due tbbstmt.tbbstmt_minimum_due%TYPE,
p_media_id tbbstmt.tbbstmt_media_id%TYPE,
p_internal_record_id gb_common.internal_record_id_type)
Register the attribute/value pairs to the message cache for create and update operations.
This signature registers all parameters.
| Parameters |
| p_operation_type |
Type of DML operation: create,update,delete. NUMBER Required | |
| p_stmt_number |
Unique generated document number for the statement. NUMBER(38) Required Key | |
| p_pidm |
Internal Identification Number of the person or non-person account, valid in SPRIDEN. NUMBER(8) Required | |
| p_bill_date |
Date of the bill as specified by the parameter. DATE Required | |
| p_bill_run |
Run Number for bill as submitted via job submission. NUMBER Required | |
| p_user_id |
Oracle ID of the user who created or last updated the data. VARCHAR2(30) Required | |
| p_data_origin |
Source system that last created or updated the data. VARCHAR2(30) | |
| p_type |
Type of statement requested, ST = student statement, SB = schedule bill. VARCHAR2(2) | |
| p_sort |
Sort variable for printing, 00 - no address, 01- valid address. VARCHAR2(2) | |
| p_term_code |
Term for which the statement is produced, when processing schedule bill. Valid in STVTERM. VARCHAR2(6) | |
| p_due_date |
Due Date by which payment is requested. DATE | |
| p_atyp_code |
In combination with ATYP_SEQNO, the address where the statement will be sent. VARCHAR2(2) | |
| p_atyp_seqno |
In combination with ATYP_CODE, the address where the statement will be sent. Combination valid and active in SPRADDR. NUMBER(2) | |
| p_sort_zip |
Zip Code to which statement will be sent for sort by zip code. VARCHAR2(10) | |
| p_sort_id |
Identification Number of the entity receiving the bill for sort by Id. VARCHAR2(9) | |
| p_sort_name |
Name of the entity receiving the bill for sort by name. VARCHAR2(75) | |
| p_sort_campus |
The campus location associated with the student for the term, populated if sorting schedule bill. VARCHAR2(3) | |
| p_email_addr |
EMail address for the recipient of the bill. VARCHAR2(90) | |
| p_balance |
Balance of the account at the time of billing. NUMBER(14,2) | |
| p_past_due |
Amount Past Due at the time of billing. NUMBER(14,2) | |
| p_amount_due |
Amount currently due in response to billing. NUMBER(14,2) | |
| p_minimum_due |
Minimum payment due in response to billing if dynamic automated installment plan calculated. NUMBER(14,2) | |
| p_media_id |
Reference to Media Id of the centralized storage for binary large objects table (GORBLOB). NUMBER(38) | |
| p_internal_record_id |
Database ROWID VARCHAR2(18) required |
p_validate
Procedure p_validate(p_stmt_number tbbstmt.tbbstmt_stmt_number%TYPE,
p_pidm tbbstmt.tbbstmt_pidm%TYPE,
p_bill_date tbbstmt.tbbstmt_bill_date%TYPE,
p_bill_run tbbstmt.tbbstmt_bill_run%TYPE,
p_user_id tbbstmt.tbbstmt_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_data_origin tbbstmt.tbbstmt_data_origin%TYPE DEFAULT NULL,
p_type tbbstmt.tbbstmt_type%TYPE DEFAULT NULL,
p_sort tbbstmt.tbbstmt_sort%TYPE DEFAULT NULL,
p_term_code tbbstmt.tbbstmt_term_code%TYPE DEFAULT NULL,
p_due_date tbbstmt.tbbstmt_due_date%TYPE DEFAULT NULL,
p_atyp_code tbbstmt.tbbstmt_atyp_code%TYPE DEFAULT NULL,
p_atyp_seqno tbbstmt.tbbstmt_atyp_seqno%TYPE DEFAULT NULL,
p_sort_zip tbbstmt.tbbstmt_sort_zip%TYPE DEFAULT NULL,
p_sort_id tbbstmt.tbbstmt_sort_id%TYPE DEFAULT NULL,
p_sort_name tbbstmt.tbbstmt_sort_name%TYPE DEFAULT NULL,
p_sort_campus tbbstmt.tbbstmt_sort_campus%TYPE DEFAULT NULL,
p_email_addr tbbstmt.tbbstmt_email_addr%TYPE DEFAULT NULL,
p_balance tbbstmt.tbbstmt_balance%TYPE DEFAULT NULL,
p_past_due tbbstmt.tbbstmt_past_due%TYPE DEFAULT NULL,
p_amount_due tbbstmt.tbbstmt_amount_due%TYPE DEFAULT NULL,
p_minimum_due tbbstmt.tbbstmt_minimum_due%TYPE DEFAULT NULL,
p_media_id tbbstmt.tbbstmt_media_id%TYPE DEFAULT NULL)
Validates all the data in the record.
| Parameters |
| p_stmt_number |
Unique generated document number for the statement. NUMBER(38) Required Key | |
| p_pidm |
Internal Identification Number of the person or non-person account, valid in SPRIDEN. NUMBER(8) Required | |
| p_bill_date |
Date of the bill as specified by the parameter. DATE Required | |
| p_bill_run |
Run Number for bill as submitted via job submission. NUMBER Required | |
| p_user_id |
Oracle ID of the user who created or last updated the data. VARCHAR2(30) Required | |
| p_data_origin |
Source system that last created or updated the data. VARCHAR2(30) | |
| p_type |
Type of statement requested, ST = student statement, SB = schedule bill. VARCHAR2(2) | |
| p_sort |
Sort variable for printing, 00 - no address, 01- valid address. VARCHAR2(2) | |
| p_term_code |
Term for which the statement is produced, when processing schedule bill. Valid in STVTERM. VARCHAR2(6) | |
| p_due_date |
Due Date by which payment is requested. DATE | |
| p_atyp_code |
In combination with ATYP_SEQNO, the address where the statement will be sent. VARCHAR2(2) | |
| p_atyp_seqno |
In combination with ATYP_CODE, the address where the statement will be sent. Combination valid and active in SPRADDR. NUMBER(2) | |
| p_sort_zip |
Zip Code to which statement will be sent for sort by zip code. VARCHAR2(10) | |
| p_sort_id |
Identification Number of the entity receiving the bill for sort by Id. VARCHAR2(9) | |
| p_sort_name |
Name of the entity receiving the bill for sort by name. VARCHAR2(75) | |
| p_sort_campus |
The campus location associated with the student for the term, populated if sorting schedule bill. VARCHAR2(3) | |
| p_email_addr |
EMail address for the recipient of the bill. VARCHAR2(90) | |
| p_balance |
Balance of the account at the time of billing. NUMBER(14,2) | |
| p_past_due |
Amount Past Due at the time of billing. NUMBER(14,2) | |
| p_amount_due |
Amount currently due in response to billing. NUMBER(14,2) | |
| p_minimum_due |
Minimum payment due in response to billing if dynamic automated installment plan calculated. NUMBER(14,2) | |
| p_media_id |
Reference to Media Id of the centralized storage for binary large objects table (GORBLOB). NUMBER(38) |