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_APCOO dependencies on IGS_AD_PRD_AD_PRC_CA

Line 262: cp_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,

258: -- This will be fired from the form when defining an admission
259: -- period for an admission category and process type.
260: DECLARE
261: CURSOR c_apcoo(
262: cp_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
263: cp_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
264: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,
265: cp_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS
266: SELECT 'x'

Line 263: cp_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,

259: -- period for an admission category and process type.
260: DECLARE
261: CURSOR c_apcoo(
262: cp_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
263: cp_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
264: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,
265: cp_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS
266: SELECT 'x'
267: FROM IGS_AD_PRD_PS_OF_OPT

Line 264: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,

260: DECLARE
261: CURSOR c_apcoo(
262: cp_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
263: cp_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
264: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,
265: cp_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS
266: SELECT 'x'
267: FROM IGS_AD_PRD_PS_OF_OPT
268: WHERE adm_cal_type = cp_adm_cal_type AND

Line 265: cp_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS

261: CURSOR c_apcoo(
262: cp_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
263: cp_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
264: cp_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE,
265: cp_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS
266: SELECT 'x'
267: FROM IGS_AD_PRD_PS_OF_OPT
268: WHERE adm_cal_type = cp_adm_cal_type AND
269: adm_ci_sequence_number = cp_adm_ci_sequence_number AND

Line 274: cp_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,

270: admission_cat = cp_admission_cat AND
271: s_admission_process_type = cp_s_admission_process_type;
272: v_apc_exists c_apcoo%ROWTYPE;
273: CURSOR c_acov(
274: cp_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
275: cp_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE) IS
276: SELECT DISTINCT acov.course_cd,
277: acov.version_number,
278: acov.acad_cal_type

Line 275: cp_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE) IS

271: s_admission_process_type = cp_s_admission_process_type;
272: v_apc_exists c_apcoo%ROWTYPE;
273: CURSOR c_acov(
274: cp_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,
275: cp_adm_ci_sequence_number IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE) IS
276: SELECT DISTINCT acov.course_cd,
277: acov.version_number,
278: acov.acad_cal_type
279: FROM IGS_PS_OFR_PAT_APCOO_V acov