index

Package gb_classtimes

This package provides the Common Business interface for the meeting times API (gb_classtimes).
 
Meeting times can be added for valid course sections in the Schedule module as well as events and functions associated with events on the Events Management module.
 
The mandatory values for meeting times records are different depending on whether meeting times records are being created or updated to support course sections or events and functions.
For course sections, term, CRN, start date and end date, schedule type, number of hours per week session meets, session credit hours and session indicator must be supplied. The term for a course section must be valid in the Term Validation table (STVTERM). The CRN must be valid for a course section for the term specified.  The start date must be equal to or less than the end date.
 
For events and functions, term, CRN, start and end date, and begin and end time must be supplied.
Term must be the literal value 'EVENT' for meeting times associated with events and functions.
The CRN must be valid for an existing event (SLBEVNT). The start date must be less than or equal to the end date. The end time must be greater than the start time.
 
Multiple meeting times may exist for a course section as well as for an event or function. Meeting times may specify additional optional information including days of the week, start and end times, and building and room codes. Valid days of the week are for any day(s) that exist between the specified start and end date for the meeting times (M - Monday, T - Tuesday, W - Wednesday, R - Thursday, F - Friday, S - Saturday, U - Sunday). A start time and end time for a course section, event or function must be entered in military format with values between 0000 and 2359. Both start and end time must be provided.
 
A building code can be provided without a room code. When both a building and room code are provided, only rooms defined with Room Type - 'C' (Course) may be used to schedule course sections. Rooms defined with Room Type - 'D' (Dorm) or 'O' (Other) may be used to schedule events and functions.
 
Dates, times and other values must be valid and exist without time and room conflicts (unless overridden).
Overrides for meeting times conflicts are administratively authorized. Conflict override indicators for course sections overrides may be either 'T' (Time conflict), 'R' (Room conflict), or 'O' (Other conflicts).
Event overrides is restricted to 'O'.
 
A meeting times record for a traditional course section can be deleted if no faculty assignment exists for the meeting time. A meeting times record for an open learning course section can be deleted even if a faculty assignment exists for the meeting time.
 
@headcom

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   Attempts to select one record using provided keys.
f_query_by_rowid   Selects one record using the ROWID.
f_query_one_lock   Selects one record using the ROWID and locks it.
p_create   Creates a record.
p_delete   Deletes a record.
p_lock   Locks a record using the ROWID.
p_update   Updates a record.

Types
classtimes_rec   Classtimes entity record type
classtimes_ref   Classtimes entity cursor variable type
classtimes_tab   Classtimes entity table type

Constants
M_ENTITY_NAME   Business Entity name

M_ENTITY_NAME 

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

Business Entity name

classtimes_rec 

TYPE classtimes_rec IS RECORD (
   r_term_code               ssrmeet.ssrmeet_term_code%TYPE,
   r_crn                     ssrmeet.ssrmeet_crn%TYPE,
   r_begin_time              ssrmeet.ssrmeet_begin_time%TYPE,
   r_end_time                ssrmeet.ssrmeet_end_time%TYPE,
   r_bldg_code               ssrmeet.ssrmeet_bldg_code%TYPE,
   r_room_code               ssrmeet.ssrmeet_room_code%TYPE,
   r_start_date              ssrmeet.ssrmeet_start_date%TYPE,
   r_end_date                ssrmeet.ssrmeet_end_date%TYPE,
   r_catagory                ssrmeet.ssrmeet_catagory%TYPE,
   r_sun_day                 ssrmeet.ssrmeet_sun_day%TYPE,
   r_mon_day                 ssrmeet.ssrmeet_mon_day%TYPE,
   r_tue_day                 ssrmeet.ssrmeet_tue_day%TYPE,
   r_wed_day                 ssrmeet.ssrmeet_wed_day%TYPE,
   r_thu_day                 ssrmeet.ssrmeet_thu_day%TYPE,
   r_fri_day                 ssrmeet.ssrmeet_fri_day%TYPE,
   r_sat_day                 ssrmeet.ssrmeet_sat_day%TYPE,
   r_schd_code               ssrmeet.ssrmeet_schd_code%TYPE,
   r_over_ride               ssrmeet.ssrmeet_over_ride%TYPE,
   r_credit_hr_sess          ssrmeet.ssrmeet_credit_hr_sess%TYPE,
   r_meet_no                 ssrmeet.ssrmeet_meet_no%TYPE,
   r_hrs_week                ssrmeet.ssrmeet_hrs_week%TYPE,
   r_func_code               ssrmeet.ssrmeet_func_code%TYPE,
   r_comt_code               ssrmeet.ssrmeet_comt_code%TYPE,
   r_schs_code               ssrmeet.ssrmeet_schs_code%TYPE,
   r_mtyp_code               ssrmeet.ssrmeet_mtyp_code%TYPE,
   r_data_origin             ssrmeet.ssrmeet_data_origin%TYPE,
   r_user_id                 ssrmeet.ssrmeet_user_id%TYPE,
   r_internal_record_id      gb_common.internal_record_id_type);

Classtimes entity record type

classtimes_ref 

TYPE classtimes_ref IS REF CURSOR RETURN classtimes_rec;

Classtimes entity cursor variable type

classtimes_tab 

TYPE classtimes_tab IS TABLE OF classtimes_rec INDEX BY BINARY_INTEGER;

Classtimes 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 VARCHAR2) RETURN VARCHAR2

Checks to see if a record exists.

Parameters
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 classtimes_rec,
                   rec_two classtimes_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
First   record to compare. Type classtimes_rec. Required
Second   record to compare. Type classtimes_rec. Required

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

f_query_all 

FUNCTION f_query_all(p_term_code      ssrmeet.ssrmeet_term_code%TYPE,
                     p_crn            ssrmeet.ssrmeet_crn%TYPE DEFAULT NULL,
                     p_begin_time     ssrmeet.ssrmeet_begin_time%TYPE DEFAULT NULL,
                     p_end_time       ssrmeet.ssrmeet_end_time%TYPE DEFAULT NULL,
                     p_bldg_code      ssrmeet.ssrmeet_bldg_code%TYPE DEFAULT NULL,
                     p_room_code      ssrmeet.ssrmeet_room_code%TYPE DEFAULT NULL,
                     p_start_date     ssrmeet.ssrmeet_start_date%TYPE DEFAULT NULL,
                     p_end_date       ssrmeet.ssrmeet_end_date%TYPE DEFAULT NULL,
                     p_catagory       ssrmeet.ssrmeet_catagory%TYPE DEFAULT NULL,
                     p_sun_day        ssrmeet.ssrmeet_sun_day%TYPE DEFAULT NULL,
                     p_mon_day        ssrmeet.ssrmeet_mon_day%TYPE DEFAULT NULL,
                     p_tue_day        ssrmeet.ssrmeet_tue_day%TYPE DEFAULT NULL,
                     p_wed_day        ssrmeet.ssrmeet_wed_day%TYPE DEFAULT NULL,
                     p_thu_day        ssrmeet.ssrmeet_thu_day%TYPE DEFAULT NULL,
                     p_fri_day        ssrmeet.ssrmeet_fri_day%TYPE DEFAULT NULL,
                     p_sat_day        ssrmeet.ssrmeet_sat_day%TYPE DEFAULT NULL,
                     p_schd_code      ssrmeet.ssrmeet_schd_code%TYPE DEFAULT NULL,
                     p_over_ride      ssrmeet.ssrmeet_over_ride%TYPE DEFAULT NULL,
                     p_credit_hr_sess ssrmeet.ssrmeet_credit_hr_sess%TYPE DEFAULT NULL,
                     p_meet_no        ssrmeet.ssrmeet_meet_no%TYPE DEFAULT NULL,
                     p_hrs_week       ssrmeet.ssrmeet_hrs_week%TYPE DEFAULT NULL,
                     p_func_code      ssrmeet.ssrmeet_func_code%TYPE DEFAULT NULL,
                     p_comt_code      ssrmeet.ssrmeet_comt_code%TYPE DEFAULT NULL,
                     p_schs_code      ssrmeet.ssrmeet_schs_code%TYPE DEFAULT NULL,
                     p_mtyp_code      ssrmeet.ssrmeet_mtyp_code%TYPE DEFAULT NULL,
                     p_data_origin    ssrmeet.ssrmeet_data_origin%TYPE DEFAULT NULL,
                     p_user_id        ssrmeet.ssrmeet_user_id%TYPE DEFAULT NULL)
  RETURN classtimes_ref

Selects all records for the entity.

Parameters
p_term_code   Term for the meeting times for the course section (for event/functions provide 'EVENT'). VARCHAR2(6) Required
p_crn   Course Reference Number (CRN) of the course section. VARCHAR2(5)
p_begin_time   Begin Time of the course section in HHMM format using 24-hour time. VARCHAR2(4)
p_end_time   End Time of the course section in HHMM format using 24-hour time. VARCHAR2(4)
p_bldg_code   Building associated with the course section. VARCHAR2(6)
p_room_code   Room associated with the course section. VARCHAR2(10)
p_start_date   Section Meeting Start Date. DATE
p_end_date   Section End Date. DATE
p_catagory   Section Indicator. VARCHAR2(2)
p_sun_day   Section Meeting Time Sunday Indicator. VARCHAR2(1)
p_mon_day   Section Meeting Time Monday Indicator. VARCHAR2(1)
p_tue_day   Section Meeting Time Tuesday Indicator. VARCHAR2(1)
p_wed_day   Section Meeting Time Wednesday Indicator. VARCHAR2(1)
p_thu_day   Section Meeting Time Thursday Indicator. VARCHAR2(1)
p_fri_day   Section Meeting Time Friday Indicator. VARCHAR2(1)
p_sat_day   Section Meeting Time Saturday Indicator. VARCHAR2(1)
p_schd_code   Section Schedule Type. VARCHAR2(3)
p_over_ride   Section Time Conflict Override Indicator. VARCHAR2(1)
p_credit_hr_sess   Session credit hours. NUMBER(7,3)
p_meet_no   Total Section Meeting Number which is system-generated. NUMBER(4)
p_hrs_week   Section Metting Hours per Week. NUMBER(5,2)
p_func_code   Function code assigned to an event. VARCHAR2(12)
p_comt_code   Committee/Service Type code. VARCHAR2(6)
p_schs_code   Schedule Status Code for use with Scheduling Tool Interface. VARCHAR2(3)
p_mtyp_code   Meeting Type Code assigned to the course section. VARCHAR2(4)
p_data_origin   Source system that generated the data. VARCHAR2(30)
p_user_id   Oracle ID of the user who inserted or last updated the data. VARCHAR2(30)

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

f_query_one 

FUNCTION f_query_one(p_term_code      ssrmeet.ssrmeet_term_code%TYPE,
                     p_crn            ssrmeet.ssrmeet_crn%TYPE,
                     p_begin_time     ssrmeet.ssrmeet_begin_time%TYPE,
                     p_end_time       ssrmeet.ssrmeet_end_time%TYPE,
                     p_bldg_code      ssrmeet.ssrmeet_bldg_code%TYPE,
                     p_room_code      ssrmeet.ssrmeet_room_code%TYPE,
                     p_start_date     ssrmeet.ssrmeet_start_date%TYPE,
                     p_end_date       ssrmeet.ssrmeet_end_date%TYPE,
                     p_catagory       ssrmeet.ssrmeet_catagory%TYPE,
                     p_sun_day        ssrmeet.ssrmeet_sun_day%TYPE,
                     p_mon_day        ssrmeet.ssrmeet_mon_day%TYPE,
                     p_tue_day        ssrmeet.ssrmeet_tue_day%TYPE,
                     p_wed_day        ssrmeet.ssrmeet_wed_day%TYPE,
                     p_thu_day        ssrmeet.ssrmeet_thu_day%TYPE,
                     p_fri_day        ssrmeet.ssrmeet_fri_day%TYPE,
                     p_sat_day        ssrmeet.ssrmeet_sat_day%TYPE,
                     p_schd_code      ssrmeet.ssrmeet_schd_code%TYPE,
                     p_over_ride      ssrmeet.ssrmeet_over_ride%TYPE,
                     p_credit_hr_sess ssrmeet.ssrmeet_credit_hr_sess%TYPE,
                     p_meet_no        ssrmeet.ssrmeet_meet_no%TYPE,
                     p_hrs_week       ssrmeet.ssrmeet_hrs_week%TYPE,
                     p_func_code      ssrmeet.ssrmeet_func_code%TYPE,
                     p_comt_code      ssrmeet.ssrmeet_comt_code%TYPE,
                     p_schs_code      ssrmeet.ssrmeet_schs_code%TYPE,
                     p_mtyp_code      ssrmeet.ssrmeet_mtyp_code%TYPE,
                     p_data_origin    ssrmeet.ssrmeet_data_origin%TYPE,
                     p_user_id        ssrmeet.ssrmeet_user_id%TYPE)
  RETURN classtimes_ref

Attempts to select one record using provided keys.
The SSRMEET table does not have a primary or unique key. There is no guarantee that the f_query_one function will return a unique record. The suggested approach is to use the f_query_all get multiple rows, perform analysis on the exact row(s) to work on then use the f_query_by_rowid using the ROWID.

Parameters
p_term_code   Term for the meeting times for the course section (for event/functions provide 'EVENT'). VARCHAR2(6) Required
p_crn   Course Reference Number (CRN) of the course section. VARCHAR2(5) Required
p_begin_time   Begin Time of the course section in HHMM format using 24-hour time. VARCHAR2(4) Required
p_end_time   End Time of the course section in HHMM format using 24-hour time. VARCHAR2(4) Required
p_bldg_code   Building associated with the course section. VARCHAR2(6) Required
p_room_code   Room associated with the course section. VARCHAR2(10) Required
p_start_date   Section Meeting Start Date. DATE Required
p_end_date   Section End Date. DATE Required
p_catagory   Section Indicator. VARCHAR2(2) Required
p_sun_day   Section Meeting Time Sunday Indicator. VARCHAR2(1) Required
p_mon_day   Section Meeting Time Monday Indicator. VARCHAR2(1) Required
p_tue_day   Section Meeting Time Tuesday Indicator. VARCHAR2(1) Required
p_wed_day   Section Meeting Time Wednesday Indicator. VARCHAR2(1) Required
p_thu_day   Section Meeting Time Thursday Indicator. VARCHAR2(1) Required
p_fri_day   Section Meeting Time Friday Indicator. VARCHAR2(1) Required
p_sat_day   Section Meeting Time Saturday Indicator. VARCHAR2(1) Required
p_schd_code   Section Schedule Type. VARCHAR2(3) Required
p_over_ride   Section Time Conflict Override Indicator. VARCHAR2(1) Required
p_credit_hr_sess   Session credit hours. NUMBER(7,3) Required
p_meet_no   Total Section Meeting Number which is system-generated. NUMBER(4) Required
p_hrs_week   Section Metting Hours per Week. NUMBER(5,2) Required
p_func_code   Function code assigned to an event. VARCHAR2(12) Required
p_comt_code   Committee/Service Type code. VARCHAR2(6) Required
p_schs_code   Schedule Status Code for use with Scheduling Tool Interface. VARCHAR2(3) Required
p_mtyp_code   Meeting Type Code assigned to the course section. VARCHAR2(4) Required
p_data_origin   Source system that generated the data. VARCHAR2(30) Required
p_user_id   Oracle ID of the user who inserted or last updated the data. VARCHAR2(30) Required

Returns
A cursor variable that will attempt to fetch one record (not guaranteed).

f_query_by_rowid 

FUNCTION f_query_by_rowid(p_rowid VARCHAR2) RETURN classtimes_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_rowid VARCHAR2) RETURN classtimes_ref

Selects one record using the ROWID and locks it.

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

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

p_create 

PROCEDURE p_create(p_term_code      ssrmeet.ssrmeet_term_code%TYPE,
                   p_crn            ssrmeet.ssrmeet_crn%TYPE,
                   p_days_code      ssrmeet.ssrmeet_days_code%TYPE DEFAULT NULL,
                   p_day_number     ssrmeet.ssrmeet_day_number%TYPE DEFAULT NULL,
                   p_begin_time     ssrmeet.ssrmeet_begin_time%TYPE DEFAULT NULL,
                   p_end_time       ssrmeet.ssrmeet_end_time%TYPE DEFAULT NULL,
                   p_bldg_code      ssrmeet.ssrmeet_bldg_code%TYPE DEFAULT NULL,
                   p_room_code      ssrmeet.ssrmeet_room_code%TYPE DEFAULT NULL,
                   p_start_date     ssrmeet.ssrmeet_start_date%TYPE,
                   p_end_date       ssrmeet.ssrmeet_end_date%TYPE,
                   p_catagory       ssrmeet.ssrmeet_catagory%TYPE DEFAULT NULL,
                   p_sun_day        ssrmeet.ssrmeet_sun_day%TYPE DEFAULT NULL,
                   p_mon_day        ssrmeet.ssrmeet_mon_day%TYPE DEFAULT NULL,
                   p_tue_day        ssrmeet.ssrmeet_tue_day%TYPE DEFAULT NULL,
                   p_wed_day        ssrmeet.ssrmeet_wed_day%TYPE DEFAULT NULL,
                   p_thu_day        ssrmeet.ssrmeet_thu_day%TYPE DEFAULT NULL,
                   p_fri_day        ssrmeet.ssrmeet_fri_day%TYPE DEFAULT NULL,
                   p_sat_day        ssrmeet.ssrmeet_sat_day%TYPE DEFAULT NULL,
                   p_schd_code      ssrmeet.ssrmeet_schd_code%TYPE DEFAULT NULL,
                   p_over_ride      ssrmeet.ssrmeet_over_ride%TYPE DEFAULT NULL,
                   p_credit_hr_sess ssrmeet.ssrmeet_credit_hr_sess%TYPE DEFAULT NULL,
                   p_meet_no        ssrmeet.ssrmeet_meet_no%TYPE DEFAULT NULL,
                   p_hrs_week       ssrmeet.ssrmeet_hrs_week%TYPE DEFAULT NULL,
                   p_func_code      ssrmeet.ssrmeet_func_code%TYPE DEFAULT NULL,
                   p_comt_code      ssrmeet.ssrmeet_comt_code%TYPE DEFAULT NULL,
                   p_schs_code      ssrmeet.ssrmeet_schs_code%TYPE DEFAULT NULL,
                   p_mtyp_code      ssrmeet.ssrmeet_mtyp_code%TYPE DEFAULT NULL,
                   p_data_origin    ssrmeet.ssrmeet_data_origin%TYPE DEFAULT NULL,
                   p_user_id        ssrmeet.ssrmeet_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_rowid_out      OUT VARCHAR2)

Creates a record.
@parm p_rowid_out Database ROWID of the record to be created. VARCHAR2(18)

Parameters
p_term_code   Term for the meeting times for the course section (for event/functions provide 'EVENT'). VARCHAR2(6) Required
p_crn   Course Reference Number (CRN) of the course section. VARCHAR2(5) Required
p_begin_time   Begin Time of the course section in HHMM format using 24-hour time. VARCHAR2(4)
p_end_time   End Time of the course section in HHMM format using 24-hour time. VARCHAR2(4)
p_bldg_code   Building associated with the course section. VARCHAR2(6)
p_room_code   Room associated with the course section. VARCHAR2(10)
p_start_date   Section Meeting Start Date. DATE Required
p_end_date   Section End Date. DATE Required
p_catagory   Section Indicator. VARCHAR2(2)
p_sun_day   Section Meeting Time Sunday Indicator. VARCHAR2(1)
p_mon_day   Section Meeting Time Monday Indicator. VARCHAR2(1)
p_tue_day   Section Meeting Time Tuesday Indicator. VARCHAR2(1)
p_wed_day   Section Meeting Time Wednesday Indicator. VARCHAR2(1)
p_thu_day   Section Meeting Time Thursday Indicator. VARCHAR2(1)
p_fri_day   Section Meeting Time Friday Indicator. VARCHAR2(1)
p_sat_day   Section Meeting Time Saturday Indicator. VARCHAR2(1)
p_schd_code   Section Schedule Type. VARCHAR2(3)
p_over_ride   Section Time Conflict Override Indicator. VARCHAR2(1)
p_credit_hr_sess   Session credit hours. NUMBER(7,3)
p_meet_no   Total Section Meeting Number which is system-generated. NUMBER(4)
p_hrs_week   Section Metting Hours per Week. NUMBER(5,2)
p_func_code   Function code assigned to an event. VARCHAR2(12)
p_comt_code   Committee/Service Type code. VARCHAR2(6)
p_schs_code   Schedule Status Code for use with Scheduling Tool Interface. VARCHAR2(3)
p_mtyp_code   Meeting Type Code assigned to the course section. VARCHAR2(4)
p_data_origin   Source system that generated the data. VARCHAR2(30)
p_user_id   Oracle ID of the user who inserted or last updated the data. VARCHAR2(30)

p_delete 

PROCEDURE p_delete(p_rowid VARCHAR2)

Deletes a record.

Parameters
p_rowid   Database ROWID of record to delete. VARCHAR(18)

p_lock 

PROCEDURE p_lock(p_rowid_inout IN OUT VARCHAR2)

Locks a record using the ROWID.

Parameters
p_rowid_inout   Database ROWID of record to lock. VARCHAR(18) Required

p_update 

PROCEDURE p_update(p_term_code      ssrmeet.ssrmeet_term_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_crn            ssrmeet.ssrmeet_crn%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_days_code      ssrmeet.ssrmeet_days_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_day_number     ssrmeet.ssrmeet_day_number%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_begin_time     ssrmeet.ssrmeet_begin_time%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_end_time       ssrmeet.ssrmeet_end_time%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_bldg_code      ssrmeet.ssrmeet_bldg_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_room_code      ssrmeet.ssrmeet_room_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_start_date     ssrmeet.ssrmeet_start_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_end_date       ssrmeet.ssrmeet_end_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_catagory       ssrmeet.ssrmeet_catagory%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_sun_day        ssrmeet.ssrmeet_sun_day%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_mon_day        ssrmeet.ssrmeet_mon_day%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_tue_day        ssrmeet.ssrmeet_tue_day%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_wed_day        ssrmeet.ssrmeet_wed_day%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_thu_day        ssrmeet.ssrmeet_thu_day%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_fri_day        ssrmeet.ssrmeet_fri_day%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_sat_day        ssrmeet.ssrmeet_sat_day%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_schd_code      ssrmeet.ssrmeet_schd_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_over_ride      ssrmeet.ssrmeet_over_ride%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_credit_hr_sess ssrmeet.ssrmeet_credit_hr_sess%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_meet_no        ssrmeet.ssrmeet_meet_no%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_hrs_week       ssrmeet.ssrmeet_hrs_week%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_func_code      ssrmeet.ssrmeet_func_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_comt_code      ssrmeet.ssrmeet_comt_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_schs_code      ssrmeet.ssrmeet_schs_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_mtyp_code      ssrmeet.ssrmeet_mtyp_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_data_origin    ssrmeet.ssrmeet_data_origin%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_user_id        ssrmeet.ssrmeet_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_rowid          VARCHAR2)

Updates a record.

Parameters
p_term_code   Term for the meeting times for the course section (for event/functions provide 'EVENT'). VARCHAR2(6)
p_crn   Course Reference Number (CRN) of the course section. VARCHAR2(5)
p_begin_time   Begin Time of the course section in HHMM format using 24-hour time. VARCHAR2(4)
p_end_time   End Time of the course section in HHMM format using 24-hour time. VARCHAR2(4)
p_bldg_code   Building associated with the course section. VARCHAR2(6)
p_room_code   Room associated with the course section. VARCHAR2(10)
p_start_date   Section Meeting Start Date. DATE
p_end_date   Section End Date. DATE
p_catagory   Section Indicator. VARCHAR2(2)
p_sun_day   Section Meeting Time Sunday Indicator. VARCHAR2(1)
p_mon_day   Section Meeting Time Monday Indicator. VARCHAR2(1)
p_tue_day   Section Meeting Time Tuesday Indicator. VARCHAR2(1)
p_wed_day   Section Meeting Time Wednesday Indicator. VARCHAR2(1)
p_thu_day   Section Meeting Time Thursday Indicator. VARCHAR2(1)
p_fri_day   Section Meeting Time Friday Indicator. VARCHAR2(1)
p_sat_day   Section Meeting Time Saturday Indicator. VARCHAR2(1)
p_schd_code   Section Schedule Type. VARCHAR2(3)
p_over_ride   Section Time Conflict Override Indicator. VARCHAR2(1)
p_credit_hr_sess   Session credit hours. NUMBER(7,3)
p_meet_no   Total Section Meeting Number which is system-generated. NUMBER(4)
p_hrs_week   Section Metting Hours per Week. NUMBER(5,2)
p_func_code   Function code assigned to an event. VARCHAR2(12)
p_comt_code   Committee/Service Type code. VARCHAR2(6)
p_schs_code   Schedule Status Code for use with Scheduling Tool Interface. VARCHAR2(3)
p_mtyp_code   Meeting Type Code assigned to the course section. VARCHAR2(4)
p_data_origin   Source system that generated the data. VARCHAR2(30)
p_user_id   Oracle ID of the user who inserted or last updated the data. VARCHAR2(30)
p_rowid   Database ROWID of record to update. VARCHAR(18) Required