index

Package sb_mass_entry_rules

Support subprograms for the Mass Entry API (sb_mass_entry).

Program units
f_parent_exists  
p_register_entity   Registers 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.

f_parent_exists 

Function f_parent_exists(p_form_name   sormaud.sormaud_form_name%TYPE,
                         p_add_user_id sormaud.sormaud_add_user_id%TYPE,
                         p_add_date    sormaud.sormaud_add_date%TYPE)
  RETURN VARCHAR2

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_form_name          sormaud.sormaud_form_name%TYPE,
                            p_add_user_id        sormaud.sormaud_add_user_id%TYPE,
                            p_add_date           sormaud.sormaud_add_date%TYPE,
                            p_pidm               sormaud.sormaud_pidm%TYPE,
                            p_seqno              sormaud.sormaud_seqno%TYPE,
                            p_manual_add_ind     sormaud.sormaud_manual_add_ind%TYPE,
                            p_process_ind        sormaud.sormaud_process_ind%TYPE,
                            p_update_cde         sormaud.sormaud_update_cde%TYPE,
                            p_user_id            sormaud.sormaud_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin        sormaud.sormaud_data_origin%TYPE,
                            p_term_code          sormaud.sormaud_term_code%TYPE,
                            p_key_seqno          sormaud.sormaud_key_seqno%TYPE,
                            p_key_text           sormaud.sormaud_key_text%TYPE,
                            p_hold_cde           sormaud.sormaud_hold_cde%TYPE,
                            p_msg                sormaud.sormaud_msg%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_form_name   Mass entry form name. VARCHAR2(30) Required Key
p_add_user_id   ID of the user who initiated the mass entry. VARCHAR2(30) Required Key
p_add_date   Date and timestamp the mass entry was initiated. DATE Required Key
p_pidm   Unique identifier (PIDM) for the person selected or entered for the mass entry process. NUMBER(8) Required Key
p_seqno   A one up sequence number for each PIDM and mass entry form, add date and add user ID. NUMBER(2) Required Key
p_manual_add_ind   Y/N indicator for whether the record was manually inserted on the mass entry form.  If the record was selected from the population selection process the value will be N for no. VARCHAR2(1) Required
p_process_ind   Y/N indicator for whether the record was selected to be process by the mass entry update procedure. VARCHAR2(1) Required
p_update_cde   Value that indicates if the mass entry completed successfully (Y); partially successful (P); none of the updates were successful (F); or (N) for when the update process did not process the record. VARCHAR2(1) Required
p_user_id   ID of the most recent user to create or update the record. VARCHAR2(30) Required
p_data_origin   Data origin of the insert or update to the record. VARCHAR2(30) Required
p_term_code   Term code for the mass entry host subject key. This  is the effective term for the learner, the admissions application term for the application, or blank for outcome records. VARCHAR2(6)
p_key_seqno   Key sequence number for the mass entry host subject key. This is the admissions application number for the application or the degree sequence number on the outcome records. NUMBER(2)
p_key_text   Key text value for the mass entry host subject key. This is the ceremony code for some of the graduation mass entry forms. VARCHAR2(30)
p_hold_cde   Y/N indicator for whether a hold exists for the person. VARCHAR2(1)
p_msg   Error messages returned from the mass entry processing. VARCHAR2(4000)
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_validate 

Procedure p_validate(p_form_name      sormaud.sormaud_form_name%TYPE,
                     p_add_user_id    sormaud.sormaud_add_user_id%TYPE,
                     p_add_date       sormaud.sormaud_add_date%TYPE,
                     p_pidm           sormaud.sormaud_pidm%TYPE,
                     p_seqno          sormaud.sormaud_seqno%TYPE,
                     p_manual_add_ind sormaud.sormaud_manual_add_ind%TYPE,
                     p_process_ind    sormaud.sormaud_process_ind%TYPE,
                     p_update_cde     sormaud.sormaud_update_cde%TYPE,
                     p_user_id        sormaud.sormaud_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_data_origin    sormaud.sormaud_data_origin%TYPE,
                     p_term_code      sormaud.sormaud_term_code%TYPE DEFAULT NULL,
                     p_key_seqno      sormaud.sormaud_key_seqno%TYPE DEFAULT NULL,
                     p_key_text       sormaud.sormaud_key_text%TYPE DEFAULT NULL,
                     p_hold_cde       sormaud.sormaud_hold_cde%TYPE DEFAULT NULL,
                     p_msg            sormaud.sormaud_msg%TYPE DEFAULT NULL)

Validates all data in the record.

Parameters
p_form_name   Mass entry form name. VARCHAR2(30) Required Key
p_add_user_id   ID of the user who initiated the mass entry. VARCHAR2(30) Required Key
p_add_date   Date and timestamp the mass entry was initiated. DATE Required Key
p_pidm   Unique identifier (PIDM) for the person selected or entered for the mass entry process. NUMBER(8) Required Key
p_seqno   A one up sequence number for each PIDM and mass entry form, add date and add user ID. NUMBER(2) Required Key
p_manual_add_ind   Y/N indicator for whether the record was manually inserted on the mass entry form.  If the record was selected from the population selection process the value will be N for no. VARCHAR2(1) Required
p_process_ind   Y/N indicator for whether the record was selected to be process by the mass entry update procedure. VARCHAR2(1) Required
p_update_cde   Value that indicates if the mass entry completed successfully (Y); partially successful (P); none of the updates were successful (F); or (N) for when the update process did not process the record. VARCHAR2(1) Required
p_user_id   ID of the most recent user to create or update the record. VARCHAR2(30) Required
p_data_origin   Data origin of the insert or update to the record. VARCHAR2(30) Required
p_term_code   Term code for the mass entry host subject key. This  is the effective term for the learner, the admissions application term for the application, or blank for outcome records. VARCHAR2(6)
p_key_seqno   Key sequence number for the mass entry host subject key. This is the admissions application number for the application or the degree sequence number on the outcome records. NUMBER(2)
p_key_text   Key text value for the mass entry host subject key. This is the ceremony code for some of the graduation mass entry forms. VARCHAR2(30)
p_hold_cde   Y/N indicator for whether a hold exists for the person. VARCHAR2(1)
p_msg   Error messages returned from the mass entry processing. VARCHAR2(4000)