BANINST1@S10B80 |
|
Package sb_term_rules This package provides the support subprograms for the Term API (sb_term). |
| Program units |
| p_register_entity | Registers the attribute/value pairs to the message cache. |
| p_register_entity | Registers the attribute/value pairs to the message cache. |
| p_validate | Validates all the data in the record. |
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. |
p_register_entity
Procedure p_register_entity(p_operation_type NUMBER,
p_term_code sobterm.sobterm_term_code%TYPE,
p_crn_oneup sobterm.sobterm_crn_oneup%TYPE,
p_reg_allowed sobterm.sobterm_reg_allowed%TYPE,
p_readm_req sobterm.sobterm_readm_req%TYPE,
p_fee_assessment sobterm.sobterm_fee_assessment%TYPE,
p_fee_assessmnt_eff_date sobterm.sobterm_fee_assessmnt_eff_date%TYPE,
p_dupl_severity sobterm.sobterm_dupl_severity%TYPE,
p_link_severity sobterm.sobterm_link_severity%TYPE,
p_preq_severity sobterm.sobterm_preq_severity%TYPE,
p_corq_severity sobterm.sobterm_corq_severity%TYPE,
p_time_severity sobterm.sobterm_time_severity%TYPE,
p_capc_severity sobterm.sobterm_capc_severity%TYPE,
p_levl_severity sobterm.sobterm_levl_severity%TYPE,
p_coll_severity sobterm.sobterm_coll_severity%TYPE,
p_majr_severity sobterm.sobterm_majr_severity%TYPE,
p_clas_severity sobterm.sobterm_clas_severity%TYPE,
p_appr_severity sobterm.sobterm_appr_severity%TYPE,
p_minh_severity sobterm.sobterm_minh_severity%TYPE,
p_maxh_severity sobterm.sobterm_maxh_severity%TYPE,
p_hold_severity sobterm.sobterm_hold_severity%TYPE,
p_hold sobterm.sobterm_hold%TYPE,
p_refund_ind sobterm.sobterm_refund_ind%TYPE,
p_bycrn_ind sobterm.sobterm_bycrn_ind%TYPE,
p_rept_severity sobterm.sobterm_rept_severity%TYPE,
p_rpth_severity sobterm.sobterm_rpth_severity%TYPE,
p_test_severity sobterm.sobterm_test_severity%TYPE,
p_camp_severity sobterm.sobterm_camp_severity%TYPE,
p_fee_assess_vr sobterm.sobterm_fee_assess_vr%TYPE,
p_print_bill_vr sobterm.sobterm_print_bill_vr%TYPE,
p_tmst_calc_ind sobterm.sobterm_tmst_calc_ind%TYPE,
p_incl_attmpt_hrs_ind sobterm.sobterm_incl_attmpt_hrs_ind%TYPE,
p_cred_web_upd_ind sobterm.sobterm_cred_web_upd_ind%TYPE,
p_gmod_web_upd_ind sobterm.sobterm_gmod_web_upd_ind%TYPE,
p_levl_web_upd_ind sobterm.sobterm_levl_web_upd_ind%TYPE,
p_closect_web_disp_ind sobterm.sobterm_closect_web_disp_ind%TYPE,
p_mailer_web_ind sobterm.sobterm_mailer_web_ind%TYPE,
p_schd_web_search_ind sobterm.sobterm_schd_web_search_ind%TYPE,
p_camp_web_search_ind sobterm.sobterm_camp_web_search_ind%TYPE,
p_sess_web_search_ind sobterm.sobterm_sess_web_search_ind%TYPE,
p_instr_web_search_ind sobterm.sobterm_instr_web_search_ind%TYPE,
p_facschd_web_disp_ind sobterm.sobterm_facschd_web_disp_ind%TYPE,
p_claslst_web_disp_ind sobterm.sobterm_claslst_web_disp_ind%TYPE,
p_overapp_web_upd_ind sobterm.sobterm_overapp_web_upd_ind%TYPE,
p_add_drp_web_upd_ind sobterm.sobterm_add_drp_web_upd_ind%TYPE,
p_degree_severity sobterm.sobterm_degree_severity%TYPE,
p_program_severity sobterm.sobterm_program_severity%TYPE,
p_dept_severity sobterm.sobterm_dept_severity%TYPE,
p_atts_severity sobterm.sobterm_atts_severity%TYPE,
p_chrt_severity sobterm.sobterm_chrt_severity%TYPE,
p_mexc_severity sobterm.sobterm_mexc_severity%TYPE,
p_inprogress_usage_ind sobterm.sobterm_inprogress_usage_ind%TYPE,
p_grade_detail_web_ind sobterm.sobterm_grade_detail_web_ind%TYPE,
p_midterm_web_ind sobterm.sobterm_midterm_web_ind%TYPE,
p_profile_send_ind sobterm.sobterm_profile_send_ind%TYPE,
p_cutoff_date sobterm.sobterm_cutoff_date%TYPE,
p_tiv_date_source sobterm.sobterm_tiv_date_source%TYPE,
p_web_capp_term_ind sobterm.sobterm_web_capp_term_ind%TYPE,
p_web_capp_catlg_ind sobterm.sobterm_web_capp_catlg_ind%TYPE,
p_attr_web_search_ind sobterm.sobterm_attr_web_search_ind%TYPE,
p_levl_web_search_ind sobterm.sobterm_levl_web_search_ind%TYPE,
p_insm_web_search_ind sobterm.sobterm_insm_web_search_ind%TYPE,
p_ls_title_webs_disp_ind sobterm.sobterm_ls_title_webs_disp_ind%TYPE,
p_ls_desc_webs_disp_ind sobterm.sobterm_ls_desc_webs_disp_ind%TYPE,
p_duration_web_srch_ind sobterm.sobterm_duration_web_srch_ind%TYPE,
p_levl_web_catl_srch_ind sobterm.sobterm_levl_web_catl_srch_ind%TYPE,
p_styp_web_catl_srch_ind sobterm.sobterm_styp_web_catl_srch_ind%TYPE,
p_coll_web_catl_srch_ind sobterm.sobterm_coll_web_catl_srch_ind%TYPE,
p_div_web_catl_srch_ind sobterm.sobterm_div_web_catl_srch_ind%TYPE,
p_dept_web_catl_srch_ind sobterm.sobterm_dept_web_catl_srch_ind%TYPE,
p_prog_att_webc_srch_ind sobterm.sobterm_prog_att_webc_srch_ind%TYPE,
p_lc_title_webc_disp_ind sobterm.sobterm_lc_title_webc_disp_ind%TYPE,
p_lc_desc_webc_disp_ind sobterm.sobterm_lc_desc_webc_disp_ind%TYPE,
p_dynamic_sched_term_ind sobterm.sobterm_dynamic_sched_term_ind%TYPE,
p_assess_swap_ind sobterm.sobterm_assess_swap_ind%TYPE,
p_assess_rev_nrf_ind sobterm.sobterm_assess_rev_nrf_ind%TYPE,
p_assess_reg_grace_ind sobterm.sobterm_assess_reg_grace_ind%TYPE,
p_study_path_ind sobterm.sobterm_study_path_ind%TYPE,
p_future_repeat_ind sobterm.sobterm_future_repeat_ind%TYPE,
p_sp_web_upd_ind sobterm.sobterm_sp_web_upd_ind%TYPE,
p_sectionfee_ind sobterm.sobterm_sectionfee_ind%TYPE,
p_meeting_time_src_cde sobterm.sobterm_meeting_time_src_cde%TYPE DEFAULT NULL,
p_plan_term_open_cde sobterm.sobterm_plan_term_open_cde%TYPE DEFAULT NULL,
p_sec_allowed_plan_cde sobterm.sobterm_sec_allowed_plan_cde%TYPE DEFAULT NULL,
p_max_plans sobterm.sobterm_max_plans%TYPE DEFAULT NULL,
p_deg_audit_plan_cde sobterm.sobterm_deg_audit_plan_cde%TYPE DEFAULT NULL,
p_plan_da_reg_cde sobterm.sobterm_plan_da_reg_cde%TYPE DEFAULT NULL,
p_plan_reg_cde sobterm.sobterm_plan_reg_cde%TYPE DEFAULT NULL,
p_cond_add_drop_cde sobterm.sobterm_cond_add_drop_cde%TYPE DEFAULT NULL,
p_auto_drop_cde sobterm.sobterm_auto_drop_cde%TYPE DEFAULT NULL,
p_admin_drop_cde sobterm.sobterm_admin_drop_cde%TYPE DEFAULT NULL,
p_drop_last_class_cde sobterm.sobterm_drop_last_class_cde%TYPE DEFAULT NULL,
p_data_origin sobterm.sobterm_data_origin%TYPE,
p_user_id sobterm.sobterm_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_internal_record_id VARCHAR2)
Registers the attribute/value pairs to the message cache.
This signature registers all the parameters.
| Parameters |
| p_term_code |
Unique term code that identifies the base term record. VARCHAR2(6) Required Key | |
| p_crn_oneup |
Last Course Reference Number (CRN) generated by the system. NUMBER(5) Required | |
| p_reg_allowed |
Indicates whether online registration is allowed for the Key Block Term. Values are "Y"-allow registration or "N"-no online registration. VARCHAR2(1) Required | |
| p_readm_req |
Re-Admit term. If a student has not registered since this term, they must be re-admitted through Admissions. VARCHAR2(6) | |
| p_fee_assessment |
Indicates whether fee assessment can be initiated online. "Y"-allow online fee assessment, "N"-only batch fee assessment. VARCHAR2(1) Required | |
| p_fee_assessmnt_eff_date |
Effective date associated with fees assessed online at registration. This date is associated with charges on the student Account Detail Record. DATE | |
| p_dupl_severity |
Indicates how duplicate course entries are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_link_severity |
Indicates how linked course sections are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_preq_severity |
Indicates whether course prerequisites are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_corq_severity |
Indicates whether course and section corequisites are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_time_severity |
Indicates whether course section time conflicts are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_capc_severity |
Indicates whether course section capacity is checked during online registration. Values are "F"-fatal error, "W"-warning, "N"-no check. VARCHAR2(1) Required | |
| p_levl_severity |
Indicates whether course level restrictions are checked during online registration. Values are "F"-fatal error, "W"-warning, "N"-no check. VARCHAR2(1) Required | |
| p_coll_severity |
Indicates whether course or section college restrictions are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_majr_severity |
Indicates whether course or section student major restrictions are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_clas_severity |
Indicates whether course or section class restrictions are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_appr_severity |
Indicates whether course section special approval indicators are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_minh_severity |
Indicates whether the student minimum hours are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_maxh_severity |
Indicates whether the student maximum hours are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_hold_severity |
Indicates whether the person holds are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_hold |
Registration Hold Password. VARCHAR2(3) | |
| p_refund_ind |
Refund By Total Indicator. VARCHAR2(1) | |
| p_bycrn_ind |
Assess by CRN Indicator. VARCHAR2(1) | |
| p_rept_severity |
Used to denote repeat severity. VARCHAR2(1) Required | |
| p_rpth_severity |
Used to denote repeat hours severity. VARCHAR2(1) Required | |
| p_test_severity |
Used to denote test score severity. VARCHAR2(1) | |
| p_camp_severity |
Campus Registration Restriction error severity code. VARCHAR2(1) Required | |
| p_fee_assess_vr |
Self-Service and Voice Response Fee Assessment Indicator. VARCHAR2(1) | |
| p_print_bill_vr |
Self-Service and Voice Response Print Bill Indicator. VARCHAR2(1) | |
| p_tmst_calc_ind |
Indicates whether time status calculations should occur automatically in designated forms on a term-by-term basis. VARCHAR2(1) Required | |
| p_incl_attmpt_hrs_ind |
Indicates whether the system should include credit hours from in-progress courses (those still in registration and not yet rolled to history) when calculating student classification for registration purposes. VARCHAR2(1) Required | |
| p_cred_web_upd_ind |
Indicates whether students can change class option credit hours on the Web. VARCHAR2(1) Required | |
| p_gmod_web_upd_ind |
Indicates whether students can change class option grading modes on the Web. VARCHAR2(1) Required | |
| p_levl_web_upd_ind |
Indicates whether students can change class option levels on the Web. VARCHAR2(1) Required | |
| p_closect_web_disp_ind |
Indicates whether a closed section should be displayed on the Web. VARCHAR2(1) Required | |
| p_mailer_web_ind |
Indicates whether to allow grades to be accessed on the Web for the term. VARCHAR2(1) Required | |
| p_schd_web_search_ind |
Indicates whether schedule types will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_camp_web_search_ind |
Indicates whether campuses will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_sess_web_search_ind |
Indicates whether sessions will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_instr_web_search_ind |
Indicates whether instructors will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_facschd_web_disp_ind |
Controls access to the Faculty Schedule Display page in the Faculty Web product. VARCHAR2(1) Required | |
| p_claslst_web_disp_ind |
Controls access to the Class List Display page in the Faculty Web product. VARCHAR2(1) Required | |
| p_overapp_web_upd_ind |
Controls access to the Registration Approval/Overrides page in the Faculty Web product. VARCHAR2(1) Required | |
| p_add_drp_web_upd_ind |
Controls access to the Registration Add/Drop page in the Faculty Web product. VARCHAR2(1) Required | |
| p_degree_severity |
Indicates the type of degree restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_program_severity |
Indicates the type of program restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_dept_severity |
Indicates the type of department restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_atts_severity |
Indicates the type of student attribute restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_chrt_severity |
Indicates the type of cohort restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_mexc_severity |
Indicates the type of mutual exclusion restriction checking (no checking, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_inprogress_usage_ind |
Indicates whether in-progress courses should fulfill prerequisite requirements for the term. VARCHAR2(1) Required | |
| p_grade_detail_web_ind |
Indicates whether to allow grade detail display via the Web for the term. VARCHAR2(2) Required | |
| p_midterm_web_ind |
Indicates whether to allow midterm grade display via the Web for the term. VARCHAR2(2) Required | |
| p_profile_send_ind |
Indicates whether information specific to the term should be passed to Campus Pipeline. VARCHAR2(2) Required | |
| p_cutoff_date |
Last date that calculated charges are considered original. DATE Required | |
| p_tiv_date_source |
Source of Title IV default start and end date. T=Term; P=Part-of-Term. VARCHAR2(1) Required | |
| p_web_capp_term_ind |
Indicates whether the term code displayed in the key block is a valid term code to be used as the evaluation term for WebCAPP (degree evaluation on the Web) compliance processing. VARCHAR2(1) Required | |
| p_web_capp_catlg_ind |
Indicates whether the term code displayed in the key block is a valid term code to be used as a catalog term for WebCAPP (degree evaluation on the Web) processing. VARCHAR2(1) Required | |
| p_attr_web_search_ind |
Indicates whether the term code displayed in the key block will allow attributes as search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_levl_web_search_ind |
Indicates whether levels will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_insm_web_search_ind |
Indicates whether instructional methods will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_ls_title_webs_disp_ind |
Indicates whether long section titles should be displayed on the Web. VARCHAR2(1) Required | |
| p_ls_desc_webs_disp_ind |
Indicates whether long section descriptions should be displayed on the Web. VARCHAR2(1) Required | |
| p_duration_web_srch_ind |
Indicates whether durations will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_levl_web_catl_srch_ind |
Indicates whether levels will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_styp_web_catl_srch_ind |
Indicates whether schedule types will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_coll_web_catl_srch_ind |
Indicates whether colleges will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_div_web_catl_srch_ind |
Indicates whether divisions will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_dept_web_catl_srch_ind |
Indicates whether departments will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_prog_att_webc_srch_ind |
Indicates whether program attributes will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_lc_title_webc_disp_ind |
Indicates whether long course titles should be displayed in the Web catalog. VARCHAR2(1) Required | |
| p_lc_desc_webc_disp_ind |
Indicates whether long course descriptions should be displayed in the Web catalog. VARCHAR2(1) Required | |
| p_dynamic_sched_term_ind |
Indicates whether the term should be displayed in the Web Select Term pulldown. VARCHAR2(1) Required | |
| p_assess_swap_ind |
Indicates whether to allow course/hours swapping in registration fee assessment. VARCHAR2(1) Required | |
| p_assess_rev_nrf_ind |
Indicates whether to allow the reversal of charges to detail codes having a category code other than TUI or FEE in registration fee assessment. VARCHAR2(1) Required | |
| p_assess_reg_grace_ind |
Indicates whether to allow grace when dropping a course with the same amount of bill hours as a course added on the same initial day of a student's registration. VARCHAR2(1) Required | |
| p_study_path_ind |
Indicates whether study path is required for registration for the term. VARCHAR2(1) Required | |
| p_future_repeat_ind |
Indicates whether future registrations are to be considered by repeat course processing. VARCHAR2(1) Required | |
| p_sp_web_upd_ind |
Indicates whether students can change class option study paths on the Web. VARCHAR2(1) Required | |
| p_sectionfee_ind |
Indicates whether the study path from a registration is stored in SFRFAUD and TBRACCD when the charge is from a section fee. VARCHAR2(1) Required | |
| p_meeting_time_src_cde |
Code for Meeting Time Integration Source. VARCHAR2(1) -- Y or N or null | |
| p_plan_term_open_cde |
Code for Term open for Planning VARCHAR2(1) -- Y or N or null | |
| p_sec_allowed_plan_cde |
Code for Section is allowed to add to Plans.VARCHAR2(1) -- Y or N or null | |
| p_max_plans |
Maximum numbers of Plans that students can create. NUMBER(3) -- Values can be between 0 to 999 | |
| p_deg_audit_plan_cde |
Code for Degree Audit System Integration --VARCHAR2(1) -- Y or N or null | |
| p_plan_da_reg_cde. |
Banner XE code to allow Degree Audit plans to display in registration. Y or N or null. | |
| p_plan_reg_cde. |
Banner XE code to allow Registration Plans to display in registration. Y or N or null. | |
| p_cond_add_drop_cde |
Banner XE Registration code Y or N to allow conditional add drop selection. | |
| p_auto_drop_cde |
Banner XE Registration code C (Confirm automatic drop), Y(Yes automatically drop), N(No provide error message) to automatically drop connected classes . | |
| p_admin_drop_cde |
Banner XE Registration code Y or N to process administrative drops on connected classes when student initiates registration. | |
| p_drop_last_class_cde |
Banner XE Registration code Y or N to allow the student to drop all classes during self-service registration. | |
| 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_internal_record_id |
Database ROWID. |
p_validate
Procedure p_validate(p_term_code sobterm.sobterm_term_code%TYPE,
p_crn_oneup sobterm.sobterm_crn_oneup%TYPE,
p_reg_allowed sobterm.sobterm_reg_allowed%TYPE,
p_readm_req sobterm.sobterm_readm_req%TYPE DEFAULT NULL,
p_fee_assessment sobterm.sobterm_fee_assessment%TYPE,
p_fee_assessmnt_eff_date sobterm.sobterm_fee_assessmnt_eff_date%TYPE DEFAULT NULL,
p_dupl_severity sobterm.sobterm_dupl_severity%TYPE,
p_link_severity sobterm.sobterm_link_severity%TYPE,
p_preq_severity sobterm.sobterm_preq_severity%TYPE,
p_corq_severity sobterm.sobterm_corq_severity%TYPE,
p_time_severity sobterm.sobterm_time_severity%TYPE,
p_capc_severity sobterm.sobterm_capc_severity%TYPE,
p_levl_severity sobterm.sobterm_levl_severity%TYPE,
p_coll_severity sobterm.sobterm_coll_severity%TYPE,
p_majr_severity sobterm.sobterm_majr_severity%TYPE,
p_clas_severity sobterm.sobterm_clas_severity%TYPE,
p_appr_severity sobterm.sobterm_appr_severity%TYPE,
p_minh_severity sobterm.sobterm_minh_severity%TYPE,
p_maxh_severity sobterm.sobterm_maxh_severity%TYPE,
p_hold_severity sobterm.sobterm_hold_severity%TYPE,
p_hold sobterm.sobterm_hold%TYPE DEFAULT NULL,
p_refund_ind sobterm.sobterm_refund_ind%TYPE DEFAULT NULL,
p_bycrn_ind sobterm.sobterm_bycrn_ind%TYPE DEFAULT NULL,
p_rept_severity sobterm.sobterm_rept_severity%TYPE,
p_rpth_severity sobterm.sobterm_rpth_severity%TYPE,
p_test_severity sobterm.sobterm_test_severity%TYPE DEFAULT NULL,
p_camp_severity sobterm.sobterm_camp_severity%TYPE,
p_fee_assess_vr sobterm.sobterm_fee_assess_vr%TYPE DEFAULT NULL,
p_print_bill_vr sobterm.sobterm_print_bill_vr%TYPE DEFAULT NULL,
p_tmst_calc_ind sobterm.sobterm_tmst_calc_ind%TYPE,
p_incl_attmpt_hrs_ind sobterm.sobterm_incl_attmpt_hrs_ind%TYPE,
p_cred_web_upd_ind sobterm.sobterm_cred_web_upd_ind%TYPE,
p_gmod_web_upd_ind sobterm.sobterm_gmod_web_upd_ind%TYPE,
p_levl_web_upd_ind sobterm.sobterm_levl_web_upd_ind%TYPE,
p_closect_web_disp_ind sobterm.sobterm_closect_web_disp_ind%TYPE,
p_mailer_web_ind sobterm.sobterm_mailer_web_ind%TYPE,
p_schd_web_search_ind sobterm.sobterm_schd_web_search_ind%TYPE,
p_camp_web_search_ind sobterm.sobterm_camp_web_search_ind%TYPE,
p_sess_web_search_ind sobterm.sobterm_sess_web_search_ind%TYPE,
p_instr_web_search_ind sobterm.sobterm_instr_web_search_ind%TYPE,
p_facschd_web_disp_ind sobterm.sobterm_facschd_web_disp_ind%TYPE,
p_claslst_web_disp_ind sobterm.sobterm_claslst_web_disp_ind%TYPE,
p_overapp_web_upd_ind sobterm.sobterm_overapp_web_upd_ind%TYPE,
p_add_drp_web_upd_ind sobterm.sobterm_add_drp_web_upd_ind%TYPE,
p_degree_severity sobterm.sobterm_degree_severity%TYPE,
p_program_severity sobterm.sobterm_program_severity%TYPE,
p_dept_severity sobterm.sobterm_dept_severity%TYPE,
p_atts_severity sobterm.sobterm_atts_severity%TYPE,
p_chrt_severity sobterm.sobterm_chrt_severity%TYPE,
p_mexc_severity sobterm.sobterm_mexc_severity%TYPE,
p_inprogress_usage_ind sobterm.sobterm_inprogress_usage_ind%TYPE,
p_grade_detail_web_ind sobterm.sobterm_grade_detail_web_ind%TYPE,
p_midterm_web_ind sobterm.sobterm_midterm_web_ind%TYPE,
p_profile_send_ind sobterm.sobterm_profile_send_ind%TYPE,
p_cutoff_date sobterm.sobterm_cutoff_date%TYPE,
p_tiv_date_source sobterm.sobterm_tiv_date_source%TYPE,
p_web_capp_term_ind sobterm.sobterm_web_capp_term_ind%TYPE,
p_web_capp_catlg_ind sobterm.sobterm_web_capp_catlg_ind%TYPE,
p_attr_web_search_ind sobterm.sobterm_attr_web_search_ind%TYPE,
p_levl_web_search_ind sobterm.sobterm_levl_web_search_ind%TYPE,
p_insm_web_search_ind sobterm.sobterm_insm_web_search_ind%TYPE,
p_ls_title_webs_disp_ind sobterm.sobterm_ls_title_webs_disp_ind%TYPE,
p_ls_desc_webs_disp_ind sobterm.sobterm_ls_desc_webs_disp_ind%TYPE,
p_duration_web_srch_ind sobterm.sobterm_duration_web_srch_ind%TYPE,
p_levl_web_catl_srch_ind sobterm.sobterm_levl_web_catl_srch_ind%TYPE,
p_styp_web_catl_srch_ind sobterm.sobterm_styp_web_catl_srch_ind%TYPE,
p_coll_web_catl_srch_ind sobterm.sobterm_coll_web_catl_srch_ind%TYPE,
p_div_web_catl_srch_ind sobterm.sobterm_div_web_catl_srch_ind%TYPE,
p_dept_web_catl_srch_ind sobterm.sobterm_dept_web_catl_srch_ind%TYPE,
p_prog_att_webc_srch_ind sobterm.sobterm_prog_att_webc_srch_ind%TYPE,
p_lc_title_webc_disp_ind sobterm.sobterm_lc_title_webc_disp_ind%TYPE,
p_lc_desc_webc_disp_ind sobterm.sobterm_lc_desc_webc_disp_ind%TYPE,
p_dynamic_sched_term_ind sobterm.sobterm_dynamic_sched_term_ind%TYPE,
p_assess_swap_ind sobterm.sobterm_assess_swap_ind%TYPE,
p_assess_rev_nrf_ind sobterm.sobterm_assess_rev_nrf_ind%TYPE,
p_assess_reg_grace_ind sobterm.sobterm_assess_reg_grace_ind%TYPE,
p_study_path_ind sobterm.sobterm_study_path_ind%TYPE,
p_future_repeat_ind sobterm.sobterm_future_repeat_ind%TYPE,
p_sp_web_upd_ind sobterm.sobterm_sp_web_upd_ind%TYPE,
p_sectionfee_ind sobterm.sobterm_sectionfee_ind%TYPE,
p_meeting_time_src_cde sobterm.sobterm_meeting_time_src_cde%TYPE DEFAULT NULL,
p_plan_term_open_cde sobterm.sobterm_plan_term_open_cde%TYPE DEFAULT NULL,
p_sec_allowed_plan_cde sobterm.sobterm_sec_allowed_plan_cde%TYPE DEFAULT NULL,
p_max_plans sobterm.sobterm_max_plans%TYPE DEFAULT NULL,
p_deg_audit_plan_cde sobterm.sobterm_deg_audit_plan_cde%TYPE DEFAULT NULL,
p_plan_da_reg_cde sobterm.sobterm_plan_da_reg_cde%TYPE DEFAULT NULL,
p_plan_reg_cde sobterm.sobterm_plan_reg_cde%TYPE DEFAULT NULL,
p_cond_add_drop_cde sobterm.sobterm_cond_add_drop_cde%TYPE DEFAULT NULL,
p_auto_drop_cde sobterm.sobterm_auto_drop_cde%TYPE DEFAULT NULL,
p_admin_drop_cde sobterm.sobterm_admin_drop_cde%TYPE DEFAULT NULL,
p_drop_last_class_cde sobterm.sobterm_drop_last_class_cde%TYPE DEFAULT NULL,
p_data_origin sobterm.sobterm_data_origin%TYPE DEFAULT NULL,
p_user_id sobterm.sobterm_user_id%TYPE DEFAULT gb_common.f_sct_user)
Validates all the data in the record.
| Parameters |
| p_term_code |
Unique term code that identifies the base term record. VARCHAR2(6) Required Key | |
| p_crn_oneup |
Last Course Reference Number (CRN) generated by the system. NUMBER(5) Required | |
| p_reg_allowed |
Indicates whether online registration is allowed for the Key Block Term. Values are "Y"-allow registration or "N"-no online registration. VARCHAR2(1) Required | |
| p_readm_req |
Re-Admit term. If a student has not registered since this term, they must be re-admitted through Admissions. VARCHAR2(6) | |
| p_fee_assessment |
Indicates whether fee assessment can be initiated online. "Y"-allow online fee assessment, "N"-only batch fee assessment. VARCHAR2(1) Required | |
| p_fee_assessmnt_eff_date |
Effective date associated with fees assessed online at registration. This date is associated with charges on the student Account Detail Record. DATE | |
| p_dupl_severity |
Indicates how duplicate course entries are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_link_severity |
Indicates how linked course sections are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_preq_severity |
Indicates whether course prerequisites are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_corq_severity |
Indicates whether course and section corequisites are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_time_severity |
Indicates whether course section time conflicts are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_capc_severity |
Indicates whether course section capacity is checked during online registration. Values are "F"-fatal error, "W"-warning, "N"-no check. VARCHAR2(1) Required | |
| p_levl_severity |
Indicates whether course level restrictions are checked during online registration. Values are "F"-fatal error, "W"-warning, "N"-no check. VARCHAR2(1) Required | |
| p_coll_severity |
Indicates whether course or section college restrictions are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_majr_severity |
Indicates whether course or section student major restrictions are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_clas_severity |
Indicates whether course or section class restrictions are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_appr_severity |
Indicates whether course section special approval indicators are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_minh_severity |
Indicates whether the student minimum hours are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_maxh_severity |
Indicates whether the student maximum hours are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_hold_severity |
Indicates whether the person holds are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_hold |
Registration Hold Password. VARCHAR2(3) | |
| p_refund_ind |
Refund By Total Indicator. VARCHAR2(1) | |
| p_bycrn_ind |
Assess by CRN Indicator. VARCHAR2(1) | |
| p_rept_severity |
Used to denote repeat severity. VARCHAR2(1) Required | |
| p_rpth_severity |
Used to denote repeat hours severity. VARCHAR2(1) Required | |
| p_test_severity |
Used to denote test score severity. VARCHAR2(1) | |
| p_camp_severity |
Campus Registration Restriction error severity code. VARCHAR2(1) Required | |
| p_fee_assess_vr |
Self-Service and Voice Response Fee Assessment Indicator. VARCHAR2(1) | |
| p_print_bill_vr |
Self-Service and Voice Response Print Bill Indicator. VARCHAR2(1) | |
| p_tmst_calc_ind |
Indicates whether time status calculations should occur automatically in designated forms on a term-by-term basis. VARCHAR2(1) Required | |
| p_incl_attmpt_hrs_ind |
Indicates whether the system should include credit hours from in-progress courses (those still in registration and not yet rolled to history) when calculating student classification for registration purposes. VARCHAR2(1) Required | |
| p_cred_web_upd_ind |
Indicates whether students can change class option credit hours on the Web. VARCHAR2(1) Required | |
| p_gmod_web_upd_ind |
Indicates whether students can change class option grading modes on the Web. VARCHAR2(1) Required | |
| p_levl_web_upd_ind |
Indicates whether students can change class option levels on the Web. VARCHAR2(1) Required | |
| p_closect_web_disp_ind |
Indicates whether a closed section should be displayed on the Web. VARCHAR2(1) Required | |
| p_mailer_web_ind |
Indicates whether to allow grades to be accessed in the Web for the term. VARCHAR2(1) Required | |
| p_schd_web_search_ind |
Indicates whether schedule types will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_sess_web_search_ind |
Indicates whether session will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_camp_web_search_ind |
Indicates whether campuses will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_sess_web_search_ind |
Indicates whether sessions will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_instr_web_search_ind |
Indicates whether instructors will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_facschd_web_disp_ind |
Controls access to the Faculty Schedule Display page in the Faculty Web product. VARCHAR2(1) Required | |
| p_claslst_web_disp_ind |
Controls access to the Class List Display page in the Faculty Web product. VARCHAR2(1) Required | |
| p_overapp_web_upd_ind |
Controls access to the Registration Approval/Overrides page in the Faculty Web product. VARCHAR2(1) Required | |
| p_add_drp_web_upd_ind |
Controls access to the Registration Add/Drop page in the Faculty Web product. VARCHAR2(1) Required | |
| p_degree_severity |
Indicates the type of degree restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_program_severity |
Indicates the type of program restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_dept_severity |
Indicates the type of department restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_atts_severity |
Indicates the type of student attribute restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_chrt_severity |
Indicates the type of cohort restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_mexc_severity |
Indicates the type of mutual exclusion restriction checking (no checking, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_inprogress_usage_ind |
Indicates whether in-progress courses should fulfill prerequisite requirements for the term. VARCHAR2(1) Required | |
| p_grade_detail_web_ind |
Indicates whether to allow grade detail display via the Web for the term. VARCHAR2(2) Required | |
| p_midterm_web_ind |
Indicates whether to allow midterm grade display via the Web for the term. VARCHAR2(2) Required | |
| p_profile_send_ind |
Indicates whether information specific to the term should be passed to Campus Pipeline. VARCHAR2(2) Required | |
| p_cutoff_date |
Last date that calculated charges are considered original. DATE Required | |
| p_tiv_date_source |
Source of Title IV default start and end date. T=Term; P=Part-of-Term. VARCHAR2(1) Required | |
| p_web_capp_term_ind |
Indicates whether the term code displayed in the key block is a valid term code to be used as the evaluation term for WebCAPP (degree evaluation on the Web) compliance processing. VARCHAR2(1) Required | |
| p_web_capp_catlg_ind |
Indicates whether the term code displayed in the key block is a valid term code to be used as a catalog term for WebCAPP (degree evaluation on the Web) processing. VARCHAR2(1) Required | |
| p_attr_web_search_ind |
Indicates whether the term code displayed in the key block will allow attributes as search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_levl_web_search_ind |
Indicates whether levels will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_insm_web_search_ind |
Indicates whether instructional methods will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_ls_title_webs_disp_ind |
Indicates whether long section titles should be displayed on the Web. VARCHAR2(1) Required | |
| p_ls_desc_webs_disp_ind |
Indicates whether long section descriptions should be displayed on the Web. VARCHAR2(1) Required | |
| p_duration_web_srch_ind |
Indicates whether durations will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_levl_web_catl_srch_ind |
Indicates whether levels will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_styp_web_catl_srch_ind |
Indicates whether schedule types will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_coll_web_catl_srch_ind |
Indicates whether colleges will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_div_web_catl_srch_ind |
Indicates whether divisions will be included in the search criterion on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_dept_web_catl_srch_ind |
Indicates whether departments will be included in the search criterion on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_prog_att_webc_srch_ind |
Indicates whether program attributes will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_lc_title_webc_disp_ind |
Indicates whether long course titles should be displayed in the Web catalog. VARCHAR2(1) Required | |
| p_lc_desc_webc_disp_ind |
Indicates whether long course descriptions should be displayed in the Web catalog. VARCHAR2(1) Required | |
| p_dynamic_sched_term_ind |
Indicates whether the term should be displayed on the Web Select Term pulldown. VARCHAR2(1) Required | |
| p_assess_swap_ind |
Indicates whether to allow course/hours swapping in registration fee assessment. VARCHAR2(1) Required | |
| p_assess_rev_nrf_ind |
Indicates whether to allow the reversal of charges to detail codes having a category code other than TUI or FEE in registration fee assessment. VARCHAR2(1) Required | |
| p_assess_reg_grace_ind |
Indicates whether to allow grace when dropping a course with the same amount of bill hours as a course added on the same initial day of a student's registration. VARCHAR2(1) Required | |
| p_study_path_ind |
Indicates whether study path is required for registration for the term. VARCHAR2(1) Required | |
| p_future_repeat_ind |
Indicates whether future registrations are to be considered by repeat course processing. VARCHAR2(1) Required | |
| p_sp_web_upd_ind |
Indicates whether students can change class option study paths on the Web. VARCHAR2(1) Required | |
| p_sectionfee_ind |
Indicates whether the study path from a registration is stored in SFRFAUD and TBRACCD when the charge is from a section fee. VARCHAR2(1) Required | |
| p_meeting_time_src_cde |
Code for Meeting Time Integration Source. VARCHAR2(1) -- Y or N or null | |
| p_plan_term_open_cde |
Code for Term open for Planning VARCHAR2(1) -- Y or N or null | |
| p_sec_allowed_plan_cde |
Code for Section is allowed to add to Plans.VARCHAR2(1) -- Y or N or null | |
| p_max_plans |
Maximum numbers of Plans that students can create. NUMBER(3) -- Values can be between 0 to 999 | |
| p_deg_audit_plan_cde |
Code for Degree Audit System Integration --VARCHAR2(1) -- Y or N or null | |
| p_plan_da_reg_cde. |
Banner XE code to allow Degree Audit plans to display in registration. Y or N or null. | |
| p_plan_reg_cde. |
Banner XE code to allow Registration Plans to display in registration. Y or N or null. | |
| p_cond_add_drop_cde |
Banner XE Registration code Y or N to allow conditional add drop selection. | |
| p_auto_drop_cde |
Banner XE Registration code C (Confirm automatic drop), Y(Yes automatically drop), N(No provide error message) to automatically drop connected classes . | |
| p_admin_drop_cde |
Banner XE Registration code Y or N to process administrative drops on connected classes when student initiates registration. | |
| p_drop_last_class_cde |
Banner XE Registration code Y or N to allow the student to drop all classes during self-service registration. | |
| 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) |