index

Package sb_highschool_rules

Support subprograms for the High School API (sb_highschool).

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_pidm               sorhsch.sorhsch_pidm%TYPE,
                            p_sbgi_code          sorhsch.sorhsch_sbgi_code%TYPE,
                            p_graduation_date    sorhsch.sorhsch_graduation_date%TYPE,
                            p_gpa                sorhsch.sorhsch_gpa%TYPE,
                            p_class_rank         sorhsch.sorhsch_class_rank%TYPE,
                            p_class_size         sorhsch.sorhsch_class_size%TYPE,
                            p_percentile         sorhsch.sorhsch_percentile%TYPE,
                            p_dplm_code          sorhsch.sorhsch_dplm_code%TYPE,
                            p_coll_prep_ind      sorhsch.sorhsch_coll_prep_ind%TYPE,
                            p_trans_recv_date    sorhsch.sorhsch_trans_recv_date%TYPE,
                            p_admr_code          sorhsch.sorhsch_admr_code%TYPE,
                            p_user_id            sorhsch.sorhsch_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin        sorhsch.sorhsch_data_origin%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_pidm   Internal identification number of the student. NUMBER(8) Required Key
p_sbgi_code   High school code of the prospect/applicant. VARCHAR2(6) Required Key
p_graduation_date   Prospect/applicant graduation date from high school. DATE
p_gpa   Prospect/applicant high school GPA. VARCHAR2(24)
p_class_rank   Prospect/applicant high school class rank. NUMBER(4)
p_class_size   Size of the prospect/applicant high school graduating  class size. NUMBER(4)
p_percentile   Prospect/applicant class percentile as related to class rank and size. NUMBER(5,2)
p_dplm_code   Prospect/applicant high school diploma type, such as college prep. VARCHAR2(2)
p_coll_prep_ind   Indicator for whether the prospect/applicant high school program was college prep.  Values are "Y" or null. VARCHAR2(1)
p_trans_recv_date   Date the prospect/applicant high school transcript was received. DATE
p_admr_code   Admission checklist request item code which may be cross referenced, such as receipt of high school transcript. VARCHAR2(4)
p_user_id   Oracle ID of the user who inserted or last updated the data. VARCHAR2(30)
p_data_origin   Source system that created or updated the row. VARCHAR2(30)
p_internal_record_id   Database ROWID VARCHAR2(18) required

p_validate 

Procedure p_validate(p_pidm            sorhsch.sorhsch_pidm%TYPE,
                     p_sbgi_code       sorhsch.sorhsch_sbgi_code%TYPE,
                     p_graduation_date sorhsch.sorhsch_graduation_date%TYPE DEFAULT NULL,
                     p_gpa             sorhsch.sorhsch_gpa%TYPE DEFAULT NULL,
                     p_class_rank      sorhsch.sorhsch_class_rank%TYPE DEFAULT NULL,
                     p_class_size      sorhsch.sorhsch_class_size%TYPE DEFAULT NULL,
                     p_percentile      sorhsch.sorhsch_percentile%TYPE DEFAULT NULL,
                     p_dplm_code       sorhsch.sorhsch_dplm_code%TYPE DEFAULT NULL,
                     p_coll_prep_ind   sorhsch.sorhsch_coll_prep_ind%TYPE DEFAULT NULL,
                     p_trans_recv_date sorhsch.sorhsch_trans_recv_date%TYPE DEFAULT NULL,
                     p_admr_code       sorhsch.sorhsch_admr_code%TYPE DEFAULT NULL,
                     p_user_id         sorhsch.sorhsch_user_id%TYPE DEFAULT gb_common.f_sct_user,
                     p_data_origin     sorhsch.sorhsch_data_origin%TYPE DEFAULT NULL,
                     p_rowid           gb_common.internal_record_id_type DEFAULT NULL)

Validates all data in the record.

Parameters
p_pidm   Internal identification number of the student. NUMBER(8) Required Key
p_sbgi_code   High school code of the prospect/applicant. VARCHAR2(6) Required Key
p_graduation_date   Prospect/applicant graduation date from high school. DATE
p_gpa   Prospect/applicant high school GPA. VARCHAR2(24)
p_class_rank   Prospect/applicant high school class rank. NUMBER(4)
p_class_size   Size of the prospect/applicant high school graduating class size. NUMBER(4)
p_percentile   Prospect/applicant class percentile as related to class rank and size. NUMBER(5,2)
p_dplm_code   Prospect/applicant high school diploma type, such as college prep. VARCHAR2(2)
p_coll_prep_ind   Indicator for whether the prospect/applicant high school program was college prep.  Values are "Y" or null. VARCHAR2(1)
p_trans_recv_date   Date the prospect/applicant high school transcript was received. DATE
p_admr_code   Admission checklist request item code which may be cross referenced, such as receipt of high school transcript here. VARCHAR2(4)
p_user_id   Oracle ID of the user who inserted or last updated the data. VARCHAR2(30)
p_data_origin   Source system that created or updated the row. VARCHAR2(30)