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_PS_ENT_PT_REF_CD_PKG dependencies on IGS_PS_OFR_OPT_UNIT_SET_V

Line 316: CURSOR cur_check(cp_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,

312: WHERE restricted_flag='Y'
313: AND reference_cd_type=cp_reference_cd_type;
314: l_var VARCHAR2(1);
315:
316: CURSOR cur_check(cp_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
317: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
318: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
319: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
320: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,

Line 317: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,

313: AND reference_cd_type=cp_reference_cd_type;
314: l_var VARCHAR2(1);
315:
316: CURSOR cur_check(cp_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
317: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
318: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
319: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
320: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
321: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,

Line 318: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,

314: l_var VARCHAR2(1);
315:
316: CURSOR cur_check(cp_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
317: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
318: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
319: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
320: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
321: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
322: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,

Line 319: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,

315:
316: CURSOR cur_check(cp_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
317: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
318: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
319: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
320: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
321: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
322: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
323: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS

Line 320: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,

316: CURSOR cur_check(cp_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
317: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
318: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
319: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
320: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
321: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
322: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
323: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS
324: SELECT 'X'

Line 321: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,

317: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
318: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
319: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
320: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
321: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
322: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
323: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS
324: SELECT 'X'
325: FROM igs_ps_ofr_opt_unit_set_v

Line 322: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,

318: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
319: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
320: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
321: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
322: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
323: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS
324: SELECT 'X'
325: FROM igs_ps_ofr_opt_unit_set_v
326: WHERE course_cd=cp_course_cd

Line 323: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS

319: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
320: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
321: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
322: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
323: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS
324: SELECT 'X'
325: FROM igs_ps_ofr_opt_unit_set_v
326: WHERE course_cd=cp_course_cd
327: AND crv_version_number=cp_crv_version_number

Line 325: FROM igs_ps_ofr_opt_unit_set_v

321: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
322: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
323: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS
324: SELECT 'X'
325: FROM igs_ps_ofr_opt_unit_set_v
326: WHERE course_cd=cp_course_cd
327: AND crv_version_number=cp_crv_version_number
328: AND cal_type = cp_cal_type
329: AND location_cd = cp_location_cd