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_AD_VAL_CRS_ADMPERD dependencies on IGS_AD_PRD_PS_OF_OPT

Line 168: cp_adm_cal_type IGS_AD_PRD_PS_OF_OPT.adm_cal_type%TYPE,

164: -- the admission period
165: DECLARE
166: v_record_found BOOLEAN DEFAULT FALSE;
167: CURSOR c_apcoo_adm (
168: cp_adm_cal_type IGS_AD_PRD_PS_OF_OPT.adm_cal_type%TYPE,
169: cp_adm_ci_sequence_number
170: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,
171: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
172: cp_s_admission_process_type

Line 170: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,

166: v_record_found BOOLEAN DEFAULT FALSE;
167: CURSOR c_apcoo_adm (
168: cp_adm_cal_type IGS_AD_PRD_PS_OF_OPT.adm_cal_type%TYPE,
169: cp_adm_ci_sequence_number
170: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,
171: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
172: cp_s_admission_process_type
173: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE) IS
174: SELECT 'x'

Line 171: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,

167: CURSOR c_apcoo_adm (
168: cp_adm_cal_type IGS_AD_PRD_PS_OF_OPT.adm_cal_type%TYPE,
169: cp_adm_ci_sequence_number
170: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,
171: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
172: cp_s_admission_process_type
173: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE) IS
174: SELECT 'x'
175: FROM IGS_AD_PRD_PS_OF_OPT apcoo

Line 173: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE) IS

169: cp_adm_ci_sequence_number
170: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,
171: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
172: cp_s_admission_process_type
173: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE) IS
174: SELECT 'x'
175: FROM IGS_AD_PRD_PS_OF_OPT apcoo
176: WHERE apcoo.adm_cal_type = cp_adm_cal_type AND
177: apcoo.adm_ci_sequence_number = cp_adm_ci_sequence_number AND

Line 175: FROM IGS_AD_PRD_PS_OF_OPT apcoo

171: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
172: cp_s_admission_process_type
173: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE) IS
174: SELECT 'x'
175: FROM IGS_AD_PRD_PS_OF_OPT apcoo
176: WHERE apcoo.adm_cal_type = cp_adm_cal_type AND
177: apcoo.adm_ci_sequence_number = cp_adm_ci_sequence_number AND
178: apcoo.admission_cat = cp_admission_cat AND
179: apcoo.s_admission_process_type = cp_s_admission_process_type;

Line 181: cp_adm_cal_type IGS_AD_PRD_PS_OF_OPT.adm_cal_type%TYPE,

177: apcoo.adm_ci_sequence_number = cp_adm_ci_sequence_number AND
178: apcoo.admission_cat = cp_admission_cat AND
179: apcoo.s_admission_process_type = cp_s_admission_process_type;
180: CURSOR c_adm_perd_course_off_opt (
181: cp_adm_cal_type IGS_AD_PRD_PS_OF_OPT.adm_cal_type%TYPE,
182: cp_adm_ci_sequence_number
183: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,
184: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
185: cp_s_admission_process_type

Line 183: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,

179: apcoo.s_admission_process_type = cp_s_admission_process_type;
180: CURSOR c_adm_perd_course_off_opt (
181: cp_adm_cal_type IGS_AD_PRD_PS_OF_OPT.adm_cal_type%TYPE,
182: cp_adm_ci_sequence_number
183: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,
184: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
185: cp_s_admission_process_type
186: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,
187: cp_course_cd IGS_PS_OFR_OPT.course_cd%TYPE,

Line 184: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,

180: CURSOR c_adm_perd_course_off_opt (
181: cp_adm_cal_type IGS_AD_PRD_PS_OF_OPT.adm_cal_type%TYPE,
182: cp_adm_ci_sequence_number
183: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,
184: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
185: cp_s_admission_process_type
186: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,
187: cp_course_cd IGS_PS_OFR_OPT.course_cd%TYPE,
188: cp_version_number IGS_PS_OFR_OPT.version_number%TYPE,

Line 186: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,

182: cp_adm_ci_sequence_number
183: IGS_AD_PRD_PS_OF_OPT.adm_ci_sequence_number%TYPE,
184: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE,
185: cp_s_admission_process_type
186: IGS_AD_PRD_PS_OF_OPT.s_admission_process_type%TYPE,
187: cp_course_cd IGS_PS_OFR_OPT.course_cd%TYPE,
188: cp_version_number IGS_PS_OFR_OPT.version_number%TYPE,
189: cp_acad_cal_type IGS_PS_OFR_OPT.cal_type%TYPE) IS
190: SELECT apcoo.location_cd,

Line 193: FROM IGS_AD_PRD_PS_OF_OPT apcoo

189: cp_acad_cal_type IGS_PS_OFR_OPT.cal_type%TYPE) IS
190: SELECT apcoo.location_cd,
191: apcoo.attendance_mode,
192: apcoo.attendance_type
193: FROM IGS_AD_PRD_PS_OF_OPT apcoo
194: WHERE apcoo.adm_cal_type = cp_adm_cal_type AND
195: apcoo.adm_ci_sequence_number = cp_adm_ci_sequence_number AND
196: apcoo.admission_cat = cp_admission_cat AND
197: apcoo.s_admission_process_type = cp_s_admission_process_type AND