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,
527: wl_percentage_allocation igs_ps_usec_tch_resp.percentage_allocation%TYPE,
528: instructional_load_lecture igs_ps_usec_tch_resp.instructional_load_lecture%TYPE,
529: instructional_load_laboratory igs_ps_usec_tch_resp.instructional_load_lab%TYPE,
530: instructional_load_other igs_ps_usec_tch_resp.instructional_load%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,
527: wl_percentage_allocation igs_ps_usec_tch_resp.percentage_allocation%TYPE,
528: instructional_load_lecture igs_ps_usec_tch_resp.instructional_load_lecture%TYPE,
529: instructional_load_laboratory igs_ps_usec_tch_resp.instructional_load_lab%TYPE,
530: instructional_load_other igs_ps_usec_tch_resp.instructional_load%TYPE,
531: lead_instructor_flag igs_ps_usec_tch_resp.lead_instructor_flag%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,
527: wl_percentage_allocation igs_ps_usec_tch_resp.percentage_allocation%TYPE,
528: instructional_load_lecture igs_ps_usec_tch_resp.instructional_load_lecture%TYPE,
529: instructional_load_laboratory igs_ps_usec_tch_resp.instructional_load_lab%TYPE,
530: instructional_load_other igs_ps_usec_tch_resp.instructional_load%TYPE,
531: lead_instructor_flag igs_ps_usec_tch_resp.lead_instructor_flag%TYPE,
532: system_uoo_id NUMBER,
525: occurrence_identifier igs_ps_usec_occurs_all.occurrence_identifier%type,
526: confirmed_flag igs_ps_usec_tch_resp.confirmed_flag%TYPE,
527: wl_percentage_allocation igs_ps_usec_tch_resp.percentage_allocation%TYPE,
528: instructional_load_lecture igs_ps_usec_tch_resp.instructional_load_lecture%TYPE,
529: instructional_load_laboratory igs_ps_usec_tch_resp.instructional_load_lab%TYPE,
530: instructional_load_other igs_ps_usec_tch_resp.instructional_load%TYPE,
531: lead_instructor_flag igs_ps_usec_tch_resp.lead_instructor_flag%TYPE,
532: system_uoo_id NUMBER,
533: system_uso_id NUMBER,
526: confirmed_flag igs_ps_usec_tch_resp.confirmed_flag%TYPE,
527: wl_percentage_allocation igs_ps_usec_tch_resp.percentage_allocation%TYPE,
528: instructional_load_lecture igs_ps_usec_tch_resp.instructional_load_lecture%TYPE,
529: instructional_load_laboratory igs_ps_usec_tch_resp.instructional_load_lab%TYPE,
530: instructional_load_other igs_ps_usec_tch_resp.instructional_load%TYPE,
531: lead_instructor_flag igs_ps_usec_tch_resp.lead_instructor_flag%TYPE,
532: system_uoo_id NUMBER,
533: system_uso_id NUMBER,
534: system_instructor_id NUMBER,
527: wl_percentage_allocation igs_ps_usec_tch_resp.percentage_allocation%TYPE,
528: instructional_load_lecture igs_ps_usec_tch_resp.instructional_load_lecture%TYPE,
529: instructional_load_laboratory igs_ps_usec_tch_resp.instructional_load_lab%TYPE,
530: instructional_load_other igs_ps_usec_tch_resp.instructional_load%TYPE,
531: lead_instructor_flag igs_ps_usec_tch_resp.lead_instructor_flag%TYPE,
532: system_uoo_id NUMBER,
533: system_uso_id NUMBER,
534: system_instructor_id NUMBER,
535: interface_id NUMBER(15),
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,
844: instructional_load_other NUMBER, --igs_ps_usec_tch_resp.instructional_load%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,
844: instructional_load_other NUMBER, --igs_ps_usec_tch_resp.instructional_load%TYPE,
845: lead_instructor_flag igs_ps_usec_tch_resp.lead_instructor_flag%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,
844: instructional_load_other NUMBER, --igs_ps_usec_tch_resp.instructional_load%TYPE,
845: lead_instructor_flag igs_ps_usec_tch_resp.lead_instructor_flag%TYPE,
846: msg_from NUMBER(6),
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,
844: instructional_load_other NUMBER, --igs_ps_usec_tch_resp.instructional_load%TYPE,
845: lead_instructor_flag igs_ps_usec_tch_resp.lead_instructor_flag%TYPE,
846: msg_from NUMBER(6),
847: msg_to NUMBER(6),
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,
844: instructional_load_other NUMBER, --igs_ps_usec_tch_resp.instructional_load%TYPE,
845: lead_instructor_flag igs_ps_usec_tch_resp.lead_instructor_flag%TYPE,
846: msg_from NUMBER(6),
847: msg_to NUMBER(6),
848: status VARCHAR2(1)
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,
844: instructional_load_other NUMBER, --igs_ps_usec_tch_resp.instructional_load%TYPE,
845: lead_instructor_flag igs_ps_usec_tch_resp.lead_instructor_flag%TYPE,
846: msg_from NUMBER(6),
847: msg_to NUMBER(6),
848: status VARCHAR2(1)
849: );