|
Package sb_edi_course_rules This package provides the support subprograms for the EDI Course API (sb_edi_course).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 shrcrsr.shrcrsr_dcmt_seqno%TYPE,
p_ases_seqno shrcrsr.shrcrsr_ases_seqno%TYPE,
p_basi_code shrcrsr.shrcrsr_basi_code%TYPE,
p_cred_code shrcrsr.shrcrsr_cred_code%TYPE,
p_hours_attempted shrcrsr.shrcrsr_hours_attempted%TYPE,
p_hours_earned shrcrsr.shrcrsr_hours_earned%TYPE,
p_amcas_grade_qual shrcrsr.shrcrsr_amcas_grade_qual%TYPE,
p_grade shrcrsr.shrcrsr_grade%TYPE,
p_honors_ind shrcrsr.shrcrsr_honors_ind%TYPE,
p_course_level shrcrsr.shrcrsr_course_level%TYPE,
p_repeat_ind shrcrsr.shrcrsr_repeat_ind%TYPE,
p_xcurr_code_qual shrcrsr.shrcrsr_xcurr_code_qual%TYPE,
p_xcurr_code shrcrsr.shrcrsr_xcurr_code%TYPE,
p_quality_points shrcrsr.shrcrsr_quality_points%TYPE,
p_k12_grade_level shrcrsr.shrcrsr_k12_grade_level%TYPE,
p_subj_code shrcrsr.shrcrsr_subj_code%TYPE,
p_crse_numb shrcrsr.shrcrsr_crse_numb%TYPE,
p_crse_title shrcrsr.shrcrsr_crse_title%TYPE,
p_k12_days_attend shrcrsr.shrcrsr_k12_days_attend%TYPE,
p_k12_days_absent shrcrsr.shrcrsr_k12_days_absent%TYPE,
p_drop_date shrcrsr.shrcrsr_drop_date%TYPE,
p_override_code shrcrsr.shrcrsr_override_code%TYPE,
p_duplicate shrcrsr.shrcrsr_duplicate%TYPE,
p_data_origin shrcrsr.shrcrsr_data_origin%TYPE,
p_user_id shrcrsr.shrcrsr_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_ude shrcrsr.shrcrsr_ude%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 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. | |
| p_ases_seqno |
EDI academic session sequence number. NUMBER(4) Required. | |
| p_basi_code |
EDI basis for academic credit. VARCHAR2(1). | |
| p_cred_code |
EDI academic credit type code. VARCHAR2(1). | |
| p_hours_attempted |
EDI credit hours attempted. NUMBER(11,3). | |
| p_hours_earned |
EDI credit hours earned. NUMBER(11,3). | |
| p_amcas_grade_qual |
EDI grading scheme. VARCHAR2(14). | |
| p_grade |
EDI academic grade. VARCHAR2(6). | |
| p_honors_ind |
EDI honors indicator. VARCHAR2(1). | |
| p_course_level |
EDI academic course level code. VARCHAR2(2). | |
| p_repeat_ind |
EDI course repeat or number count indicator. VARCHAR2(1). | |
| p_xcurr_code_qual |
EDI curriculum code qualifier. VARCHAR2(2). | |
| p_xcurr_code |
EDI curriculum code. VARCHAR2(20). | |
| p_quality_points |
EDI academic quality points. NUMBER(17,6). | |
| p_k12_grade_level |
EDI course grade level (K-12). VARCHAR2(2). | |
| p_subj_code |
EDI subject abbreviation. VARCHAR2(35). | |
| p_crse_numb |
EDI course number. VARCHAR2(30). | |
| p_crse_title |
EDI course title. VARCHAR2(35). | |
| p_k12_days_attend |
EDI days attended (K-12). NUMBER(4). | |
| p_k12_days_absent |
EDI days absent (K-12). NUMBER(4). | |
| p_drop_date |
EDI student drop date. VARCHAR2(6). | |
| p_override_code |
EDI override academic course source code. VARCHAR2(2). | |
| p_duplicate |
Indicates a duplicate transfer subject/course for a given EDI transcript. VARCHAR2(2). | |
| 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_ude |
User-defined extension data under the course element. CLOB. | |
| p_internal_record_id |
Database ROWID. VARCHAR2(18) Required. |
p_validate
PROCEDURE p_validate(p_dcmt_seqno shrcrsr.shrcrsr_dcmt_seqno%TYPE,
p_ases_seqno shrcrsr.shrcrsr_ases_seqno%TYPE,
p_basi_code shrcrsr.shrcrsr_basi_code%TYPE DEFAULT NULL,
p_cred_code shrcrsr.shrcrsr_cred_code%TYPE DEFAULT NULL,
p_hours_attempted shrcrsr.shrcrsr_hours_attempted%TYPE DEFAULT NULL,
p_hours_earned shrcrsr.shrcrsr_hours_earned%TYPE DEFAULT NULL,
p_amcas_grade_qual shrcrsr.shrcrsr_amcas_grade_qual%TYPE DEFAULT NULL,
p_grade shrcrsr.shrcrsr_grade%TYPE DEFAULT NULL,
p_honors_ind shrcrsr.shrcrsr_honors_ind%TYPE DEFAULT NULL,
p_course_level shrcrsr.shrcrsr_course_level%TYPE DEFAULT NULL,
p_repeat_ind shrcrsr.shrcrsr_repeat_ind%TYPE DEFAULT NULL,
p_xcurr_code_qual shrcrsr.shrcrsr_xcurr_code_qual%TYPE DEFAULT NULL,
p_xcurr_code shrcrsr.shrcrsr_xcurr_code%TYPE DEFAULT NULL,
p_quality_points shrcrsr.shrcrsr_quality_points%TYPE DEFAULT NULL,
p_k12_grade_level shrcrsr.shrcrsr_k12_grade_level%TYPE DEFAULT NULL,
p_subj_code shrcrsr.shrcrsr_subj_code%TYPE DEFAULT NULL,
p_crse_numb shrcrsr.shrcrsr_crse_numb%TYPE DEFAULT NULL,
p_crse_title shrcrsr.shrcrsr_crse_title%TYPE DEFAULT NULL,
p_k12_days_attend shrcrsr.shrcrsr_k12_days_attend%TYPE DEFAULT NULL,
p_k12_days_absent shrcrsr.shrcrsr_k12_days_absent%TYPE DEFAULT NULL,
p_drop_date shrcrsr.shrcrsr_drop_date%TYPE DEFAULT NULL,
p_override_code shrcrsr.shrcrsr_override_code%TYPE DEFAULT NULL,
p_duplicate shrcrsr.shrcrsr_duplicate%TYPE DEFAULT NULL,
p_data_origin shrcrsr.shrcrsr_data_origin%TYPE DEFAULT NULL,
p_user_id shrcrsr.shrcrsr_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_ude shrcrsr.shrcrsr_ude%TYPE DEFAULT NULL);
Validates all the data in the record.
| Parameters |
| p_dcmt_seqno |
EDI document ID number. NUMBER(8) Required. | |
| p_ases_seqno |
EDI academic session sequence number. NUMBER(4) Required. | |
| p_basi_code |
EDI basis for academic credit. VARCHAR2(1). | |
| p_cred_code |
EDI academic credit type code. VARCHAR2(1). | |
| p_hours_attempted |
EDI credit hours attempted. NUMBER(11,3). | |
| p_hours_earned |
EDI credit hours earned. NUMBER(11,3). | |
| p_amcas_grade_qual |
EDI grading scheme. VARCHAR2(14). | |
| p_grade |
EDI academic grade. VARCHAR2(6). | |
| p_honors_ind |
EDI honors indicator. VARCHAR2(1). | |
| p_course_level |
EDI academic course level code. VARCHAR2(2). | |
| p_repeat_ind |
EDI course repeat or number count indicator. VARCHAR2(1). | |
| p_xcurr_code_qual |
EDI curriculum code qualifier. VARCHAR2(2). | |
| p_xcurr_code |
EDI curriculum code. VARCHAR2(20). | |
| p_quality_points |
EDI academic quality points. NUMBER(17,6). | |
| p_k12_grade_level |
EDI course grade level (K-12). VARCHAR2(2). | |
| p_subj_code |
EDI subject abbreviation. VARCHAR2(35). | |
| p_crse_numb |
EDI course number. VARCHAR2(30). | |
| p_crse_title |
EDI course title. VARCHAR2(35). | |
| p_k12_days_attend |
EDI days attended (K-12). NUMBER(4). | |
| p_k12_days_absent |
EDI days absent (K-12). NUMBER(4). | |
| p_drop_date |
EDI student drop date. VARCHAR2(6). | |
| p_override_code |
EDI override academic course source code. VARCHAR2(2). | |
| p_duplicate |
Indicates a duplicate transfer subject/course for a given EDI transcript. VARCHAR2(2). | |
| 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_ude |
User-defined extension data under the course element. CLOB. |