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

Line 117: CURSOR c_apptype_admcal(p_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,p_adm_cal_seq IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,

113: FROM igs_ad_ss_appl_typ
114: WHERE admission_application_type = p_app_type;
115:
116: -- Cursor to validate whether the Application Type is available in the current Admission Calendar
117: CURSOR c_apptype_admcal(p_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,p_adm_cal_seq IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
118: p_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE, p_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS
119: SELECT adm_cal_type
120: FROM IGS_AD_PRD_AD_PRC_CA
121: WHERE adm_cal_type = p_adm_cal_type AND

Line 118: p_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE, p_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS

114: WHERE admission_application_type = p_app_type;
115:
116: -- Cursor to validate whether the Application Type is available in the current Admission Calendar
117: CURSOR c_apptype_admcal(p_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,p_adm_cal_seq IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
118: p_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE, p_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS
119: SELECT adm_cal_type
120: FROM IGS_AD_PRD_AD_PRC_CA
121: WHERE adm_cal_type = p_adm_cal_type AND
122: adm_ci_sequence_number = p_adm_cal_seq AND

Line 120: FROM IGS_AD_PRD_AD_PRC_CA

116: -- Cursor to validate whether the Application Type is available in the current Admission Calendar
117: CURSOR c_apptype_admcal(p_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,p_adm_cal_seq IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,
118: p_admission_cat IGS_AD_PRD_AD_PRC_CA.admission_cat%TYPE, p_s_admission_process_type IGS_AD_PRD_AD_PRC_CA.s_admission_process_type%TYPE) IS
119: SELECT adm_cal_type
120: FROM IGS_AD_PRD_AD_PRC_CA
121: WHERE adm_cal_type = p_adm_cal_type AND
122: adm_ci_sequence_number = p_adm_cal_seq AND
123: admission_cat = p_admission_cat AND
124: s_admission_process_type = p_s_admission_process_type;

Line 188: l_apptype_admcal_rec IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE := NULL;

184: l_estatus_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
185: l_elevel_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
186: l_spcl_grp1_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
187: l_spcl_grp2_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
188: l_apptype_admcal_rec IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE := NULL;
189: l_late_app_rec IGS_AD_PRCS_CAT_STEP.S_ADMISSION_STEP_TYPE%TYPE := NULL;
190: l_appsource_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
191: l_cal_rel_rec IGS_CA_INST.CAL_TYPE%TYPE := NULL;
192: