|
Package sb_wl_reordering_rules This package provides messaging support and field validations for the Waitlist Reorder Priority Rules API (sb_wl_reordering). |
| 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)
Registers 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 sobropr.sobropr_primary_key%TYPE,
p_term_code sobropr.sobropr_term_code%TYPE,
p_priority_num sobropr.sobropr_priority_num%TYPE,
p_user_id sobropr.sobropr_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_levl_code sobropr.sobropr_levl_code%TYPE,
p_camp_code sobropr.sobropr_camp_code%TYPE,
p_coll_code sobropr.sobropr_coll_code%TYPE,
p_degc_code sobropr.sobropr_degc_code%TYPE,
p_program sobropr.sobropr_program%TYPE,
p_clas_code sobropr.sobropr_clas_code%TYPE,
p_atts_code sobropr.sobropr_atts_code%TYPE,
p_astd_code sobropr.sobropr_astd_code%TYPE,
p_chrt_code sobropr.sobropr_chrt_code%TYPE,
p_lfst_code sobropr.sobropr_lfst_code%TYPE,
p_majr_code sobropr.sobropr_majr_code%TYPE,
p_min_gpa sobropr.sobropr_min_gpa%TYPE,
p_max_gpa sobropr.sobropr_max_gpa%TYPE,
p_data_origin sobropr.sobropr_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 priority rule. NUMBER(9) Required Key | |
| p_term_code |
Term code associated with the entries on the Automated Waitlist Term Control Form (SOAWLTC) on Waitlist Reordering Rules block. VARCHAR2(6) Required | |
| p_priority_num |
Number of the priority rule. NUMBER(4) 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 reordering rule. VARCHAR2(2) | |
| p_camp_code |
Campus code the system is to use in the reordering rule. VARCHAR2(3) | |
| p_coll_code |
College code the system is to use in the reordering rule. VARCHAR2(2) | |
| p_degc_code |
Degree code the system is to use in the reordering rule. VARCHAR2(6) | |
| p_program |
Program code the system is to use in the reordering rule. VARCHAR2(12) | |
| p_clas_code |
Class code the system is to use in the reordering rule. VARCHAR2(2) | |
| p_atts_code |
Attribute code the system is to use in the reordering 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 reordering rule. VARCHAR2(10) | |
| p_lfst_code |
Field of student type the major code values should apply to in the reordering rule. VARCHAR2(15) | |
| p_majr_code |
Major code the system is to use in the reordering rule. VARCHAR2(4) | |
| p_min_gpa |
Minimum GPA the system is to use in the reordering rule. NUMBER(23,9) | |
| p_max_gpa |
Maximum GPA the system is to use in the reordering 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 sobropr.sobropr_primary_key%TYPE,
p_term_code sobropr.sobropr_term_code%TYPE,
p_priority_num sobropr.sobropr_priority_num%TYPE,
p_user_id sobropr.sobropr_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_levl_code sobropr.sobropr_levl_code%TYPE DEFAULT NULL,
p_camp_code sobropr.sobropr_camp_code%TYPE DEFAULT NULL,
p_coll_code sobropr.sobropr_coll_code%TYPE DEFAULT NULL,
p_degc_code sobropr.sobropr_degc_code%TYPE DEFAULT NULL,
p_program sobropr.sobropr_program%TYPE DEFAULT NULL,
p_clas_code sobropr.sobropr_clas_code%TYPE DEFAULT NULL,
p_atts_code sobropr.sobropr_atts_code%TYPE DEFAULT NULL,
p_astd_code sobropr.sobropr_astd_code%TYPE DEFAULT NULL,
p_chrt_code sobropr.sobropr_chrt_code%TYPE DEFAULT NULL,
p_lfst_code sobropr.sobropr_lfst_code%TYPE DEFAULT NULL,
p_majr_code sobropr.sobropr_majr_code%TYPE DEFAULT NULL,
p_min_gpa sobropr.sobropr_min_gpa%TYPE DEFAULT NULL,
p_max_gpa sobropr.sobropr_max_gpa%TYPE DEFAULT NULL,
p_data_origin sobropr.sobropr_data_origin%TYPE DEFAULT NULL)
Validates all data in the record.
| Parameters |
| p_primary_key |
Unique sequence number to identify priority rule. NUMBER(9) Required Key | |
| p_term_code |
Term code associated with the entries on the Automated Waitlist Term Control Form (SOAWLTC) on Waitlist Reordering Rules block. VARCHAR2(6) Required | |
| p_priority_num |
Number of the priority rule. NUMBER(4) 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 reordering rule. VARCHAR2(2) | |
| p_camp_code |
Campus code the system is to use in the reordering rule. VARCHAR2(3) | |
| p_coll_code |
College code the system is to use in the reordering rule. VARCHAR2(2) | |
| p_degc_code |
Degree code the system is to use in the reordering rule. VARCHAR2(6) | |
| p_program |
Program code the system is to use in the reordering rule. VARCHAR2(12) | |
| p_clas_code |
Class code the system is to use in the reordering rule. VARCHAR2(2) | |
| p_atts_code |
Attribute code the system is to use in the reordering 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 reordering rule. VARCHAR2(10) | |
| p_lfst_code |
Field of student type the major code values should apply to in the reordering rule. VARCHAR2(15) | |
| p_majr_code |
Major code the system is to use in the reordering rule. VARCHAR2(4) | |
| p_min_gpa |
Minimum GPA the system is to use in the reordering rule. NUMBER(23,9) | |
| p_max_gpa |
Maximum GPA the system is to use in the reordering rule. NUMBER(23,9) | |
| p_data_origin |
Source system that created or updated the row. VARCHAR2(30) |