eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_HE_VERIFY_RETURN_PKG dependencies on IGS_HE_POOUS_ALL

Line 338: CURSOR c_get_poous(cp_crv_version_number igs_he_poous_all.crv_version_number%TYPE,

334: AND version_number = cp_version_number;
335:
336:
337: -- Does POOUS have associated HESA record?
338: CURSOR c_get_poous(cp_crv_version_number igs_he_poous_all.crv_version_number%TYPE,
339: cp_course_cd igs_he_poous_all.course_cd%TYPE,
340: cp_cal_type igs_he_poous_all.cal_type%TYPE,
341: cp_location_cd igs_he_poous_all.location_cd%TYPE,
342: cp_attendance_mode igs_he_poous_all.attendance_mode%TYPE,

Line 339: cp_course_cd igs_he_poous_all.course_cd%TYPE,

335:
336:
337: -- Does POOUS have associated HESA record?
338: CURSOR c_get_poous(cp_crv_version_number igs_he_poous_all.crv_version_number%TYPE,
339: cp_course_cd igs_he_poous_all.course_cd%TYPE,
340: cp_cal_type igs_he_poous_all.cal_type%TYPE,
341: cp_location_cd igs_he_poous_all.location_cd%TYPE,
342: cp_attendance_mode igs_he_poous_all.attendance_mode%TYPE,
343: cp_attendance_type igs_he_poous_all.attendance_type%TYPE,

Line 340: cp_cal_type igs_he_poous_all.cal_type%TYPE,

336:
337: -- Does POOUS have associated HESA record?
338: CURSOR c_get_poous(cp_crv_version_number igs_he_poous_all.crv_version_number%TYPE,
339: cp_course_cd igs_he_poous_all.course_cd%TYPE,
340: cp_cal_type igs_he_poous_all.cal_type%TYPE,
341: cp_location_cd igs_he_poous_all.location_cd%TYPE,
342: cp_attendance_mode igs_he_poous_all.attendance_mode%TYPE,
343: cp_attendance_type igs_he_poous_all.attendance_type%TYPE,
344: cp_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,

Line 341: cp_location_cd igs_he_poous_all.location_cd%TYPE,

337: -- Does POOUS have associated HESA record?
338: CURSOR c_get_poous(cp_crv_version_number igs_he_poous_all.crv_version_number%TYPE,
339: cp_course_cd igs_he_poous_all.course_cd%TYPE,
340: cp_cal_type igs_he_poous_all.cal_type%TYPE,
341: cp_location_cd igs_he_poous_all.location_cd%TYPE,
342: cp_attendance_mode igs_he_poous_all.attendance_mode%TYPE,
343: cp_attendance_type igs_he_poous_all.attendance_type%TYPE,
344: cp_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,
345: cp_us_version_number igs_he_poous_all.us_version_number%TYPE) IS

Line 342: cp_attendance_mode igs_he_poous_all.attendance_mode%TYPE,

338: CURSOR c_get_poous(cp_crv_version_number igs_he_poous_all.crv_version_number%TYPE,
339: cp_course_cd igs_he_poous_all.course_cd%TYPE,
340: cp_cal_type igs_he_poous_all.cal_type%TYPE,
341: cp_location_cd igs_he_poous_all.location_cd%TYPE,
342: cp_attendance_mode igs_he_poous_all.attendance_mode%TYPE,
343: cp_attendance_type igs_he_poous_all.attendance_type%TYPE,
344: cp_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,
345: cp_us_version_number igs_he_poous_all.us_version_number%TYPE) IS
346: SELECT DECODE(count(crv_version_number), 0, 'N', 'Y') poous_flag

Line 343: cp_attendance_type igs_he_poous_all.attendance_type%TYPE,

339: cp_course_cd igs_he_poous_all.course_cd%TYPE,
340: cp_cal_type igs_he_poous_all.cal_type%TYPE,
341: cp_location_cd igs_he_poous_all.location_cd%TYPE,
342: cp_attendance_mode igs_he_poous_all.attendance_mode%TYPE,
343: cp_attendance_type igs_he_poous_all.attendance_type%TYPE,
344: cp_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,
345: cp_us_version_number igs_he_poous_all.us_version_number%TYPE) IS
346: SELECT DECODE(count(crv_version_number), 0, 'N', 'Y') poous_flag
347: FROM igs_he_poous_all

Line 344: cp_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,

340: cp_cal_type igs_he_poous_all.cal_type%TYPE,
341: cp_location_cd igs_he_poous_all.location_cd%TYPE,
342: cp_attendance_mode igs_he_poous_all.attendance_mode%TYPE,
343: cp_attendance_type igs_he_poous_all.attendance_type%TYPE,
344: cp_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,
345: cp_us_version_number igs_he_poous_all.us_version_number%TYPE) IS
346: SELECT DECODE(count(crv_version_number), 0, 'N', 'Y') poous_flag
347: FROM igs_he_poous_all
348: WHERE crv_version_number = cp_crv_version_number

Line 345: cp_us_version_number igs_he_poous_all.us_version_number%TYPE) IS

341: cp_location_cd igs_he_poous_all.location_cd%TYPE,
342: cp_attendance_mode igs_he_poous_all.attendance_mode%TYPE,
343: cp_attendance_type igs_he_poous_all.attendance_type%TYPE,
344: cp_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,
345: cp_us_version_number igs_he_poous_all.us_version_number%TYPE) IS
346: SELECT DECODE(count(crv_version_number), 0, 'N', 'Y') poous_flag
347: FROM igs_he_poous_all
348: WHERE crv_version_number = cp_crv_version_number
349: AND course_cd = cp_course_cd

Line 347: FROM igs_he_poous_all

343: cp_attendance_type igs_he_poous_all.attendance_type%TYPE,
344: cp_unit_set_cd igs_he_poous_all.unit_set_cd%TYPE,
345: cp_us_version_number igs_he_poous_all.us_version_number%TYPE) IS
346: SELECT DECODE(count(crv_version_number), 0, 'N', 'Y') poous_flag
347: FROM igs_he_poous_all
348: WHERE crv_version_number = cp_crv_version_number
349: AND course_cd = cp_course_cd
350: AND cal_type = cp_cal_type
351: AND location_cd = cp_location_cd