|
Package BANINST1.sb_course_rules This package provides support subprograms for the Course API (sb_course). |
| Program units |
| p_register_entity |
| p_register_entity |
| p_validate |
| p_validate_children |
p_register_entity
Procedure p_register_entity(p_operation_type NUMBER,
p_internal_record_id VARCHAR2)
Registers the attribute/value pairs to the message cache.
This signature uses the ROWID only for the delete operations.
| Parameters |
| p_internal_record_id |
Database ROWID. VARCHAR2(18) |
p_register_entity
Procedure p_register_entity(p_operation_type NUMBER,
p_subj_code scbcrse.scbcrse_subj_code%TYPE,
p_crse_numb scbcrse.scbcrse_crse_numb%TYPE,
p_eff_term scbcrse.scbcrse_eff_term%TYPE,
p_coll_code scbcrse.scbcrse_coll_code%TYPE,
p_divs_code scbcrse.scbcrse_divs_code%TYPE,
p_dept_code scbcrse.scbcrse_dept_code%TYPE,
p_csta_code scbcrse.scbcrse_csta_code%TYPE,
p_title scbcrse.scbcrse_title%TYPE,
p_cipc_code scbcrse.scbcrse_cipc_code%TYPE,
p_credit_hr_ind scbcrse.scbcrse_credit_hr_ind%TYPE,
p_credit_hr_low scbcrse.scbcrse_credit_hr_low%TYPE,
p_credit_hr_high scbcrse.scbcrse_credit_hr_high%TYPE,
p_lec_hr_ind scbcrse.scbcrse_lec_hr_ind%TYPE,
p_lec_hr_low scbcrse.scbcrse_lec_hr_low%TYPE,
p_lec_hr_high scbcrse.scbcrse_lec_hr_high%TYPE,
p_lab_hr_ind scbcrse.scbcrse_lab_hr_ind%TYPE,
p_lab_hr_low scbcrse.scbcrse_lab_hr_low%TYPE,
p_lab_hr_high scbcrse.scbcrse_lab_hr_high%TYPE,
p_oth_hr_ind scbcrse.scbcrse_oth_hr_ind%TYPE,
p_oth_hr_low scbcrse.scbcrse_oth_hr_low%TYPE,
p_oth_hr_high scbcrse.scbcrse_oth_hr_high%TYPE,
p_bill_hr_ind scbcrse.scbcrse_bill_hr_ind%TYPE,
p_bill_hr_low scbcrse.scbcrse_bill_hr_low%TYPE,
p_bill_hr_high scbcrse.scbcrse_bill_hr_high%TYPE,
p_aprv_code scbcrse.scbcrse_aprv_code%TYPE,
p_repeat_limit scbcrse.scbcrse_repeat_limit%TYPE,
p_pwav_code scbcrse.scbcrse_pwav_code%TYPE,
p_tuiw_ind scbcrse.scbcrse_tuiw_ind%TYPE,
p_add_fees_ind scbcrse.scbcrse_add_fees_ind%TYPE,
p_cont_hr_low scbcrse.scbcrse_cont_hr_low%TYPE,
p_cont_hr_ind scbcrse.scbcrse_cont_hr_ind%TYPE,
p_cont_hr_high scbcrse.scbcrse_cont_hr_high%TYPE,
p_ceu_ind scbcrse.scbcrse_ceu_ind%TYPE,
p_reps_code scbcrse.scbcrse_reps_code%TYPE,
p_max_rpt_units scbcrse.scbcrse_max_rpt_units%TYPE,
p_capp_prereq_test_ind scbcrse.scbcrse_capp_prereq_test_ind%TYPE,
p_dunt_code scbcrse.scbcrse_dunt_code%TYPE,
p_number_of_units scbcrse.scbcrse_number_of_units%TYPE,
p_data_origin scbcrse.scbcrse_data_origin%TYPE,
p_user_id scbcrse.scbcrse_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_prereq_chk_method_cde scbcrse.scbcrse_prereq_chk_method_cde%TYPE,
p_internal_record_id VARCHAR2)
Registers the attribute/value pairs to the message cache.
This signature registers all the parameters.
| Parameters |
| p_subj_code |
Subject area of the course. VARCHAR2(4) Required Key | |
| p_crse_numb |
Course number associated with the subject for the course. VARCHAR2(5) Required Key | |
| p_eff_term |
Term this version of the course becomes effective. VARCHAR2(6) Required Key | |
| p_coll_code |
College which offers the course. VARCHAR2(2) Required | |
| p_divs_code |
Division which offers the course. VARCHAR2(4) | |
| p_dept_code |
Department which offers the course. VARCHAR2(4) | |
| p_csta_code |
Status of the course. VARCHAR2(1) Required | |
| p_title |
Title of the course. VARCHAR2(30) | |
| p_cipc_code |
CIP code of the course. VARCHAR2(6) | |
| p_credit_hr_ind |
Indicates whether the course can be offered for variable credit. VARCHAR2(2) | |
| p_credit_hr_low |
Minimum number of credit hours for which a course may be offered. NUMBER(7,3) Required | |
| p_credit_hr_high |
Maximum credit hour value within a range, or a second credit hour value for which the course may be taken. NUMBER(7,3) | |
| p_lec_hr_ind |
Indicates whether the course can be offered for variable lecture hours. VARCHAR2(2) | |
| p_lec_hr_low |
Minimum number of lecture hours for which a course may be offered. NUMBER(7,3) | |
| p_lec_hr_high |
Maximum lecture hour value within a range, or a second lecture hour value for which the course may be taken. NUMBER(7,3) | |
| p_lab_hr_ind |
Indicates whether the course can be offered for variable lab hours. VARCHAR2(2) | |
| p_lab_hr_low |
Minimum number of lab hours for which a course may be offered. NUMBER(7,3) | |
| p_lab_hr_high |
Maximum lab hour value within a range, or a second lab hour value for which the course may be taken. NUMBER(7,3) | |
| p_oth_hr_ind |
Indicates whether the course can be offered for variable other hours. VARCHAR2(2) | |
| p_oth_hr_low |
Minimum number of other hours for which the course may be offered. NUMBER(7,3) | |
| p_oth_hr_high |
Maximum other hour value within a range, or a second other hour value for which the course may be taken. NUMBER(7,3) | |
| p_bill_hr_ind |
Indicates whether the course can be offered for variable billing hours. VARCHAR2(2) | |
| p_bill_hr_low |
Minimum number of billing hours for which the course may be offered. NUMBER(7,3) Required | |
| p_bill_hr_high |
Maximum billing hour value within a range, or a second billing hour value for which the course may be taken. NUMBER(7,3) | |
| p_aprv_code |
Type of requirements a course is approved to fulfill. VARCHAR2(1) | |
| p_repeat_limit |
Maximum number of times the course may be repeated by a student. NUMBER(2) | |
| p_pwav_code |
Type of authorization a student must have in order to waive a prerequisite requirement. VARCHAR2(1) | |
| p_tuiw_ind |
Indicator that specifies whether the course is exempt from tuition and fees defined on the Registration Fees Process Control Form (SFARGFE). VARCHAR2(1) | |
| p_add_fees_ind |
Indicator that specifies that additional fees defined on the Fee Code block of the Course Detail Form (SCADETL) are charged for the course. VARCHAR2(1) | |
| p_cont_hr_low |
Minimum number of contact hours for which the course may be offered. NUMBER(7,3) | |
| p_cont_hr_ind |
Indicates whether the course can be offered for variable contact hours. VARCHAR2(2) | |
| p_cont_hr_high |
Maximum contact hour value within a range, or a second contact hour value for which the course may be taken. NUMBER(7,3) | |
| p_ceu_ind |
Indicates that a course is a Continuing Education course. VARCHAR2(1) | |
| p_reps_code |
Repeat status code used for reporting purposes. VARCHAR2(2) | |
| p_max_rpt_units |
Maximum number of credits for which a student may repeat the course. NUMBER(9,3) | |
| p_capp_prereq_test_ind |
Indicates whether CAPP (degree evaluation) areas or existing prerequisite and test score restrictions are in effect for the course. VARCHAR2(1) Required | |
| p_dunt_code |
Type of duration for which the course is offered. VARCHAR2(4) | |
| p_number_of_units |
Total number of times the duration unit extends. NUMBER(7,2) | |
| 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_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 being registered. VARCHAR2(18) |
p_validate
Procedure p_validate(p_subj_code scbcrse.scbcrse_subj_code%TYPE,
p_crse_numb scbcrse.scbcrse_crse_numb%TYPE,
p_eff_term scbcrse.scbcrse_eff_term%TYPE,
p_coll_code scbcrse.scbcrse_coll_code%TYPE DEFAULT NULL,
p_divs_code scbcrse.scbcrse_divs_code%TYPE DEFAULT NULL,
p_dept_code scbcrse.scbcrse_dept_code%TYPE DEFAULT NULL,
p_csta_code scbcrse.scbcrse_csta_code%TYPE DEFAULT NULL,
p_title scbcrse.scbcrse_title%TYPE DEFAULT NULL,
p_cipc_code scbcrse.scbcrse_cipc_code%TYPE DEFAULT NULL,
p_credit_hr_ind scbcrse.scbcrse_credit_hr_ind%TYPE DEFAULT NULL,
p_credit_hr_low scbcrse.scbcrse_credit_hr_low%TYPE DEFAULT NULL,
p_credit_hr_high scbcrse.scbcrse_credit_hr_high%TYPE DEFAULT NULL,
p_lec_hr_ind scbcrse.scbcrse_lec_hr_ind%TYPE DEFAULT NULL,
p_lec_hr_low scbcrse.scbcrse_lec_hr_low%TYPE DEFAULT NULL,
p_lec_hr_high scbcrse.scbcrse_lec_hr_high%TYPE DEFAULT NULL,
p_lab_hr_ind scbcrse.scbcrse_lab_hr_ind%TYPE DEFAULT NULL,
p_lab_hr_low scbcrse.scbcrse_lab_hr_low%TYPE DEFAULT NULL,
p_lab_hr_high scbcrse.scbcrse_lab_hr_high%TYPE DEFAULT NULL,
p_oth_hr_ind scbcrse.scbcrse_oth_hr_ind%TYPE DEFAULT NULL,
p_oth_hr_low scbcrse.scbcrse_oth_hr_low%TYPE DEFAULT NULL,
p_oth_hr_high scbcrse.scbcrse_oth_hr_high%TYPE DEFAULT NULL,
p_bill_hr_ind scbcrse.scbcrse_bill_hr_ind%TYPE DEFAULT NULL,
p_bill_hr_low scbcrse.scbcrse_bill_hr_low%TYPE DEFAULT NULL,
p_bill_hr_high scbcrse.scbcrse_bill_hr_high%TYPE DEFAULT NULL,
p_aprv_code scbcrse.scbcrse_aprv_code%TYPE DEFAULT NULL,
p_repeat_limit scbcrse.scbcrse_repeat_limit%TYPE DEFAULT NULL,
p_pwav_code scbcrse.scbcrse_pwav_code%TYPE DEFAULT NULL,
p_tuiw_ind scbcrse.scbcrse_tuiw_ind%TYPE DEFAULT NULL,
p_add_fees_ind scbcrse.scbcrse_add_fees_ind%TYPE DEFAULT NULL,
p_cont_hr_low scbcrse.scbcrse_cont_hr_low%TYPE DEFAULT NULL,
p_cont_hr_ind scbcrse.scbcrse_cont_hr_ind%TYPE DEFAULT NULL,
p_cont_hr_high scbcrse.scbcrse_cont_hr_high%TYPE DEFAULT NULL,
p_ceu_ind scbcrse.scbcrse_ceu_ind%TYPE DEFAULT NULL,
p_reps_code scbcrse.scbcrse_reps_code%TYPE DEFAULT NULL,
p_max_rpt_units scbcrse.scbcrse_max_rpt_units%TYPE DEFAULT NULL,
p_capp_prereq_test_ind scbcrse.scbcrse_capp_prereq_test_ind%TYPE,
p_dunt_code scbcrse.scbcrse_dunt_code%TYPE DEFAULT NULL,
p_number_of_units scbcrse.scbcrse_number_of_units%TYPE DEFAULT NULL,
p_data_origin scbcrse.scbcrse_data_origin%TYPE DEFAULT NULL,
p_user_id scbcrse.scbcrse_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_prereq_chk_method_cde scbcrse.scbcrse_prereq_chk_method_cde%TYPE DEFAULT NULL)
Validates all the data in the record.
| Parameters |
| p_subj_code |
Subject area of the course. VARCHAR2(4) Required Key | |
| p_crse_numb |
Course number associated with the subject for the course. VARCHAR2(5) Required Key | |
| p_eff_term |
Term this version of the course becomes effective. VARCHAR2(6) Required Key | |
| p_coll_code |
College which offers the course. VARCHAR2(2) Required | |
| p_divs_code |
Division which offers the course. VARCHAR2(4) | |
| p_dept_code |
Department which offers the course. VARCHAR2(4) | |
| p_csta_code |
Status of the course. VARCHAR2(1) Required | |
| p_title |
Title of the course. VARCHAR2(30) | |
| p_cipc_code |
CIP code of the course. VARCHAR2(6) | |
| p_credit_hr_ind |
Indicates whether the course can be offered for variable credit. VARCHAR2(2) | |
| p_credit_hr_low |
Minimum number of credit hours for which a course may be offered. NUMBER(7,3) Required | |
| p_credit_hr_high |
Maximum credit hour value within a range, or a second credit hour value for which the course may be taken. NUMBER(7,3) | |
| p_lec_hr_ind |
Indicates whether the course can be offered for variable lecture hours. VARCHAR2(2) | |
| p_lec_hr_low |
Minimum number of lecture hours for which a course may be offered. NUMBER(7,3) | |
| p_lec_hr_high |
Maximum lecture hour value within a range, or a second lecture hour value for which the course may be taken. NUMBER(7,3) | |
| p_lab_hr_ind |
Indicates whether the course can be offered for variable lab hours. VARCHAR2(2) | |
| p_lab_hr_low |
Minimum number of lab hours for which a course may be offered. NUMBER(7,3) | |
| p_lab_hr_high |
Maximum lab hour value within a range, or a second lab hour value for which the course may be taken. NUMBER(7,3) | |
| p_oth_hr_ind |
Indicates whether the course can be offered for variable other hours. VARCHAR2(2) | |
| p_oth_hr_low |
Minimum number of other hours for which the course may be offered. NUMBER(7,3) | |
| p_oth_hr_high |
Maximum other hour value within a range, or a second other hour value for which the course may be taken. NUMBER(7,3) | |
| p_bill_hr_ind |
Indicates whether the course can be offered for variable billing hours. VARCHAR2(2) | |
| p_bill_hr_low |
Minimum number of billing hours for which the course may be offered. NUMBER(7,3) Required | |
| p_bill_hr_high |
Maximum billing hour value within a range, or a second billing hour value for which the course may be taken. NUMBER(7,3) | |
| p_aprv_code |
Type of requirements a course is approved to fulfill. VARCHAR2(1) | |
| p_repeat_limit |
Maximum number of times the course may be repeated by a student. NUMBER(2) | |
| p_pwav_code |
Type of authorization a student must have in order to waive a prerequisite requirement. VARCHAR2(1) | |
| p_tuiw_ind |
Indicator that specifies whether the course is exempt from tuition and fees defined on the Registration Fees Process Control Form (SFARGFE). VARCHAR2(1) | |
| p_add_fees_ind |
Indicator that specifies that additional fees defined on the Fee Code block of the Course Detail Form (SCADETL) are charged for the course. VARCHAR2(1) | |
| p_cont_hr_low |
Minimum number of contact hours for which the course may be offered. NUMBER(7,3) | |
| p_cont_hr_ind |
Indicates whether the course can be offered for variable contact hours. VARCHAR2(2) | |
| p_cont_hr_high |
Maximum contact hour value within a range, or a second contact hour value for which the course may be taken. NUMBER(7,3) | |
| p_ceu_ind |
Indicates that a course is a Continuing Education course. VARCHAR2(1) | |
| p_reps_code |
Repeat status code used for reporting purposes. VARCHAR2(2) | |
| p_max_rpt_units |
Maximum number of credits for which a student may repeat the course. NUMBER(9,3) | |
| p_capp_prereq_test_ind |
Indicates whether CAPP (degree evaluation) areas or existing prerequisite and test score restrictions are in effect for the course. VARCHAR2(1) Required | |
| p_dunt_code |
Type of duration for which the course is offered. VARCHAR2(4) | |
| p_number_of_units |
Total number of times the duration unit extends. NUMBER(7,2) | |
| 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_prereq_chk_method_cde |
Denote B for Basic, C for CAPP, and D for DegreeWorks prerequisite checking method. VARCHAR2(1) |
p_validate_children
Procedure p_validate_children(p_base_exists IN BOOLEAN,
p_ceu_ind IN scbcrse.scbcrse_ceu_ind%TYPE DEFAULT NULL,
p_levl_code IN scrlevl.scrlevl_levl_code%TYPE DEFAULT NULL,
p_gmod_code IN scrgmod.scrgmod_gmod_code%TYPE DEFAULT NULL,
p_schd_code IN scrschd.scrschd_schd_code%TYPE DEFAULT NULL,
p_insm_code IN scrschd.scrschd_insm_code%TYPE DEFAULT NULL)
Validates the data used to create the child records.
| Parameters |
| p_base_exists |
Indicates whether or not a Course Base Maintenance (SCBCRKY) record exists for this course. BOOLEAN | |
| p_ceu_ind |
Indicates whether or not a course is a Continuing Education course. VARCHAR2(1) | |
| p_levl_code |
Level for which the course may be offered. VARCHAR2(2) | |
| p_gmod_code |
Grading mode authorized for the course. VARCHAR2(1) | |
| p_schd_code |
Schedule type code authorized for the course. VARCHAR2(3) | |
| p_insm_code |
Instructional method for the course. VARCHAR2(5) |