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

Line 431: p_admission_cat igs_ad_appl_all.admission_cat%TYPE,

427:
428:
429: -- Get the details of
430: CURSOR cur_appl_case4(
431: p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
432: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE,
433: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
434: p_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,
435: p_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,

Line 432: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE,

428:
429: -- Get the details of
430: CURSOR cur_appl_case4(
431: p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
432: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE,
433: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
434: p_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,
435: p_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,
436: p_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE

Line 433: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,

429: -- Get the details of
430: CURSOR cur_appl_case4(
431: p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
432: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE,
433: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
434: p_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,
435: p_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,
436: p_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE
437: ) IS

Line 434: p_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,

430: CURSOR cur_appl_case4(
431: p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
432: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE,
433: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
434: p_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,
435: p_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,
436: p_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE
437: ) IS
438: SELECT apai.person_id, apai.admission_appl_number, apai. course_cd, apai.sequence_number

Line 435: p_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,

431: p_admission_cat igs_ad_appl_all.admission_cat%TYPE,
432: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE,
433: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
434: p_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,
435: p_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,
436: p_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE
437: ) IS
438: SELECT apai.person_id, apai.admission_appl_number, apai. course_cd, apai.sequence_number
439: FROM igs_ad_ps_appl_inst apai,

Line 436: p_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE

432: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE,
433: p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
434: p_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,
435: p_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,
436: p_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE
437: ) IS
438: SELECT apai.person_id, apai.admission_appl_number, apai. course_cd, apai.sequence_number
439: FROM igs_ad_ps_appl_inst apai,
440: igs_ad_appl aa,

Line 463: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;

459: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
460: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
461: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
462: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
463: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;
464: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;
465: l_records_not_found BOOLEAN := TRUE;
466:
467: BEGIN

Line 464: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;

460: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
461: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
462: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
463: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;
464: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;
465: l_records_not_found BOOLEAN := TRUE;
466:
467: BEGIN
468: