|
Package tb_term_control_ar_rules Support subprograms for TERM_CONTROL_AR. |
| 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_term_code tbbterm.tbbterm_term_code%TYPE,
p_detail_web_disp_ind tbbterm.tbbterm_detail_web_disp_ind%TYPE,
p_web_eff_date tbbterm.tbbterm_web_eff_date%TYPE,
p_sum_detc_ind tbbterm.tbbterm_sum_detc_ind%TYPE,
p_aid_auth_disp_ind tbbterm.tbbterm_aid_auth_disp_ind%TYPE,
p_aid_memo_disp_ind tbbterm.tbbterm_aid_memo_disp_ind%TYPE,
p_oth_memo_disp_ind tbbterm.tbbterm_oth_memo_disp_ind%TYPE,
p_pay_btn_ind tbbterm.tbbterm_pay_btn_ind%TYPE,
p_accd_due_cde tbbterm.tbbterm_accd_due_cde%TYPE,
p_auth_due_cde tbbterm.tbbterm_auth_due_cde%TYPE,
p_memo_due_cde tbbterm.tbbterm_memo_due_cde%TYPE,
p_aid_calc_ind tbbterm.tbbterm_aid_calc_ind%TYPE,
p_data_origin tbbterm.tbbterm_data_origin%TYPE,
p_user_id tbbterm.tbbterm_user_id%TYPE DEFAULT gb_common.f_sct_user,
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_term_code |
Unique term code that identifies the base term record. VARCHAR2(6) Required Key | |
| p_detail_web_disp_ind |
Display of self-service Account Detail for Term is enabled for this term (Y/N). VARCHAR2(1) Required | |
| p_web_eff_date |
Effective date for calculation of Current Due and memo Release of deposits. DATE | |
| p_sum_detc_ind |
Account detail is summarized by detail code (Y/N). VARCHAR2(1) Required | |
| p_aid_auth_disp_ind |
Authorized Aid is displayed for this term (Y/N). VARCHAR2(1) Required | |
| p_aid_memo_disp_ind |
Financial Aid memos are displayed for this term (Y/N). VARCHAR2(1) Required | |
| p_oth_memo_disp_ind |
Other memos are displayed for this term (Y/N). VARCHAR2(1) Required | |
| p_pay_btn_ind |
Display Pay Now buttons.(Y/N/). VARCHAR2(1) Required | |
| p_accd_due_cde |
Calculations in Account Detail section - values (A)ccount Balance only or (B)oth Balance and Current Amount Due. VARCHAR2(1) Required | |
| p_auth_due_cde |
Calculations in Authorized Aid section - values (N)o adjusted totals, (A)djusted Account Balance only, or (B)oth adjusted Balance and Current Amount Due. VARCHAR2(1) Required | |
| p_memo_due_cde |
Calculations in Memo section - values (N)o adjusted totals, or (A)djusted Account Balance only, or (B)oth adjusted Balance and Current Amount Due. VARCHAR2(1) Required | |
| p_aid_calc_ind |
Reserved for future use (Y/N). VARCHAR2(1) Required | |
| p_data_origin |
Source system that last created or updated the data. VARCHAR2(30) | |
| p_user_id |
User who created or last updated the record. VARCHAR2(30) Required | |
| p_internal_record_id |
Database ROWID VARCHAR2(18) required |
p_validate
Procedure p_validate(p_term_code tbbterm.tbbterm_term_code%TYPE,
p_detail_web_disp_ind tbbterm.tbbterm_detail_web_disp_ind%TYPE,
p_web_eff_date tbbterm.tbbterm_web_eff_date%TYPE DEFAULT NULL,
p_sum_detc_ind tbbterm.tbbterm_sum_detc_ind%TYPE,
p_aid_auth_disp_ind tbbterm.tbbterm_aid_auth_disp_ind%TYPE,
p_aid_memo_disp_ind tbbterm.tbbterm_aid_memo_disp_ind%TYPE,
p_oth_memo_disp_ind tbbterm.tbbterm_oth_memo_disp_ind%TYPE,
p_pay_btn_ind tbbterm.tbbterm_pay_btn_ind%TYPE,
p_accd_due_cde tbbterm.tbbterm_accd_due_cde%TYPE,
p_auth_due_cde tbbterm.tbbterm_auth_due_cde%TYPE,
p_memo_due_cde tbbterm.tbbterm_memo_due_cde%TYPE,
p_aid_calc_ind tbbterm.tbbterm_aid_calc_ind%TYPE,
p_data_origin tbbterm.tbbterm_data_origin%TYPE DEFAULT NULL,
p_user_id tbbterm.tbbterm_user_id%TYPE DEFAULT gb_common.f_sct_user)
Validates all the data in the record.
| Parameters |
| p_term_code |
Unique term code that identifies the base term record. VARCHAR2(6) Required Key | |
| p_detail_web_disp_ind |
Display of self-service Account Detail for Term is enabled for this term (Y/N). VARCHAR2(1) Required | |
| p_web_eff_date |
Effective date for calculation of Current Due and memo Release of deposits. DATE | |
| p_sum_detc_ind |
Account detail is summarized by detail code (Y/N). VARCHAR2(1) Required | |
| p_aid_auth_disp_ind |
Authorized Aid is displayed for this term (Y/N). VARCHAR2(1) Required | |
| p_aid_memo_disp_ind |
Financial Aid memos are displayed for this term (Y/N). VARCHAR2(1) Required | |
| p_oth_memo_disp_ind |
Other memos are displayed for this term (Y/N). VARCHAR2(1) Required | |
| p_pay_btn_ind |
Display Pay Now buttons.(Y/N/). VARCHAR2(1) Required | |
| p_accd_due_cde |
Calculations in Account Detail section - values (A)ccount Balance only or (B)oth Balance and Current Amount Due. VARCHAR2(1) Required | |
| p_auth_due_cde |
Calculations in Authorized Aid section - values (N)o adjusted totals, (A)djusted Account Balance only, or (B)oth adjusted Balance and Current Amount Due. VARCHAR2(1) Required | |
| p_memo_due_cde |
Calculations in Memo section - values (N)o adjusted totals, or (A)djusted Account Balance only, or (B)oth adjusted Balance and Current Amount Due. VARCHAR2(1) Required | |
| p_aid_calc_ind |
Reserved for future use (Y/N). VARCHAR2(1) Required | |
| p_data_origin |
Source system that last created or updated the data. VARCHAR2(30) | |
| p_user_id |
User who created or last updated the record. VARCHAR2(30) Required |