Package sb_gradapp_selrule

Package sb_gradapp_selrule_rules

Support subprograms for the Graduation Application Select Rules API (sb_gradapp_selrule).

Program units

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_seqno              shbgads.shbgads_seqno%TYPE,
                            p_process_order_no   shbgads.shbgads_process_order_no%TYPE,
                            p_gadr_code          shbgads.shbgads_gadr_code%TYPE,
                            p_user_id            shbgads.shbgads_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_levl_code          shbgads.shbgads_levl_code%TYPE,
                            p_camp_code          shbgads.shbgads_camp_code%TYPE,
                            p_coll_code          shbgads.shbgads_coll_code%TYPE,
                            p_degc_code          shbgads.shbgads_degc_code%TYPE,
                            p_program            shbgads.shbgads_program%TYPE,
                            p_lfst_code          shbgads.shbgads_lfst_code%TYPE,
                            p_majr_code          shbgads.shbgads_majr_code%TYPE,
                            p_dept_code          shbgads.shbgads_dept_code%TYPE,
                            p_data_origin        shbgads.shbgads_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_seqno	One-up number to define the row. NUMBER(8) Required Key
	p_process_order_no	Order in which to check the select rules. NUMBER(6) Required
	p_gadr_code	Display rule code for the graduation application. VARCHAR2(15) Required
	p_user_id	ID of the most recent user to create or update the row in the SHBGADS table. VARCHAR2(30) Required
	p_levl_code	Level code of the select rule. VARCHAR2(2)
	p_camp_code	Campus code of the select rule. VARCHAR2(3)
	p_coll_code	College code of the select rule. VARCHAR2(2)
	p_degc_code	Degree code of the select rule. VARCHAR2(6)
	p_program	Program of the select rule. VARCHAR2(12)
	p_lfst_code	Learner field of study type code of the select rule. VARCHAR2(15)
	p_majr_code	Major code for the field of study of the select rule. VARCHAR2(4)
	p_dept_code	Department code associated with the major field of study of the select rule. VARCHAR2(4)
	p_data_origin	Value of the source system that inserted or updated the row. VARCHAR2(30)
	p_internal_record_id	Database ROWID VARCHAR2(18) Required

p_validate

Procedure p_validate(p_seqno            shbgads.shbgads_seqno%TYPE,
                     p_process_order_no shbgads.shbgads_process_order_no%TYPE,
                     p_gadr_code        shbgads.shbgads_gadr_code%TYPE,
                     p_user_id          shbgads.shbgads_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_levl_code        shbgads.shbgads_levl_code%TYPE DEFAULT NULL,
                     p_camp_code        shbgads.shbgads_camp_code%TYPE DEFAULT NULL,
                     p_coll_code        shbgads.shbgads_coll_code%TYPE DEFAULT NULL,
                     p_degc_code        shbgads.shbgads_degc_code%TYPE DEFAULT NULL,
                     p_program          shbgads.shbgads_program%TYPE DEFAULT NULL,
                     p_lfst_code        shbgads.shbgads_lfst_code%TYPE DEFAULT NULL,
                     p_majr_code        shbgads.shbgads_majr_code%TYPE DEFAULT NULL,
                     p_dept_code        shbgads.shbgads_dept_code%TYPE DEFAULT NULL,
                     p_data_origin      shbgads.shbgads_data_origin%TYPE DEFAULT NULL)

Validates all data in the record.

Parameters

	p_seqno	One-up number to define the row. NUMBER(8) Required Key
	p_process_order_no	Order in which to check the select rules. NUMBER(6) Required
	p_gadr_code	Display rule code for the graduation application. VARCHAR2(15) Required
	p_user_id	ID of the most recent user to create or update the row in the SHBGADS table. VARCHAR2(30) Required
	p_levl_code	Level code of the select rule. VARCHAR2(2)
	p_camp_code	Campus code of the select rule. VARCHAR2(3)
	p_coll_code	College code of the select rule. VARCHAR2(2)
	p_degc_code	Degree code of the select rule. VARCHAR2(6)
	p_program	Program of the select rule. VARCHAR2(12)
	p_lfst_code	Learner field of study type code of the select rule. VARCHAR2(15)
	p_majr_code	Major code for the field of study of the select rule. VARCHAR2(4)
	p_dept_code	Department code associated with the major field of study of the select rule. VARCHAR2(4)
	p_data_origin	Value of the source system that inserted or updated the row. VARCHAR2(30)