BANINST1@S10B80

index

Package sb_wl_notification_rules

Support subprograms for the WL_NOTIFICATION (sb_wl_notification).

Program units
p_register_entity   Register 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 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)

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          sfrwlnt.sfrwlnt_term_code%TYPE,
                            p_crn                sfrwlnt.sfrwlnt_crn%TYPE,
                            p_pidm               sfrwlnt.sfrwlnt_pidm%TYPE,
                            p_user_id            sfrwlnt.sfrwlnt_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_start_date         sfrwlnt.sfrwlnt_start_date%TYPE,
                            p_end_date           sfrwlnt.sfrwlnt_end_date%TYPE,
                            p_wl_priority        sfrwlnt.sfrwlnt_wl_priority%TYPE,
                            p_reg_conf_stat      sfrwlnt.sfrwlnt_reg_conf_stat%TYPE,
                            p_data_origin        sfrwlnt.sfrwlnt_data_origin%TYPE,
                            p_error_status       sfrwlnt.sfrwlnt_error_status%TYPE,
                            p_error_count        sfrwlnt.sfrwlnt_error_count%TYPE,
                            p_last_error_message sfrwlnt.sfrwlnt_last_error_message%TYPE,
                            p_last_error_date    sfrwlnt.sfrwlnt_last_error_date%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 of the section that has an available seat. VARCHAR2(6) Required Key
p_crn   Course reference number of the section that has an available seat. VARCHAR2(5) Required Key
p_pidm   Unique identifier(PIDM) of the student that has been notified of available seats. NUMBER(8) Required Key
p_user_id   ID of the user who inserted or last updated the data. VARCHAR2(30) Required
p_start_date   Date and time stamp of the notification. DATE
p_end_date   Date and time stamp of deadline to register for the course. DATE
p_wl_priority   Waitlist priority at notification time. NUMBER(11,6)
p_reg_conf_stat   Registration confirmation. Valid values: P-pending, R-student already registered for the Course, X-student was removed from the Waitlist. VARCHAR2(1)
p_data_origin   Source system that created or updated the row. VARCHAR2(30)
p_error_status   Email error status Success(S), Temporary error(T), Permanent error(P), Other(O). VARCHAR2(1)
p_error_count   Number of email failures. NUMBER(5)
p_last_error_message   Last updated email error. VARCHAR2(300)
p_last_error_date   Date and Time stamp of last email error. DATE
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_validate 

Procedure p_validate(p_term_code          sfrwlnt.sfrwlnt_term_code%TYPE,
                     p_crn                sfrwlnt.sfrwlnt_crn%TYPE,
                     p_pidm               sfrwlnt.sfrwlnt_pidm%TYPE,
                     p_user_id            sfrwlnt.sfrwlnt_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_start_date         sfrwlnt.sfrwlnt_start_date%TYPE DEFAULT NULL,
                     p_end_date           sfrwlnt.sfrwlnt_end_date%TYPE DEFAULT NULL,
                     p_wl_priority        sfrwlnt.sfrwlnt_wl_priority%TYPE DEFAULT NULL,
                     p_reg_conf_stat      sfrwlnt.sfrwlnt_reg_conf_stat%TYPE DEFAULT NULL,
                     p_data_origin        sfrwlnt.sfrwlnt_data_origin%TYPE DEFAULT NULL,
                     p_error_status       sfrwlnt.sfrwlnt_error_status%TYPE DEFAULT NULL,
                     p_error_count        sfrwlnt.sfrwlnt_error_count%TYPE DEFAULT NULL,
                     p_last_error_message sfrwlnt.sfrwlnt_last_error_message%TYPE DEFAULT NULL,
                     p_last_error_date    sfrwlnt.sfrwlnt_last_error_date%TYPE DEFAULT NULL)

Validates all data in the record.

Parameters
p_term_code   Term code of the section that has an available seat. VARCHAR2(6) Required Key
p_crn   Course reference number of the section that has an available seat. VARCHAR2(5) Required Key
p_pidm   Unique identifier(PIDM) of the student that has been notified of available seats. NUMBER(8) Required Key
p_user_id   ID of the user who inserted or last updated the data. VARCHAR2(30) Required
p_start_date   Date and time stamp of the notification. DATE
p_end_date   Date and time stamp of deadline to register for the course. DATE
p_wl_priority   Waitlist priority at notification time. NUMBER(11,6)
p_reg_conf_stat   Registration confirmation. Valid values: P-pending, R-student already registered for the Course, X-student was removed from the Waitlist. VARCHAR2(1)
p_data_origin   Source system that created or updated the row. VARCHAR2(30)
p_error_status   Email error status Success(S), Temporary error(T), Permanent error(P), Other(O). VARCHAR2(1)
p_error_count   Number of email failures. NUMBER(5)
p_last_error_message   Last updated email error. VARCHAR2(300)
p_last_error_date   Date and Time stamp of last email error. DATE