[Home] [Help]
304:
305: /*********************** Unit Sections ************************/
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,
305: /*********************** Unit Sections ************************/
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,
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,
315: unit_section_status igs_ps_unit_ofr_opt_all.unit_section_status%type,
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,
315: unit_section_status igs_ps_unit_ofr_opt_all.unit_section_status%type,
316: unit_section_start_date igs_ps_unit_ofr_opt_all.unit_section_start_date%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,
315: unit_section_status igs_ps_unit_ofr_opt_all.unit_section_status%type,
316: unit_section_start_date igs_ps_unit_ofr_opt_all.unit_section_start_date%type,
317: unit_section_end_date igs_ps_unit_ofr_opt_all.unit_section_end_date%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,
315: unit_section_status igs_ps_unit_ofr_opt_all.unit_section_status%type,
316: unit_section_start_date igs_ps_unit_ofr_opt_all.unit_section_start_date%type,
317: unit_section_end_date igs_ps_unit_ofr_opt_all.unit_section_end_date%type,
318: offered_ind igs_ps_unit_ofr_opt_all.offered_ind%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,
315: unit_section_status igs_ps_unit_ofr_opt_all.unit_section_status%type,
316: unit_section_start_date igs_ps_unit_ofr_opt_all.unit_section_start_date%type,
317: unit_section_end_date igs_ps_unit_ofr_opt_all.unit_section_end_date%type,
318: offered_ind igs_ps_unit_ofr_opt_all.offered_ind%type,
319: state_financial_aid igs_ps_unit_ofr_opt_all.state_financial_aid%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,
315: unit_section_status igs_ps_unit_ofr_opt_all.unit_section_status%type,
316: unit_section_start_date igs_ps_unit_ofr_opt_all.unit_section_start_date%type,
317: unit_section_end_date igs_ps_unit_ofr_opt_all.unit_section_end_date%type,
318: offered_ind igs_ps_unit_ofr_opt_all.offered_ind%type,
319: state_financial_aid igs_ps_unit_ofr_opt_all.state_financial_aid%type,
320: grading_schema_prcdnce_ind igs_ps_unit_ofr_opt_all.grading_schema_prcdnce_ind%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,
315: unit_section_status igs_ps_unit_ofr_opt_all.unit_section_status%type,
316: unit_section_start_date igs_ps_unit_ofr_opt_all.unit_section_start_date%type,
317: unit_section_end_date igs_ps_unit_ofr_opt_all.unit_section_end_date%type,
318: offered_ind igs_ps_unit_ofr_opt_all.offered_ind%type,
319: state_financial_aid igs_ps_unit_ofr_opt_all.state_financial_aid%type,
320: grading_schema_prcdnce_ind igs_ps_unit_ofr_opt_all.grading_schema_prcdnce_ind%type,
321: federal_financial_aid igs_ps_unit_ofr_opt_all.federal_financial_aid%type,
314: call_number igs_ps_unit_ofr_opt_all.call_number%type,
315: unit_section_status igs_ps_unit_ofr_opt_all.unit_section_status%type,
316: unit_section_start_date igs_ps_unit_ofr_opt_all.unit_section_start_date%type,
317: unit_section_end_date igs_ps_unit_ofr_opt_all.unit_section_end_date%type,
318: offered_ind igs_ps_unit_ofr_opt_all.offered_ind%type,
319: state_financial_aid igs_ps_unit_ofr_opt_all.state_financial_aid%type,
320: grading_schema_prcdnce_ind igs_ps_unit_ofr_opt_all.grading_schema_prcdnce_ind%type,
321: federal_financial_aid igs_ps_unit_ofr_opt_all.federal_financial_aid%type,
322: unit_quota igs_ps_unit_ofr_opt_all.unit_quota%type,
315: unit_section_status igs_ps_unit_ofr_opt_all.unit_section_status%type,
316: unit_section_start_date igs_ps_unit_ofr_opt_all.unit_section_start_date%type,
317: unit_section_end_date igs_ps_unit_ofr_opt_all.unit_section_end_date%type,
318: offered_ind igs_ps_unit_ofr_opt_all.offered_ind%type,
319: state_financial_aid igs_ps_unit_ofr_opt_all.state_financial_aid%type,
320: grading_schema_prcdnce_ind igs_ps_unit_ofr_opt_all.grading_schema_prcdnce_ind%type,
321: federal_financial_aid igs_ps_unit_ofr_opt_all.federal_financial_aid%type,
322: unit_quota igs_ps_unit_ofr_opt_all.unit_quota%type,
323: unit_quota_reserved_places igs_ps_unit_ofr_opt_all.unit_quota_reserved_places%type,
316: unit_section_start_date igs_ps_unit_ofr_opt_all.unit_section_start_date%type,
317: unit_section_end_date igs_ps_unit_ofr_opt_all.unit_section_end_date%type,
318: offered_ind igs_ps_unit_ofr_opt_all.offered_ind%type,
319: state_financial_aid igs_ps_unit_ofr_opt_all.state_financial_aid%type,
320: grading_schema_prcdnce_ind igs_ps_unit_ofr_opt_all.grading_schema_prcdnce_ind%type,
321: federal_financial_aid igs_ps_unit_ofr_opt_all.federal_financial_aid%type,
322: unit_quota igs_ps_unit_ofr_opt_all.unit_quota%type,
323: unit_quota_reserved_places igs_ps_unit_ofr_opt_all.unit_quota_reserved_places%type,
324: institutional_financial_aid igs_ps_unit_ofr_opt_all.institutional_financial_aid%type,
317: unit_section_end_date igs_ps_unit_ofr_opt_all.unit_section_end_date%type,
318: offered_ind igs_ps_unit_ofr_opt_all.offered_ind%type,
319: state_financial_aid igs_ps_unit_ofr_opt_all.state_financial_aid%type,
320: grading_schema_prcdnce_ind igs_ps_unit_ofr_opt_all.grading_schema_prcdnce_ind%type,
321: federal_financial_aid igs_ps_unit_ofr_opt_all.federal_financial_aid%type,
322: unit_quota igs_ps_unit_ofr_opt_all.unit_quota%type,
323: unit_quota_reserved_places igs_ps_unit_ofr_opt_all.unit_quota_reserved_places%type,
324: institutional_financial_aid igs_ps_unit_ofr_opt_all.institutional_financial_aid%type,
325: grading_schema_cd igs_ps_unit_ofr_opt_all.grading_schema_cd%type,
318: offered_ind igs_ps_unit_ofr_opt_all.offered_ind%type,
319: state_financial_aid igs_ps_unit_ofr_opt_all.state_financial_aid%type,
320: grading_schema_prcdnce_ind igs_ps_unit_ofr_opt_all.grading_schema_prcdnce_ind%type,
321: federal_financial_aid igs_ps_unit_ofr_opt_all.federal_financial_aid%type,
322: unit_quota igs_ps_unit_ofr_opt_all.unit_quota%type,
323: unit_quota_reserved_places igs_ps_unit_ofr_opt_all.unit_quota_reserved_places%type,
324: institutional_financial_aid igs_ps_unit_ofr_opt_all.institutional_financial_aid%type,
325: grading_schema_cd igs_ps_unit_ofr_opt_all.grading_schema_cd%type,
326: gs_version_number igs_ps_unit_ofr_opt_all.gs_version_number%type,
319: state_financial_aid igs_ps_unit_ofr_opt_all.state_financial_aid%type,
320: grading_schema_prcdnce_ind igs_ps_unit_ofr_opt_all.grading_schema_prcdnce_ind%type,
321: federal_financial_aid igs_ps_unit_ofr_opt_all.federal_financial_aid%type,
322: unit_quota igs_ps_unit_ofr_opt_all.unit_quota%type,
323: unit_quota_reserved_places igs_ps_unit_ofr_opt_all.unit_quota_reserved_places%type,
324: institutional_financial_aid igs_ps_unit_ofr_opt_all.institutional_financial_aid%type,
325: grading_schema_cd igs_ps_unit_ofr_opt_all.grading_schema_cd%type,
326: gs_version_number igs_ps_unit_ofr_opt_all.gs_version_number%type,
327: unit_contact_number igs_pe_person_base_v.person_number%type,
320: grading_schema_prcdnce_ind igs_ps_unit_ofr_opt_all.grading_schema_prcdnce_ind%type,
321: federal_financial_aid igs_ps_unit_ofr_opt_all.federal_financial_aid%type,
322: unit_quota igs_ps_unit_ofr_opt_all.unit_quota%type,
323: unit_quota_reserved_places igs_ps_unit_ofr_opt_all.unit_quota_reserved_places%type,
324: institutional_financial_aid igs_ps_unit_ofr_opt_all.institutional_financial_aid%type,
325: grading_schema_cd igs_ps_unit_ofr_opt_all.grading_schema_cd%type,
326: gs_version_number igs_ps_unit_ofr_opt_all.gs_version_number%type,
327: unit_contact_number igs_pe_person_base_v.person_number%type,
328: ss_enrol_ind igs_ps_unit_ofr_opt_all.ss_enrol_ind%type,
321: federal_financial_aid igs_ps_unit_ofr_opt_all.federal_financial_aid%type,
322: unit_quota igs_ps_unit_ofr_opt_all.unit_quota%type,
323: unit_quota_reserved_places igs_ps_unit_ofr_opt_all.unit_quota_reserved_places%type,
324: institutional_financial_aid igs_ps_unit_ofr_opt_all.institutional_financial_aid%type,
325: grading_schema_cd igs_ps_unit_ofr_opt_all.grading_schema_cd%type,
326: gs_version_number igs_ps_unit_ofr_opt_all.gs_version_number%type,
327: unit_contact_number igs_pe_person_base_v.person_number%type,
328: ss_enrol_ind igs_ps_unit_ofr_opt_all.ss_enrol_ind%type,
329: owner_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%type,
322: unit_quota igs_ps_unit_ofr_opt_all.unit_quota%type,
323: unit_quota_reserved_places igs_ps_unit_ofr_opt_all.unit_quota_reserved_places%type,
324: institutional_financial_aid igs_ps_unit_ofr_opt_all.institutional_financial_aid%type,
325: grading_schema_cd igs_ps_unit_ofr_opt_all.grading_schema_cd%type,
326: gs_version_number igs_ps_unit_ofr_opt_all.gs_version_number%type,
327: unit_contact_number igs_pe_person_base_v.person_number%type,
328: ss_enrol_ind igs_ps_unit_ofr_opt_all.ss_enrol_ind%type,
329: owner_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%type,
330: attendance_required_ind igs_ps_unit_ofr_opt_all.attendance_required_ind%type,
324: institutional_financial_aid igs_ps_unit_ofr_opt_all.institutional_financial_aid%type,
325: grading_schema_cd igs_ps_unit_ofr_opt_all.grading_schema_cd%type,
326: gs_version_number igs_ps_unit_ofr_opt_all.gs_version_number%type,
327: unit_contact_number igs_pe_person_base_v.person_number%type,
328: ss_enrol_ind igs_ps_unit_ofr_opt_all.ss_enrol_ind%type,
329: owner_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%type,
330: attendance_required_ind igs_ps_unit_ofr_opt_all.attendance_required_ind%type,
331: reserved_seating_allowed igs_ps_unit_ofr_opt_all.reserved_seating_allowed%type,
332: special_permission_ind igs_ps_unit_ofr_opt_all.special_permission_ind%type,
325: grading_schema_cd igs_ps_unit_ofr_opt_all.grading_schema_cd%type,
326: gs_version_number igs_ps_unit_ofr_opt_all.gs_version_number%type,
327: unit_contact_number igs_pe_person_base_v.person_number%type,
328: ss_enrol_ind igs_ps_unit_ofr_opt_all.ss_enrol_ind%type,
329: owner_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%type,
330: attendance_required_ind igs_ps_unit_ofr_opt_all.attendance_required_ind%type,
331: reserved_seating_allowed igs_ps_unit_ofr_opt_all.reserved_seating_allowed%type,
332: special_permission_ind igs_ps_unit_ofr_opt_all.special_permission_ind%type,
333: ss_display_ind igs_ps_unit_ofr_opt_all.ss_display_ind%type,
326: gs_version_number igs_ps_unit_ofr_opt_all.gs_version_number%type,
327: unit_contact_number igs_pe_person_base_v.person_number%type,
328: ss_enrol_ind igs_ps_unit_ofr_opt_all.ss_enrol_ind%type,
329: owner_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%type,
330: attendance_required_ind igs_ps_unit_ofr_opt_all.attendance_required_ind%type,
331: reserved_seating_allowed igs_ps_unit_ofr_opt_all.reserved_seating_allowed%type,
332: special_permission_ind igs_ps_unit_ofr_opt_all.special_permission_ind%type,
333: ss_display_ind igs_ps_unit_ofr_opt_all.ss_display_ind%type,
334: rev_account_cd igs_ps_unit_ofr_opt_all.rev_account_cd%type,
327: unit_contact_number igs_pe_person_base_v.person_number%type,
328: ss_enrol_ind igs_ps_unit_ofr_opt_all.ss_enrol_ind%type,
329: owner_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%type,
330: attendance_required_ind igs_ps_unit_ofr_opt_all.attendance_required_ind%type,
331: reserved_seating_allowed igs_ps_unit_ofr_opt_all.reserved_seating_allowed%type,
332: special_permission_ind igs_ps_unit_ofr_opt_all.special_permission_ind%type,
333: ss_display_ind igs_ps_unit_ofr_opt_all.ss_display_ind%type,
334: rev_account_cd igs_ps_unit_ofr_opt_all.rev_account_cd%type,
335: anon_unit_grading_ind igs_ps_unit_ofr_opt_all.anon_unit_grading_ind%type,
328: ss_enrol_ind igs_ps_unit_ofr_opt_all.ss_enrol_ind%type,
329: owner_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%type,
330: attendance_required_ind igs_ps_unit_ofr_opt_all.attendance_required_ind%type,
331: reserved_seating_allowed igs_ps_unit_ofr_opt_all.reserved_seating_allowed%type,
332: special_permission_ind igs_ps_unit_ofr_opt_all.special_permission_ind%type,
333: ss_display_ind igs_ps_unit_ofr_opt_all.ss_display_ind%type,
334: rev_account_cd igs_ps_unit_ofr_opt_all.rev_account_cd%type,
335: anon_unit_grading_ind igs_ps_unit_ofr_opt_all.anon_unit_grading_ind%type,
336: anon_assess_grading_ind igs_ps_unit_ofr_opt_all.anon_assess_grading_ind%type,
329: owner_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%type,
330: attendance_required_ind igs_ps_unit_ofr_opt_all.attendance_required_ind%type,
331: reserved_seating_allowed igs_ps_unit_ofr_opt_all.reserved_seating_allowed%type,
332: special_permission_ind igs_ps_unit_ofr_opt_all.special_permission_ind%type,
333: ss_display_ind igs_ps_unit_ofr_opt_all.ss_display_ind%type,
334: rev_account_cd igs_ps_unit_ofr_opt_all.rev_account_cd%type,
335: anon_unit_grading_ind igs_ps_unit_ofr_opt_all.anon_unit_grading_ind%type,
336: anon_assess_grading_ind igs_ps_unit_ofr_opt_all.anon_assess_grading_ind%type,
337: non_std_usec_ind igs_ps_unit_ofr_opt_all.non_std_usec_ind%type,
330: attendance_required_ind igs_ps_unit_ofr_opt_all.attendance_required_ind%type,
331: reserved_seating_allowed igs_ps_unit_ofr_opt_all.reserved_seating_allowed%type,
332: special_permission_ind igs_ps_unit_ofr_opt_all.special_permission_ind%type,
333: ss_display_ind igs_ps_unit_ofr_opt_all.ss_display_ind%type,
334: rev_account_cd igs_ps_unit_ofr_opt_all.rev_account_cd%type,
335: anon_unit_grading_ind igs_ps_unit_ofr_opt_all.anon_unit_grading_ind%type,
336: anon_assess_grading_ind igs_ps_unit_ofr_opt_all.anon_assess_grading_ind%type,
337: non_std_usec_ind igs_ps_unit_ofr_opt_all.non_std_usec_ind%type,
338: auditable_ind igs_ps_unit_ofr_opt_all.auditable_ind%type,
331: reserved_seating_allowed igs_ps_unit_ofr_opt_all.reserved_seating_allowed%type,
332: special_permission_ind igs_ps_unit_ofr_opt_all.special_permission_ind%type,
333: ss_display_ind igs_ps_unit_ofr_opt_all.ss_display_ind%type,
334: rev_account_cd igs_ps_unit_ofr_opt_all.rev_account_cd%type,
335: anon_unit_grading_ind igs_ps_unit_ofr_opt_all.anon_unit_grading_ind%type,
336: anon_assess_grading_ind igs_ps_unit_ofr_opt_all.anon_assess_grading_ind%type,
337: non_std_usec_ind igs_ps_unit_ofr_opt_all.non_std_usec_ind%type,
338: auditable_ind igs_ps_unit_ofr_opt_all.auditable_ind%type,
339: audit_permission_ind igs_ps_unit_ofr_opt_all.audit_permission_ind%type,
332: special_permission_ind igs_ps_unit_ofr_opt_all.special_permission_ind%type,
333: ss_display_ind igs_ps_unit_ofr_opt_all.ss_display_ind%type,
334: rev_account_cd igs_ps_unit_ofr_opt_all.rev_account_cd%type,
335: anon_unit_grading_ind igs_ps_unit_ofr_opt_all.anon_unit_grading_ind%type,
336: anon_assess_grading_ind igs_ps_unit_ofr_opt_all.anon_assess_grading_ind%type,
337: non_std_usec_ind igs_ps_unit_ofr_opt_all.non_std_usec_ind%type,
338: auditable_ind igs_ps_unit_ofr_opt_all.auditable_ind%type,
339: audit_permission_ind igs_ps_unit_ofr_opt_all.audit_permission_ind%type,
340: waitlist_allowed igs_ps_unit_ofr_pat_all.waitlist_allowed%type,
333: ss_display_ind igs_ps_unit_ofr_opt_all.ss_display_ind%type,
334: rev_account_cd igs_ps_unit_ofr_opt_all.rev_account_cd%type,
335: anon_unit_grading_ind igs_ps_unit_ofr_opt_all.anon_unit_grading_ind%type,
336: anon_assess_grading_ind igs_ps_unit_ofr_opt_all.anon_assess_grading_ind%type,
337: non_std_usec_ind igs_ps_unit_ofr_opt_all.non_std_usec_ind%type,
338: auditable_ind igs_ps_unit_ofr_opt_all.auditable_ind%type,
339: audit_permission_ind igs_ps_unit_ofr_opt_all.audit_permission_ind%type,
340: waitlist_allowed igs_ps_unit_ofr_pat_all.waitlist_allowed%type,
341: max_students_per_waitlist igs_ps_unit_ofr_pat_all.max_students_per_waitlist%type,
334: rev_account_cd igs_ps_unit_ofr_opt_all.rev_account_cd%type,
335: anon_unit_grading_ind igs_ps_unit_ofr_opt_all.anon_unit_grading_ind%type,
336: anon_assess_grading_ind igs_ps_unit_ofr_opt_all.anon_assess_grading_ind%type,
337: non_std_usec_ind igs_ps_unit_ofr_opt_all.non_std_usec_ind%type,
338: auditable_ind igs_ps_unit_ofr_opt_all.auditable_ind%type,
339: audit_permission_ind igs_ps_unit_ofr_opt_all.audit_permission_ind%type,
340: waitlist_allowed igs_ps_unit_ofr_pat_all.waitlist_allowed%type,
341: max_students_per_waitlist igs_ps_unit_ofr_pat_all.max_students_per_waitlist%type,
342: minimum_credit_points igs_ps_usec_cps.minimum_credit_points%type,
335: anon_unit_grading_ind igs_ps_unit_ofr_opt_all.anon_unit_grading_ind%type,
336: anon_assess_grading_ind igs_ps_unit_ofr_opt_all.anon_assess_grading_ind%type,
337: non_std_usec_ind igs_ps_unit_ofr_opt_all.non_std_usec_ind%type,
338: auditable_ind igs_ps_unit_ofr_opt_all.auditable_ind%type,
339: audit_permission_ind igs_ps_unit_ofr_opt_all.audit_permission_ind%type,
340: waitlist_allowed igs_ps_unit_ofr_pat_all.waitlist_allowed%type,
341: max_students_per_waitlist igs_ps_unit_ofr_pat_all.max_students_per_waitlist%type,
342: minimum_credit_points igs_ps_usec_cps.minimum_credit_points%type,
343: maximum_credit_points igs_ps_usec_cps.maximum_credit_points%type,
397: interface_id NUMBER(15),
398: msg_from NUMBER(6),
399: msg_to NUMBER(6),
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,
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
409: );
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
409: );
410:
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
409: );
410:
411: TYPE usec_tbl_type IS TABLE OF usec_rec_type INDEX BY BINARY_INTEGER;
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,
424: default_flag igs_ps_usec_grd_schm.default_flag%type,
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,
424: default_flag igs_ps_usec_grd_schm.default_flag%type,
425: interface_id NUMBER(15),
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,
445: monday igs_ps_usec_occurs_all.monday%type,
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,
445: monday igs_ps_usec_occurs_all.monday%type,
446: tuesday igs_ps_usec_occurs_all.tuesday%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,
505: reference_cd igs_ge_ref_cd.reference_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,
505: reference_cd igs_ge_ref_cd.reference_cd%type,
506: description igs_ge_ref_cd.description%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,
527: wl_percentage_allocation igs_ps_usec_tch_resp.percentage_allocation%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,
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,
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,
552: facility_code igs_ps_uso_facility.facility_code%TYPE,
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,
552: facility_code igs_ps_uso_facility.facility_code%TYPE,
553: msg_from NUMBER(6),
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,
569: percentage igs_ps_tch_resp_ovrd_all.percentage%TYPE,
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,
569: percentage igs_ps_tch_resp_ovrd_all.percentage%TYPE,
570: msg_from NUMBER(6),
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,
586: note_text igs_ge_note.note_text%TYPE,
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,
586: note_text igs_ge_note.note_text%TYPE,
587: msg_from NUMBER(6),
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,
603: exam_end_time VARCHAR2(5),--igs_ps_usec_as.exam_end_time%TYPE,
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,
603: exam_end_time VARCHAR2(5),--igs_ps_usec_as.exam_end_time%TYPE,
604: exam_location_cd igs_ps_usec_as.location_cd%TYPE,
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,
623: building_cd igs_ad_building.building_cd%TYPE,
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,
623: building_cd igs_ad_building.building_cd%TYPE,
624: room_cd igs_ad_room.room_cd%TYPE,
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),
645: msg_to NUMBER(6),
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),
645: msg_to NUMBER(6),
646: status VARCHAR2(1)
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),
660: msg_from NUMBER(6),
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),
660: msg_from NUMBER(6),
661: msg_to NUMBER(6),
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,
676: max_enr_group NUMBER,--igs_ps_usec_x_grp.max_enr_group%TYPE,
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,
676: max_enr_group NUMBER,--igs_ps_usec_x_grp.max_enr_group%TYPE,
677: max_ovr_group NUMBER,--igs_ps_usec_x_grp.max_ovr_group%TYPE,
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,
695: max_ovr_group NUMBER,--igs_ps_uso_cm_grp.max_ovr_group%TYPE,
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,
695: max_ovr_group NUMBER,--igs_ps_uso_cm_grp.max_ovr_group%TYPE,
696: host igs_ps_uso_clas_meet.host%TYPE,
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,
713: preference_order igs_ps_usec_wlst_prf.preference_order%TYPE,
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,
713: preference_order igs_ps_usec_wlst_prf.preference_order%TYPE,
714: preference_code igs_ps_usec_wlst_prf.preference_code%TYPE,
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,
732: preference_order igs_ps_rsv_usec_prf.preference_order%TYPE,
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,
732: preference_order igs_ps_rsv_usec_prf.preference_order%TYPE,
733: preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,
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,
752: closed_flag igs_ps_usec_sp_fees.closed_flag%TYPE,
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,
752: closed_flag igs_ps_usec_sp_fees.closed_flag%TYPE,
753: msg_from NUMBER(6),
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,
769: formula_method igs_ps_nsus_rtn.formula_method%TYPE,
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,
769: formula_method igs_ps_nsus_rtn.formula_method%TYPE,
770: round_method igs_ps_nsus_rtn.round_method%TYPE,
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,
788: offset_value igs_ps_nsus_rtn_dtl.offset_value%TYPE,
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,
788: offset_value igs_ps_nsus_rtn_dtl.offset_value%TYPE,
789: retention_percent igs_ps_nsus_rtn_dtl.retention_percent%TYPE,
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,
809: msg_from NUMBER(6),
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,
809: msg_from NUMBER(6),
810: msg_to NUMBER(6),
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,
825: msg_from NUMBER(6),
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,
825: msg_from NUMBER(6),
826: msg_to NUMBER(6),
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,
841: wl_percentage_allocation NUMBER, --igs_ps_usec_tch_resp.percentage_allocation%TYPE,
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,
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,
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,
862: midterm_formula_qty NUMBER,--igs_as_us_ai_group.midterm_formula_qty%TYPE,
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,
862: midterm_formula_qty NUMBER,--igs_as_us_ai_group.midterm_formula_qty%TYPE,
863: midterm_weight_qty NUMBER,--igs_as_us_ai_group.midterm_weight_qty%TYPE,