eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_GEN_004 dependencies on IGS_AD_CAL_CONF

Line 203: v_dt_alias IGS_AD_CAL_CONF.adm_appl_chng_of_pref_dt_alias%TYPE;

199: BEGIN -- admp_get_chg_pref_dt
200: -- This module retrieves the date instance for change of preferences.
201: DECLARE
202: v_out_date DATE;
203: v_dt_alias IGS_AD_CAL_CONF.adm_appl_chng_of_pref_dt_alias%TYPE;
204: CURSOR c_sacc_dt_alias IS
205: SELECT sacc.adm_appl_chng_of_pref_dt_alias
206: FROM IGS_AD_CAL_CONF sacc
207: WHERE sacc.s_control_num = 1;

Line 206: FROM IGS_AD_CAL_CONF sacc

202: v_out_date DATE;
203: v_dt_alias IGS_AD_CAL_CONF.adm_appl_chng_of_pref_dt_alias%TYPE;
204: CURSOR c_sacc_dt_alias IS
205: SELECT sacc.adm_appl_chng_of_pref_dt_alias
206: FROM IGS_AD_CAL_CONF sacc
207: WHERE sacc.s_control_num = 1;
208: CURSOR c_aa_acaiv IS
209: SELECT acaiv.adm_cal_type,
210: acaiv.adm_ci_sequence_number,

Line 637: v_comp_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_e_comp_perd_dt_alias%TYPE;

633: --This can be determined from a start date or expected completeion details
634: DECLARE
635: v_cal_type IGS_PS_OFR.cal_type%TYPE;
636: v_att_gat IGS_EN_ATD_TYPE.govt_attendance_type%TYPE;
637: v_comp_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_e_comp_perd_dt_alias%TYPE;
638: v_completion_time IGS_PS_VER.std_ft_completion_time%TYPE;
639: v_completion_months IGS_PS_VER.std_ft_completion_time%TYPE;
640: v_completion_dt DATE;
641: v_start_dt_yyyy VARCHAR2(4);

Line 649: v_adm_e_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_e_comp_perd_dt_alias%TYPE;

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;
653: v_completion_days NUMBER;

Line 650: v_adm_m_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_m_comp_perd_dt_alias%TYPE;

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;
653: v_completion_days NUMBER;
654: CURSOR c_co IS

Line 651: v_adm_s_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_s_comp_perd_dt_alias%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;
653: v_completion_days NUMBER;
654: CURSOR c_co IS
655: SELECT co.cal_type

Line 663: FROM IGS_AD_CAL_CONF sacco

659: CURSOR c_sacco IS
660: SELECT adm_appl_e_comp_perd_dt_alias,
661: adm_appl_m_comp_perd_dt_alias,
662: adm_appl_s_comp_perd_dt_alias
663: FROM IGS_AD_CAL_CONF sacco
664: WHERE s_control_num = 1;
665:
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.

Line 678: cp_adm_e_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_e_comp_perd_dt_alias%TYPE,

674: SUBSTR(IGS_GE_DATE.IGSCHAR(alias_val),1,4) >= p_expected_completion_yr
675: ORDER BY alias_val; -- Order is changed to Ascending. Bug :2647482
676:
677: CURSOR c_dai2 (
678: cp_adm_e_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_e_comp_perd_dt_alias%TYPE,
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

Line 679: cp_adm_m_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_m_comp_perd_dt_alias%TYPE,

675: ORDER BY alias_val; -- Order is changed to Ascending. Bug :2647482
676:
677: CURSOR c_dai2 (
678: cp_adm_e_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_e_comp_perd_dt_alias%TYPE,
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

Line 680: cp_adm_s_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_s_comp_perd_dt_alias%TYPE) IS

676:
677: CURSOR c_dai2 (
678: cp_adm_e_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_e_comp_perd_dt_alias%TYPE,
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(