APPS.IGS_AD_GEN_007 dependencies on IGS_CA_DA_INST_V

Line 406: v_offer_resp_dt_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

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;

Line 516: --Match on the components and save the IGS_CA_DA_INST_V key for the

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;