index

Package gb_pcol_minor_rules

Support subprograms for the PRIOR COLLEGE MINOR API (gb_pcol_minor).

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 the 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, or delete. NUMBER Required
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_register_entity 

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_pidm               sorminr.sorminr_pidm%TYPE,
                            p_sbgi_code          sorminr.sorminr_sbgi_code%TYPE,
                            p_degc_code          sorminr.sorminr_degc_code%TYPE,
                            p_degr_seq_no        sorminr.sorminr_degr_seq_no%TYPE,
                            p_majr_code_minor    sorminr.sorminr_majr_code_minor%TYPE,
                            p_data_origin        sorminr.sorminr_data_origin%TYPE,
                            p_user_id            sorminr.sorminr_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            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 the parameters.

Parameters
p_operation_type   Type of DML operation: create, update, or delete. NUMBER Required
p_pidm   Internal identification number. NUMBER(8) Required Key
p_sbgi_code   Prior college code.  The SBGI code must be previously defined on the source/background institution code validation table. VARCHAR2(6) Required Key
p_degc_code   Prior college degree code.  The degree code must be previously defined on the degree code validation table. VARCHAR2(6) Key
p_degr_seq_no   Prior college degree sequence number. NUMBER(2) Required Key
p_majr_code_minor   Minor code.  The minor code must be previously defined as a minor on the Major, Minor, Concentration validation table. VARCHAR2(4) Required Key
p_data_origin   Source system that created or updated the row. VARCHAR2(30)
p_user_id   The Oracle user ID of the user who changed the record. VARCHAR2(30)
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_validate 

PROCEDURE p_validate(p_pidm            sorminr.sorminr_pidm%TYPE,
                     p_sbgi_code       sorminr.sorminr_sbgi_code%TYPE,
                     p_degc_code       sorminr.sorminr_degc_code%TYPE,
                     p_degr_seq_no     sorminr.sorminr_degr_seq_no%TYPE,
                     p_majr_code_minor sorminr.sorminr_majr_code_minor%TYPE,
                     p_data_origin     sorminr.sorminr_data_origin%TYPE DEFAULT NULL,
                     p_user_id         sorminr.sorminr_user_id%TYPE DEFAULT gb_common.f_sct_user)

Validates all the data in the record.
The internal identification number, source background institution code, degree sequence number and minor code are required.

Parameters
p_pidm   Internal identification number. NUMBER(8) Required Key
p_sbgi_code   Prior college code.  The SBGI code must be previously defined on the source/background institution code validation table. VARCHAR2(6) Required Key
p_degc_code   Prior college degree code.  The degree code must be previously defined on the degree code validation table. VARCHAR2(6) Key
p_degr_seq_no   Prior college degree sequence number. NUMBER(2) Required Key
p_majr_code_minor   Minor code.  The minor code must be previously defined as a minor on the Major, Minor, Concentration validation table. VARCHAR2(4) Required Key
p_data_origin   Source system that created or updated the row. VARCHAR2(30)
p_user_id   The Oracle user ID of the user who changed the record. VARCHAR2(30)