[Home] [Help]
514: TYPE unit_ref_tbl_type IS TABLE OF unit_ref_rec_type INDEX BY BINARY_INTEGER;
515:
516: /********************** Unit Section Occurrence Instructor ************/
517: TYPE uso_ins_rec_type IS RECORD (
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,
624: room_cd igs_ad_room.room_cd%TYPE,
625: number_of_students igs_ps_us_unsched_cl.number_of_students%TYPE,
626: hours_per_student igs_ps_us_unsched_cl.hours_per_student%TYPE,
627: hours_per_faculty igs_ps_us_unsched_cl.hours_per_faculty%TYPE,
628: instructor_number hz_parties.party_number%TYPE,
629: msg_from NUMBER(6),
630: msg_to NUMBER(6),
631: status VARCHAR2(1)
632: );
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,
841: wl_percentage_allocation NUMBER, --igs_ps_usec_tch_resp.percentage_allocation%TYPE,
842: instructional_load_lecture NUMBER, --igs_ps_usec_tch_resp.instructional_load_lecture%TYPE,
843: instructional_load_laboratory NUMBER, --igs_ps_usec_tch_resp.instructional_load_lab%TYPE,