APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_UC_SYS_CALNDRS

Line 194: CURSOR cur_get_term(cp_entry_year igs_uc_sys_calndrs.entry_year%type) IS

190: l_max_curr_cycle IGS_UC_DEFAULTS.current_cycle%TYPE;
191:
192: -- anwest UCFD040 Bug# 4015492 New cursor to store load calender instances for UCAS
193: -- system codes and cycles
194: CURSOR cur_get_term(cp_entry_year igs_uc_sys_calndrs.entry_year%type) IS
195: SELECT DISTINCT ucsyscal.system_code,
196: ucsyscal.entry_year,
197: cainstall.cal_type,
198: cainstall.sequence_number,

Line 204: IGS_UC_SYS_CALNDRS ucsyscal

200: FROM IGS_CA_INST_ALL cainstall,
201: IGS_CA_INST_REL cainstrel,
202: IGS_CA_TYPE catype,
203: IGS_CA_STAT castat,
204: IGS_UC_SYS_CALNDRS ucsyscal
205: WHERE castat.s_cal_status = 'ACTIVE' and
206: catype.s_cal_cat = 'LOAD' and
207: cainstall.cal_status = castat.s_cal_status and
208: cainstall.cal_type = catype.cal_type and

Line 218: TYPE res_term_type IS RECORD (system_code igs_uc_sys_calndrs.system_code%TYPE,

214: ucsyscal.entry_year >= cp_entry_year - 1
215: ORDER BY ucsyscal.system_code, cainstall.start_dt;
216:
217: -- anwest UCFD040 Bug# 4015492 New type to hold attributes of a cursor above
218: TYPE res_term_type IS RECORD (system_code igs_uc_sys_calndrs.system_code%TYPE,
219: entry_year igs_uc_sys_calndrs.entry_year%TYPE,
220: cal_type igs_ca_inst_all.cal_type%TYPE,
221: sequence_number igs_ca_inst_all.sequence_number%TYPE);
222:

Line 219: entry_year igs_uc_sys_calndrs.entry_year%TYPE,

215: ORDER BY ucsyscal.system_code, cainstall.start_dt;
216:
217: -- anwest UCFD040 Bug# 4015492 New type to hold attributes of a cursor above
218: TYPE res_term_type IS RECORD (system_code igs_uc_sys_calndrs.system_code%TYPE,
219: entry_year igs_uc_sys_calndrs.entry_year%TYPE,
220: cal_type igs_ca_inst_all.cal_type%TYPE,
221: sequence_number igs_ca_inst_all.sequence_number%TYPE);
222:
223: -- anwest UCFD040 Bug# 4015492 New type to store multiple record types

Line 290: l_prev_system_code IGS_UC_SYS_CALNDRS.system_code%TYPE;

286: l_res_term_det res_term_table_type;
287: l_res_term_loc NUMBER;
288: l_term_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
289: l_term_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
290: l_prev_system_code IGS_UC_SYS_CALNDRS.system_code%TYPE;
291: l_prev_entry_year IGS_UC_SYS_CALNDRS.entry_year%TYPE;
292:
293: PROCEDURE get_term_dtls(p_app_no IN NUMBER,
294: p_res_term_det IN res_term_table_type,

Line 291: l_prev_entry_year IGS_UC_SYS_CALNDRS.entry_year%TYPE;

287: l_res_term_loc NUMBER;
288: l_term_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
289: l_term_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE;
290: l_prev_system_code IGS_UC_SYS_CALNDRS.system_code%TYPE;
291: l_prev_entry_year IGS_UC_SYS_CALNDRS.entry_year%TYPE;
292:
293: PROCEDURE get_term_dtls(p_app_no IN NUMBER,
294: p_res_term_det IN res_term_table_type,
295: p_term_cal_type OUT NOCOPY VARCHAR2,