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

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

163: END Check_Constraints;
164:
165: PROCEDURE Check_Parent_Existance AS
166:
167: CURSOR cur_check(cp_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
168: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
169: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
170: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
171: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,

Line 168: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,

164:
165: PROCEDURE Check_Parent_Existance AS
166:
167: CURSOR cur_check(cp_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
168: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
169: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
170: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
171: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
172: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,

Line 169: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,

165: PROCEDURE Check_Parent_Existance AS
166:
167: CURSOR cur_check(cp_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
168: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
169: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
170: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
171: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
172: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
173: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,

Line 170: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,

166:
167: CURSOR cur_check(cp_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
168: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
169: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
170: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
171: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
172: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
173: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
174: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS

Line 171: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,

167: CURSOR cur_check(cp_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
168: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
169: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
170: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
171: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
172: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
173: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
174: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS
175: SELECT 'X'

Line 172: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,

168: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
169: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
170: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
171: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
172: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
173: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
174: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS
175: SELECT 'X'
176: FROM igs_ps_ofr_opt_unit_set_v

Line 173: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,

169: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
170: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
171: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
172: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
173: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
174: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS
175: SELECT 'X'
176: FROM igs_ps_ofr_opt_unit_set_v
177: WHERE course_cd=cp_course_cd

Line 174: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS

170: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
171: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
172: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
173: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
174: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS
175: SELECT 'X'
176: FROM igs_ps_ofr_opt_unit_set_v
177: WHERE course_cd=cp_course_cd
178: AND crv_version_number=cp_crv_version_number

Line 176: FROM igs_ps_ofr_opt_unit_set_v

172: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
173: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
174: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS
175: SELECT 'X'
176: FROM igs_ps_ofr_opt_unit_set_v
177: WHERE course_cd=cp_course_cd
178: AND crv_version_number=cp_crv_version_number
179: AND cal_type = cp_cal_type
180: AND location_cd = cp_location_cd