[Home] [Help]
402: -- Calculate the offer response date. If the date cannot be derived return
403: -- NULL, otherwise return the derived date.
404: v_offer_resp_offset IGS_AD_PRCS_CAT.offer_response_offset%TYPE;
405: v_appl_offer_resp_dt_alias IGS_AD_CAL_CONF.adm_appl_offer_resp_dt_alias%TYPE;
406: v_offer_resp_dt_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
407: v_offer_resp_dt DATE;
408: v_apc_found BOOLEAN;
409: v_dai_sequence_number IGS_AD_PECRS_OFOP_DT.dai_sequence_number%TYPE ;
410: v_apcood_found BOOLEAN := FALSE;
441: apcood.dt_alias = cp_appl_offer_resp_dt_alias;
442:
443: CURSOR c_daiv IS
444: SELECT IGS_CA_GEN_001.calp_set_alias_value(absolute_val, IGS_CA_GEN_002.cals_clc_dt_from_dai(ci_sequence_number, CAL_TYPE, DT_ALIAS, sequence_number) ) alias_val
445: FROM IGS_CA_DA_INST daiv,
446: IGS_AD_PERD_AD_CAT apac
447: WHERE daiv.dt_alias = v_appl_offer_resp_dt_alias AND
448: apac.adm_cal_type = p_adm_cal_type AND
449: apac.adm_ci_sequence_number = p_adm_ci_sequence_number AND
460: ORDER BY 1 desc;
461:
462: CURSOR c_daiv2 IS
463: SELECT IGS_CA_GEN_001.calp_set_alias_value(absolute_val, IGS_CA_GEN_002.cals_clc_dt_from_dai(ci_sequence_number, CAL_TYPE, DT_ALIAS, sequence_number) ) alias_val
464: FROM IGS_CA_DA_INST daiv
465: WHERE daiv.cal_type = p_adm_cal_type AND
466: daiv.ci_sequence_number = p_adm_ci_sequence_number AND
467: daiv.dt_alias = v_appl_offer_resp_dt_alias AND
468: daiv.sequence_number = v_dai_sequence_number;
512: (v_apcood_rec.attendance_mode IS NULL OR
513: v_apcood_rec.attendance_mode = p_attendance_mode) AND
514: (v_apcood_rec.attendance_type IS NULL OR
515: v_apcood_rec.attendance_type = p_attendance_type)) THEN
516: --Match on the components and save the IGS_CA_DA_INST_V key for the
517: --Record that matches with the highest number of components
518: IF (v_apcood_rec.s_admission_process_type IS NOT NULL) THEN
519: IF (v_apcood_rec.s_admission_process_type = p_admission_process_type) THEN
520: v_curr_component_ctr := v_curr_component_ctr + 1;