index

Package gb_pcol_major_rules

This package provides the support subprograms for the PRIOR COLLEGE MAJOR API (gb_pcol_major).

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               sormajr.sormajr_pidm%TYPE,
                            p_sbgi_code          sormajr.sormajr_sbgi_code%TYPE,
                            p_degc_code          sormajr.sormajr_degc_code%TYPE,
                            p_degr_seq_no        sormajr.sormajr_degr_seq_no%TYPE,
                            p_majr_code_major    sormajr.sormajr_majr_code_major%TYPE,
                            p_data_origin        sormajr.sormajr_data_origin%TYPE,
                            p_user_id            sormajr.sormajr_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_major   Major code.  The major code must be previously defined as a major 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            sormajr.sormajr_pidm%TYPE,
                     p_sbgi_code       sormajr.sormajr_sbgi_code%TYPE,
                     p_degc_code       sormajr.sormajr_degc_code%TYPE,
                     p_degr_seq_no     sormajr.sormajr_degr_seq_no%TYPE,
                     p_majr_code_major sormajr.sormajr_majr_code_major%TYPE,
                     p_data_origin     sormajr.sormajr_data_origin%TYPE DEFAULT NULL,
                     p_user_id         sormajr.sormajr_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 major 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_major   Major code.  The major code must be previously defined as a major 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)