APPS.IGS_AD_GEN_003 dependencies on IGS_AD_CAL_CONF

Line 220: v_sacc_due_dt_alias IGS_AD_CAL_CONF.adm_appl_due_dt_alias%TYPE;

216: RETURN DATE IS
217: BEGIN --admp_get_adm_perd_dt
218: --This module returns the date value for an admission period date alias.
219: DECLARE
220: v_sacc_due_dt_alias IGS_AD_CAL_CONF.adm_appl_due_dt_alias%TYPE;
221: v_sacc_final_dt_alias IGS_AD_CAL_CONF.adm_appl_final_dt_alias%TYPE;
222: v_daiv_alias_val DATE;
223: v_dai_sequence_number IGS_AD_PECRS_OFOP_DT.dai_sequence_number%TYPE;
224: v_apcood_found BOOLEAN;

Line 221: v_sacc_final_dt_alias IGS_AD_CAL_CONF.adm_appl_final_dt_alias%TYPE;

217: BEGIN --admp_get_adm_perd_dt
218: --This module returns the date value for an admission period date alias.
219: DECLARE
220: v_sacc_due_dt_alias IGS_AD_CAL_CONF.adm_appl_due_dt_alias%TYPE;
221: v_sacc_final_dt_alias IGS_AD_CAL_CONF.adm_appl_final_dt_alias%TYPE;
222: v_daiv_alias_val DATE;
223: v_dai_sequence_number IGS_AD_PECRS_OFOP_DT.dai_sequence_number%TYPE;
224: v_apcood_found BOOLEAN;
225: v_curr_component_ctr NUMBER;

Line 230: FROM IGS_AD_CAL_CONF sacc

226: v_high_component_ctr NUMBER;
227: CURSOR c_sacc IS
228: SELECT adm_appl_due_dt_alias,
229: adm_appl_final_dt_alias
230: FROM IGS_AD_CAL_CONF sacc
231: WHERE s_control_num = 1;
232: CURSOR c_daiv IS
233: 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
234: FROM IGS_CA_DA_INST daiv,

Line 883: l_due_dt_alias IGS_AD_CAL_CONF.adm_appl_due_dt_alias%TYPE;

879:
880: DECLARE
881:
882: l_apc_step_exists VARCHAR2(1);
883: l_due_dt_alias IGS_AD_CAL_CONF.adm_appl_due_dt_alias%TYPE;
884: l_final_dt_alias IGS_AD_CAL_CONF.adm_appl_final_dt_alias%TYPE;
885: l_offer_resp_dt_alias IGS_AD_CAL_CONF.adm_appl_offer_resp_dt_alias%TYPE;
886: l_dt_alias IGS_AD_CAL_CONF.adm_appl_offer_resp_dt_alias%TYPE;
887: l_out_dt DATE;

Line 884: l_final_dt_alias IGS_AD_CAL_CONF.adm_appl_final_dt_alias%TYPE;

880: DECLARE
881:
882: l_apc_step_exists VARCHAR2(1);
883: l_due_dt_alias IGS_AD_CAL_CONF.adm_appl_due_dt_alias%TYPE;
884: l_final_dt_alias IGS_AD_CAL_CONF.adm_appl_final_dt_alias%TYPE;
885: l_offer_resp_dt_alias IGS_AD_CAL_CONF.adm_appl_offer_resp_dt_alias%TYPE;
886: l_dt_alias IGS_AD_CAL_CONF.adm_appl_offer_resp_dt_alias%TYPE;
887: l_out_dt DATE;
888:

Line 885: l_offer_resp_dt_alias IGS_AD_CAL_CONF.adm_appl_offer_resp_dt_alias%TYPE;

881:
882: l_apc_step_exists VARCHAR2(1);
883: l_due_dt_alias IGS_AD_CAL_CONF.adm_appl_due_dt_alias%TYPE;
884: l_final_dt_alias IGS_AD_CAL_CONF.adm_appl_final_dt_alias%TYPE;
885: l_offer_resp_dt_alias IGS_AD_CAL_CONF.adm_appl_offer_resp_dt_alias%TYPE;
886: l_dt_alias IGS_AD_CAL_CONF.adm_appl_offer_resp_dt_alias%TYPE;
887: l_out_dt DATE;
888:
889: CURSOR c_apc_step IS

Line 886: l_dt_alias IGS_AD_CAL_CONF.adm_appl_offer_resp_dt_alias%TYPE;

882: l_apc_step_exists VARCHAR2(1);
883: l_due_dt_alias IGS_AD_CAL_CONF.adm_appl_due_dt_alias%TYPE;
884: l_final_dt_alias IGS_AD_CAL_CONF.adm_appl_final_dt_alias%TYPE;
885: l_offer_resp_dt_alias IGS_AD_CAL_CONF.adm_appl_offer_resp_dt_alias%TYPE;
886: l_dt_alias IGS_AD_CAL_CONF.adm_appl_offer_resp_dt_alias%TYPE;
887: l_out_dt DATE;
888:
889: CURSOR c_apc_step IS
890: SELECT 'X'

Line 899: FROM IGS_AD_CAL_CONF

895: step_group_type <> 'TRACK';
896:
897: CURSOR c_dt_alias IS
898: SELECT adm_appl_due_dt_alias, adm_appl_final_dt_alias, adm_appl_offer_resp_dt_alias
899: FROM IGS_AD_CAL_CONF
900: WHERE s_control_num = '1';
901:
902: BEGIN
903: