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_PS_APPL_INST_PKG dependencies on IGS_AD_APPL_ALL

Line 412: CURSOR get_single_response (p_admission_cat igs_ad_appl_all.admission_cat%TYPE,

408: WHERE person_id = p_person_id
409: AND admission_appl_number = p_admission_appl_number;
410:
411: -- Following cursors added as part of Single Response build Bug:3132406
412: CURSOR get_single_response (p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
413: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
414: SELECT admprd.single_response_flag
415: FROM igs_ad_prd_ad_prc_ca admprd,
416: igs_ad_appl_all appl,

Line 413: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS

409: AND admission_appl_number = p_admission_appl_number;
410:
411: -- Following cursors added as part of Single Response build Bug:3132406
412: CURSOR get_single_response (p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
413: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
414: SELECT admprd.single_response_flag
415: FROM igs_ad_prd_ad_prc_ca admprd,
416: igs_ad_appl_all appl,
417: igs_ad_ps_appl_inst_all aplinst

Line 416: igs_ad_appl_all appl,

412: CURSOR get_single_response (p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
413: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
414: SELECT admprd.single_response_flag
415: FROM igs_ad_prd_ad_prc_ca admprd,
416: igs_ad_appl_all appl,
417: igs_ad_ps_appl_inst_all aplinst
418: WHERE appl.person_id = new_references.person_id
419: AND appl.admission_appl_number = new_references.admission_appl_number
420: AND appl.person_id = aplinst.person_id

Line 429: FROM igs_ad_appl_all appl,

425: AND admprd.s_admission_process_type = p_s_admission_process_type;
426:
427: CURSOR get_aplinst_response_accepted IS
428: SELECT distinct appl.application_id, aplinst.nominated_course_cd
429: FROM igs_ad_appl_all appl,
430: igs_ad_ps_appl_inst aplinst,
431: igs_ad_prd_ad_prc_ca admprd
432: WHERE appl.person_id = aplinst.person_id
433: AND appl.admission_appl_number = aplinst.admission_appl_number

Line 452: l_application_id igs_ad_appl_all.application_id%TYPE;

448:
449:
450: l_appl_dt igs_ad_appl.appl_dt%TYPE;
451: l_single_response_flag igs_ad_prd_ad_prc_ca.single_response_flag%TYPE;
452: l_application_id igs_ad_appl_all.application_id%TYPE;
453: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;
454: l_adm_alt_code igs_ca_inst.alternate_code%TYPE;
455: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
456:

Line 4050: FROM IGS_AD_PS_APPL_INST_ALL ainst, IGS_AD_APPL_ALL apl

4046: x_acad_cal_type VARCHAR2
4047: ) IS
4048: CURSOR cur_rowid IS
4049: SELECT ainst.rowid
4050: FROM IGS_AD_PS_APPL_INST_ALL ainst, IGS_AD_APPL_ALL apl
4051: WHERE ainst.person_id = apl.person_id
4052: AND ainst.admission_appl_number = apl.admission_appl_number
4053: AND ainst.unit_set_cd = x_unit_set_cd
4054: AND ainst.us_version_number = x_version_number