APPS.IGS_PRECREATE_APPL_PUB dependencies on IGS_AD_PRCS_CAT_STEP

Line 175: CURSOR c_late_app(p_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,p_s_adm_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS

171: cstat.cal_status = ci2.cal_status AND
172: cstat.s_cal_status = 'ACTIVE';
173:
174: -- Cursor to find out if Late Applications are allowed
175: CURSOR c_late_app(p_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,p_s_adm_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
176: SELECT S_ADMISSION_STEP_TYPE
177: FROM IGS_AD_PRCS_CAT_STEP apcs
178: WHERE admission_cat = p_admission_cat AND
179: s_admission_process_type = p_s_adm_process_type AND

Line 177: FROM IGS_AD_PRCS_CAT_STEP apcs

173:
174: -- Cursor to find out if Late Applications are allowed
175: CURSOR c_late_app(p_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,p_s_adm_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
176: SELECT S_ADMISSION_STEP_TYPE
177: FROM IGS_AD_PRCS_CAT_STEP apcs
178: WHERE admission_cat = p_admission_cat AND
179: s_admission_process_type = p_s_adm_process_type AND
180: s_admission_step_type = 'LATE-APP' AND
181: mandatory_step_ind = 'Y';

Line 189: l_late_app_rec IGS_AD_PRCS_CAT_STEP.S_ADMISSION_STEP_TYPE%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:
193: l_apptype_rec c_apptype%ROWTYPE := NULL;

Line 843: FROM IGS_AD_PRCS_CAT_STEP apcs

839:
840: -- Cursor to check if the Preference Limit APC Step is set or not against the Application Type
841: CURSOR c_pref_limit(p_admission_cat VARCHAR2,p_s_adm_process_type VARCHAR2) IS
842: SELECT S_ADMISSION_STEP_TYPE
843: FROM IGS_AD_PRCS_CAT_STEP apcs
844: WHERE admission_cat = p_admission_cat AND
845: s_admission_process_type = p_s_adm_process_type AND
846: s_admission_step_type = 'PREF-LIMIT' AND
847: mandatory_step_ind = 'Y';

Line 863: l_pref_limit_rec IGS_AD_PRCS_CAT_STEP.S_ADMISSION_STEP_TYPE%TYPE := NULL;

859: l_location_rec IGS_AD_LOCATION.location_cd%TYPE := NULL;
860: l_att_type_rec IGS_EN_ATD_TYPE.ATTENDANCE_TYPE%TYPE := NULL;
861: l_att_mode_rec IGS_EN_ATD_MODE.ATTENDANCE_MODE%TYPE := NULL;
862: l_off_pattern_rec IGS_PS_OFR_PAT_OFERPAT_V.ACAD_CAL_TYPE%TYPE := NULL;
863: l_pref_limit_rec IGS_AD_PRCS_CAT_STEP.S_ADMISSION_STEP_TYPE%TYPE := NULL;
864: l_prog_inst_rec IGS_SS_APP_PGM_STG.SS_ADMAPPL_PGM_ID%TYPE := NULL;
865:
866: l_ss_adm_appl_id IGS_SS_APP_PGM_STG.ss_adm_appl_id%TYPE;
867: l_preference_number IGS_SS_APP_PGM_STG.preference_number%TYPE;