APPS.IGS_PRECREATE_APPL_PUB dependencies on IGS_CA_INST

Line 135: CURSOR c_cal(p_cal_type IGS_CA_INST.cal_type%TYPE, p_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

131: code_id = p_app_source_id AND
132: SYSTEM_STATUS IN ('WEB_STAFF', 'WEB_APPL');
133:
134: -- Cursor to validate Calendars
135: CURSOR c_cal(p_cal_type IGS_CA_INST.cal_type%TYPE, p_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
136: SELECT cal.cal_type, cal.sequence_number,cal.description
137: FROM IGS_CA_INST cal,
138: igs_ca_stat cstat
139: WHERE cal.cal_type = p_cal_type AND

Line 137: FROM IGS_CA_INST cal,

133:
134: -- Cursor to validate Calendars
135: CURSOR c_cal(p_cal_type IGS_CA_INST.cal_type%TYPE, p_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
136: SELECT cal.cal_type, cal.sequence_number,cal.description
137: FROM IGS_CA_INST cal,
138: igs_ca_stat cstat
139: WHERE cal.cal_type = p_cal_type AND
140: cal.sequence_number = p_sequence_number AND
141: end_dt > sysdate AND

Line 146: CURSOR c_cal_rel(p_adm_cal_type IGS_CA_INST.cal_type%TYPE, p_adm_sequence_number IGS_CA_INST.sequence_number%TYPE,p_acad_cal_type IGS_CA_INST.cal_type%TYPE, p_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

142: cstat.cal_status = cal.cal_status AND
143: cstat.s_cal_status = 'ACTIVE';
144:
145: -- Cursor to validte relationship between Academic Calendar and Admission Calendar
146: CURSOR c_cal_rel(p_adm_cal_type IGS_CA_INST.cal_type%TYPE, p_adm_sequence_number IGS_CA_INST.sequence_number%TYPE,p_acad_cal_type IGS_CA_INST.cal_type%TYPE, p_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
147: SELECT ci1.CAL_TYPE
148: FROM
149: igs_ca_inst ci1,
150: igs_ca_inst_rel cir,

Line 149: igs_ca_inst ci1,

145: -- Cursor to validte relationship between Academic Calendar and Admission Calendar
146: CURSOR c_cal_rel(p_adm_cal_type IGS_CA_INST.cal_type%TYPE, p_adm_sequence_number IGS_CA_INST.sequence_number%TYPE,p_acad_cal_type IGS_CA_INST.cal_type%TYPE, p_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
147: SELECT ci1.CAL_TYPE
148: FROM
149: igs_ca_inst ci1,
150: igs_ca_inst_rel cir,
151: igs_ca_inst ci2,
152: igs_ca_type cat1,
153: igs_ca_type cat2,

Line 150: igs_ca_inst_rel cir,

146: CURSOR c_cal_rel(p_adm_cal_type IGS_CA_INST.cal_type%TYPE, p_adm_sequence_number IGS_CA_INST.sequence_number%TYPE,p_acad_cal_type IGS_CA_INST.cal_type%TYPE, p_acad_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
147: SELECT ci1.CAL_TYPE
148: FROM
149: igs_ca_inst ci1,
150: igs_ca_inst_rel cir,
151: igs_ca_inst ci2,
152: igs_ca_type cat1,
153: igs_ca_type cat2,
154: igs_ca_stat cstat

Line 151: igs_ca_inst ci2,

147: SELECT ci1.CAL_TYPE
148: FROM
149: igs_ca_inst ci1,
150: igs_ca_inst_rel cir,
151: igs_ca_inst ci2,
152: igs_ca_type cat1,
153: igs_ca_type cat2,
154: igs_ca_stat cstat
155: WHERE

Line 191: l_cal_rel_rec IGS_CA_INST.CAL_TYPE%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;
194: l_cal_rec c_cal%ROWTYPE := NULL;
195: