index

Package sb_edi_course

This package provides the Common Business Interface for the EDI Course API (sb_edi_course).
For use with internal processing to produce the XML transcript.

Program units
f_api_version   Returns the API version number.
f_exists   Checks to see if a record exists.
f_isequal   Compares two records for equality.
f_query_all   Selects all records for the entity.
f_query_one   Selects one record using the key.
f_query_by_rowid   Selects one record using the ROWID.
f_query_one_lock   Selects one record and locks it.
p_create   Creates a record.
p_delete   Deletes a record.
p_lock   Locks a record.
p_update   Updates a record.

Types
edi_course_rec   Business Entity record type
edi_course_ref   Entity cursor variable type
edi_course_tab   Entity table type

Constants
M_ENTITY_NAME   Business Entity Name

M_ENTITY_NAME 

M_ENTITY_NAME    CONSTANT VARCHAR2(10) := 'EDI_COURSE';

Business Entity Name

edi_course_rec 

TYPE edi_course_rec IS RECORD (
  r_dcmt_seqno              shrcrsr.shrcrsr_dcmt_seqno%TYPE,
  r_ases_seqno              shrcrsr.shrcrsr_ases_seqno%TYPE,
  r_basi_code               shrcrsr.shrcrsr_basi_code%TYPE,
  r_cred_code               shrcrsr.shrcrsr_cred_code%TYPE,
  r_hours_attempted         shrcrsr.shrcrsr_hours_attempted%TYPE,
  r_hours_earned            shrcrsr.shrcrsr_hours_earned%TYPE,
  r_amcas_grade_qual        shrcrsr.shrcrsr_amcas_grade_qual%TYPE,
  r_grade                   shrcrsr.shrcrsr_grade%TYPE,
  r_honors_ind              shrcrsr.shrcrsr_honors_ind%TYPE,
  r_course_level            shrcrsr.shrcrsr_course_level%TYPE,
  r_repeat_ind              shrcrsr.shrcrsr_repeat_ind%TYPE,
  r_xcurr_code_qual         shrcrsr.shrcrsr_xcurr_code_qual%TYPE,
  r_xcurr_code              shrcrsr.shrcrsr_xcurr_code%TYPE,
  r_quality_points          shrcrsr.shrcrsr_quality_points%TYPE,
  r_k12_grade_level         shrcrsr.shrcrsr_k12_grade_level%TYPE,
  r_subj_code               shrcrsr.shrcrsr_subj_code%TYPE,
  r_crse_numb               shrcrsr.shrcrsr_crse_numb%TYPE,
  r_crse_title              shrcrsr.shrcrsr_crse_title%TYPE,
  r_k12_days_attend         shrcrsr.shrcrsr_k12_days_attend%TYPE,
  r_k12_days_absent         shrcrsr.shrcrsr_k12_days_absent%TYPE,
  r_drop_date               shrcrsr.shrcrsr_drop_date%TYPE,
  r_override_code           shrcrsr.shrcrsr_override_code%TYPE,
  r_duplicate               shrcrsr.shrcrsr_duplicate%TYPE,
  r_data_origin             shrcrsr.shrcrsr_data_origin%TYPE,
  r_user_id                 shrcrsr.shrcrsr_user_id%TYPE,
  r_ude                     shrcrsr.shrcrsr_ude%TYPE,
  r_internal_record_id      gb_common.internal_record_id_type);

Business Entity record type

edi_course_ref 

TYPE edi_course_ref IS REF CURSOR RETURN edi_course_rec;

Entity cursor variable type

edi_course_tab 

TYPE edi_course_tab IS TABLE OF edi_course_rec INDEX BY BINARY_INTEGER;

Entity table type

f_api_version 

FUNCTION f_api_version RETURN PLS_INTEGER;

Returns the API version number.

Returns
Version of the API signature. Changes only when the signature changes.

f_exists 

FUNCTION f_exists(p_rowid gb_common.internal_record_id_type)
   RETURN VARCHAR2;

Checks to see if a record exists.

Parameters
p_rowid   Database ROWID of the record to be selected. VARCHAR2(18).

Returns
Y if found, otherwise N.

f_isequal 

FUNCTION f_isequal(rec_one edi_course_rec,
                   rec_two edi_course_rec) RETURN VARCHAR2;

Compares two records for equality.
Tests each field of rec_one against the corresponding field of rec_two. Two null values are considered equal.

Parameters
rec_one   The first record to compare. type edi_course_rec Required.
rec_two   The second record to compare. type edi_course_rec Required.

Returns
Y if all values in records are equal, otherwise N. Nulls match Nulls.

f_query_all 

FUNCTION f_query_all(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,
                     p_ude              shrcrsr.shrcrsr_ude%TYPE)
   RETURN edi_course_ref;

Selects all records for the entity.

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.

Returns
A cursor variable that will fetch the set of records.

f_query_one 

FUNCTION f_query_one(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,
                     p_ude              shrcrsr.shrcrsr_ude%TYPE)
   RETURN edi_course_ref;

Selects one record using the key.

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.

Returns
A cursor variable that will fetch exactly one record.

f_query_by_rowid 

FUNCTION f_query_by_rowid(p_rowid gb_common.internal_record_id_type)
   RETURN edi_course_ref;

Selects one record using the ROWID.

Parameters
p_rowid   Database ROWID of the record to be selected. VARCHAR2(18) Required.

Returns
A cursor variable that will fetch exactly one record.

f_query_one_lock 

FUNCTION f_query_one_lock(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,
                          p_ude              shrcrsr.shrcrsr_ude%TYPE,
                          p_rowid            gb_common.internal_record_id_type)
   RETURN edi_course_ref;

Selects one record and locks it.

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.
p_rowid   Database ROWID of the record to be selected. VARCHAR2(18).

Returns
A cursor variable for one record, locking the record.

p_create 

PROCEDURE p_create(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,
                   p_rowid_out        OUT gb_common.internal_record_id_type);

Creates a 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.
p_rowid_out   Database ROWID of the record to be created. VARCHAR2(18) Required.

p_delete 

PROCEDURE p_delete(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,
                   p_ude              shrcrsr.shrcrsr_ude%TYPE,
                   p_rowid            gb_common.internal_record_id_type);

Deletes a 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.
p_rowid   Database ROWID of the record to be deleted. VARCHAR2(18).

p_lock 

PROCEDURE p_lock(p_rowid_inout IN OUT gb_common.internal_record_id_type);

Locks a record.
If the ROWID is not passed in, the record is located using the key values and the ROWID of the locked row is passed in p_rowid_inout.

Parameters
p_rowid_inout   Database ROWID of the record to be locked. VARCHAR2(18) Required.

p_update 

PROCEDURE p_update(p_dcmt_seqno       shrcrsr.shrcrsr_dcmt_seqno%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_ases_seqno       shrcrsr.shrcrsr_ases_seqno%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_basi_code        shrcrsr.shrcrsr_basi_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_cred_code        shrcrsr.shrcrsr_cred_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_hours_attempted  shrcrsr.shrcrsr_hours_attempted%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_hours_earned     shrcrsr.shrcrsr_hours_earned%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_amcas_grade_qual shrcrsr.shrcrsr_amcas_grade_qual%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_grade            shrcrsr.shrcrsr_grade%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_honors_ind       shrcrsr.shrcrsr_honors_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_course_level     shrcrsr.shrcrsr_course_level%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_repeat_ind       shrcrsr.shrcrsr_repeat_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_xcurr_code_qual  shrcrsr.shrcrsr_xcurr_code_qual%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_xcurr_code       shrcrsr.shrcrsr_xcurr_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_quality_points   shrcrsr.shrcrsr_quality_points%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_k12_grade_level  shrcrsr.shrcrsr_k12_grade_level%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_subj_code        shrcrsr.shrcrsr_subj_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_crse_numb        shrcrsr.shrcrsr_crse_numb%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_crse_title       shrcrsr.shrcrsr_crse_title%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_k12_days_attend  shrcrsr.shrcrsr_k12_days_attend%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_k12_days_absent  shrcrsr.shrcrsr_k12_days_absent%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_drop_date        shrcrsr.shrcrsr_drop_date%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_override_code    shrcrsr.shrcrsr_override_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_duplicate        shrcrsr.shrcrsr_duplicate%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_data_origin      shrcrsr.shrcrsr_data_origin%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_user_id          shrcrsr.shrcrsr_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_ude              shrcrsr.shrcrsr_ude%TYPE DEFAULT dml_common.f_unspecified_clob,
                   p_rowid            gb_common.internal_record_id_type);

Updates a 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.
p_rowid   Database ROWID of the record to be updated. VARCHAR2(18).