index

Package sb_edi_acad_summ_rules

This package provides the support subprograms for the EDI Academic Summary API (sb_edi_acad_summ).
For use with internal processing to produce the XML transcript.

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 the delete operations.

Parameters
p_operation_type   Type of DML operation: create, update, delete. NUMBER Required Key.
p_internal_record_id   Database ROWID. VARCHAR2(18) Required.

p_register_entity 

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_dcmt_seqno         shrsuma.shrsuma_dcmt_seqno%TYPE,
                            p_gpa_seqno          shrsuma.shrsuma_gpa_seqno%TYPE,
                            p_ctyp_code          shrsuma.shrsuma_ctyp_code%TYPE,
                            p_slvl_code          shrsuma.shrsuma_slvl_code%TYPE,
                            p_gpa_hours          shrsuma.shrsuma_gpa_hours%TYPE,
                            p_hours_attempted    shrsuma.shrsuma_hours_attempted%TYPE,
                            p_hours_earned       shrsuma.shrsuma_hours_earned%TYPE,
                            p_gpa_low            shrsuma.shrsuma_gpa_low%TYPE,
                            p_gpa_high           shrsuma.shrsuma_gpa_high%TYPE,
                            p_gpa                shrsuma.shrsuma_gpa%TYPE,
                            p_gpa_excess_ind     shrsuma.shrsuma_gpa_excess_ind%TYPE,
                            p_class_rank         shrsuma.shrsuma_class_rank%TYPE,
                            p_class_size         shrsuma.shrsuma_class_size%TYPE,
                            p_rdql_code          shrsuma.shrsuma_rdql_code%TYPE,
                            p_rank_date          shrsuma.shrsuma_rank_date%TYPE,
                            p_data_origin        shrsuma.shrsuma_data_origin%TYPE,
                            p_user_id            shrsuma.shrsuma_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, delete. NUMBER Required.
p_dcmt_seqno   EDI document sequence number. NUMBER(8) Required Key.
p_gpa_seqno   EDI GPA sequence number. NUMBER(8) Required Key.
p_ctyp_code   EDI credit type code. VARCHAR2(1).
p_slvl_code   EDI student course level code. VARCHAR2(2).
p_gpa_hours   EDI academic credit hours included in GPA. NUMBER(11,3).
p_hours_attempted   EDI academic credit hours attempted. NUMBER(11,3).
p_hours_earned   EDI academic credit hours earned. NUMBER(11,3).
p_gpa_low   EDI lowest possible grade average. NUMBER(23,9).
p_gpa_high   EDI highest possible grade average. NUMBER(23,9).
p_gpa   EDI academic grade point average. NUMBER(23,9).
p_gpa_excess_ind   EDI excessive GPA indicator. VARCHAR2(1).
p_class_rank   EDI position in class (K-12). NUMBER(4).
p_class_size   EDI total number in class (K-12). NUMBER(5).
p_rdql_code   EDI format code for class rank date. VARCHAR2(3).
p_rank_date   EDI class rank date. VARCHAR2(8).
p_data_origin   Source system that created or updated the row. VARCHAR2(30).
p_user_id   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_dcmt_seqno      shrsuma.shrsuma_dcmt_seqno%TYPE,
                     p_gpa_seqno       shrsuma.shrsuma_gpa_seqno%TYPE,
                     p_ctyp_code       shrsuma.shrsuma_ctyp_code%TYPE DEFAULT NULL,
                     p_slvl_code       shrsuma.shrsuma_slvl_code%TYPE DEFAULT NULL,
                     p_gpa_hours       shrsuma.shrsuma_gpa_hours%TYPE DEFAULT NULL,
                     p_hours_attempted shrsuma.shrsuma_hours_attempted%TYPE DEFAULT NULL,
                     p_hours_earned    shrsuma.shrsuma_hours_earned%TYPE DEFAULT NULL,
                     p_gpa_low         shrsuma.shrsuma_gpa_low%TYPE DEFAULT NULL,
                     p_gpa_high        shrsuma.shrsuma_gpa_high%TYPE DEFAULT NULL,
                     p_gpa             shrsuma.shrsuma_gpa%TYPE DEFAULT NULL,
                     p_gpa_excess_ind  shrsuma.shrsuma_gpa_excess_ind%TYPE DEFAULT NULL,
                     p_class_rank      shrsuma.shrsuma_class_rank%TYPE DEFAULT NULL,
                     p_class_size      shrsuma.shrsuma_class_size%TYPE DEFAULT NULL,
                     p_rdql_code       shrsuma.shrsuma_rdql_code%TYPE DEFAULT NULL,
                     p_rank_date       shrsuma.shrsuma_rank_date%TYPE DEFAULT NULL,
                     p_data_origin     shrsuma.shrsuma_data_origin%TYPE DEFAULT NULL,
                     p_user_id         shrsuma.shrsuma_user_id%TYPE DEFAULT gb_common.f_sct_user);

Validates all the data in the record.

Parameters
p_dcmt_seqno   EDI document sequence number. NUMBER(8) Required Key.
p_gpa_seqno   EDI GPA sequence number. NUMBER(8) Required Key.
p_ctyp_code   EDI credit type code. VARCHAR2(1).
p_slvl_code   EDI student course level code. VARCHAR2(2).
p_gpa_hours   EDI academic credit hours included in GPA. NUMBER(11,3).
p_hours_attempted   EDI academic credit hours attempted. NUMBER(11,3).
p_hours_earned   EDI academic credit hours earned. NUMBER(11,3).
p_gpa_low   EDI lowest possible grade average. NUMBER(23,9).
p_gpa_high   EDI highest possible grade average. NUMBER(23,9).
p_gpa   EDI academic grade point average. NUMBER(23,9).
p_gpa_excess_ind   EDI excessive GPA indicator. VARCHAR2(1).
p_class_rank   EDI position in class (K-12). NUMBER(4).
p_class_size   EDI total number in class (K-12). NUMBER(5).
p_rdql_code   EDI format code for class rank date. VARCHAR2(3).
p_rank_date   EDI class rank date. VARCHAR2(8).
p_data_origin   Source system that created or updated the row. VARCHAR2(30).
p_user_id   Oracle ID of the user who changed the record. VARCHAR2(30).