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_SUSPEND_APPL_PKG dependencies on IGS_AD_PRD_AD_PRC_CA

Line 78: cp_adm_cat igs_ad_prd_ad_prc_ca.admission_cat%TYPE,

74: CURSOR c_all_records_case_4(cp_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE,
75: cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,
76: cp_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,
77: cp_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE,
78: cp_adm_cat igs_ad_prd_ad_prc_ca.admission_cat%TYPE,
79: cp_admission_process_type igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE) IS
80: SELECT a.*
81: FROM IGS_AD_PS_APPL_INST a, IGS_AD_APPL_ALL b
82: WHERE a.person_id=b.person_id AND

Line 79: cp_admission_process_type igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE) IS

75: cp_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE,
76: cp_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE,
77: cp_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE,
78: cp_adm_cat igs_ad_prd_ad_prc_ca.admission_cat%TYPE,
79: cp_admission_process_type igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE) IS
80: SELECT a.*
81: FROM IGS_AD_PS_APPL_INST a, IGS_AD_APPL_ALL b
82: WHERE a.person_id=b.person_id AND
83: a.admission_appl_number = b.admission_appl_number AND

Line 106: lv_admission_cat igs_ad_prd_ad_prc_ca.admission_cat%TYPE ;

102: lv_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE;
103: lv_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE;
104: lv_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE;
105: lv_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE;
106: lv_admission_cat igs_ad_prd_ad_prc_ca.admission_cat%TYPE ;
107: lv_admission_process_type igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE;
108: lv_alt_code_acad igs_ca_inst.alternate_code%TYPE;
109: lv_alt_code_adm igs_ca_inst.alternate_code%TYPE;
110:

Line 107: lv_admission_process_type igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE;

103: lv_acad_ci_sequence_number igs_ad_appl_all.acad_ci_sequence_number%TYPE;
104: lv_adm_cal_type igs_ad_appl_all.adm_cal_type%TYPE;
105: lv_adm_ci_sequence_number igs_ad_appl_all.adm_ci_sequence_number%TYPE;
106: lv_admission_cat igs_ad_prd_ad_prc_ca.admission_cat%TYPE ;
107: lv_admission_process_type igs_ad_prd_ad_prc_ca.s_admission_process_type%TYPE;
108: lv_alt_code_acad igs_ca_inst.alternate_code%TYPE;
109: lv_alt_code_adm igs_ca_inst.alternate_code%TYPE;
110:
111: