|
Package sb_wl_exclusion_rules Support subprograms for the Waitlist Exclusion Rules API (sb_wl_exclusion). |
| Program units |
| p_register_entity |
| p_register_entity |
| p_validate |
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 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_primary_key sobexcr.sobexcr_primary_key%TYPE,
p_term_code sobexcr.sobexcr_term_code%TYPE,
p_user_id sobexcr.sobexcr_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_levl_code sobexcr.sobexcr_levl_code%TYPE,
p_camp_code sobexcr.sobexcr_camp_code%TYPE,
p_coll_code sobexcr.sobexcr_coll_code%TYPE,
p_degc_code sobexcr.sobexcr_degc_code%TYPE,
p_program sobexcr.sobexcr_program%TYPE,
p_clas_code sobexcr.sobexcr_clas_code%TYPE,
p_atts_code sobexcr.sobexcr_atts_code%TYPE,
p_astd_code sobexcr.sobexcr_astd_code%TYPE,
p_chrt_code sobexcr.sobexcr_chrt_code%TYPE,
p_lfst_code sobexcr.sobexcr_lfst_code%TYPE,
p_majr_code sobexcr.sobexcr_majr_code%TYPE,
p_min_gpa sobexcr.sobexcr_min_gpa%TYPE,
p_max_gpa sobexcr.sobexcr_max_gpa%TYPE,
p_data_origin sobexcr.sobexcr_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 all parameters.
| Parameters |
| p_operation_type |
Type of DML operation: create,update,delete. NUMBER Required | |
| p_primary_key |
Unique sequence number to identify exclusion rule. NUMBER(9) Required Key | |
| p_term_code |
Term code associated with the entries on the Automated Waitlist Term Control Form (SOAWLTC) on Waitlist Exclusions Block. VARCHAR2(6) Required | |
| p_user_id |
ID of the user who inserted or last updated the data. VARCHAR2(30) Required | |
| p_levl_code |
Level code the system is to use in the exclusion rule. VARCHAR2(2) | |
| p_camp_code |
Campus code the system is to use in the exclusion rule. VARCHAR2(3) | |
| p_coll_code |
College code the system is to use in the exclusion rule. VARCHAR2(2) | |
| p_degc_code |
Degree code the system is to use in the exclusion rule. VARCHAR2(6) | |
| p_program |
Program code the system is to use in the exclusion rule. VARCHAR2(12) | |
| p_clas_code |
Class code the system is to use in the exclusion rule. VARCHAR2(2) | |
| p_atts_code |
Attribute code the system is to use in the exclusion rule. VARCHAR2(4) | |
| p_astd_code |
Academic standing code referenced in the General Student, Registration and Academic History Modules. VARCHAR2(2) | |
| p_chrt_code |
Cohort code the system is to use in the exclusion rule. VARCHAR2(10) | |
| p_lfst_code |
Field of student type the major code values should apply to in the exclusion rule. VARCHAR2(15) | |
| p_majr_code |
Major code the system is to use in the exclusion rule. VARCHAR2(4) | |
| p_min_gpa |
Minimum GPA the system is to use in the exclusion rule. NUMBER(23,9) | |
| p_max_gpa |
Maximum GPA the system is to use in the exclusion rule. NUMBER(23,9) | |
| p_data_origin |
Source system that created or updated the row. VARCHAR2(30) | |
| p_internal_record_id |
Database ROWID VARCHAR2(18) required |
p_validate
Procedure p_validate(p_primary_key sobexcr.sobexcr_primary_key%TYPE,
p_term_code sobexcr.sobexcr_term_code%TYPE,
p_user_id sobexcr.sobexcr_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_levl_code sobexcr.sobexcr_levl_code%TYPE DEFAULT NULL,
p_camp_code sobexcr.sobexcr_camp_code%TYPE DEFAULT NULL,
p_coll_code sobexcr.sobexcr_coll_code%TYPE DEFAULT NULL,
p_degc_code sobexcr.sobexcr_degc_code%TYPE DEFAULT NULL,
p_program sobexcr.sobexcr_program%TYPE DEFAULT NULL,
p_clas_code sobexcr.sobexcr_clas_code%TYPE DEFAULT NULL,
p_atts_code sobexcr.sobexcr_atts_code%TYPE DEFAULT NULL,
p_astd_code sobexcr.sobexcr_astd_code%TYPE DEFAULT NULL,
p_chrt_code sobexcr.sobexcr_chrt_code%TYPE DEFAULT NULL,
p_lfst_code sobexcr.sobexcr_lfst_code%TYPE DEFAULT NULL,
p_majr_code sobexcr.sobexcr_majr_code%TYPE DEFAULT NULL,
p_min_gpa sobexcr.sobexcr_min_gpa%TYPE DEFAULT NULL,
p_max_gpa sobexcr.sobexcr_max_gpa%TYPE DEFAULT NULL,
p_data_origin sobexcr.sobexcr_data_origin%TYPE DEFAULT NULL)
Validates all data in the record.
| Parameters |
| p_primary_key |
Unique sequence number to identify exclusion rule. NUMBER(9) Required Key | |
| p_term_code |
Term code associated with the entries on the Automated Waitlist Term Control Form (SOAWLTC) on Waitlist Exclusions Block. VARCHAR2(6) Required | |
| p_user_id |
ID of the user who inserted or last updated the data. VARCHAR2(30) Required | |
| p_levl_code |
Level code the system is to use in the exclusion rule. VARCHAR2(2) | |
| p_camp_code |
Campus code the system is to use in the exclusion rule. VARCHAR2(3) | |
| p_coll_code |
College code the system is to use in the exclusion rule. VARCHAR2(2) | |
| p_degc_code |
Degree code the system is to use in the exclusion rule. VARCHAR2(6) | |
| p_program |
Program code the system is to use in the exclusion rule. VARCHAR2(12) | |
| p_clas_code |
Class code the system is to use in the exclusion rule. VARCHAR2(2) | |
| p_atts_code |
Attribute code the system is to use in the exclusion rule. VARCHAR2(4) | |
| p_astd_code |
Academic standing code referenced in the General Student, Registration and Academic History Modules. VARCHAR2(2) | |
| p_chrt_code |
Cohort code the system is to use in the exclusion rule. VARCHAR2(10) | |
| p_lfst_code |
Field of student type the major code values should apply to in the exclusion rule. VARCHAR2(15) | |
| p_majr_code |
Major code the system is to use in the exclusion rule. VARCHAR2(4) | |
| p_min_gpa |
Minimum GPA the system is to use in the exclusion rule. NUMBER(23,9) | |
| p_max_gpa |
Maximum GPA the system is to use in the exclusion rule. NUMBER(23,9) | |
| p_data_origin |
Source system that created or updated the row. VARCHAR2(30) |