|
Package sb_application_decision_rules Support subprograms for the Application Decision API (sb_application_decision).This is the API for the Student Application Decision Table (SARAPPD). Internal identification number, term code, application number and sequence number are the keys for each application decision. Separate decision codes can be entered on multiple admission applications for the same applicant within the same term. |
Program units |
p_register_entity | Registers the attribute value pairs to the message cache for delete operations. |
p_register_entity | Registers 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);
Registers 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 of the record. VARCHAR2(18) Required |
p_register_entity
PROCEDURE p_register_entity(p_operation_type NUMBER, p_pidm sarappd.sarappd_pidm%TYPE, p_term_code_entry sarappd.sarappd_term_code_entry%TYPE, p_appl_no sarappd.sarappd_appl_no%TYPE, p_seq_no sarappd.sarappd_seq_no%TYPE, p_apdc_date sarappd.sarappd_apdc_date%TYPE, p_apdc_code sarappd.sarappd_apdc_code%TYPE, p_maint_ind sarappd.sarappd_maint_ind%TYPE, p_user sarappd.sarappd_user%TYPE, p_data_origin sarappd.sarappd_data_origin%TYPE, p_internal_record_id gb_common.internal_record_id_type);
Registers the attribute/value pairs to the message cache for create and update operations.
This signature registers the all parameters.
Parameters |
p_operation_type |
Type of DML operation: create, update, delete. NUMBER Required | |
p_pidm |
Unique identifier of the applicant. NUMBER(8) Required Key | |
p_term_code_entry |
Effective term of the application record. VARCHAR2(6) Required Key | |
p_appl_no |
Application number within the effective term record. NUMBER(2) Required Key | |
p_seq_no |
System assigned internal sequence number associated with the application record. NUMBER(2) Required Key | |
p_apdc_date |
Date the application decision was effective. DATE Required | |
p_apdc_code |
Application decision value associated with the application decision. VARCHAR2(2) Required | |
p_maint_ind |
Identifies whether the application decision was maintained by the system or the user. VARCHAR2(1) Required | |
p_user |
User ID of the most recent user to create or update a record. VARCHAR2(30) Required | |
p_data_origin |
Source system that generated the data. VARCHAR2(30) | |
p_internal_record_id |
Database ROWID of the record. VARCHAR2(18) Required |
p_validate
PROCEDURE p_validate(p_pidm sarappd.sarappd_pidm%TYPE, p_term_code_entry sarappd.sarappd_term_code_entry%TYPE, p_appl_no sarappd.sarappd_appl_no%TYPE, p_seq_no sarappd.sarappd_seq_no%TYPE, p_apdc_date sarappd.sarappd_apdc_date%TYPE, p_apdc_code sarappd.sarappd_apdc_code%TYPE, p_maint_ind sarappd.sarappd_maint_ind%TYPE, p_user sarappd.sarappd_user%TYPE, p_data_origin sarappd.sarappd_data_origin%TYPE DEFAULT NULL);
Validates all the data in the record.
Parameters |
p_pidm |
Internal identification number of the applicant. NUMBER(8) Required Key | |
p_term_code_entry |
Effective term of the application record. VARCHAR2(6) Required Key | |
p_appl_no |
Application number within the effective term record. NUMBER(2) Required Key | |
p_seq_no |
System assigned internal sequence number associated with the application record. NUMBER(2) Required Key | |
p_apdc_date |
Date the application decision was effective. DATE Required | |
p_apdc_code |
Application decision value associated with the application decision. VARCHAR2(2) Required | |
p_maint_ind |
Identifies whether the application decision was maintained by the system or the user. VARCHAR2(1) Required | |
p_user |
User ID of the most recent user to create or update a record. VARCHAR2(30) Required | |
p_data_origin |
Source system that generated the data. VARCHAR2(30) |