APPS.IGS_PS_WF_EVENT_HOOK_PKG dependencies on IGS_PS_UNIT_OFR_OPT_V

Line 33: TYPE rec_UnitDtls IS RECORD (unit_cd IGS_PS_UNIT_OFR_OPT_V.unit_cd%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,
36: cal_end_dt IGS_PS_UNIT_OFR_OPT_V.cal_end_dt%TYPE,
37: location_cd IGS_PS_UNIT_OFR_OPT_V.location_cd%TYPE,

Line 34: title IGS_PS_UNIT_OFR_OPT_V.title%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,
36: cal_end_dt IGS_PS_UNIT_OFR_OPT_V.cal_end_dt%TYPE,
37: location_cd IGS_PS_UNIT_OFR_OPT_V.location_cd%TYPE,
38: location_description IGS_PS_UNIT_OFR_OPT_V.location_description%TYPE,

Line 35: cal_start_dt IGS_PS_UNIT_OFR_OPT_V.cal_start_dt%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,
36: cal_end_dt IGS_PS_UNIT_OFR_OPT_V.cal_end_dt%TYPE,
37: location_cd IGS_PS_UNIT_OFR_OPT_V.location_cd%TYPE,
38: location_description IGS_PS_UNIT_OFR_OPT_V.location_description%TYPE,
39: unit_mode IGS_PS_UNIT_OFR_OPT_V.unit_mode%TYPE);

Line 36: cal_end_dt IGS_PS_UNIT_OFR_OPT_V.cal_end_dt%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,
36: cal_end_dt IGS_PS_UNIT_OFR_OPT_V.cal_end_dt%TYPE,
37: location_cd IGS_PS_UNIT_OFR_OPT_V.location_cd%TYPE,
38: location_description IGS_PS_UNIT_OFR_OPT_V.location_description%TYPE,
39: unit_mode IGS_PS_UNIT_OFR_OPT_V.unit_mode%TYPE);
40: TYPE rec_StudentDetails IS RECORD ( person_id igs_pe_person.person_id%TYPE,

Line 37: location_cd IGS_PS_UNIT_OFR_OPT_V.location_cd%TYPE,

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,
36: cal_end_dt IGS_PS_UNIT_OFR_OPT_V.cal_end_dt%TYPE,
37: location_cd IGS_PS_UNIT_OFR_OPT_V.location_cd%TYPE,
38: location_description IGS_PS_UNIT_OFR_OPT_V.location_description%TYPE,
39: unit_mode IGS_PS_UNIT_OFR_OPT_V.unit_mode%TYPE);
40: TYPE rec_StudentDetails IS RECORD ( person_id igs_pe_person.person_id%TYPE,
41: unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,

Line 38: location_description IGS_PS_UNIT_OFR_OPT_V.location_description%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,
36: cal_end_dt IGS_PS_UNIT_OFR_OPT_V.cal_end_dt%TYPE,
37: location_cd IGS_PS_UNIT_OFR_OPT_V.location_cd%TYPE,
38: location_description IGS_PS_UNIT_OFR_OPT_V.location_description%TYPE,
39: unit_mode IGS_PS_UNIT_OFR_OPT_V.unit_mode%TYPE);
40: TYPE rec_StudentDetails IS RECORD ( person_id igs_pe_person.person_id%TYPE,
41: unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
42: person_number igs_pe_person.person_number%TYPE,

Line 39: unit_mode IGS_PS_UNIT_OFR_OPT_V.unit_mode%TYPE);

35: cal_start_dt IGS_PS_UNIT_OFR_OPT_V.cal_start_dt%TYPE,
36: cal_end_dt IGS_PS_UNIT_OFR_OPT_V.cal_end_dt%TYPE,
37: location_cd IGS_PS_UNIT_OFR_OPT_V.location_cd%TYPE,
38: location_description IGS_PS_UNIT_OFR_OPT_V.location_description%TYPE,
39: unit_mode IGS_PS_UNIT_OFR_OPT_V.unit_mode%TYPE);
40: TYPE rec_StudentDetails IS RECORD ( person_id igs_pe_person.person_id%TYPE,
41: unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE,
42: person_number igs_pe_person.person_number%TYPE,
43: email_addr igs_pe_person.email_addr%TYPE,