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

Line 130: || jchakrab 03-May-2006 Added check for parent unitsets in IGS_PS_OFR_OPT_UNIT_SET_V

126: || Purpose : Checks for the existance of Parent records.
127: || Known limitations, enhancements or remarks :
128: || Change History :
129: || Who When What
130: || jchakrab 03-May-2006 Added check for parent unitsets in IGS_PS_OFR_OPT_UNIT_SET_V
131: || sbaliga 9-May-2002 The parent table has been changed from igs_he_poous_all
132: || to igs_ps_ofr_opt_all and Igs_en_unit_set_all as aprt of #2330002
133: || (reverse chronological order - newest change first)
134: */

Line 136: CURSOR cur_unitset_check(cp_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,

132: || to igs_ps_ofr_opt_all and Igs_en_unit_set_all as aprt of #2330002
133: || (reverse chronological order - newest change first)
134: */
135:
136: CURSOR cur_unitset_check(cp_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
137: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
138: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
139: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
140: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,

Line 137: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,

133: || (reverse chronological order - newest change first)
134: */
135:
136: CURSOR cur_unitset_check(cp_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
137: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
138: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
139: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
140: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
141: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,

Line 138: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,

134: */
135:
136: CURSOR cur_unitset_check(cp_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
137: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
138: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
139: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
140: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
141: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
142: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,

Line 139: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,

135:
136: CURSOR cur_unitset_check(cp_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
137: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
138: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
139: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
140: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
141: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
142: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
143: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS

Line 140: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,

136: CURSOR cur_unitset_check(cp_course_cd igs_ps_ofr_opt_unit_set_v.course_cd%TYPE,
137: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
138: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
139: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
140: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
141: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
142: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
143: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS
144: SELECT 'X'

Line 141: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,

137: cp_crv_version_number igs_ps_ofr_opt_unit_set_v.crv_version_number%TYPE,
138: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
139: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
140: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
141: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
142: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
143: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS
144: SELECT 'X'
145: FROM IGS_PS_OFR_OPT_UNIT_SET_V

Line 142: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,

138: cp_cal_type igs_ps_ofr_opt_unit_set_v.cal_type%TYPE,
139: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
140: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
141: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
142: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
143: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS
144: SELECT 'X'
145: FROM IGS_PS_OFR_OPT_UNIT_SET_V
146: WHERE COURSE_CD = cp_course_cd

Line 143: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS

139: cp_location_cd igs_ps_ofr_opt_unit_set_v.location_cd%TYPE,
140: cp_attendance_mode igs_ps_ofr_opt_unit_set_v.attendance_mode%TYPE,
141: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
142: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
143: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS
144: SELECT 'X'
145: FROM IGS_PS_OFR_OPT_UNIT_SET_V
146: WHERE COURSE_CD = cp_course_cd
147: AND CRV_VERSION_NUMBER = cp_crv_version_number

Line 145: FROM IGS_PS_OFR_OPT_UNIT_SET_V

141: cp_attendance_type igs_ps_ofr_opt_unit_set_v.attendance_type%TYPE,
142: cp_unit_set_cd igs_ps_ofr_opt_unit_set_v.unit_set_cd%TYPE,
143: cp_us_version_number igs_ps_ofr_opt_unit_set_v.us_version_number%TYPE) IS
144: SELECT 'X'
145: FROM IGS_PS_OFR_OPT_UNIT_SET_V
146: WHERE COURSE_CD = cp_course_cd
147: AND CRV_VERSION_NUMBER = cp_crv_version_number
148: AND CAL_TYPE = cp_cal_type
149: AND LOCATION_CD = cp_location_cd

Line 202: --Added this check for unit sets in IGS_PS_OFR_OPT_UNIT_SET_V view

198: igs_ge_msg_stack.add;
199: app_exception.raise_exception;
200: END IF;
201:
202: --Added this check for unit sets in IGS_PS_OFR_OPT_UNIT_SET_V view
203: OPEN cur_unitset_check( new_references.course_cd,
204: new_references.crv_version_number,
205: new_references.cal_type,
206: new_references.location_cd,