APPS.IGS_AD_GEN_004 dependencies on IGS_CA_DA_INST_V

Line 646: v_dai2_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

642: v_completion_dt_yyyy VARCHAR2(4);
643: v_context_completion_dt DATE;
644: v_dai2_alias_val_dd_mon VARCHAR2(7);
645: v_dai2_alias_val_yyyy VARCHAR2(4);
646: v_dai2_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
647: v_dai2_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE;
648: v_dai IGS_CA_DA_INST_V.alias_val%TYPE;
649: v_adm_e_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_e_comp_perd_dt_alias%TYPE;
650: v_adm_m_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_m_comp_perd_dt_alias%TYPE;

Line 647: v_dai2_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE;

643: v_context_completion_dt DATE;
644: v_dai2_alias_val_dd_mon VARCHAR2(7);
645: v_dai2_alias_val_yyyy VARCHAR2(4);
646: v_dai2_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
647: v_dai2_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE;
648: v_dai IGS_CA_DA_INST_V.alias_val%TYPE;
649: v_adm_e_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_e_comp_perd_dt_alias%TYPE;
650: v_adm_m_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_m_comp_perd_dt_alias%TYPE;
651: v_adm_s_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_s_comp_perd_dt_alias%TYPE;

Line 648: v_dai IGS_CA_DA_INST_V.alias_val%TYPE;

644: v_dai2_alias_val_dd_mon VARCHAR2(7);
645: v_dai2_alias_val_yyyy VARCHAR2(4);
646: v_dai2_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
647: v_dai2_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE;
648: v_dai IGS_CA_DA_INST_V.alias_val%TYPE;
649: v_adm_e_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_e_comp_perd_dt_alias%TYPE;
650: v_adm_m_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_m_comp_perd_dt_alias%TYPE;
651: v_adm_s_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_s_comp_perd_dt_alias%TYPE;
652: v_rec_cnt NUMBER;

Line 670: FROM IGS_CA_DA_INST_V dai

666: --Following cursor is modified as part of bug 2715535, to pick up alias values which are greater than
667: --the Context Completion Date such that the Year part of it is greater than or equal to Expected Completion Year.
668: CURSOR c_dai IS
669: SELECT dai.alias_val
670: FROM IGS_CA_DA_INST_V dai
671: WHERE dt_alias = v_comp_perd_dt_alias AND
672: cal_type = v_cal_type AND
673: NVL(alias_val, IGS_GE_DATE.IGSDATE('1900/01/01')) >= v_context_completion_dt AND
674: SUBSTR(IGS_GE_DATE.IGSCHAR(alias_val),1,4) >= p_expected_completion_yr

Line 683: FROM IGS_CA_DA_INST_V dai

679: cp_adm_m_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_m_comp_perd_dt_alias%TYPE,
680: cp_adm_s_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_s_comp_perd_dt_alias%TYPE) IS
681: SELECT alias_val,
682: dt_alias
683: FROM IGS_CA_DA_INST_V dai
684: WHERE dt_alias IN(
685: NVL(cp_adm_e_perd_dt_alias, 'NONE'),
686: NVL(cp_adm_m_perd_dt_alias, 'NONE'),
687: NVL(cp_adm_s_perd_dt_alias, 'NONE')