BANINST1@S10B80

index

Package sb_course_registration

NOTE: Please be advised that this API  is currently intended to only support internal operations.
To ensure data integrity,  this api  is not supported  when called by external applications or interfaces to manipulate data. The recommendation for external applications is to use message level integration  to integrate with this entitity in  SCT Banner.
 
This package provides the Common Business interface for the Course Registration API (sb_course_registration).
Course registration information includes the details of the current status of each student enrollment in a course section.  Student course enrollment information includes the course registration number (CRN), course registration status (such as registered, dropped, audit), status date, number of credit and billing hours, course level and grading mode as well as indicators to show if overrides were granted for any of the registration errors that may have been encountered during the registration process.  In addition Midterm and Final grades are posted to course registration records that are gradable.
 
Course registration information is used in several business processes and functions, including display of student schedule information, calculation of student enrollment time status, fee assessment and refunding calculations, enrolling verification processing and degree audit (CAPP) compliance processing.
 
Course registration always reflects the most current information for a student's registration in a specific course for a term.  The complete audit trail of course enrollment changes is captured and stored in the audit table SFRSTCA.
Course registration information is processed from the following sources based on business rules established by each institution:
  • Administrative processing of Student Course Registration.
  • Student Self-Service and Faculty and Advisor Self-Service.
  • Banner Voice Response.
  • Course Request and Schedule batch processing.
 
For the current release the API supports only the Query signature. The insert, update, and delete signatures and not supported. Any call to the insert, update, and delete signature will result in an error message. The API call is not supported for the current release.
Program units
f_api_version   Returns the API version number.
f_final_grade_exists   Checks to see if a final grade exists.
f_midterm_grade_exists   Checks to see if a midterm grade exists.
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
course_registration_rec   Entity record type
course_registration_ref   Entity cursor variable type
course_registration_tab   Entity table type

Constants
M_ENTITY_NAME   Business Entity name

M_ENTITY_NAME 

M_ENTITY_NAME    CONSTANT VARCHAR2(19) := 'COURSE_REGISTRATION';

Business Entity name

course_registration_rec 

TYPE course_registration_rec IS RECORD (
   r_term_code               sfrstcr.sfrstcr_term_code%TYPE,
   r_pidm                    sfrstcr.sfrstcr_pidm%TYPE,
   r_crn                     sfrstcr.sfrstcr_crn%TYPE,
   r_class_sort_key          sfrstcr.sfrstcr_class_sort_key%TYPE,
   r_reg_seq                 sfrstcr.sfrstcr_reg_seq%TYPE,
   r_ptrm_code               sfrstcr.sfrstcr_ptrm_code%TYPE,
   r_rsts_code               sfrstcr.sfrstcr_rsts_code%TYPE,
   r_rsts_date               sfrstcr.sfrstcr_rsts_date%TYPE,
   r_error_flag              sfrstcr.sfrstcr_error_flag%TYPE,
   r_rmsg_cde                sfrstcr.sfrstcr_rmsg_cde%TYPE,
   r_message                 sfrstcr.sfrstcr_message%TYPE,
   r_bill_hr                 sfrstcr.sfrstcr_bill_hr%TYPE,
   r_waiv_hr                 sfrstcr.sfrstcr_waiv_hr%TYPE,
   r_credit_hr               sfrstcr.sfrstcr_credit_hr%TYPE,
   r_bill_hr_hold            sfrstcr.sfrstcr_bill_hr_hold%TYPE,
   r_credit_hr_hold          sfrstcr.sfrstcr_credit_hr_hold%TYPE,
   r_gmod_code               sfrstcr.sfrstcr_gmod_code%TYPE,
   r_grde_code               sfrstcr.sfrstcr_grde_code%TYPE,
   r_grde_code_mid           sfrstcr.sfrstcr_grde_code_mid%TYPE,
   r_grde_date               sfrstcr.sfrstcr_grde_date%TYPE,
   r_dupl_over               sfrstcr.sfrstcr_dupl_over%TYPE,
   r_link_over               sfrstcr.sfrstcr_link_over%TYPE,
   r_corq_over               sfrstcr.sfrstcr_corq_over%TYPE,
   r_preq_over               sfrstcr.sfrstcr_preq_over%TYPE,
   r_time_over               sfrstcr.sfrstcr_time_over%TYPE,
   r_capc_over               sfrstcr.sfrstcr_capc_over%TYPE,
   r_levl_over               sfrstcr.sfrstcr_levl_over%TYPE,
   r_coll_over               sfrstcr.sfrstcr_coll_over%TYPE,
   r_majr_over               sfrstcr.sfrstcr_majr_over%TYPE,
   r_clas_over               sfrstcr.sfrstcr_clas_over%TYPE,
   r_appr_over               sfrstcr.sfrstcr_appr_over%TYPE,
   r_appr_received_ind       sfrstcr.sfrstcr_appr_received_ind%TYPE,
   r_add_date                sfrstcr.sfrstcr_add_date%TYPE,
   r_levl_code               sfrstcr.sfrstcr_levl_code%TYPE,
   r_camp_code               sfrstcr.sfrstcr_camp_code%TYPE,
   r_reserved_key            sfrstcr.sfrstcr_reserved_key%TYPE,
   r_attend_hr               sfrstcr.sfrstcr_attend_hr%TYPE,
   r_rept_over               sfrstcr.sfrstcr_rept_over%TYPE,
   r_rpth_over               sfrstcr.sfrstcr_rpth_over%TYPE,
   r_test_over               sfrstcr.sfrstcr_test_over%TYPE,
   r_camp_over               sfrstcr.sfrstcr_camp_over%TYPE,
   r_user                    sfrstcr.sfrstcr_user%TYPE,
   r_degc_over               sfrstcr.sfrstcr_degc_over%TYPE,
   r_prog_over               sfrstcr.sfrstcr_prog_over%TYPE,
   r_last_attend             sfrstcr.sfrstcr_last_attend%TYPE,
   r_gcmt_code               sfrstcr.sfrstcr_gcmt_code%TYPE,
   r_data_origin             sfrstcr.sfrstcr_data_origin%TYPE,
   r_assess_activity_date    sfrstcr.sfrstcr_assess_activity_date%TYPE,
   r_dept_over               sfrstcr.sfrstcr_dept_over%TYPE,
   r_atts_over               sfrstcr.sfrstcr_atts_over%TYPE,
   r_chrt_over               sfrstcr.sfrstcr_chrt_over%TYPE,
   r_wl_priority             sfrstcr.sfrstcr_wl_priority%TYPE,
   r_wl_priority_orig        sfrstcr.sfrstcr_wl_priority_orig%TYPE,
   r_grde_code_incmp_final   sfrstcr.sfrstcr_grde_code_incmp_final%TYPE,
   r_incomplete_ext_date     sfrstcr.sfrstcr_incomplete_ext_date%TYPE,
   r_mexc_over               sfrstcr.sfrstcr_mexc_over%TYPE,
   r_stsp_key_sequence       sfrstcr.sfrstcr_stsp_key_sequence%TYPE,
   r_internal_record_id      gb_common.internal_record_id_type,
   r_blck_code                sfrstcr.sfrstcr_blck_code%TYPE, 
   r_brdh_seq_num             sfrstcr.sfrstcr_brdh_seq_num%TYPE);

Entity record type

course_registration_ref 

TYPE course_registration_ref IS REF CURSOR RETURN course_registration_rec;

Entity cursor variable type

course_registration_tab 

TYPE course_registration_tab IS TABLE OF course_registration_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_final_grade_exists 

Function f_final_grade_exists(p_term_code sfrstcr.sfrstcr_term_code%TYPE,
                              p_pidm      sfrstcr.sfrstcr_pidm%TYPE,
                              p_crn       sfrstcr.sfrstcr_crn%TYPE)
  RETURN VARCHAR2

Checks to see if a final grade exists.

Parameters
p_term_code   Registration term code. VARCHAR2(6) Required Key
p_pidm   Internal Identification Number of the person registered. NUMBER(8) Required Key
p_crn   Course reference number associated with the class section. VARCHAR2(5) Required Key

Returns
Y if found, otherwise N.

f_midterm_grade_exists 

Function f_midterm_grade_exists(p_term_code sfrstcr.sfrstcr_term_code%TYPE,
                                p_pidm      sfrstcr.sfrstcr_pidm%TYPE,
                                p_crn       sfrstcr.sfrstcr_crn%TYPE)
  RETURN VARCHAR2

Checks to see if a midterm grade exists.

Parameters
p_term_code   Registration term code. VARCHAR2(6) Required Key
p_pidm   Internal Identification Number of the person registered. NUMBER(8) Required Key
p_crn   Course reference number associated with the class section. VARCHAR2(5) Required Key

Returns
Y if found, otherwise N.

f_exists 

Function f_exists(p_term_code sfrstcr.sfrstcr_term_code%TYPE,
                  p_pidm      sfrstcr.sfrstcr_pidm%TYPE,
                  p_crn       sfrstcr.sfrstcr_crn%TYPE,
                  p_rowid     VARCHAR2 DEFAULT NULL) RETURN VARCHAR2

Checks to see if a record exists.

Parameters
p_term_code   Registration term code. VARCHAR2(6) Required Key
p_pidm   Internal Identification Number of the person registered. NUMBER(8) Required Key
p_crn   Course reference number associated with the class section. VARCHAR2(5) Required Key
p_rowid   Database ROWID of the record to be selected. VARCHAR(18)

Returns
Y if found, otherwise N.

f_isequal 

Function f_isequal(rec_one course_registration_rec,
                   rec_two course_registration_rec) RETURN VARCHAR2

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

Parameters
rec_one   First record to compare. Type course_registration_rec. Required
rec_two   Second record to compare. Type course_registration_rec. Required

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

f_query_all 

Function f_query_all(p_term_code sfrstcr.sfrstcr_term_code%TYPE DEFAULT NULL,
                     p_pidm      sfrstcr.sfrstcr_pidm%TYPE,
                     p_crn       sfrstcr.sfrstcr_crn%TYPE DEFAULT NULL)
  RETURN course_registration_ref

Selects all records for the entity.
Note that parameters other than PIDM default to NULL and are ignored if not populated. AND is used when multiple criteria are given.

Parameters
p_term_code   Term associated with the transaction. Term code must be valid in STVTERM for student transactions or ARTERM for non-student transactions. VARCHAR2(6) Default NULL
p_pidm   Internal Identification Number of the person or non-person account, valid in SPRIDEN. * NUMBER(8) Required Key
p_crn   Course reference number associated with the class section. VARCHAR2(5) Default NULL

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

f_query_one 

Function f_query_one(p_term_code sfrstcr.sfrstcr_term_code%TYPE,
                     p_pidm      sfrstcr.sfrstcr_pidm%TYPE,
                     p_crn       sfrstcr.sfrstcr_crn%TYPE)
  RETURN course_registration_ref

Selects one record using the key.

Parameters
p_term_code   Registration term code. VARCHAR2(6) Required Key
p_pidm   Internal Identification Number of the person registered. NUMBER(8) Required Key
p_crn   Course reference number associated with the class section. VARCHAR2(5) Required Key

Returns
A cursor variable that will fetch exactly one record.

f_query_by_rowid 

Function f_query_by_rowid(p_rowid VARCHAR2) RETURN course_registration_ref

Selects one record using the ROWID.

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

Returns
A cursor variable that will fetch exactly one record.

f_query_one_lock 

Function f_query_one_lock(p_term_code sfrstcr.sfrstcr_term_code%TYPE,
                          p_pidm      sfrstcr.sfrstcr_pidm%TYPE,
                          p_crn       sfrstcr.sfrstcr_crn%TYPE,
                          p_rowid     VARCHAR2 DEFAULT NULL)
  RETURN course_registration_ref

Selects one record and locks it.

Parameters
p_term_code   Registration term code. VARCHAR2(6) Required Key
p_pidm   Internal Identification Number of the person registered. NUMBER(8) Required Key
p_crn   Course reference number associated with the class section. VARCHAR2(5) Required Key
p_rowid   Database ROWID of the record to be selected. VARCHAR(18)

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

p_create 

Procedure p_create(p_term_code             sfrstcr.sfrstcr_term_code%TYPE,
                   p_pidm                  sfrstcr.sfrstcr_pidm%TYPE,
                   p_crn                   sfrstcr.sfrstcr_crn%TYPE,
                   p_class_sort_key        sfrstcr.sfrstcr_class_sort_key%TYPE DEFAULT NULL,
                   p_reg_seq               sfrstcr.sfrstcr_reg_seq%TYPE,
                   p_ptrm_code             sfrstcr.sfrstcr_ptrm_code%TYPE DEFAULT NULL,
                   p_rsts_code             sfrstcr.sfrstcr_rsts_code%TYPE DEFAULT NULL,
                   p_rsts_date             sfrstcr.sfrstcr_rsts_date%TYPE DEFAULT NULL,
                   p_error_flag            sfrstcr.sfrstcr_error_flag%TYPE DEFAULT NULL,
                   p_rmsg_cde              sfrstcr.sfrstcr_rmsg_cde%TYPE DEFAULT NULL,
                   p_message               sfrstcr.sfrstcr_message%TYPE DEFAULT NULL,
                   p_bill_hr               sfrstcr.sfrstcr_bill_hr%TYPE DEFAULT NULL,
                   p_waiv_hr               sfrstcr.sfrstcr_waiv_hr%TYPE DEFAULT NULL,
                   p_credit_hr             sfrstcr.sfrstcr_credit_hr%TYPE DEFAULT NULL,
                   p_bill_hr_hold          sfrstcr.sfrstcr_bill_hr_hold%TYPE DEFAULT NULL,
                   p_credit_hr_hold        sfrstcr.sfrstcr_credit_hr_hold%TYPE DEFAULT NULL,
                   p_gmod_code             sfrstcr.sfrstcr_gmod_code%TYPE DEFAULT NULL,
                   p_grde_code             sfrstcr.sfrstcr_grde_code%TYPE DEFAULT NULL,
                   p_grde_code_mid         sfrstcr.sfrstcr_grde_code_mid%TYPE DEFAULT NULL,
                   p_grde_date             sfrstcr.sfrstcr_grde_date%TYPE DEFAULT NULL,
                   p_dupl_over             sfrstcr.sfrstcr_dupl_over%TYPE DEFAULT NULL,
                   p_link_over             sfrstcr.sfrstcr_link_over%TYPE DEFAULT NULL,
                   p_corq_over             sfrstcr.sfrstcr_corq_over%TYPE DEFAULT NULL,
                   p_preq_over             sfrstcr.sfrstcr_preq_over%TYPE DEFAULT NULL,
                   p_time_over             sfrstcr.sfrstcr_time_over%TYPE DEFAULT NULL,
                   p_capc_over             sfrstcr.sfrstcr_capc_over%TYPE DEFAULT NULL,
                   p_levl_over             sfrstcr.sfrstcr_levl_over%TYPE DEFAULT NULL,
                   p_coll_over             sfrstcr.sfrstcr_coll_over%TYPE DEFAULT NULL,
                   p_majr_over             sfrstcr.sfrstcr_majr_over%TYPE DEFAULT NULL,
                   p_clas_over             sfrstcr.sfrstcr_clas_over%TYPE DEFAULT NULL,
                   p_appr_over             sfrstcr.sfrstcr_appr_over%TYPE DEFAULT NULL,
                   p_appr_received_ind     sfrstcr.sfrstcr_appr_received_ind%TYPE DEFAULT NULL,
                   p_add_date              sfrstcr.sfrstcr_add_date%TYPE,
                   p_levl_code             sfrstcr.sfrstcr_levl_code%TYPE,
                   p_camp_code             sfrstcr.sfrstcr_camp_code%TYPE,
                   p_reserved_key          sfrstcr.sfrstcr_reserved_key%TYPE DEFAULT NULL,
                   p_attend_hr             sfrstcr.sfrstcr_attend_hr%TYPE DEFAULT NULL,
                   p_rept_over             sfrstcr.sfrstcr_rept_over%TYPE DEFAULT NULL,
                   p_rpth_over             sfrstcr.sfrstcr_rpth_over%TYPE DEFAULT NULL,
                   p_test_over             sfrstcr.sfrstcr_test_over%TYPE DEFAULT NULL,
                   p_camp_over             sfrstcr.sfrstcr_camp_over%TYPE DEFAULT NULL,
                   p_user                  sfrstcr.sfrstcr_user%TYPE DEFAULT NULL,
                   p_degc_over             sfrstcr.sfrstcr_degc_over%TYPE DEFAULT NULL,
                   p_prog_over             sfrstcr.sfrstcr_prog_over%TYPE DEFAULT NULL,
                   p_last_attend           sfrstcr.sfrstcr_last_attend%TYPE DEFAULT NULL,
                   p_gcmt_code             sfrstcr.sfrstcr_gcmt_code%TYPE DEFAULT NULL,
                   p_data_origin           sfrstcr.sfrstcr_data_origin%TYPE DEFAULT NULL,
                   p_assess_activity_date  sfrstcr.sfrstcr_assess_activity_date%TYPE DEFAULT NULL,
                   p_dept_over             sfrstcr.sfrstcr_dept_over%TYPE DEFAULT NULL,
                   p_atts_over             sfrstcr.sfrstcr_atts_over%TYPE DEFAULT NULL,
                   p_chrt_over             sfrstcr.sfrstcr_chrt_over%TYPE DEFAULT NULL,
                   p_wl_priority           sfrstcr.sfrstcr_wl_priority%TYPE DEFAULT NULL,
                   p_wl_priority_orig      sfrstcr.sfrstcr_wl_priority_orig%TYPE DEFAULT NULL,
                   p_grde_code_incmp_final sfrstcr.sfrstcr_grde_code_incmp_final%TYPE DEFAULT NULL,
                   p_incomplete_ext_date   sfrstcr.sfrstcr_incomplete_ext_date%TYPE DEFAULT NULL,
                   p_mexc_over             sfrstcr.sfrstcr_mexc_over%TYPE DEFAULT NULL,
                   p_stsp_key_sequence     sfrstcr.sfrstcr_stsp_key_sequence%TYPE DEFAULT NULL,
                   p_rowid_out             OUT VARCHAR2,
                   p_blck_code             sfrstcr.sfrstcr_blck_code%TYPE DEFAULT NULL,
                   p_brdh_seq_num          sfrstcr.sfrstcr_brdh_seq_num%TYPE DEFAULT NULL)

Creates a record.
NOTE: THE API CALL IS NOT SUPPORTED FOR THE CURRENT RELEASE. A call to this signature will result in an error message being delivered to the calling client.

Parameters
p_term_code   Registration term code. VARCHAR2(6) Required Key
p_pidm   Internal Identification Number of the person registered. NUMBER(8) Required Key
p_crn   Course reference number associated with the class section. VARCHAR2(5) Required Key
p_class_sort_key   Class of the registrant. NUMBER(4)
p_reg_seq   Sequence in which the student enrolled in the associated class section. NUMBER(4) Required
p_ptrm_code   Part-Of-Term code associated with the CRN. VARCHAR2(3)
p_rsts_code   Course registration status associated with the CRN. VARCHAR2(2)
p_rsts_date   Date associated with the course registration status of the CRN. DATE
p_error_flag   Error associated with the registration of the CRN, if applicable. Valid values are F=Fatal, D=Do not count in enrollment, L=Waitlisted, O=Override. VARCHAR2(1)
p_rmsg_cde   Message type code associated with the registration of the CRN. VARCHAR2(4)
p_message   Message associated with the registration of the CRN. VARCHAR2(200)
p_bill_hr   Billing hours associated with the CRN. NUMBER(7,3)
p_waiv_hr   Waived hours associated with the CRN. NUMBER(7,3)
p_credit_hr   Credit hours associated with the CRN. NUMBER(7,3)
p_bill_hr_hold   Billing hours to hold for reinstatements. NUMBER(7,3)
p_credit_hr_hold   Credit hours to hold for reinstatements. NUMBER(7,3)
p_gmod_code   Grade mode associated with the CRN. VARCHAR2(1)
p_grde_code   Grade code associated with the CRN. VARCHAR2(6)
p_grde_code_mid   Midterm grade code associated with the CRN. VARCHAR2(6)
p_grde_date   Date associated with the grade of the CRN. DATE
p_dupl_over   Duplicate course override of the CRN. VARCHAR2(1)
p_link_over   Link override of the CRN. VARCHAR2(1)
p_corq_over   Corequisite override of the CRN. VARCHAR2(1)
p_preq_over   Prerequisite override of the CRN. VARCHAR2(1)
p_time_over   Time conflict override of the CRN. VARCHAR2(1)
p_capc_over   Capacity override of the CRN. VARCHAR2(1)
p_levl_over   Level restriction override of the CRN. VARCHAR2(1)
p_coll_over   College restriction override of the CRN. VARCHAR2(1)
p_majr_over   Major restriction override of the CRN. VARCHAR2(1)
p_clas_over   Class restriction override of the CRN. VARCHAR2(1)
p_appr_over   Special approval override of the CRN. VARCHAR2(1)
p_appr_received_ind   Special approval received indicator for the CRN. VARCHAR2(1)
p_add_date   Add date of the registrant in the CRN. DATE Required
p_levl_code   Level the registrant is enrolled for the CRN. VARCHAR2(2) Required
p_camp_code   Campus code of the CRN. VARCHAR2(3) Required
p_reserved_key   Student Course Registration Table Reserved Key. VARCHAR2(8)
p_attend_hr   Number of hours the student attended the class. NUMBER(9,3)
p_rept_over   Repeat course restriction override of the CRN. VARCHAR2(1)
p_rpth_over   Repeat course hour restriction override of the CRN. VARCHAR2(1)
p_test_over   Test score restriction override of the CRN. VARCHAR2(1)
p_camp_over   Campus Registration Restriction override code. VARCHAR2(1)
p_user   Oracle ID of the user who entered the registration request. VARCHAR2(30)
p_degc_over   Degree restriction override indicator. VARCHAR2(1)
p_prog_over   Program restriction override indicator. VARCHAR2(1)
p_last_attend   Date the student last attended the class. DATE
p_gcmt_code   Grade comment (result code) for the section. VARCHAR2(7)
p_data_origin   Source system that generated the data. VARCHAR2(30)
p_assess_activity_date   Date of registration activity that impacted Fee Assessment. DATE
p_dept_over   Department restriction override indicator. VARCHAR2(1)
p_atts_over   Student attribute restriction override indicator. VARCHAR2(1)
p_chrt_over   Cohort restriction override indicator. VARCHAR2(1)
p_wl_priority   Waitlist Priority Number . NUMBER (11,6)
p_wl_priority_orig   Wheter Waitlist Priority Number was system or manually generated. VARCHAR2(1)
p_grde_code_incmp_final   Actual Grade code to identify default final grade for incomplete coursework. VARCHAR2(6)
p_incomplete_ext_date   Date to identify when the default final grade will be applied if coursework is incomplete. DATE
p_mexc_over   Mutual Exclusion restriction override indicator. VARCHAR2(1)
p_stsp_key_sequence   The key sequence of the learner study path under which the CRN is registered. NUMBER(2)
p_rowid_out   Database ROWID of the record to be created. VARCHAR(18) Required
p_blck_code   Block code student is registered. VAHRCHAR2(10) Optional
p_brdh_seq_num   Sequence number that uniquely identifies the rule for block assignment. NUMBER(7) Optional

p_delete 

Procedure p_delete(p_term_code sfrstcr.sfrstcr_term_code%TYPE,
                   p_pidm      sfrstcr.sfrstcr_pidm%TYPE,
                   p_crn       sfrstcr.sfrstcr_crn%TYPE,
                   p_rowid     VARCHAR2 DEFAULT NULL)

Deletes a record.
NOTE: THE API CALL IS NOT SUPPORTED FOR THE CURRENT RELEASE. A call to this signature will result in an error message being delivered to the calling client.

Parameters
p_term_code   Registration term code. VARCHAR2(6) Required Key
p_pidm   Internal Identification Number of the person registered. NUMBER(8) Required Key
p_crn   Course reference number associated with the class section. VARCHAR2(5) Required Key
p_rowid   Database ROWID of the record to be deleted. VARCHAR(18)

p_lock 

Procedure p_lock(p_term_code   sfrstcr.sfrstcr_term_code%TYPE,
                 p_pidm        sfrstcr.sfrstcr_pidm%TYPE,
                 p_crn         sfrstcr.sfrstcr_crn%TYPE,
                 p_rowid_inout IN OUT VARCHAR2)

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_term_code   Registration term code. VARCHAR2(6) Required Key
p_pidm   Internal Identification Number of the person registered. NUMBER(8) Required Key
p_crn   Course reference number associated with the class section. VARCHAR2(5) Required Key
p_rowid_inout   Database ROWID of the record to be locked. VARCHAR(18) Required

p_update 

Procedure p_update(p_term_code             sfrstcr.sfrstcr_term_code%TYPE,
                   p_pidm                  sfrstcr.sfrstcr_pidm%TYPE,
                   p_crn                   sfrstcr.sfrstcr_crn%TYPE,
                   p_class_sort_key        sfrstcr.sfrstcr_class_sort_key%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_reg_seq               sfrstcr.sfrstcr_reg_seq%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_ptrm_code             sfrstcr.sfrstcr_ptrm_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_rsts_code             sfrstcr.sfrstcr_rsts_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_rsts_date             sfrstcr.sfrstcr_rsts_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_error_flag            sfrstcr.sfrstcr_error_flag%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_rmsg_cde              sfrstcr.sfrstcr_rmsg_cde%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_message               sfrstcr.sfrstcr_message%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_bill_hr               sfrstcr.sfrstcr_bill_hr%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_waiv_hr               sfrstcr.sfrstcr_waiv_hr%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_credit_hr             sfrstcr.sfrstcr_credit_hr%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_bill_hr_hold          sfrstcr.sfrstcr_bill_hr_hold%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_credit_hr_hold        sfrstcr.sfrstcr_credit_hr_hold%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_gmod_code             sfrstcr.sfrstcr_gmod_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_grde_code             sfrstcr.sfrstcr_grde_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_grde_code_mid         sfrstcr.sfrstcr_grde_code_mid%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_grde_date             sfrstcr.sfrstcr_grde_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_dupl_over             sfrstcr.sfrstcr_dupl_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_link_over             sfrstcr.sfrstcr_link_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_corq_over             sfrstcr.sfrstcr_corq_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_preq_over             sfrstcr.sfrstcr_preq_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_time_over             sfrstcr.sfrstcr_time_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_capc_over             sfrstcr.sfrstcr_capc_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_levl_over             sfrstcr.sfrstcr_levl_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_coll_over             sfrstcr.sfrstcr_coll_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_majr_over             sfrstcr.sfrstcr_majr_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_clas_over             sfrstcr.sfrstcr_clas_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_appr_over             sfrstcr.sfrstcr_appr_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_appr_received_ind     sfrstcr.sfrstcr_appr_received_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_add_date              sfrstcr.sfrstcr_add_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_levl_code             sfrstcr.sfrstcr_levl_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_camp_code             sfrstcr.sfrstcr_camp_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_reserved_key          sfrstcr.sfrstcr_reserved_key%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_attend_hr             sfrstcr.sfrstcr_attend_hr%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_rept_over             sfrstcr.sfrstcr_rept_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_rpth_over             sfrstcr.sfrstcr_rpth_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_test_over             sfrstcr.sfrstcr_test_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_camp_over             sfrstcr.sfrstcr_camp_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_user                  sfrstcr.sfrstcr_user%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_degc_over             sfrstcr.sfrstcr_degc_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_prog_over             sfrstcr.sfrstcr_prog_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_last_attend           sfrstcr.sfrstcr_last_attend%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_gcmt_code             sfrstcr.sfrstcr_gcmt_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_data_origin           sfrstcr.sfrstcr_data_origin%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_assess_activity_date  sfrstcr.sfrstcr_assess_activity_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_dept_over             sfrstcr.sfrstcr_dept_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_atts_over             sfrstcr.sfrstcr_atts_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_chrt_over             sfrstcr.sfrstcr_chrt_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_wl_priority           sfrstcr.sfrstcr_wl_priority%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_wl_priority_orig      sfrstcr.sfrstcr_wl_priority_orig%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_grde_code_incmp_final sfrstcr.sfrstcr_grde_code_incmp_final%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_incomplete_ext_date   sfrstcr.sfrstcr_incomplete_ext_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_mexc_over             sfrstcr.sfrstcr_mexc_over%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_stsp_key_sequence     sfrstcr.sfrstcr_stsp_key_sequence%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_rowid                 VARCHAR2 DEFAULT NULL,
                   p_blck_code             sfrstcr.sfrstcr_blck_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_brdh_seq_num          sfrstcr.sfrstcr_brdh_seq_num%TYPE DEFAULT dml_common.f_unspecified_number)

Updates a record.
NOTE: THE API CALL IS NOT SUPPORTED FOR THE CURRENT RELEASE. A call to this signature will result in an error message being delivered to the calling client.

Parameters
p_term_code   Registration term code. VARCHAR2(6) Required Key
p_pidm   Internal Identification Number of the person registered. NUMBER(8) Required Key
p_crn   Course reference number associated with the class section. VARCHAR2(5) Required Key
p_class_sort_key   Class of the registrant. NUMBER(4)
p_reg_seq   Sequence in which the student enrolled in the associated class section. NUMBER(4) Required
p_ptrm_code   Part-Of-Term code associated with the CRN. VARCHAR2(3)
p_rsts_code   Course registration status associated with the CRN. VARCHAR2(2)
p_rsts_date   Date associated with the course registration status of the CRN. DATE
p_error_flag   Error associated with the registration of the CRN, if applicable. Valid values are F=Fatal, D=Do not count in enrollment, L=Waitlisted, O=Override. VARCHAR2(1)
p_rmsg_cde   Message type code associated with the registration of the CRN. VARCHAR2(4)
p_message   Message associated with the registration of the CRN. VARCHAR2(200)
p_bill_hr   Billing hours associated with the CRN. NUMBER(7,3)
p_waiv_hr   Waived hours associated with the CRN. NUMBER(7,3)
p_credit_hr   Credit hours associated with the CRN. NUMBER(7,3)
p_bill_hr_hold   Billing hours to hold for reinstatements. NUMBER(7,3)
p_credit_hr_hold   Credit hours to hold for reinstatements. NUMBER(7,3)
p_gmod_code   Grade mode associated with the CRN. VARCHAR2(1)
p_grde_code   Grade code associated with the CRN. VARCHAR2(6)
p_grde_code_mid   Midterm grade code associated with the CRN. VARCHAR2(6)
p_grde_date   Date associated with the grade of the CRN. DATE
p_dupl_over   Duplicate course override of the CRN. VARCHAR2(1)
p_link_over   Link override of the CRN. VARCHAR2(1)
p_corq_over   Corequisite override of the CRN. VARCHAR2(1)
p_preq_over   Prerequisite override of the CRN. VARCHAR2(1)
p_time_over   Time conflict override of the CRN. VARCHAR2(1)
p_capc_over   Capacity override of the CRN. VARCHAR2(1)
p_levl_over   Level restriction override of the CRN. VARCHAR2(1)
p_coll_over   College restriction override of the CRN. VARCHAR2(1)
p_majr_over   Major restriction override of the CRN. VARCHAR2(1)
p_clas_over   Class restriction override of the CRN. VARCHAR2(1)
p_appr_over   Special approval override of the CRN. VARCHAR2(1)
p_appr_received_ind   Special approval received indicator for the CRN. VARCHAR2(1)
p_add_date   Add date of the registrant in the CRN. DATE Required
p_levl_code   Level the registrant is enrolled for the CRN. VARCHAR2(2) Required
p_camp_code   Campus code of the CRN. VARCHAR2(3) Required
p_reserved_key   Student Course Registration Table Reserved Key. VARCHAR2(8)
p_attend_hr   Number of hours the student attended the class. NUMBER(9,3)
p_rept_over   Repeat course restriction override of the CRN. VARCHAR2(1)
p_rpth_over   Repeat course hour restriction override of the CRN. VARCHAR2(1)
p_test_over   Test score restriction override of the CRN. VARCHAR2(1)
p_camp_over   Campus Registration Restriction override code. VARCHAR2(1)
p_user   Oracle ID of the user who entered the registration request. VARCHAR2(30)
p_degc_over   Degree restriction override indicator. VARCHAR2(1)
p_prog_over   Program restriction override indicator. VARCHAR2(1)
p_last_attend   Date the student last attended the class. DATE
p_gcmt_code   Grade comment (result code) for the section. VARCHAR2(7)
p_data_origin   Source system that generated the data. VARCHAR2(30)
p_assess_activity_date   Date of registration activity that impacted Fee Assessment. DATE
p_dept_over   Department restriction override indicator. VARCHAR2(1)
p_atts_over   Student attribute restriction override indicator. VARCHAR2(1)
p_chrt_over   Cohort restriction override indicator. VARCHAR2(1)
p_wl_priority   Waitlist Priority Number . NUMBER (11,6)
p_wl_priority_orig   Wheter Waitlist Priority Number was system or manually generated. VARCHAR2(1)
p_grde_code_incmp_final   Actual Grade code to identify default final grade for incomplete coursework. VARCHAR2(6)
p_incomplete_ext_date   Date to identify when the default final grade will be applied if coursework is incomplete. DATE
p_mexc_over   Mutual Exclusion restriction override  indicator. VARCHAR2(1)
p_stsp_key_sequence   The key sequence of the learner study path under which the CRN is registered. NUMBER(2)
p_rowid   Database ROWID of the record to be updated. VARCHAR(18)
p_blck_code   Block code student is registered. VAHRCHAR2(10)
p_brdh_seq_num   Sequence number that uniquely identifies the rule for block assignment. NUMBER(7)