4: TYPE OccurOld IS REF CURSOR;
5: TYPE UnitDtls IS REF CURSOR;
6: TYPE StudentDetails IS REF CURSOR;
7: TYPE InstructorDetails IS REF CURSOR;
8: TYPE rec_OccurNew IS RECORD (monday IGS_PS_USEC_OCCURS.monday%TYPE,
9: tuesday IGS_PS_USEC_OCCURS.tuesday%TYPE,
10: wednesday IGS_PS_USEC_OCCURS.wednesday%TYPE,
11: thursday IGS_PS_USEC_OCCURS.thursday%TYPE,
12: friday IGS_PS_USEC_OCCURS.friday%TYPE,
5: TYPE UnitDtls IS REF CURSOR;
6: TYPE StudentDetails IS REF CURSOR;
7: TYPE InstructorDetails IS REF CURSOR;
8: TYPE rec_OccurNew IS RECORD (monday IGS_PS_USEC_OCCURS.monday%TYPE,
9: tuesday IGS_PS_USEC_OCCURS.tuesday%TYPE,
10: wednesday IGS_PS_USEC_OCCURS.wednesday%TYPE,
11: thursday IGS_PS_USEC_OCCURS.thursday%TYPE,
12: friday IGS_PS_USEC_OCCURS.friday%TYPE,
13: saturday IGS_PS_USEC_OCCURS.saturday%TYPE,
6: TYPE StudentDetails IS REF CURSOR;
7: TYPE InstructorDetails IS REF CURSOR;
8: TYPE rec_OccurNew IS RECORD (monday IGS_PS_USEC_OCCURS.monday%TYPE,
9: tuesday IGS_PS_USEC_OCCURS.tuesday%TYPE,
10: wednesday IGS_PS_USEC_OCCURS.wednesday%TYPE,
11: thursday IGS_PS_USEC_OCCURS.thursday%TYPE,
12: friday IGS_PS_USEC_OCCURS.friday%TYPE,
13: saturday IGS_PS_USEC_OCCURS.saturday%TYPE,
14: sunday IGS_PS_USEC_OCCURS.sunday%TYPE,
7: TYPE InstructorDetails IS REF CURSOR;
8: TYPE rec_OccurNew IS RECORD (monday IGS_PS_USEC_OCCURS.monday%TYPE,
9: tuesday IGS_PS_USEC_OCCURS.tuesday%TYPE,
10: wednesday IGS_PS_USEC_OCCURS.wednesday%TYPE,
11: thursday IGS_PS_USEC_OCCURS.thursday%TYPE,
12: friday IGS_PS_USEC_OCCURS.friday%TYPE,
13: saturday IGS_PS_USEC_OCCURS.saturday%TYPE,
14: sunday IGS_PS_USEC_OCCURS.sunday%TYPE,
15: start_time IGS_PS_USEC_OCCURS.start_time%TYPE,
8: TYPE rec_OccurNew IS RECORD (monday IGS_PS_USEC_OCCURS.monday%TYPE,
9: tuesday IGS_PS_USEC_OCCURS.tuesday%TYPE,
10: wednesday IGS_PS_USEC_OCCURS.wednesday%TYPE,
11: thursday IGS_PS_USEC_OCCURS.thursday%TYPE,
12: friday IGS_PS_USEC_OCCURS.friday%TYPE,
13: saturday IGS_PS_USEC_OCCURS.saturday%TYPE,
14: sunday IGS_PS_USEC_OCCURS.sunday%TYPE,
15: start_time IGS_PS_USEC_OCCURS.start_time%TYPE,
16: end_time IGS_PS_USEC_OCCURS.end_time%TYPE,
9: tuesday IGS_PS_USEC_OCCURS.tuesday%TYPE,
10: wednesday IGS_PS_USEC_OCCURS.wednesday%TYPE,
11: thursday IGS_PS_USEC_OCCURS.thursday%TYPE,
12: friday IGS_PS_USEC_OCCURS.friday%TYPE,
13: saturday IGS_PS_USEC_OCCURS.saturday%TYPE,
14: sunday IGS_PS_USEC_OCCURS.sunday%TYPE,
15: start_time IGS_PS_USEC_OCCURS.start_time%TYPE,
16: end_time IGS_PS_USEC_OCCURS.end_time%TYPE,
17: building_code IGS_PS_USEC_OCCURS.building_code%TYPE,
10: wednesday IGS_PS_USEC_OCCURS.wednesday%TYPE,
11: thursday IGS_PS_USEC_OCCURS.thursday%TYPE,
12: friday IGS_PS_USEC_OCCURS.friday%TYPE,
13: saturday IGS_PS_USEC_OCCURS.saturday%TYPE,
14: sunday IGS_PS_USEC_OCCURS.sunday%TYPE,
15: start_time IGS_PS_USEC_OCCURS.start_time%TYPE,
16: end_time IGS_PS_USEC_OCCURS.end_time%TYPE,
17: building_code IGS_PS_USEC_OCCURS.building_code%TYPE,
18: room_code IGS_PS_USEC_OCCURS.room_code%TYPE);
11: thursday IGS_PS_USEC_OCCURS.thursday%TYPE,
12: friday IGS_PS_USEC_OCCURS.friday%TYPE,
13: saturday IGS_PS_USEC_OCCURS.saturday%TYPE,
14: sunday IGS_PS_USEC_OCCURS.sunday%TYPE,
15: start_time IGS_PS_USEC_OCCURS.start_time%TYPE,
16: end_time IGS_PS_USEC_OCCURS.end_time%TYPE,
17: building_code IGS_PS_USEC_OCCURS.building_code%TYPE,
18: room_code IGS_PS_USEC_OCCURS.room_code%TYPE);
19:
12: friday IGS_PS_USEC_OCCURS.friday%TYPE,
13: saturday IGS_PS_USEC_OCCURS.saturday%TYPE,
14: sunday IGS_PS_USEC_OCCURS.sunday%TYPE,
15: start_time IGS_PS_USEC_OCCURS.start_time%TYPE,
16: end_time IGS_PS_USEC_OCCURS.end_time%TYPE,
17: building_code IGS_PS_USEC_OCCURS.building_code%TYPE,
18: room_code IGS_PS_USEC_OCCURS.room_code%TYPE);
19:
20: TYPE rec_OccurOld IS RECORD (unit_section_occurrence_id IGS_PS_SH_USEC_OCCURS.unit_section_occurrence_id%TYPE,
13: saturday IGS_PS_USEC_OCCURS.saturday%TYPE,
14: sunday IGS_PS_USEC_OCCURS.sunday%TYPE,
15: start_time IGS_PS_USEC_OCCURS.start_time%TYPE,
16: end_time IGS_PS_USEC_OCCURS.end_time%TYPE,
17: building_code IGS_PS_USEC_OCCURS.building_code%TYPE,
18: room_code IGS_PS_USEC_OCCURS.room_code%TYPE);
19:
20: TYPE rec_OccurOld IS RECORD (unit_section_occurrence_id IGS_PS_SH_USEC_OCCURS.unit_section_occurrence_id%TYPE,
21: monday IGS_PS_SH_USEC_OCCURS.monday%TYPE,
14: sunday IGS_PS_USEC_OCCURS.sunday%TYPE,
15: start_time IGS_PS_USEC_OCCURS.start_time%TYPE,
16: end_time IGS_PS_USEC_OCCURS.end_time%TYPE,
17: building_code IGS_PS_USEC_OCCURS.building_code%TYPE,
18: room_code IGS_PS_USEC_OCCURS.room_code%TYPE);
19:
20: TYPE rec_OccurOld IS RECORD (unit_section_occurrence_id IGS_PS_SH_USEC_OCCURS.unit_section_occurrence_id%TYPE,
21: monday IGS_PS_SH_USEC_OCCURS.monday%TYPE,
22: tuesday IGS_PS_SH_USEC_OCCURS.tuesday%TYPE,