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_CA_VAL_QLITY dependencies on IGS_EN_CAL_CONF

Line 1519: FROM IGS_EN_CAL_CONF

1515: commence_cutoff_dt_alias,
1516: enr_form_due_dt_alias,
1517: enr_pckg_prod_dt_alias,
1518: effect_enr_strt_dt_alias
1519: FROM IGS_EN_CAL_CONF
1520: WHERE s_control_num = 1;
1521: CURSOR c_chk_da_exists (
1522: cp_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE,
1523: cp_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE ) IS

Line 1522: cp_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE,

1518: effect_enr_strt_dt_alias
1519: FROM IGS_EN_CAL_CONF
1520: WHERE s_control_num = 1;
1521: CURSOR c_chk_da_exists (
1522: cp_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE,
1523: cp_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE ) IS
1524: SELECT 'x'
1525: FROM IGS_CA_DA_INST_V daiv,
1526: IGS_CA_TYPE ct

Line 1531: cp_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE,

1527: WHERE daiv.DT_ALIAS = cp_dt_alias AND
1528: daiv.CAL_TYPE = ct.CAL_TYPE AND
1529: ct.S_CAL_CAT <> cp_s_cal_cat;
1530: CURSOR c_chk_da_exists1 (
1531: cp_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE,
1532: cp_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE ,
1533: cp_s_cal_cat1 IGS_CA_TYPE.S_CAL_CAT%TYPE) IS
1534: SELECT 'x'
1535: FROM IGS_CA_DA_INST_V daiv,

Line 1541: v_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE;

1537: WHERE daiv.DT_ALIAS = cp_dt_alias AND
1538: daiv.CAL_TYPE = ct.CAL_TYPE AND
1539: ct.S_CAL_CAT <> cp_s_cal_cat AND
1540: ct.S_CAL_CAT <> cp_s_cal_cat1;
1541: v_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE;
1542: v_commencement_dt_alias IGS_EN_CAL_CONF.commencement_dt_alias%TYPE;
1543: v_commence_cutoff_dt_alias IGS_EN_CAL_CONF.commence_cutoff_dt_alias%TYPE;
1544: v_enr_form_due_dt_alias IGS_EN_CAL_CONF.enr_form_due_dt_alias%TYPE;
1545: v_enr_pckg_prod_dt_alias IGS_EN_CAL_CONF.enr_pckg_prod_dt_alias%TYPE;

Line 1542: v_commencement_dt_alias IGS_EN_CAL_CONF.commencement_dt_alias%TYPE;

1538: daiv.CAL_TYPE = ct.CAL_TYPE AND
1539: ct.S_CAL_CAT <> cp_s_cal_cat AND
1540: ct.S_CAL_CAT <> cp_s_cal_cat1;
1541: v_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE;
1542: v_commencement_dt_alias IGS_EN_CAL_CONF.commencement_dt_alias%TYPE;
1543: v_commence_cutoff_dt_alias IGS_EN_CAL_CONF.commence_cutoff_dt_alias%TYPE;
1544: v_enr_form_due_dt_alias IGS_EN_CAL_CONF.enr_form_due_dt_alias%TYPE;
1545: v_enr_pckg_prod_dt_alias IGS_EN_CAL_CONF.enr_pckg_prod_dt_alias%TYPE;
1546: v_effect_enr_strt_dt_alias IGS_EN_CAL_CONF.effect_enr_strt_dt_alias%TYPE;

Line 1543: v_commence_cutoff_dt_alias IGS_EN_CAL_CONF.commence_cutoff_dt_alias%TYPE;

1539: ct.S_CAL_CAT <> cp_s_cal_cat AND
1540: ct.S_CAL_CAT <> cp_s_cal_cat1;
1541: v_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE;
1542: v_commencement_dt_alias IGS_EN_CAL_CONF.commencement_dt_alias%TYPE;
1543: v_commence_cutoff_dt_alias IGS_EN_CAL_CONF.commence_cutoff_dt_alias%TYPE;
1544: v_enr_form_due_dt_alias IGS_EN_CAL_CONF.enr_form_due_dt_alias%TYPE;
1545: v_enr_pckg_prod_dt_alias IGS_EN_CAL_CONF.enr_pckg_prod_dt_alias%TYPE;
1546: v_effect_enr_strt_dt_alias IGS_EN_CAL_CONF.effect_enr_strt_dt_alias%TYPE;
1547: v_check_dt_alias_flag CHAR;

Line 1544: v_enr_form_due_dt_alias IGS_EN_CAL_CONF.enr_form_due_dt_alias%TYPE;

1540: ct.S_CAL_CAT <> cp_s_cal_cat1;
1541: v_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE;
1542: v_commencement_dt_alias IGS_EN_CAL_CONF.commencement_dt_alias%TYPE;
1543: v_commence_cutoff_dt_alias IGS_EN_CAL_CONF.commence_cutoff_dt_alias%TYPE;
1544: v_enr_form_due_dt_alias IGS_EN_CAL_CONF.enr_form_due_dt_alias%TYPE;
1545: v_enr_pckg_prod_dt_alias IGS_EN_CAL_CONF.enr_pckg_prod_dt_alias%TYPE;
1546: v_effect_enr_strt_dt_alias IGS_EN_CAL_CONF.effect_enr_strt_dt_alias%TYPE;
1547: v_check_dt_alias_flag CHAR;
1548:

Line 1545: v_enr_pckg_prod_dt_alias IGS_EN_CAL_CONF.enr_pckg_prod_dt_alias%TYPE;

1541: v_load_effect_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE;
1542: v_commencement_dt_alias IGS_EN_CAL_CONF.commencement_dt_alias%TYPE;
1543: v_commence_cutoff_dt_alias IGS_EN_CAL_CONF.commence_cutoff_dt_alias%TYPE;
1544: v_enr_form_due_dt_alias IGS_EN_CAL_CONF.enr_form_due_dt_alias%TYPE;
1545: v_enr_pckg_prod_dt_alias IGS_EN_CAL_CONF.enr_pckg_prod_dt_alias%TYPE;
1546: v_effect_enr_strt_dt_alias IGS_EN_CAL_CONF.effect_enr_strt_dt_alias%TYPE;
1547: v_check_dt_alias_flag CHAR;
1548:
1549: v_test_flag BOOLEAN := FALSE;

Line 1546: v_effect_enr_strt_dt_alias IGS_EN_CAL_CONF.effect_enr_strt_dt_alias%TYPE;

1542: v_commencement_dt_alias IGS_EN_CAL_CONF.commencement_dt_alias%TYPE;
1543: v_commence_cutoff_dt_alias IGS_EN_CAL_CONF.commence_cutoff_dt_alias%TYPE;
1544: v_enr_form_due_dt_alias IGS_EN_CAL_CONF.enr_form_due_dt_alias%TYPE;
1545: v_enr_pckg_prod_dt_alias IGS_EN_CAL_CONF.enr_pckg_prod_dt_alias%TYPE;
1546: v_effect_enr_strt_dt_alias IGS_EN_CAL_CONF.effect_enr_strt_dt_alias%TYPE;
1547: v_check_dt_alias_flag CHAR;
1548:
1549: v_test_flag BOOLEAN := FALSE;
1550: BEGIN

Line 1551: -- Check optional enrolment date aliases from the IGS_EN_CAL_CONF table

1547: v_check_dt_alias_flag CHAR;
1548:
1549: v_test_flag BOOLEAN := FALSE;
1550: BEGIN
1551: -- Check optional enrolment date aliases from the IGS_EN_CAL_CONF table
1552: OPEN c_chk_dt_aliases;
1553: FETCH c_chk_dt_aliases INTO
1554: v_load_effect_dt_alias,
1555: v_commencement_dt_alias,

Line 1915: FROM IGS_EN_CAL_CONF secc,

1911: CURSOR c_secc_dai (
1912: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1913: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1914: SELECT count(*)
1915: FROM IGS_EN_CAL_CONF secc,
1916: IGS_CA_DA_INST dai
1917: WHERE secc.s_control_num = 1 AND
1918: dai.CAL_TYPE = cp_cal_type AND
1919: dai.ci_sequence_number = cp_sequence_number AND