Package sb_wl_collector

Package sb_wl_collector_rules

Support subprograms for the Waitlist Collector API (sb_wl_collector).

Program units

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_term_code          sfrcolw.sfrcolw_term_code%TYPE,
                            p_crn                sfrcolw.sfrcolw_crn%TYPE,
                            p_user_id            sfrcolw.sfrcolw_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin        sfrcolw.sfrcolw_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_term_code	Term code for the section that has new seat(s) available. VARCHAR2(6) Required Key
	p_crn	Course reference number for which the new seat is available. VARCHAR2(5) Required Key
	p_user_id	ID of the user who inserted or last updated the data. VARCHAR2(30) Required
	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_term_code   sfrcolw.sfrcolw_term_code%TYPE,
                     p_crn         sfrcolw.sfrcolw_crn%TYPE,
                     p_user_id     sfrcolw.sfrcolw_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_data_origin sfrcolw.sfrcolw_data_origin%TYPE DEFAULT NULL)

Validates all data in the record.

Parameters

	p_term_code	Term code for the section that has new seat(s) available. VARCHAR2(6) Required Key
	p_crn	Course reference number for which the new seat is available. VARCHAR2(5) Required Key
	p_user_id	ID of the user who inserted or last updated the data. VARCHAR2(30) Required
	p_data_origin	Source system that created or updated the row. VARCHAR2(30)