[Home] [Help]
224: non_schd_required_hrs igs_ps_unit_ver_all.non_schd_required_hrs%type,
225: exclude_from_max_cp_limit igs_ps_unit_ver_all.exclude_from_max_cp_limit%type,
226: record_exclusion_flag igs_ps_unit_ver_all.record_exclusion_flag%type,
227: ss_display_ind igs_ps_unit_ver_all.ss_display_ind%type,
228: enrol_load_alt_cd igs_ca_inst_all.alternate_code%type,
229: offer_load_alt_cd igs_ca_inst_all.alternate_code%type,
230: override_enrollment_max igs_ps_unit_ver_all.override_enrollment_max%type,
231: repeat_code igs_ps_rpt_fmly_all.repeat_code%type,
232: level_code igs_ps_unit_type_lvl.level_code%type,
225: exclude_from_max_cp_limit igs_ps_unit_ver_all.exclude_from_max_cp_limit%type,
226: record_exclusion_flag igs_ps_unit_ver_all.record_exclusion_flag%type,
227: ss_display_ind igs_ps_unit_ver_all.ss_display_ind%type,
228: enrol_load_alt_cd igs_ca_inst_all.alternate_code%type,
229: offer_load_alt_cd igs_ca_inst_all.alternate_code%type,
230: override_enrollment_max igs_ps_unit_ver_all.override_enrollment_max%type,
231: repeat_code igs_ps_rpt_fmly_all.repeat_code%type,
232: level_code igs_ps_unit_type_lvl.level_code%type,
233: special_permission_ind igs_ps_unit_ver_all.special_permission_ind%type,
306:
307: TYPE usec_rec_type IS RECORD (
308: unit_cd igs_ps_unit_ofr_opt_all.unit_cd%type,
309: version_number igs_ps_unit_ofr_opt_all.version_number%type,
310: teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
311: location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
312: unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
313: ivrs_available_ind igs_ps_unit_ofr_opt_all.ivrs_available_ind%type,
314: call_number igs_ps_unit_ofr_opt_all.call_number%type,
400: status VARCHAR2(1),
401: not_multiple_section_flag igs_ps_unit_ofr_opt_all.not_multiple_section_flag%TYPE,
402: sup_unit_cd igs_ps_unit_ver_all.unit_cd%type,
403: sup_version_number igs_ps_unit_ver_all.version_number%type,
404: sup_teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
405: sup_location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
406: sup_unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
407: default_enroll_flag igs_ps_unit_ofr_opt_all.default_enroll_flag%type,
408: billing_hrs igs_ps_usec_cps.billing_hrs%type
415:
416: TYPE usec_gs_rec_type IS RECORD (
417: unit_cd igs_ps_unit_ver_all.unit_cd%type,
418: version_number igs_ps_unit_ver_all.version_number%type,
419: teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
420: location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
421: unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
422: grading_schema_code igs_ps_usec_grd_schm.grading_schema_code%type,
423: grd_schm_version_number igs_ps_usec_grd_schm.grd_schm_version_number%type,
436:
437: TYPE uso_rec_type IS RECORD (
438: unit_cd igs_ps_unit_ver_all.unit_cd%type,
439: version_number igs_ps_unit_ver_all.version_number%type,
440: teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
441: location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
442: unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
443: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,
444: to_be_announced igs_ps_usec_occurs_all.to_be_announced%type,
496: production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
497: unit_cd igs_ps_unit_ver_all.unit_cd%type,
498: version_number igs_ps_unit_ver_all.version_number%type,
499: data_type varchar2(10),
500: teach_cal_alternate_code igs_ca_inst_all.alternate_code%type,
501: location_cd igs_ps_unit_ofr_opt_all.location_cd%type,
502: unit_class igs_ps_unit_ofr_opt_all.unit_class%type,
503: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,
504: reference_cd_type igs_ps_unit_ref_cd.reference_cd_type%type,
518: instructor_person_number hz_parties.party_number%TYPE,
519: production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
520: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
521: version_number igs_ps_unit_ver_all.version_number%TYPE,
522: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
523: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
524: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
525: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,
526: confirmed_flag igs_ps_usec_tch_resp.confirmed_flag%TYPE,
543: /********************** Unit Section Occurrence facilities ************/
544: TYPE usec_occurs_facility_rec_type IS RECORD (
545: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
546: version_number igs_ps_unit_ver_all.version_number%TYPE,
547: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
548: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
549: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
550: production_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE,
551: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%TYPE,
560: /********************** Unit Section Teaching Responsibility Overrides ************/
561: TYPE usec_teach_resp_ovrd_rec_type IS RECORD (
562: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
563: version_number igs_ps_unit_ver_all.version_number%TYPE,
564: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
565: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
566: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
567: org_unit_cd igs_ps_tch_resp_ovrd_all.org_unit_cd%TYPE,
568: ou_start_dt igs_ps_tch_resp_ovrd_all.ou_start_dt%TYPE,
577: /********************** Unit Section Notes ************/
578: TYPE usec_notes_rec_type IS RECORD (
579: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
580: version_number igs_ps_unit_ver_all.version_number%TYPE,
581: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
582: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
583: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
584: reference_number igs_ps_unt_ofr_opt_n.reference_number%TYPE,
585: crs_note_type igs_ps_unt_ofr_opt_n.crs_note_type%TYPE,
594: /********************** Unit Section Assessment ************/
595: TYPE usec_assmnt_rec_type IS RECORD (
596: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
597: version_number igs_ps_unit_ver_all.version_number%TYPE,
598: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
599: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
600: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
601: final_exam_date igs_ps_usec_as.final_exam_date%TYPE,
602: exam_start_time VARCHAR2(5),--igs_ps_usec_as.exam_start_time%TYPE,
614: /********************** Unit Section Plus Hours ************/
615: TYPE usec_plus_hr_rec_type IS RECORD (
616: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
617: version_number igs_ps_unit_ver_all.version_number%TYPE,
618: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
619: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
620: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
621: activity_type_code igs_ps_usec_act_type.activity_type_code%TYPE,
622: activity_location_cd igs_ad_location.location_cd%TYPE,
636: /********************** Unit Section categories ************/
637: TYPE usec_cat_rec_type IS RECORD (
638: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
639: version_number igs_ps_unit_ver_all.version_number%TYPE,
640: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
641: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
642: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
643: unit_cat igs_ps_usec_category.unit_cat%TYPE,
644: msg_from NUMBER(6),
651: /********************** Unit Section Rules ************/
652: TYPE usec_rule_rec_type IS RECORD (
653: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
654: version_number igs_ps_unit_ver_all.version_number%TYPE,
655: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
656: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
657: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
658: s_rule_call_cd igs_ps_usec_ru.s_rule_call_cd%TYPE,
659: rule_text VARCHAR2(4000),
667: /********************** Unit Section Cross Listed Groups ************/
668: TYPE usec_cross_group_rec_type IS RECORD (
669: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
670: version_number igs_ps_unit_ver_all.version_number%TYPE,
671: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
672: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
673: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
674: usec_x_listed_group_name igs_ps_usec_x_grp.usec_x_listed_group_name%TYPE,
675: location_inheritance igs_ps_usec_x_grp.location_inheritance%TYPE,
686: /********************** Unit Section Meet With Groups ************/
687: TYPE usec_meet_with_rec_type IS RECORD (
688: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
689: version_number igs_ps_unit_ver_all.version_number%TYPE,
690: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
691: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
692: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
693: class_meet_group_name igs_ps_uso_cm_grp.class_meet_group_name%TYPE,
694: max_enr_group NUMBER,--igs_ps_uso_cm_grp.max_enr_group%TYPE,
704: /********************** Unit Section Waitlist Priorities and Preferences ************/
705: TYPE usec_waitlist_rec_type IS RECORD (
706: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
707: version_number igs_ps_unit_ver_all.version_number%TYPE,
708: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
709: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
710: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
711: priority_number igs_ps_usec_wlst_pri.priority_number%TYPE,
712: priority_value igs_ps_usec_wlst_pri.priority_value%TYPE,
723: /********************** Unit Section Reserve Seating Priorities and Preferences ************/
724: TYPE usec_res_seat_rec_type IS RECORD (
725: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
726: version_number igs_ps_unit_ver_all.version_number%TYPE,
727: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
728: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
729: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
730: priority_order igs_ps_rsv_usec_pri.priority_order%TYPE,
731: priority_value igs_ps_rsv_usec_pri.priority_value%TYPE,
743: /********************** Unit Section Special Fees ************/
744: TYPE usec_sp_fee_rec_type IS RECORD (
745: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
746: version_number igs_ps_unit_ver_all.version_number%TYPE,
747: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
748: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
749: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
750: fee_type igs_ps_usec_sp_fees.fee_type%TYPE,
751: sp_fee_amt igs_ps_usec_sp_fees.sp_fee_amt%TYPE,
760: /********************** Unit Section Retention ************/
761: TYPE usec_ret_rec_type IS RECORD (
762: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
763: version_number igs_ps_unit_ver_all.version_number%TYPE,
764: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
765: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
766: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
767: definition_level igs_ps_nsus_rtn.definition_code%TYPE,
768: fee_type igs_ps_nsus_rtn.fee_type%TYPE,
779: /********************** Unit Section Retention Details ************/
780: TYPE usec_ret_dtl_rec_type IS RECORD (
781: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
782: version_number igs_ps_unit_ver_all.version_number%TYPE,
783: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
784: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
785: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
786: definition_level igs_ps_nsus_rtn.definition_code%TYPE,
787: fee_type igs_ps_nsus_rtn.fee_type%TYPE,
800: /********************** Unit Section Enrollment Deadline ************/
801: TYPE usec_enr_dead_rec_type IS RECORD (
802: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
803: version_number igs_ps_unit_ver_all.version_number%TYPE,
804: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
805: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
806: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
807: function_name igs_en_nstd_usec_dl.function_name%TYPE,
808: enr_dl_date igs_en_nstd_usec_dl.enr_dl_date%TYPE,
816: /********************** Unit Section Enrollment Discontinuation ************/
817: TYPE usec_enr_dis_rec_type IS RECORD (
818: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
819: version_number igs_ps_unit_ver_all.version_number%TYPE,
820: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
821: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
822: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
823: administrative_unit_status igs_en_usec_disc_dl.administrative_unit_status%TYPE,
824: usec_disc_dl_date igs_en_usec_disc_dl.usec_disc_dl_date%TYPE,
832: /********************** Unit Section Teaching Responsibility ************/
833: TYPE usec_teach_resp_rec_type IS RECORD (
834: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
835: version_number igs_ps_unit_ver_all.version_number%TYPE,
836: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
837: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
838: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
839: instructor_person_number hz_parties.party_number%TYPE,
840: confirmed_flag igs_ps_usec_tch_resp.confirmed_flag%TYPE,
853: /********************** Unit Section Assessment Item Group ************/
854: TYPE usec_ass_item_grp_rec_type IS RECORD (
855: unit_cd igs_ps_unit_ver_all.unit_cd%TYPE,
856: version_number igs_ps_unit_ver_all.version_number%TYPE,
857: teach_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
858: location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
859: unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
860: group_name igs_as_us_ai_group.group_name%TYPE,
861: midterm_formula_code igs_as_us_ai_group.midterm_formula_code%TYPE,
869: due_dt igs_ps_unitass_item.due_dt%TYPE,
870: reference igs_ps_unitass_item.reference%TYPE,
871: dflt_item_ind igs_ps_unitass_item.dflt_item_ind%TYPE,
872: logical_delete_dt igs_ps_unitass_item.logical_delete_dt%TYPE,
873: exam_cal_alternate_code igs_ca_inst_all.alternate_code%TYPE,
874: description igs_ps_unitass_item.description%TYPE,
875: grading_schema_cd igs_ps_unitass_item.grading_schema_cd%TYPE,
876: gs_version_number igs_ps_unitass_item.gs_version_number%TYPE,
877: release_date igs_ps_unitass_item.release_date%TYPE,