Package BANINST1.sb

Package BANINST1.sb_section

This package provides the Common Business interface for the Section API (sb_section).

Section records are created by term, subject code, and course number. They are assigned a system-generated Course Reference Number (CRN), based on the value of the CRN One-up Number in the Term Base Table (SOBTERM). The sequence number attached to the section, also referred to as the section number, must be unique for the term, subject, and course number, unless the sequence number is 0. Any number of sections may exist with a sequence number of 0 for the same term, subject code, and course number.

To create a new section, the subject code and course number must exist in the Course Base Maintenance Table (SCBCRKY), where the term code of the section is between the Start Term and the End Term of the Course Base Maintenance record.

The title remains NULL on the section record unless it differs from the title on the Course General Information Base record (SCBCRSE) for the subject code, course number, and effective term.

Campus restrictions defined in the Course Campus Restriction Repeating Table (SCRRCMP), or term restrictions defined in the Course Term Restriction Repeating Table (SCRRTRM), may prohibit a section from being created. Also, a user may be restricted from creating sections for certain campuses, based on entries in the Campus Security Table (SOBPROF).

Two types of section records, Traditional and Open Learning, may be created. Traditional sections are term-based and require all Part-of-Term information. Open Learning sections, while created for a particular term, are date-based. The learner may register within a specified date range (between the Registration From Date and the Registration To Date) and may begin study with a specified date range (between the Learner Start From Date and the Learner Start To Date). The maximum amount of time the learner has to complete the course is defined by the Number of Units and the Duration Code (e.g., 10 WEEKS).

The institution may define a number of extensions for an Open Learning section. The learner may apply for any number of extensions, within the institution-defined limit, if he or she is unable to complete the course in the allocated amount of time. For a Traditional section, extensions are not applicable and the number of extensions should be set to 0.

Updates to section information may be restricted if enrollment exists. If enrollment exists, updates are not permitted to Schedule Type or Instructional Method, because those values can be included in tuition and fee assessment calculation rules. The Part-of-Term fields may not be changed in enrollment exists or if the section was originally created as an Open Learning section.

Sections may not be deleted if enrollment exists. The maximum enrollment count and the waitlist capacity are determined by the institution (waitlisting is used only for Traditional sections). The actual enrollment count, the number of seats available, the waitlist count, and the waitlist available are updated by the Registration module and should not be updated by any other means.

Program units

f_api_version

f_exists

f_exists_subj_crse_seq

f_isequal

f_query_all

f_query_one

f_query_by_rowid

f_query_one_lock

f_get_prereq_chk_method_cde

p_create

p_delete

p_lock

p_update

Types

section_rec

section_ref

section_tab

Constants

M_ENTITY_NAME

M_ENTITY_NAME   CONSTANT VARCHAR2 (7) := 'SECTION';

Business Entity name

section_rec

TYPE section_rec IS RECORD(

   r_term_code                   ssbsect.ssbsect_term_code%TYPE,
   r_crn                         ssbsect.ssbsect_crn%TYPE,
   r_ptrm_code                   ssbsect.ssbsect_ptrm_code%TYPE,
   r_subj_code                   ssbsect.ssbsect_subj_code%TYPE,
   r_crse_numb                   ssbsect.ssbsect_crse_numb%TYPE,
   r_seq_numb                    ssbsect.ssbsect_seq_numb%TYPE,
   r_ssts_code                   ssbsect.ssbsect_ssts_code%TYPE,
   r_schd_code                   ssbsect.ssbsect_schd_code%TYPE,
   r_camp_code                   ssbsect.ssbsect_camp_code%TYPE,
   r_crse_title                  ssbsect.ssbsect_crse_title%TYPE,
   r_credit_hrs                  ssbsect.ssbsect_credit_hrs%TYPE,
   r_bill_hrs                    ssbsect.ssbsect_bill_hrs%TYPE,
   r_gmod_code                   ssbsect.ssbsect_gmod_code%TYPE,
   r_sapr_code                   ssbsect.ssbsect_sapr_code%TYPE,
   r_sess_code                   ssbsect.ssbsect_sess_code%TYPE,
   r_link_ident                  ssbsect.ssbsect_link_ident%TYPE,
   r_prnt_ind                    ssbsect.ssbsect_prnt_ind%TYPE,
   r_gradable_ind                ssbsect.ssbsect_gradable_ind%TYPE,
   r_tuiw_ind                    ssbsect.ssbsect_tuiw_ind%TYPE,
   r_reg_oneup                   ssbsect.ssbsect_reg_oneup%TYPE,
   r_prior_enrl                  ssbsect.ssbsect_prior_enrl%TYPE,
   r_proj_enrl                   ssbsect.ssbsect_proj_enrl%TYPE,
   r_max_enrl                    ssbsect.ssbsect_max_enrl%TYPE,
   r_enrl                        ssbsect.ssbsect_enrl%TYPE,
   r_seats_avail                 ssbsect.ssbsect_seats_avail%TYPE,
   r_tot_credit_hrs              ssbsect.ssbsect_tot_credit_hrs%TYPE,
   r_census_enrl                 ssbsect.ssbsect_census_enrl%TYPE,
   r_census_enrl_date            ssbsect.ssbsect_census_enrl_date%TYPE,
   r_ptrm_start_date             ssbsect.ssbsect_ptrm_start_date%TYPE,
   r_ptrm_end_date               ssbsect.ssbsect_ptrm_end_date%TYPE,
   r_ptrm_weeks                  ssbsect.ssbsect_ptrm_weeks%TYPE,
   r_reserved_ind                ssbsect.ssbsect_reserved_ind%TYPE,
   r_wait_capacity               ssbsect.ssbsect_wait_capacity%TYPE,
   r_wait_count                  ssbsect.ssbsect_wait_count%TYPE,
   r_wait_avail                  ssbsect.ssbsect_wait_avail%TYPE,
   r_lec_hr                      ssbsect.ssbsect_lec_hr%TYPE,
   r_lab_hr                      ssbsect.ssbsect_lab_hr%TYPE,
   r_oth_hr                      ssbsect.ssbsect_oth_hr%TYPE,
   r_cont_hr                     ssbsect.ssbsect_cont_hr%TYPE,
   r_acct_code                   ssbsect.ssbsect_acct_code%TYPE,
   r_accl_code                   ssbsect.ssbsect_accl_code%TYPE,
   r_census_2_date               ssbsect.ssbsect_census_2_date%TYPE,
   r_enrl_cut_off_date           ssbsect.ssbsect_enrl_cut_off_date%TYPE,
   r_acad_cut_off_date           ssbsect.ssbsect_acad_cut_off_date%TYPE,
   r_drop_cut_off_date           ssbsect.ssbsect_drop_cut_off_date%TYPE,
   r_census_2_enrl               ssbsect.ssbsect_census_2_enrl%TYPE,
   r_voice_avail                 ssbsect.ssbsect_voice_avail%TYPE,
   r_capp_prereq_test_ind        ssbsect.ssbsect_capp_prereq_test_ind%TYPE,
   r_gsch_name                   ssbsect.ssbsect_gsch_name%TYPE,
   r_best_of_comp                ssbsect.ssbsect_best_of_comp%TYPE,
   r_subset_of_comp              ssbsect.ssbsect_subset_of_comp%TYPE,
   r_insm_code                   ssbsect.ssbsect_insm_code%TYPE,
   r_reg_from_date               ssbsect.ssbsect_reg_from_date%TYPE,
   r_reg_to_date                 ssbsect.ssbsect_reg_to_date%TYPE,
   r_learner_regstart_fdate      ssbsect.ssbsect_learner_regstart_fdate%TYPE,
   r_learner_regstart_tdate      ssbsect.ssbsect_learner_regstart_tdate%TYPE,
   r_dunt_code                   ssbsect.ssbsect_dunt_code%TYPE,
   r_number_of_units             ssbsect.ssbsect_number_of_units%TYPE,
   r_number_of_extensions        ssbsect.ssbsect_number_of_extensions%TYPE,
   r_data_origin                 ssbsect.ssbsect_data_origin%TYPE,
   r_user_id                     ssbsect.ssbsect_user_id%TYPE,
   r_intg_cde                    ssbsect.ssbsect_intg_cde%TYPE,
   r_prereq_chk_method_cde       ssbsect.ssbsect_prereq_chk_method_cde%TYPE,
   r_internal_record_id          gb_common.internal_record_id_type);

Entity record type

section_ref

TYPE section_ref IS REF CURSOR
   RETURN section_rec;

Entity cursor variable type

section_tab

TYPE section_tab IS TABLE OF section_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_term_code ssbsect.ssbsect_term_code%TYPE,
                  p_crn       ssbsect.ssbsect_crn%TYPE,
                  p_rowid     VARCHAR2 DEFAULT NULL) RETURN VARCHAR2

Checks to see if a record exists.

Parameters

	p_term_code	Term code for the section. VARCHAR2(6) Required Key
	p_crn	Course Reference Number (CRN) of the section. VARCHAR2(5) Required Key
	p_rowid	Database ROWID of the record to be selected. VARCHAR2(18)

Returns

Y if found, otherwise N.

f_exists_subj_crse_seq

Function f_exists_subj_crse_seq(p_term_code ssbsect.ssbsect_term_code%TYPE,
                                p_subj_code ssbsect.ssbsect_subj_code%TYPE,
                                p_crse_numb ssbsect.ssbsect_crse_numb%TYPE,
                                p_seq_numb  ssbsect.ssbsect_seq_numb%TYPE)
  RETURN VARCHAR2

Checks to see if a record exists with this subject code, course number, and sequence number.

Parameters

	p_term_code	Term code of the exiting record. VARCHAR2(6) Required Key
	p_subj_code	Subject code of the existing record. VARCHAR2(4) Required
	p_crse_numb	Course number of the existing record. VARCHAR2(5) Required
	p_seq_numb	Sequence number of the existing record. VARCHAR2(3) Required

Returns

Y if found, otherwise N.

f_isequal

Function f_isequal(rec_one section_rec, rec_two section_rec)
  RETURN VARCHAR2

Compares two records for equality.

Parameters

	rec_one	First record to compare. Defined as type section_rec.
	rec_two	Second record to compare. Defined as type section_rec.

Returns

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

f_query_all

Function f_query_all(p_term_code ssbsect.ssbsect_term_code%TYPE,
                     p_crn       ssbsect.ssbsect_crn%TYPE DEFAULT NULL,
                     p_subj_code ssbsect.ssbsect_subj_code%TYPE DEFAULT NULL,
                     p_crse_numb ssbsect.ssbsect_crse_numb%TYPE DEFAULT NULL)
  RETURN section_ref

Selects all records for the entity.

Parameters

	p_term_code	Term code for the section. VARCHAR2(6) Required Key
	p_crn	Course Reference Number (CRN) of the section. VARCHAR2(5)
	p_subj_code	Subject code of the section. VARCHAR2(4)
	p_crse_numb	Course number of the section. VARCHAR2(5)

Returns

A cursor variable that will fetch the set of records.

f_query_one

Function f_query_one(p_term_code ssbsect.ssbsect_term_code%TYPE,
                     p_crn       ssbsect.ssbsect_crn%TYPE)
  RETURN section_ref

Selects one record using the key.

Parameters

	p_term_code	Term code for the section. VARCHAR2(6) Required Key
	p_crn	Course Reference Number (CRN) of the 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 section_ref

Selects one record using the ROWID.

Parameters

p_rowid

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

Returns

A cursor variable that will fetch exactly one record.

f_query_one_lock

Function f_query_one_lock(p_term_code ssbsect.ssbsect_term_code%TYPE,
                          p_crn       ssbsect.ssbsect_crn%TYPE,
                          p_rowid     VARCHAR2 DEFAULT NULL)
  RETURN section_ref

Selects one record and locks it.

Parameters

	p_term_code	Term code for the section. VARCHAR2(6) Required Key
	p_crn	Course Reference Number (CRN) of the section. VARCHAR2(5) Required Key
	p_rowid	Database ROWID of the record to be selected. VARCHAR2(18)

Returns

A cursor variable for one record, locking the record.

f_get_prereq_chk_method_cde

Function f_get_prereq_chk_method_cde(p_term_code ssbsect.ssbsect_term_code%TYPE,
                                     p_crn       ssbsect.ssbsect_crn%TYPE)
  RETURN VARCHAR2

Checks the value of the new prereq_chk_method_cde.

Parameters

	p_term_code	Term code for the section. VARCHAR2(6) Required Key
	p_crn	Course Reference Number (CRN) of the section. VARCHAR2(5) Required Key

Returns

The value of the code. (B)asic, (C)app, or (D)egreeworks.

p_create

Procedure p_create(p_term_code              ssbsect.ssbsect_term_code%TYPE,
                   p_crn                    ssbsect.ssbsect_crn%TYPE,
                   p_ptrm_code              ssbsect.ssbsect_ptrm_code%TYPE DEFAULT NULL,
                   p_subj_code              ssbsect.ssbsect_subj_code%TYPE,
                   p_crse_numb              ssbsect.ssbsect_crse_numb%TYPE,
                   p_seq_numb               ssbsect.ssbsect_seq_numb%TYPE,
                   p_ssts_code              ssbsect.ssbsect_ssts_code%TYPE,
                   p_schd_code              ssbsect.ssbsect_schd_code%TYPE,
                   p_camp_code              ssbsect.ssbsect_camp_code%TYPE,
                   p_crse_title             ssbsect.ssbsect_crse_title%TYPE DEFAULT NULL,
                   p_credit_hrs             ssbsect.ssbsect_credit_hrs%TYPE DEFAULT NULL,
                   p_bill_hrs               ssbsect.ssbsect_bill_hrs%TYPE DEFAULT NULL,
                   p_gmod_code              ssbsect.ssbsect_gmod_code%TYPE DEFAULT NULL,
                   p_sapr_code              ssbsect.ssbsect_sapr_code%TYPE DEFAULT NULL,
                   p_sess_code              ssbsect.ssbsect_sess_code%TYPE DEFAULT NULL,
                   p_link_ident             ssbsect.ssbsect_link_ident%TYPE DEFAULT NULL,
                   p_prnt_ind               ssbsect.ssbsect_prnt_ind%TYPE DEFAULT NULL,
                   p_gradable_ind           ssbsect.ssbsect_gradable_ind%TYPE DEFAULT NULL,
                   p_tuiw_ind               ssbsect.ssbsect_tuiw_ind%TYPE DEFAULT NULL,
                   p_reg_oneup              ssbsect.ssbsect_reg_oneup%TYPE,
                   p_prior_enrl             ssbsect.ssbsect_prior_enrl%TYPE,
                   p_proj_enrl              ssbsect.ssbsect_proj_enrl%TYPE,
                   p_max_enrl               ssbsect.ssbsect_max_enrl%TYPE,
                   p_enrl                   ssbsect.ssbsect_enrl%TYPE,
                   p_seats_avail            ssbsect.ssbsect_seats_avail%TYPE,
                   p_tot_credit_hrs         ssbsect.ssbsect_tot_credit_hrs%TYPE DEFAULT NULL,
                   p_census_enrl            ssbsect.ssbsect_census_enrl%TYPE DEFAULT NULL,
                   p_census_enrl_date       ssbsect.ssbsect_census_enrl_date%TYPE,
                   p_ptrm_start_date        ssbsect.ssbsect_ptrm_start_date%TYPE DEFAULT NULL,
                   p_ptrm_end_date          ssbsect.ssbsect_ptrm_end_date%TYPE DEFAULT NULL,
                   p_ptrm_weeks             ssbsect.ssbsect_ptrm_weeks%TYPE DEFAULT NULL,
                   p_reserved_ind           ssbsect.ssbsect_reserved_ind%TYPE DEFAULT NULL,
                   p_wait_capacity          ssbsect.ssbsect_wait_capacity%TYPE DEFAULT NULL,
                   p_wait_count             ssbsect.ssbsect_wait_count%TYPE DEFAULT NULL,
                   p_wait_avail             ssbsect.ssbsect_wait_avail%TYPE DEFAULT NULL,
                   p_lec_hr                 ssbsect.ssbsect_lec_hr%TYPE DEFAULT NULL,
                   p_lab_hr                 ssbsect.ssbsect_lab_hr%TYPE DEFAULT NULL,
                   p_oth_hr                 ssbsect.ssbsect_oth_hr%TYPE DEFAULT NULL,
                   p_cont_hr                ssbsect.ssbsect_cont_hr%TYPE DEFAULT NULL,
                   p_acct_code              ssbsect.ssbsect_acct_code%TYPE DEFAULT NULL,
                   p_accl_code              ssbsect.ssbsect_accl_code%TYPE DEFAULT NULL,
                   p_census_2_date          ssbsect.ssbsect_census_2_date%TYPE DEFAULT NULL,
                   p_enrl_cut_off_date      ssbsect.ssbsect_enrl_cut_off_date%TYPE DEFAULT NULL,
                   p_acad_cut_off_date      ssbsect.ssbsect_acad_cut_off_date%TYPE DEFAULT NULL,
                   p_drop_cut_off_date      ssbsect.ssbsect_drop_cut_off_date%TYPE DEFAULT NULL,
                   p_census_2_enrl          ssbsect.ssbsect_census_2_enrl%TYPE DEFAULT NULL,
                   p_voice_avail            ssbsect.ssbsect_voice_avail%TYPE,
                   p_capp_prereq_test_ind   ssbsect.ssbsect_capp_prereq_test_ind%TYPE,
                   p_gsch_name              ssbsect.ssbsect_gsch_name%TYPE DEFAULT NULL,
                   p_best_of_comp           ssbsect.ssbsect_best_of_comp%TYPE DEFAULT NULL,
                   p_subset_of_comp         ssbsect.ssbsect_subset_of_comp%TYPE DEFAULT NULL,
                   p_insm_code              ssbsect.ssbsect_insm_code%TYPE DEFAULT NULL,
                   p_reg_from_date          ssbsect.ssbsect_reg_from_date%TYPE DEFAULT NULL,
                   p_reg_to_date            ssbsect.ssbsect_reg_to_date%TYPE DEFAULT NULL,
                   p_learner_regstart_fdate ssbsect.ssbsect_learner_regstart_fdate%TYPE DEFAULT NULL,
                   p_learner_regstart_tdate ssbsect.ssbsect_learner_regstart_tdate%TYPE DEFAULT NULL,
                   p_dunt_code              ssbsect.ssbsect_dunt_code%TYPE DEFAULT NULL,
                   p_number_of_units        ssbsect.ssbsect_number_of_units%TYPE DEFAULT NULL,
                   p_number_of_extensions   ssbsect.ssbsect_number_of_extensions%TYPE,
                   p_data_origin            ssbsect.ssbsect_data_origin%TYPE DEFAULT NULL,
                   p_user_id                ssbsect.ssbsect_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_intg_cde               ssbsect.ssbsect_intg_cde%TYPE DEFAULT NULL,
                   p_prereq_chk_method_cde  ssbsect.ssbsect_prereq_chk_method_cde%TYPE DEFAULT NULL,
                   p_rowid_out              OUT VARCHAR2)

Creates a record.

Parameters

	p_term_code	Term code for the section. VARCHAR2(6) Required Key
	p_crn	Course Reference Number (CRN) of the section. VARCHAR2(5) Required Key
	p_ptrm_code	Part-of-Term in which the section is offered. Required for Traditional sections. NULL for Open Learning sections. VARCHAR2(3)
	p_subj_code	Subject code of the section. VARCHAR2(4) Required
	p_crse_numb	Course number of the section. VARCHAR2(5) Required
	p_seq_numb	Section number of the section. VARCHAR2(3) Required
	p_ssts_code	Status of the section. VARCHAR2(1) Required
	p_schd_code	Schedule type of the section. VARCHAR2(3) Required
	p_camp_code	Campus code of the section. VARCHAR2(3) Required
	p_crse_title	Title of the section. VARCHAR2(30)
	p_credit_hrs	Number of credit hours of the section. NUMBER(7,3)
	p_bill_hrs	Number of billing hours of the section. NUMBER(7,3)
	p_gmod_code	Grading mode of the section. VARCHAR2(1)
	p_sapr_code	Special approval a student must have to register for the section. VARCHAR2(2)
	p_sess_code	Session in which the section is scheduled. VARCHAR2(1)
	p_link_ident	Link identifier, used to link this section to other sections of the same course. VARCHAR2(2)
	p_prnt_ind	Indicates whether the section should print in the Schedule Report. VARCHAR2(1)
	p_gradable_ind	Indicates whether the section is gradable. VARCHAR2(1)
	p_tuiw_ind	Indicates whether the section is exempt from the assessment of tuition and fees. VARCHAR2(1)
	p_reg_oneup	Count associated with the last student registered for the section. NUMBER(4) Required
	p_prior_enrl	Enrollment from the prior term. NUMBER(4) Required
	p_proj_enrl	Anticipated enrollment in the section. NUMBER(4) Required
	p_max_enrl	Maximum enrollment for the section. NUMBER(4) Required
	p_enrl	Number of students enrolled in the section, with a course status that counts in enrollment. NUMBER(4) Required
	p_seats_avail	Number of remaining seats available in the section. NUMBER(4) Required
	p_tot_credit_hrs	Total of all enrolled credit hours in the section. NUMBER(9,3)
	p_census_enrl	Number of students registered for the section prior to the census date. NUMBER(4)
	p_census_enrl_date	Census date of the section. DATE Required
	p_ptrm_start_date	Start date for the part-of-term of the section. Required for Traditional sections. NULL for Open Learning sections. DATE
	p_ptrm_end_date	End date for the part-of-term of the section. Required for Traditional sections. NULL for Open Learning sections. DATE
	p_ptrm_weeks	Number of weeks defined for the part-of-term. Required for Traditional sections. NULL for Open Learning sections. NUMBER(3)
	p_reserved_ind	Indicates whether reserved seats are defined for the section. VARCHAR2(1)
	p_wait_capacity	Maximum waitlist enrollment for the section. NUMBER(4)
	p_wait_count	Number of student waitlisted for the section. NUMBER(4)
	p_wait_avail	Number of waitlist seats available for the section. NUMBER(4)
	p_lec_hr	Number of lecture hours of the section. NUMBER(9,3)
	p_lab_hr	Number of lab hours of the section. NUMBER(9,3)
	p_oth_hr	Number of other hours of the section, as defined by the institution. NUMBER(9,3)
	p_cont_hr	Number of contact hours of the section. NUMBER(9,3)
	p_acct_code	Accounting method code of the section. VARCHAR2(2)
	p_accl_code	Academic calendar type associated with the section. VARCHAR2(2)
	p_census_2_date	Census two date of the section. DATE
	p_enrl_cut_off_date	Last date on which students may enroll for the section. DATE
	p_acad_cut_off_date	Last date on which students may process the section without it appearing on their academic history information. DATE
	p_drop_cut_off_date	Last date on which students may drop the section without assessing a penalty. DATE
	p_census_2_enrl	Number of students registered for the section prior to the census two date. NUMBER(4)
	p_voice_avail	Indicates whether the section is available to Web and Voice Response Registration. VARCHAR2(1) Required
	p_capp_prereq_test_ind	Indicates whether CAPP (degree evaluation) areas or existing prerequisite and test score restrictions are in effect for the section. VARCHAR2(1) Required
	p_gsch_name	Grade scale definition code of the section. VARCHAR2(10)
	p_best_of_comp	Number of child components to be used in subset "best of" calculations when calculating a section score. NUMBER(3)
	p_subset_of_comp	Number of child components to be used in subset calculations when calculating a section score. NUMBER(3)
	p_insm_code	Instructional method code assigned to the section. VARCHAR2(5)
	p_reg_from_date	Registration From Date. Required for Open Learning sections. NULL for Traditional sections. DATE
	p_reg_to_date	Registration To Date. Required for Open Learning sections. NULL for Traditional sections. DATE
	p_learner_regstart_fdate	Learner Registration Start Date. Required for Open Learning sections. NULL for Traditional sections. DATE
	p_learner_regstart_tdate	Learner Registration To Date. Required for Open Learning sections. NULL for Traditional sections. DATE
	p_dunt_code	Duration unit code assigned to the section. Required for Open Learning sections. NULL for Traditional sections. VARCHAR2(4)
	p_number_of_units	Number of units the student will be given to complete the section. Required for Open Learning sections. NULL for Traditional sections. NUMBER(7,2)
	p_number_of_extensions	Number of extensions permitted for the section. NUMBER(3) Required
	p_data_origin	Source system that generated the data. VARCHAR2(30)
	p_user_id	Oracle ID of user who inserted or last updated the data. VARCHAR2(30)
	p_intg_cde	Integration Partner code assigned to the section. VARCHAR2(5)
	p_number_of_units	Number of units the student will be given to complete the section. Required for Open Learning sections. NULL for Traditional sections. NUMBER(7,2)
	p_prereq_chk_method_cde	Denote B for Basic, C for CAPP, and D for DegreeWorks prerequisite checking method. VARCHAR2(1)
	p_rowid_out	Database ROWID of the record to be created. VARCHAR2(18)

p_delete

Procedure p_delete(p_term_code ssbsect.ssbsect_term_code%TYPE,
                   p_crn       ssbsect.ssbsect_crn%TYPE,
                   p_rowid     VARCHAR2 DEFAULT NULL)

Deletes a record.

Parameters

	p_term_code	Term code for the section. VARCHAR2(6)
	p_crn	Course Reference Number (CRN) of the section. VARCHAR2(5)
	p_rowid	Database ROWID of the record to be deleted. VARCHAR2(18)

p_lock

Procedure p_lock(p_term_code   ssbsect.ssbsect_term_code%TYPE,
                 p_crn         ssbsect.ssbsect_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	Term code for the section. VARCHAR2(6)
	p_crn	Course Reference Number (CRN) of the section. VARCHAR2(5)
	p_rowid_inout	Database ROWID of the record to be locked. VARCHAR2(18)

p_update

Procedure p_update(p_term_code              ssbsect.ssbsect_term_code%TYPE,
                   p_crn                    ssbsect.ssbsect_crn%TYPE,
                   p_ptrm_code              ssbsect.ssbsect_ptrm_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_subj_code              ssbsect.ssbsect_subj_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_crse_numb              ssbsect.ssbsect_crse_numb%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_seq_numb               ssbsect.ssbsect_seq_numb%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_ssts_code              ssbsect.ssbsect_ssts_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_schd_code              ssbsect.ssbsect_schd_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_camp_code              ssbsect.ssbsect_camp_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_crse_title             ssbsect.ssbsect_crse_title%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_credit_hrs             ssbsect.ssbsect_credit_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_bill_hrs               ssbsect.ssbsect_bill_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_gmod_code              ssbsect.ssbsect_gmod_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_sapr_code              ssbsect.ssbsect_sapr_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_sess_code              ssbsect.ssbsect_sess_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_link_ident             ssbsect.ssbsect_link_ident%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_prnt_ind               ssbsect.ssbsect_prnt_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_gradable_ind           ssbsect.ssbsect_gradable_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_tuiw_ind               ssbsect.ssbsect_tuiw_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_reg_oneup              ssbsect.ssbsect_reg_oneup%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_prior_enrl             ssbsect.ssbsect_prior_enrl%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_proj_enrl              ssbsect.ssbsect_proj_enrl%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_max_enrl               ssbsect.ssbsect_max_enrl%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_enrl                   ssbsect.ssbsect_enrl%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_seats_avail            ssbsect.ssbsect_seats_avail%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_tot_credit_hrs         ssbsect.ssbsect_tot_credit_hrs%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_census_enrl            ssbsect.ssbsect_census_enrl%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_census_enrl_date       ssbsect.ssbsect_census_enrl_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_ptrm_start_date        ssbsect.ssbsect_ptrm_start_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_ptrm_end_date          ssbsect.ssbsect_ptrm_end_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_ptrm_weeks             ssbsect.ssbsect_ptrm_weeks%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_reserved_ind           ssbsect.ssbsect_reserved_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_wait_capacity          ssbsect.ssbsect_wait_capacity%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_wait_count             ssbsect.ssbsect_wait_count%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_wait_avail             ssbsect.ssbsect_wait_avail%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_lec_hr                 ssbsect.ssbsect_lec_hr%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_lab_hr                 ssbsect.ssbsect_lab_hr%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_oth_hr                 ssbsect.ssbsect_oth_hr%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_cont_hr                ssbsect.ssbsect_cont_hr%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_acct_code              ssbsect.ssbsect_acct_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_accl_code              ssbsect.ssbsect_accl_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_census_2_date          ssbsect.ssbsect_census_2_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_enrl_cut_off_date      ssbsect.ssbsect_enrl_cut_off_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_acad_cut_off_date      ssbsect.ssbsect_acad_cut_off_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_drop_cut_off_date      ssbsect.ssbsect_drop_cut_off_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_census_2_enrl          ssbsect.ssbsect_census_2_enrl%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_voice_avail            ssbsect.ssbsect_voice_avail%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_capp_prereq_test_ind   ssbsect.ssbsect_capp_prereq_test_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_gsch_name              ssbsect.ssbsect_gsch_name%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_best_of_comp           ssbsect.ssbsect_best_of_comp%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_subset_of_comp         ssbsect.ssbsect_subset_of_comp%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_insm_code              ssbsect.ssbsect_insm_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_reg_from_date          ssbsect.ssbsect_reg_from_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_reg_to_date            ssbsect.ssbsect_reg_to_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_learner_regstart_fdate ssbsect.ssbsect_learner_regstart_fdate%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_learner_regstart_tdate ssbsect.ssbsect_learner_regstart_tdate%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_dunt_code              ssbsect.ssbsect_dunt_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_number_of_units        ssbsect.ssbsect_number_of_units%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_number_of_extensions   ssbsect.ssbsect_number_of_extensions%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_data_origin            ssbsect.ssbsect_data_origin%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_user_id                ssbsect.ssbsect_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_intg_cde               ssbsect.ssbsect_intg_cde%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_prereq_chk_method_cde  ssbsect.ssbsect_prereq_chk_method_cde%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_rowid                  VARCHAR2 DEFAULT NULL)

Updates a record.

Parameters

	p_term_code	Term code for the section. VARCHAR2(6) Required Key
	p_crn	Course Reference Number (CRN) of the section. VARCHAR2(5) Required Key
	p_ptrm_code	Part-of-Term in which the section is offered. Required for Traditional sections. NULL for Open Learning sections. VARCHAR2(3)
	p_subj_code	Subject code of the section. VARCHAR2(4) Required
	p_crse_numb	Course number of the section. VARCHAR2(5) Required
	p_seq_numb	Section number of the section. VARCHAR2(3) Required
	p_ssts_code	Status of the section. VARCHAR2(1) Required
	p_schd_code	Schedule type of the section. VARCHAR2(3) Required
	p_camp_code	Campus code of the section. VARCHAR2(3) Required
	p_crse_title	Title of the section. VARCHAR2(30)
	p_credit_hrs	Number of credit hours of the section. NUMBER(7,3)
	p_bill_hrs	Number of billing hours of the section. NUMBER(7,3)
	p_gmod_code	Grading mode of the section. VARCHAR2(1)
	p_sapr_code	Special approval a student must have to register for the section. VARCHAR2(2)
	p_sess_code	Session in which the section is scheduled. VARCHAR2(1)
	p_link_ident	Link identifier, used to link this section to other sections of the same course. VARCHAR2(2)
	p_prnt_ind	Indicates whether the section should print in the Schedule Report. VARCHAR2(1)
	p_gradable_ind	Indicates whether the section is gradable. VARCHAR2(1)
	p_tuiw_ind	Indicates whether the section is exempt from the assessment of tuition and fees. VARCHAR2(1)
	p_reg_oneup	Count associated with the last student registered for the section. NUMBER(4) Required
	p_prior_enrl	Enrollment from the prior term. NUMBER(4) Required
	p_proj_enrl	Anticipated enrollment in the section. NUMBER(4) Required
	p_max_enrl	Maximum enrollment for the section. NUMBER(4) Required
	p_enrl	Number of students enrolled in the section, with a course status that counts in enrollment. NUMBER(4) Required
	p_seats_avail	Number of remaining seats available in the section. NUMBER(4) Required
	p_tot_credit_hrs	Total of all enrolled credit hours in the section. NUMBER(9,3)
	p_census_enrl	Number of students registered for the section prior to the census date. NUMBER(4)
	p_census_enrl_date	Census date of the section. DATE Required
	p_ptrm_start_date	Start date for the part-of-term of the section. Required for Traditional sections. NULL for Open Learning sections. DATE
	p_ptrm_end_date	End date for the part-of-term of the section. Required for Traditional sections. NULL for Open Learning sections. DATE
	p_ptrm_weeks	Number of weeks defined for the part-of-term. Required for Traditional sections. NULL for Open Learning sections. NUMBER(3)
	p_reserved_ind	Indicates whether reserved seats are defined for the section. VARCHAR2(1)
	p_wait_capacity	Maximum waitlist enrollment for the section. NUMBER(4)
	p_wait_count	Number of student waitlisted for the section. NUMBER(4)
	p_wait_avail	Number of waitlist seats available for the section. NUMBER(4)
	p_lec_hr	Number of lecture hours of the section. NUMBER(9,3)
	p_lab_hr	Number of lab hours of the section. NUMBER(9,3)
	p_oth_hr	Number of other hours of the section, as defined by the institution. NUMBER(9,3)
	p_cont_hr	Number of contact hours of the section. NUMBER(9,3)
	p_acct_code	Accounting method code of the section. VARCHAR2(2)
	p_accl_code	Academic calendar type associated with the section. VARCHAR2(2)
	p_census_2_date	Census two date of the section. DATE
	p_enrl_cut_off_date	Last date on which students may enroll for the section. DATE
	p_acad_cut_off_date	Last date on which students may process the section without it appearing on their academic history information. DATE
	p_drop_cut_off_date	Last date on which students may drop the section without assessing a penalty. DATE
	p_census_2_enrl	Number of students registered for the section prior to the census two date. NUMBER(4)
	p_voice_avail	Indicates whether the section is available to Web and Voice Response Registration. VARCHAR2(1) Required
	p_capp_prereq_test_ind	Indicates whether CAPP (degree evaluation) areas or existing prerequisite and test score restrictions are in effect for the section. VARCHAR2(1) Required
	p_gsch_name	Grade scale definition code of the section. VARCHAR2(10)
	p_best_of_comp	Number of child components to be used in subset "best of" calculations when calculating a section score. NUMBER(3)
	p_subset_of_comp	Number of child components to be used in subset calculations when calculating a section score. NUMBER(3)
	p_insm_code	Instructional method code assigned to the section. VARCHAR2(5)
	p_reg_from_date	Registration From Date. Required for Open Learning sections. NULL for Traditional sections. DATE
	p_reg_to_date	Registration To Date. Required for Open Learning sections. NULL for Traditional sections. DATE
	p_learner_regstart_fdate	Learner Registration Start Date. Required for Open Learning sections. NULL for Traditional sections. DATE
	p_learner_regstart_tdate	Learner Registration To Date. Required for Open Learning sections. NULL for Traditional sections. DATE
	p_dunt_code	Duration unit code assigned to the section. Required for Open Learning sections. NULL for Traditional sections. VARCHAR2(4)
	p_number_of_units	Number of units the student will be given to complete the section. Required for Open Learning sections. NULL for Traditional sections. NUMBER(7,2)
	p_number_of_extensions	Number of extensions permitted for the section. NUMBER(3) Required
	p_data_origin	Source system that generated the data. VARCHAR2(30)
	p_user_id	Oracle ID of user who inserted or last updated the data. VARCHAR2(30)
	p_intg_cde	Integration Partner code assigned to the section. VARCHAR2(5)
	p_prereq_chk_method_cde	Denote B for Basic, C for CAPP, and D for DegreeWorks prerequisite checking method. VARCHAR2(1)
	p_rowid	Database ROWID of the record to be updated. VARCHAR2(18)