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

Line 245: igs_ca_inst ci1,

241: ci2.start_dt adm_ci_start_dt,
242: ci2.end_dt adm_ci_end_dt
243: FROM igs_ad_appl aav, /* Replaced igs_ad_ps_apl_inst_cntx_v with underlying tables. Bug 3150054 */
244: igs_ad_ps_appl_inst acai,
245: igs_ca_inst ci1,
246: igs_ca_inst ci2
247: WHERE acai.person_id = cp_person_id AND
248: acai.admission_appl_number = cp_admission_appl_number AND
249: acai.nominated_course_cd = cp_nominated_course_cd AND

Line 246: igs_ca_inst ci2

242: ci2.end_dt adm_ci_end_dt
243: FROM igs_ad_appl aav, /* Replaced igs_ad_ps_apl_inst_cntx_v with underlying tables. Bug 3150054 */
244: igs_ad_ps_appl_inst acai,
245: igs_ca_inst ci1,
246: igs_ca_inst ci2
247: WHERE acai.person_id = cp_person_id AND
248: acai.admission_appl_number = cp_admission_appl_number AND
249: acai.nominated_course_cd = cp_nominated_course_cd AND
250: acai.sequence_number = cp_sequence_number AND

Line 260: CURSOR c_valid_acad_cals(cp_acad_ci_start_dt IN igs_ca_inst.start_dt%TYPE,

256: ci2.sequence_number = nvl(acai.adm_ci_sequence_number,aav.adm_ci_sequence_number);
257:
258:
259: --Cursor to select the valid Deferred Academic Calendars
260: CURSOR c_valid_acad_cals(cp_acad_ci_start_dt IN igs_ca_inst.start_dt%TYPE,
261: cp_acad_ci_end_dt IN igs_ca_inst.end_dt%TYPE ) IS
262: SELECT UNIQUE
263: acad_ciav.alternate_code def_acad_alternate_code
264: ,acad_ciav.cal_type def_acad_cal_type

Line 261: cp_acad_ci_end_dt IN igs_ca_inst.end_dt%TYPE ) IS

257:
258:
259: --Cursor to select the valid Deferred Academic Calendars
260: CURSOR c_valid_acad_cals(cp_acad_ci_start_dt IN igs_ca_inst.start_dt%TYPE,
261: cp_acad_ci_end_dt IN igs_ca_inst.end_dt%TYPE ) IS
262: SELECT UNIQUE
263: acad_ciav.alternate_code def_acad_alternate_code
264: ,acad_ciav.cal_type def_acad_cal_type
265: ,acad_ciav.sequence_number def_acad_ci_seq_number

Line 272: igs_ca_inst_alt_v acad_ciav,

268: ,acad_ciav.description abbreviation
269: ,acad_ciav.cal_status cal_status
270: ,acad_ciav.s_cal_status s_cal_status
271: FROM
272: igs_ca_inst_alt_v acad_ciav,
273: igs_ca_inst_alt_v adm_ciav,
274: igs_ca_inst_rel cir,
275: igs_ad_prd_ad_prc_ca apapc,
276: igs_ca_type ct

Line 273: igs_ca_inst_alt_v adm_ciav,

269: ,acad_ciav.cal_status cal_status
270: ,acad_ciav.s_cal_status s_cal_status
271: FROM
272: igs_ca_inst_alt_v acad_ciav,
273: igs_ca_inst_alt_v adm_ciav,
274: igs_ca_inst_rel cir,
275: igs_ad_prd_ad_prc_ca apapc,
276: igs_ca_type ct
277: WHERE

Line 274: igs_ca_inst_rel cir,

270: ,acad_ciav.s_cal_status s_cal_status
271: FROM
272: igs_ca_inst_alt_v acad_ciav,
273: igs_ca_inst_alt_v adm_ciav,
274: igs_ca_inst_rel cir,
275: igs_ad_prd_ad_prc_ca apapc,
276: igs_ca_type ct
277: WHERE
278: (acad_ciav.s_cal_cat = 'ACADEMIC' AND

Line 301: cp_adm_ci_end_dt igs_ca_inst.end_dt%TYPE

297: CURSOR c_valid_adm_cals( cp_admission_cat igs_ad_appl_all.admission_cat%TYPE,
298: cp_s_adm_process_type igs_ad_appl_all.s_admission_process_type%TYPE,
299: cp_def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
300: cp_def_acad_ci_seq_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
301: cp_adm_ci_end_dt igs_ca_inst.end_dt%TYPE
302: ) IS
303: SELECT
304: ciav1.alternate_code def_adm_alternate_code,
305: ciav1.cal_type def_adm_cal_type ,

Line 312: igs_ca_inst_alt_v ciav1

308: ciav1.end_dt end_dt ,
309: ciav1.description abbreviation ,
310: ciav1.cal_status cal_status
311: FROM
312: igs_ca_inst_alt_v ciav1
313: WHERE
314: (ciav1.s_cal_cat = 'ADMISSION' AND ciav1.s_cal_status = 'ACTIVE'
315: AND ciav1.start_dt > cp_adm_ci_end_dt
316: AND (ciav1.cal_type, ciav1.sequence_number) IN

Line 320: igs_ca_inst_rel cir

316: AND (ciav1.cal_type, ciav1.sequence_number) IN
317: (SELECT apapc.adm_cal_type,
318: apapc.adm_ci_sequence_number
319: FROM igs_ad_prd_ad_prc_ca apapc,
320: igs_ca_inst_rel cir
321: WHERE apapc.admission_cat = cp_admission_cat AND
322: apapc.s_admission_process_type =cp_s_adm_process_type AND
323: cir.sub_cal_type = apapc.adm_cal_type AND
324: cir.sub_ci_sequence_number = apapc.adm_ci_sequence_number AND

Line 372: CURSOR get_alternate_code ( p_cal_type igs_ca_inst.cal_type%TYPE,

368: AND admprd.s_admission_process_type = appl.s_admission_process_type
369: AND admprd.single_response_flag = 'Y';
370:
371:
372: CURSOR get_alternate_code ( p_cal_type igs_ca_inst.cal_type%TYPE,
373: p_sequence_number igs_ca_inst.sequence_number%TYPE) IS
374: SELECT alternate_code
375: FROM igs_ca_inst
376: WHERE cal_type = p_cal_type

Line 373: p_sequence_number igs_ca_inst.sequence_number%TYPE) IS

369: AND admprd.single_response_flag = 'Y';
370:
371:
372: CURSOR get_alternate_code ( p_cal_type igs_ca_inst.cal_type%TYPE,
373: p_sequence_number igs_ca_inst.sequence_number%TYPE) IS
374: SELECT alternate_code
375: FROM igs_ca_inst
376: WHERE cal_type = p_cal_type
377: AND sequence_number = p_sequence_number;

Line 375: FROM igs_ca_inst

371:
372: CURSOR get_alternate_code ( p_cal_type igs_ca_inst.cal_type%TYPE,
373: p_sequence_number igs_ca_inst.sequence_number%TYPE) IS
374: SELECT alternate_code
375: FROM igs_ca_inst
376: WHERE cal_type = p_cal_type
377: AND sequence_number = p_sequence_number;
378:
379: c_appl_inst_ctxt_rec c_appl_inst_ctxt%ROWTYPE;

Line 418: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;

414: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
415: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;
416: l_application_id igs_ad_appl_all.application_id%TYPE;
417: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
418: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;
419: l_adm_alt_code igs_ca_inst.alternate_code%TYPE;
420:
421: BEGIN
422:

Line 419: l_adm_alt_code igs_ca_inst.alternate_code%TYPE;

415: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;
416: l_application_id igs_ad_appl_all.application_id%TYPE;
417: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
418: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;
419: l_adm_alt_code igs_ca_inst.alternate_code%TYPE;
420:
421: BEGIN
422:
423: --Initialize the flag indicating the SUCCESS ('Y'). Gets updated to 'N' even if one validation fails