index

Package sb_scp_continuant_rules

Support subprograms for the SCP_CONTINUANT (sb_scp_continuant).

Program units
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.

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_term_code          sorcscp.sorcscp_term_code%TYPE,
                            p_styp_code          sorcscp.sorcscp_styp_code%TYPE,
                            p_scps_code_cont     sorcscp.sorcscp_scps_code_cont%TYPE,
                            p_user               sorcscp.sorcscp_user%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 for which you are creating the continuing SCPs. VARCHAR2(24) Required Key
p_styp_code   Student type for which you are creating the continuing SCPs. VARCHAR2(4) Required Key
p_scps_code_cont   Continuing SCP. VARCHAR2(24) Required Key
p_user   This field contains the user ID for the user who most recently added or changed the record. VARCHAR2(120) Required
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_validate 

Procedure p_validate(p_term_code      sorcscp.sorcscp_term_code%TYPE,
                     p_styp_code      sorcscp.sorcscp_styp_code%TYPE,
                     p_scps_code_cont sorcscp.sorcscp_scps_code_cont%TYPE,
                     p_user           sorcscp.sorcscp_user%TYPE)

Validates all data in the record.

Parameters
p_term_code   Term for which you are creating the continuing SCPs. VARCHAR2(24) Required Key
p_styp_code   Student type for which you are creating the continuing SCPs. VARCHAR2(4) Required Key
p_scps_code_cont   Continuing SCP. VARCHAR2(24) Required Key
p_user   This field contains the user ID for the user who most recently added or changed the record. VARCHAR2(120) Required