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_APCOOD dependencies on IGS_CA_INST

Line 172: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,

168: v_adm_cat_match BOOLEAN DEFAULT FALSE;
169: v_crv_valid_cnt NUMBER DEFAULT 0;
170: v_message_name VARCHAR2(30);
171: CURSOR c_cop_cir (
172: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
173: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
174: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
175: cp_course_cd IGS_PS_OFR.course_cd%TYPE,
176: cp_version_number IGS_PS_OFR.version_number%TYPE) IS

Line 173: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,

169: v_crv_valid_cnt NUMBER DEFAULT 0;
170: v_message_name VARCHAR2(30);
171: CURSOR c_cop_cir (
172: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
173: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
174: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
175: cp_course_cd IGS_PS_OFR.course_cd%TYPE,
176: cp_version_number IGS_PS_OFR.version_number%TYPE) IS
177: SELECT cop.course_cd,

Line 174: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,

170: v_message_name VARCHAR2(30);
171: CURSOR c_cop_cir (
172: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
173: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
174: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
175: cp_course_cd IGS_PS_OFR.course_cd%TYPE,
176: cp_version_number IGS_PS_OFR.version_number%TYPE) IS
177: SELECT cop.course_cd,
178: cop.version_number,

Line 184: IGS_CA_INST_REL cir

180: cop.location_cd,
181: cop.attendance_mode,
182: cop.attendance_type
183: FROM IGS_PS_OFR_PAT cop,
184: IGS_CA_INST_REL cir
185: WHERE cir.sup_cal_type = cp_acad_cal_type AND
186: cir.sub_cal_type = cp_adm_cal_type AND
187: cir.sub_ci_sequence_number = cp_adm_ci_sequence_number AND
188: cop.course_cd = cp_course_cd AND

Line 195: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,

191: cop.entry_point_ind = 'Y' AND
192: cop.cal_type = cir.sup_cal_type AND
193: cop.ci_sequence_number = cir.sup_ci_sequence_number;
194: CURSOR c_apapc (
195: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
196: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
197: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE) IS
198: SELECT apapc.s_admission_process_type
199: FROM IGS_AD_PRD_AD_PRC_CA apapc

Line 196: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,

192: cop.cal_type = cir.sup_cal_type AND
193: cop.ci_sequence_number = cir.sup_ci_sequence_number;
194: CURSOR c_apapc (
195: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
196: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
197: cp_admission_cat IGS_AD_PRD_PS_OF_OPT.admission_cat%TYPE) IS
198: SELECT apapc.s_admission_process_type
199: FROM IGS_AD_PRD_AD_PRC_CA apapc
200: WHERE apapc.adm_cal_type = cp_adm_cal_type AND