index

Package gb_pcol_degree_rules

Support subprograms for the PRIOR COLLEGE DEGREE API (gb_pcol_degree).

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               sordegr.sordegr_pidm%TYPE,
                            p_sbgi_code          sordegr.sordegr_sbgi_code%TYPE,
                            p_degc_code          sordegr.sordegr_degc_code%TYPE,
                            p_degr_seq_no        sordegr.sordegr_degr_seq_no%TYPE,
                            p_attend_from        sordegr.sordegr_attend_from%TYPE,
                            p_attend_to          sordegr.sordegr_attend_to%TYPE,
                            p_hours_transferred  sordegr.sordegr_hours_transferred%TYPE,
                            p_gpa_transferred    sordegr.sordegr_gpa_transferred%TYPE,
                            p_degc_date          sordegr.sordegr_degc_date%TYPE,
                            p_degc_year          sordegr.sordegr_degc_year%TYPE,
                            p_coll_code          sordegr.sordegr_coll_code%TYPE,
                            p_honr_code          sordegr.sordegr_honr_code%TYPE,
                            p_term_degree        sordegr.sordegr_term_degree%TYPE,
                            p_egol_code          sordegr.sordegr_egol_code%TYPE,
                            p_primary_ind        sordegr.sordegr_primary_ind%TYPE,
                            p_data_origin        sordegr.sordegr_data_origin%TYPE,
                            p_user_id            sordegr.sordegr_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 of the prospect or applicant. VARCHAR2(6) Required Key
p_degc_code   The degree received at the prior college. VARCHAR2(6) Key
p_degr_seq_no   A unique sequence number assigned to the prior college degree. NUMBER(2) Required Key
p_attend_from   The last date of attendance at the prior college. DATE
p_attend_to   The first date of attendance at the prior college. DATE
p_hours_transferred   The total number of hours transferred from the prior college.  This field is informational and does not update the transfer GPA in Academic History. NUMBER(11,3)
p_gpa_transferred   The transfer GPA.  This is informational and does not update the transfer GPA in Academic History. NUMBER(23,9)
p_degc_date   Prior college degree date. DATE
p_degc_year   Prior college degree year. VARCHAR2(4)
p_coll_code   Prior college code. VARCHAR2(2)
p_honr_code   Honor code. VARCHAR2(6)
p_term_degree   Terminal degree indicator. VARCHAR2(1)
p_egol_code   Education Goal Code. VARCHAR2(2)
p_primary_ind   Primary School Indicator. VARCHAR2(1)
p_data_origin   Source system that created or updated the row. VARCHAR2(30)
p_user_id   The Oracle 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              sordegr.sordegr_pidm%TYPE,
                     p_sbgi_code         sordegr.sordegr_sbgi_code%TYPE,
                     p_degc_code         sordegr.sordegr_degc_code%TYPE,
                     p_degr_seq_no       sordegr.sordegr_degr_seq_no%TYPE,
                     p_attend_from       sordegr.sordegr_attend_from%TYPE DEFAULT NULL,
                     p_attend_to         sordegr.sordegr_attend_to%TYPE DEFAULT NULL,
                     p_hours_transferred sordegr.sordegr_hours_transferred%TYPE DEFAULT NULL,
                     p_gpa_transferred   sordegr.sordegr_gpa_transferred%TYPE DEFAULT NULL,
                     p_degc_date         sordegr.sordegr_degc_date%TYPE DEFAULT NULL,
                     p_degc_year         sordegr.sordegr_degc_year%TYPE DEFAULT NULL,
                     p_coll_code         sordegr.sordegr_coll_code%TYPE DEFAULT NULL,
                     p_honr_code         sordegr.sordegr_honr_code%TYPE DEFAULT NULL,
                     p_term_degree       sordegr.sordegr_term_degree%TYPE DEFAULT NULL,
                     p_egol_code         sordegr.sordegr_egol_code%TYPE DEFAULT NULL,
                     p_primary_ind       sordegr.sordegr_primary_ind%TYPE DEFAULT NULL,
                     p_data_origin       sordegr.sordegr_data_origin%TYPE DEFAULT NULL,
                     p_user_id           sordegr.sordegr_user_id%TYPE DEFAULT gb_common.f_sct_user)

Validates all the data in the record.
The internal identification number, source background institution code and degree sequence number are required.
The graduation date must be greater than or equal to the attend to date.  The attend from date must be less than the attend to date.  If specified, the prior college degree primary indicator must be an N or Y.
If specified, the prior college terminal degree indicator must be an N or Y.

Parameters
p_pidm   Internal identification number. NUMBER(8) Required Key
p_sbgi_code   Prior college code of the prospect or applicant. VARCHAR2(6) Required Key
p_degc_code   The degree received at the prior college. VARCHAR2(6) Key
p_degr_seq_no   A unique sequence number assigned to the prior college degree. NUMBER(2) Required Key
p_attend_from   The last date of attendance at the prior college. DATE
p_attend_to   The first date of attendance at the prior college. DATE
p_hours_transferred   The total number of hours transferred from the prior college.  This field is informational and does not update the transfer GPA in Academic History. NUMBER(11,3)
p_gpa_transferred   The transfer GPA.  This is informational and does not update the transfer GPA in Academic History. NUMBER(23,9)
p_degc_date   Prior college degree date. DATE
p_degc_year   Prior college degree year. VARCHAR2(4)
p_coll_code   Prior college code. VARCHAR2(2)
p_honr_code   Honor code. VARCHAR2(6)
p_term_degree   Terminal degree indicator. VARCHAR2(1)
p_egol_code   Education Goal Code. VARCHAR2(2)
p_primary_ind   Primary School Indicator. VARCHAR2(1)
p_data_origin   Source system that created or updated the row. VARCHAR2(30)
p_user_id   The Oracle ID of the user who changed the record. VARCHAR2(30)