index

Package gb_pcol_concentration_rules

Support subprograms for the PRIOR COLLEGE CONCENTRATION API (gb_pcol_concentration).

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               sorconc.sorconc_pidm%TYPE,
                            p_sbgi_code          sorconc.sorconc_sbgi_code%TYPE,
                            p_degc_code          sorconc.sorconc_degc_code%TYPE,
                            p_degr_seq_no        sorconc.sorconc_degr_seq_no%TYPE,
                            p_majr_code_conc     sorconc.sorconc_majr_code_conc%TYPE,
                            p_data_origin        sorconc.sorconc_data_origin%TYPE,
                            p_user_id            sorconc.sorconc_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_conc   Concentration area code.  The concentration code must be previously defined as a concentration 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           sorconc.sorconc_pidm%TYPE,
                     p_sbgi_code      sorconc.sorconc_sbgi_code%TYPE,
                     p_degc_code      sorconc.sorconc_degc_code%TYPE,
                     p_degr_seq_no    sorconc.sorconc_degr_seq_no%TYPE,
                     p_majr_code_conc sorconc.sorconc_majr_code_conc%TYPE,
                     p_data_origin    sorconc.sorconc_data_origin%TYPE DEFAULT NULL,
                     p_user_id        sorconc.sorconc_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 concentration 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_conc   Concentration area code.  The concentration code must be previously defined as a concentration 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)