index

Package sb_edi_acad_sess_sum_rules

This package provides the support subprograms for the EDI Academic Session Summary API (sb_edi_acad_sess_sum).
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.
p_internal_record_id   Database ROWID. VARCHAR2(18) Required.

p_register_entity 

PROCEDURE p_register_entity(p_operation_type     NUMBER,
                            p_dcmt_seqno         shrsums.shrsums_dcmt_seqno%TYPE,
                            p_ases_seqno         shrsums.shrsums_ases_seqno%TYPE,
                            p_gpa_seqno          shrsums.shrsums_gpa_seqno%TYPE,
                            p_ctyp_code          shrsums.shrsums_ctyp_code%TYPE,
                            p_slvl_code          shrsums.shrsums_slvl_code%TYPE,
                            p_gpa_hours          shrsums.shrsums_gpa_hours%TYPE,
                            p_hours_attempted    shrsums.shrsums_hours_attempted%TYPE,
                            p_hours_earned       shrsums.shrsums_hours_earned%TYPE,
                            p_gpa_low            shrsums.shrsums_gpa_low%TYPE,
                            p_gpa_high           shrsums.shrsums_gpa_high%TYPE,
                            p_gpa                shrsums.shrsums_gpa%TYPE,
                            p_gpa_excess_ind     shrsums.shrsums_gpa_excess_ind%TYPE,
                            p_class_rank         shrsums.shrsums_class_rank%TYPE,
                            p_class_size         shrsums.shrsums_class_size%TYPE,
                            p_rdql_code          shrsums.shrsums_rdql_code%TYPE,
                            p_rank_date          shrsums.shrsums_rank_date%TYPE,
                            p_cum_sum            shrsums.shrsums_cum_sum%TYPE,
                            p_data_origin        shrsums.shrsums_data_origin%TYPE,
                            p_user_id            shrsums.shrsums_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 ID number. NUMBER(8) Required Key.
p_ases_seqno   EDI academic session sequence number. NUMBER(4) Required Key.
p_gpa_seqno   EDI GPA sequence number. NUMBER(4) 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_cum_sum   EDI Yes/No condition or response code.  Indicator to specify if this segment is included as a cumulative summary of all work up to this point (Y), a summary of work for this session only (N), or unknown (U or null). VARCHAR2(1).
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      shrsums.shrsums_dcmt_seqno%TYPE,
                     p_ases_seqno      shrsums.shrsums_ases_seqno%TYPE,
                     p_gpa_seqno       shrsums.shrsums_gpa_seqno%TYPE,
                     p_ctyp_code       shrsums.shrsums_ctyp_code%TYPE DEFAULT NULL,
                     p_slvl_code       shrsums.shrsums_slvl_code%TYPE DEFAULT NULL,
                     p_gpa_hours       shrsums.shrsums_gpa_hours%TYPE DEFAULT NULL,
                     p_hours_attempted shrsums.shrsums_hours_attempted%TYPE DEFAULT NULL,
                     p_hours_earned    shrsums.shrsums_hours_earned%TYPE DEFAULT NULL,
                     p_gpa_low         shrsums.shrsums_gpa_low%TYPE DEFAULT NULL,
                     p_gpa_high        shrsums.shrsums_gpa_high%TYPE DEFAULT NULL,
                     p_gpa             shrsums.shrsums_gpa%TYPE DEFAULT NULL,
                     p_gpa_excess_ind  shrsums.shrsums_gpa_excess_ind%TYPE DEFAULT NULL,
                     p_class_rank      shrsums.shrsums_class_rank%TYPE DEFAULT NULL,
                     p_class_size      shrsums.shrsums_class_size%TYPE DEFAULT NULL,
                     p_rdql_code       shrsums.shrsums_rdql_code%TYPE DEFAULT NULL,
                     p_rank_date       shrsums.shrsums_rank_date%TYPE DEFAULT NULL,
                     p_cum_sum         shrsums.shrsums_cum_sum%TYPE DEFAULT NULL,
                     p_data_origin     shrsums.shrsums_data_origin%TYPE DEFAULT NULL,
                     p_user_id         shrsums.shrsums_user_id%TYPE DEFAULT gb_common.f_sct_user);

Validates all the data in the record.

Parameters
p_dcmt_seqno   EDI document ID number. NUMBER(8) Required Key.
p_ases_seqno   EDI academic session sequence number. NUMBER(4) Required Key.
p_gpa_seqno   EDI GPA sequence number. NUMBER(4) 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_cum_sum   EDI Yes/No condition or response code.  Indicator to specify if this segment is included as a cumulative summary of all work up to this point (Y), a summary of work for this session only (N), or unknown (U or null). VARCHAR2(1).
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).