index

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)