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_CANCEL_RECONSIDER dependencies on IGS_CA_INST_ALL

Line 290: CURSOR c_get_alternate_code (cp_cal_type igs_ca_inst_all.cal_type%TYPE,

286: Apai.future_adm_ci_sequence_number IS NOT NULL;
287:
288: l_get_fut_appl_inst c_get_fut_appl_inst%ROWTYPE;
289:
290: CURSOR c_get_alternate_code (cp_cal_type igs_ca_inst_all.cal_type%TYPE,
291: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS
292: SELECT alternate_code
293: FROM igs_ca_inst_all
294: WHERE cal_type = cp_cal_type

Line 291: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS

287:
288: l_get_fut_appl_inst c_get_fut_appl_inst%ROWTYPE;
289:
290: CURSOR c_get_alternate_code (cp_cal_type igs_ca_inst_all.cal_type%TYPE,
291: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS
292: SELECT alternate_code
293: FROM igs_ca_inst_all
294: WHERE cal_type = cp_cal_type
295: AND sequence_number = cp_sequence_number;

Line 293: FROM igs_ca_inst_all

289:
290: CURSOR c_get_alternate_code (cp_cal_type igs_ca_inst_all.cal_type%TYPE,
291: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS
292: SELECT alternate_code
293: FROM igs_ca_inst_all
294: WHERE cal_type = cp_cal_type
295: AND sequence_number = cp_sequence_number;
296:
297: l_acad_alternate_code igs_ca_inst_all.alternate_code%TYPE;

Line 297: l_acad_alternate_code igs_ca_inst_all.alternate_code%TYPE;

293: FROM igs_ca_inst_all
294: WHERE cal_type = cp_cal_type
295: AND sequence_number = cp_sequence_number;
296:
297: l_acad_alternate_code igs_ca_inst_all.alternate_code%TYPE;
298: l_adm_alternate_code igs_ca_inst_all.alternate_code%TYPE;
299:
300: CURSOR c_get_adm_process_type (cp_s_admission_process_type igs_lookup_values.lookup_code%TYPE) IS
301: SELECT meaning

Line 298: l_adm_alternate_code igs_ca_inst_all.alternate_code%TYPE;

294: WHERE cal_type = cp_cal_type
295: AND sequence_number = cp_sequence_number;
296:
297: l_acad_alternate_code igs_ca_inst_all.alternate_code%TYPE;
298: l_adm_alternate_code igs_ca_inst_all.alternate_code%TYPE;
299:
300: CURSOR c_get_adm_process_type (cp_s_admission_process_type igs_lookup_values.lookup_code%TYPE) IS
301: SELECT meaning
302: FROM igs_lookup_values