DBA Data[Home] [Help]

APPS.IGS_PS_WF_EVENT_HOOK_PKG dependencies on IGS_PS_SH_USEC_OCCURS

Line 20: TYPE rec_OccurOld IS RECORD (unit_section_occurrence_id IGS_PS_SH_USEC_OCCURS.unit_section_occurrence_id%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,
23: wednesday IGS_PS_SH_USEC_OCCURS.wednesday%TYPE,
24: thursday IGS_PS_SH_USEC_OCCURS.thursday%TYPE,

Line 21: monday IGS_PS_SH_USEC_OCCURS.monday%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,
23: wednesday IGS_PS_SH_USEC_OCCURS.wednesday%TYPE,
24: thursday IGS_PS_SH_USEC_OCCURS.thursday%TYPE,
25: friday IGS_PS_SH_USEC_OCCURS.friday%TYPE,

Line 22: tuesday IGS_PS_SH_USEC_OCCURS.tuesday%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,
23: wednesday IGS_PS_SH_USEC_OCCURS.wednesday%TYPE,
24: thursday IGS_PS_SH_USEC_OCCURS.thursday%TYPE,
25: friday IGS_PS_SH_USEC_OCCURS.friday%TYPE,
26: saturday IGS_PS_SH_USEC_OCCURS.saturday%TYPE,

Line 23: wednesday IGS_PS_SH_USEC_OCCURS.wednesday%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,
23: wednesday IGS_PS_SH_USEC_OCCURS.wednesday%TYPE,
24: thursday IGS_PS_SH_USEC_OCCURS.thursday%TYPE,
25: friday IGS_PS_SH_USEC_OCCURS.friday%TYPE,
26: saturday IGS_PS_SH_USEC_OCCURS.saturday%TYPE,
27: sunday IGS_PS_SH_USEC_OCCURS.sunday%TYPE,

Line 24: thursday IGS_PS_SH_USEC_OCCURS.thursday%TYPE,

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,
23: wednesday IGS_PS_SH_USEC_OCCURS.wednesday%TYPE,
24: thursday IGS_PS_SH_USEC_OCCURS.thursday%TYPE,
25: friday IGS_PS_SH_USEC_OCCURS.friday%TYPE,
26: saturday IGS_PS_SH_USEC_OCCURS.saturday%TYPE,
27: sunday IGS_PS_SH_USEC_OCCURS.sunday%TYPE,
28: start_time IGS_PS_SH_USEC_OCCURS.start_time%TYPE,

Line 25: friday IGS_PS_SH_USEC_OCCURS.friday%TYPE,

21: monday IGS_PS_SH_USEC_OCCURS.monday%TYPE,
22: tuesday IGS_PS_SH_USEC_OCCURS.tuesday%TYPE,
23: wednesday IGS_PS_SH_USEC_OCCURS.wednesday%TYPE,
24: thursday IGS_PS_SH_USEC_OCCURS.thursday%TYPE,
25: friday IGS_PS_SH_USEC_OCCURS.friday%TYPE,
26: saturday IGS_PS_SH_USEC_OCCURS.saturday%TYPE,
27: sunday IGS_PS_SH_USEC_OCCURS.sunday%TYPE,
28: start_time IGS_PS_SH_USEC_OCCURS.start_time%TYPE,
29: end_time IGS_PS_SH_USEC_OCCURS.end_time%TYPE,

Line 26: saturday IGS_PS_SH_USEC_OCCURS.saturday%TYPE,

22: tuesday IGS_PS_SH_USEC_OCCURS.tuesday%TYPE,
23: wednesday IGS_PS_SH_USEC_OCCURS.wednesday%TYPE,
24: thursday IGS_PS_SH_USEC_OCCURS.thursday%TYPE,
25: friday IGS_PS_SH_USEC_OCCURS.friday%TYPE,
26: saturday IGS_PS_SH_USEC_OCCURS.saturday%TYPE,
27: sunday IGS_PS_SH_USEC_OCCURS.sunday%TYPE,
28: start_time IGS_PS_SH_USEC_OCCURS.start_time%TYPE,
29: end_time IGS_PS_SH_USEC_OCCURS.end_time%TYPE,
30: building_code IGS_PS_SH_USEC_OCCURS.building_code%TYPE,

Line 27: sunday IGS_PS_SH_USEC_OCCURS.sunday%TYPE,

23: wednesday IGS_PS_SH_USEC_OCCURS.wednesday%TYPE,
24: thursday IGS_PS_SH_USEC_OCCURS.thursday%TYPE,
25: friday IGS_PS_SH_USEC_OCCURS.friday%TYPE,
26: saturday IGS_PS_SH_USEC_OCCURS.saturday%TYPE,
27: sunday IGS_PS_SH_USEC_OCCURS.sunday%TYPE,
28: start_time IGS_PS_SH_USEC_OCCURS.start_time%TYPE,
29: end_time IGS_PS_SH_USEC_OCCURS.end_time%TYPE,
30: building_code IGS_PS_SH_USEC_OCCURS.building_code%TYPE,
31: room_code IGS_PS_SH_USEC_OCCURS.room_code%TYPE);

Line 28: start_time IGS_PS_SH_USEC_OCCURS.start_time%TYPE,

24: thursday IGS_PS_SH_USEC_OCCURS.thursday%TYPE,
25: friday IGS_PS_SH_USEC_OCCURS.friday%TYPE,
26: saturday IGS_PS_SH_USEC_OCCURS.saturday%TYPE,
27: sunday IGS_PS_SH_USEC_OCCURS.sunday%TYPE,
28: start_time IGS_PS_SH_USEC_OCCURS.start_time%TYPE,
29: end_time IGS_PS_SH_USEC_OCCURS.end_time%TYPE,
30: building_code IGS_PS_SH_USEC_OCCURS.building_code%TYPE,
31: room_code IGS_PS_SH_USEC_OCCURS.room_code%TYPE);
32:

Line 29: end_time IGS_PS_SH_USEC_OCCURS.end_time%TYPE,

25: friday IGS_PS_SH_USEC_OCCURS.friday%TYPE,
26: saturday IGS_PS_SH_USEC_OCCURS.saturday%TYPE,
27: sunday IGS_PS_SH_USEC_OCCURS.sunday%TYPE,
28: start_time IGS_PS_SH_USEC_OCCURS.start_time%TYPE,
29: end_time IGS_PS_SH_USEC_OCCURS.end_time%TYPE,
30: building_code IGS_PS_SH_USEC_OCCURS.building_code%TYPE,
31: room_code IGS_PS_SH_USEC_OCCURS.room_code%TYPE);
32:
33: TYPE rec_UnitDtls IS RECORD (unit_cd IGS_PS_UNIT_OFR_OPT_V.unit_cd%TYPE,

Line 30: building_code IGS_PS_SH_USEC_OCCURS.building_code%TYPE,

26: saturday IGS_PS_SH_USEC_OCCURS.saturday%TYPE,
27: sunday IGS_PS_SH_USEC_OCCURS.sunday%TYPE,
28: start_time IGS_PS_SH_USEC_OCCURS.start_time%TYPE,
29: end_time IGS_PS_SH_USEC_OCCURS.end_time%TYPE,
30: building_code IGS_PS_SH_USEC_OCCURS.building_code%TYPE,
31: room_code IGS_PS_SH_USEC_OCCURS.room_code%TYPE);
32:
33: TYPE rec_UnitDtls IS RECORD (unit_cd IGS_PS_UNIT_OFR_OPT_V.unit_cd%TYPE,
34: title IGS_PS_UNIT_OFR_OPT_V.title%TYPE,

Line 31: room_code IGS_PS_SH_USEC_OCCURS.room_code%TYPE);

27: sunday IGS_PS_SH_USEC_OCCURS.sunday%TYPE,
28: start_time IGS_PS_SH_USEC_OCCURS.start_time%TYPE,
29: end_time IGS_PS_SH_USEC_OCCURS.end_time%TYPE,
30: building_code IGS_PS_SH_USEC_OCCURS.building_code%TYPE,
31: room_code IGS_PS_SH_USEC_OCCURS.room_code%TYPE);
32:
33: TYPE rec_UnitDtls IS RECORD (unit_cd IGS_PS_UNIT_OFR_OPT_V.unit_cd%TYPE,
34: title IGS_PS_UNIT_OFR_OPT_V.title%TYPE,
35: cal_start_dt IGS_PS_UNIT_OFR_OPT_V.cal_start_dt%TYPE,