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_INS_ROLL_CI dependencies on IGS_CA_INST_REL

Line 1624: IGS_CA_INST_REL.load_research_percentage%TYPE;

1620: v_derived_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1621: v_derived_start_dt IGS_CA_INST.start_dt%TYPE;
1622: v_derived_end_dt IGS_CA_INST.end_dt%TYPE;
1623: v_sup_load_res_percentage
1624: IGS_CA_INST_REL.load_research_percentage%TYPE;
1625: v_other_detail VARCHAR2(255);
1626: token1_val VARCHAR2(255);
1627: token2_val VARCHAR2(255);
1628: v_dummy VARCHAR2(1);

Line 1635: FROM IGS_CA_INST_REL cir

1631: CURSOR c_cal_inst_rltsp_sup IS
1632: SELECT cir.sup_cal_type,
1633: cir.sup_ci_sequence_number,
1634: cir.load_research_percentage
1635: FROM IGS_CA_INST_REL cir
1636: WHERE cir.sub_cal_type = p_cal_type AND
1637: cir.sub_ci_sequence_number = p_sequence_number;
1638: CURSOR c_cal_instance(
1639: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

Line 1663: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,

1659: ci.end_dt = cp_end_dt AND
1660: ci.CAL_STATUS = cs.CAL_STATUS;
1661: v_derived_cal_instance_rec c_derived_cal_instance%ROWTYPE;
1662: CURSOR c_cir(
1663: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
1664: cp_sub_ci_sequence_number
1665: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE,
1666: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
1667: cp_sup_ci_sequence_number

Line 1665: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE,

1661: v_derived_cal_instance_rec c_derived_cal_instance%ROWTYPE;
1662: CURSOR c_cir(
1663: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
1664: cp_sub_ci_sequence_number
1665: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE,
1666: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
1667: cp_sup_ci_sequence_number
1668: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS
1669: SELECT 'x'

Line 1666: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,

1662: CURSOR c_cir(
1663: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
1664: cp_sub_ci_sequence_number
1665: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE,
1666: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
1667: cp_sup_ci_sequence_number
1668: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS
1669: SELECT 'x'
1670: FROM IGS_CA_INST_REL cir

Line 1668: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS

1664: cp_sub_ci_sequence_number
1665: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE,
1666: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
1667: cp_sup_ci_sequence_number
1668: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS
1669: SELECT 'x'
1670: FROM IGS_CA_INST_REL cir
1671: WHERE cir.sub_cal_type = cp_sub_cal_type AND
1672: cir.sub_ci_sequence_number = cp_sub_ci_sequence_number AND

Line 1670: FROM IGS_CA_INST_REL cir

1666: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
1667: cp_sup_ci_sequence_number
1668: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS
1669: SELECT 'x'
1670: FROM IGS_CA_INST_REL cir
1671: WHERE cir.sub_cal_type = cp_sub_cal_type AND
1672: cir.sub_ci_sequence_number = cp_sub_ci_sequence_number AND
1673: cir.sup_cal_type = cp_sup_cal_type AND
1674: cir.sup_ci_sequence_number = cp_sup_ci_sequence_number;

Line 1820: IGS_CA_INST_REL_PKG.INSERT_ROW(

1816: FETCH c_cir INTO v_dummy;
1817: IF c_cir%NOTFOUND THEN
1818: CLOSE c_cir;
1819:
1820: IGS_CA_INST_REL_PKG.INSERT_ROW(
1821: X_ROWID => X_ROWID,
1822: X_sub_cal_type => p_sub_cal_type,
1823: X_sub_ci_sequence_number => p_sub_ci_sequence_number,
1824: X_sup_cal_type => v_derived_cal_instance_rec.CAL_TYPE,

Line 1920: -- Validate IGS_CA_INST_REL

1916: CLOSE c_cal_instance;
1917: RAISE NO_DATA_FOUND;
1918: END IF;
1919: CLOSE c_cal_instance;
1920: -- Validate IGS_CA_INST_REL
1921: IF NOT IGS_CA_VAL_CIR.calp_val_cir_ci (
1922: p_sub_cal_type,
1923: p_sub_ci_sequence_number,
1924: p_sup_cal_type,

Line 1957: IGS_CA_INST_REL_PKG.INSERT_ROW(

1953: v_other_detail);
1954: ELSE
1955: -- Insert calendar instance relationship
1956:
1957: IGS_CA_INST_REL_PKG.INSERT_ROW(
1958: X_ROWID => X_ROWID,
1959: X_sub_cal_type => p_sub_cal_type,
1960: X_sub_ci_sequence_number => p_sub_ci_sequence_number,
1961: X_sup_cal_type => p_sup_cal_type,

Line 2522: v_cir5_rec IGS_CA_INST_REL%ROWTYPE;

2518: v_new_sequence_number IGS_CA_INST.sequence_number%TYPE;
2519: v_message_name VARCHAR2(30);
2520: v_rollover_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
2521: v_rollover_sequence_number IGS_CA_INST.sequence_number%TYPE;
2522: v_cir5_rec IGS_CA_INST_REL%ROWTYPE;
2523: v_ci_rollover_sequence_number
2524: IGS_CA_INST.sequence_number%TYPE;
2525: TYPE t1_rollover_ci_rec IS RECORD(
2526: CAL_TYPE IGS_CA_INST.CAL_TYPE%TYPE,

Line 2544: SELECT IGS_CA_INST_REL_SUP_CI_SNO_S1.NEXTVAL

2540: INDEX BY BINARY_INTEGER;
2541: t2_rollover_ci t2_rollover_ci_table;
2542: t2_rollover_ci_index BINARY_INTEGER;
2543: CURSOR c_ci_rollover_sequence_number IS
2544: SELECT IGS_CA_INST_REL_SUP_CI_SNO_S1.NEXTVAL
2545: FROM dual;
2546: CURSOR c_cir1 IS
2547: SELECT *
2548: FROM IGS_CA_INST_REL

Line 2548: FROM IGS_CA_INST_REL

2544: SELECT IGS_CA_INST_REL_SUP_CI_SNO_S1.NEXTVAL
2545: FROM dual;
2546: CURSOR c_cir1 IS
2547: SELECT *
2548: FROM IGS_CA_INST_REL
2549: WHERE sup_cal_type = p_cal_type AND
2550: sup_ci_sequence_number = p_sequence_number;
2551: CURSOR c_cir2 IS
2552: SELECT *

Line 2553: FROM IGS_CA_INST_REL cir1

2549: WHERE sup_cal_type = p_cal_type AND
2550: sup_ci_sequence_number = p_sequence_number;
2551: CURSOR c_cir2 IS
2552: SELECT *
2553: FROM IGS_CA_INST_REL cir1
2554: WHERE (cir1.sup_cal_type,cir1.sup_ci_sequence_number) IN
2555: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2556: FROM IGS_CA_INST_REL cir2
2557: WHERE cir2.sup_cal_type = p_cal_type AND

Line 2556: FROM IGS_CA_INST_REL cir2

2552: SELECT *
2553: FROM IGS_CA_INST_REL cir1
2554: WHERE (cir1.sup_cal_type,cir1.sup_ci_sequence_number) IN
2555: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2556: FROM IGS_CA_INST_REL cir2
2557: WHERE cir2.sup_cal_type = p_cal_type AND
2558: cir2.sup_ci_sequence_number = p_sequence_number);
2559: CURSOR c_cir3 IS
2560: SELECT *

Line 2561: FROM IGS_CA_INST_REL cir1

2557: WHERE cir2.sup_cal_type = p_cal_type AND
2558: cir2.sup_ci_sequence_number = p_sequence_number);
2559: CURSOR c_cir3 IS
2560: SELECT *
2561: FROM IGS_CA_INST_REL cir1
2562: WHERE (cir1.sup_cal_type,cir1.sup_ci_sequence_number) IN
2563: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2564: FROM IGS_CA_INST_REL cir2
2565: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN

Line 2564: FROM IGS_CA_INST_REL cir2

2560: SELECT *
2561: FROM IGS_CA_INST_REL cir1
2562: WHERE (cir1.sup_cal_type,cir1.sup_ci_sequence_number) IN
2563: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2564: FROM IGS_CA_INST_REL cir2
2565: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN
2566: (SELECT DISTINCT cir3.sub_cal_type,cir3.sub_ci_sequence_number
2567: FROM IGS_CA_INST_REL cir3
2568: WHERE cir3.sup_cal_type = p_cal_type AND

Line 2567: FROM IGS_CA_INST_REL cir3

2563: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2564: FROM IGS_CA_INST_REL cir2
2565: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN
2566: (SELECT DISTINCT cir3.sub_cal_type,cir3.sub_ci_sequence_number
2567: FROM IGS_CA_INST_REL cir3
2568: WHERE cir3.sup_cal_type = p_cal_type AND
2569: cir3.sup_ci_sequence_number = p_sequence_number));
2570: CURSOR c_cir4 IS
2571: SELECT *

Line 2572: FROM IGS_CA_INST_REL cir1

2568: WHERE cir3.sup_cal_type = p_cal_type AND
2569: cir3.sup_ci_sequence_number = p_sequence_number));
2570: CURSOR c_cir4 IS
2571: SELECT *
2572: FROM IGS_CA_INST_REL cir1
2573: WHERE (cir1.sup_cal_type,cir1.sup_ci_sequence_number) IN
2574: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2575: FROM IGS_CA_INST_REL cir2
2576: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN

Line 2575: FROM IGS_CA_INST_REL cir2

2571: SELECT *
2572: FROM IGS_CA_INST_REL cir1
2573: WHERE (cir1.sup_cal_type,cir1.sup_ci_sequence_number) IN
2574: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2575: FROM IGS_CA_INST_REL cir2
2576: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN
2577: (SELECT DISTINCT cir3.sub_cal_type,cir3.sub_ci_sequence_number
2578: FROM IGS_CA_INST_REL cir3
2579: WHERE (cir3.sup_cal_type,cir3.sup_ci_sequence_number) IN

Line 2578: FROM IGS_CA_INST_REL cir3

2574: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2575: FROM IGS_CA_INST_REL cir2
2576: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN
2577: (SELECT DISTINCT cir3.sub_cal_type,cir3.sub_ci_sequence_number
2578: FROM IGS_CA_INST_REL cir3
2579: WHERE (cir3.sup_cal_type,cir3.sup_ci_sequence_number) IN
2580: (SELECT DISTINCT cir4.sub_cal_type,cir4.sub_ci_sequence_number
2581: FROM IGS_CA_INST_REL cir4
2582: WHERE cir4.sup_cal_type = p_cal_type AND

Line 2581: FROM IGS_CA_INST_REL cir4

2577: (SELECT DISTINCT cir3.sub_cal_type,cir3.sub_ci_sequence_number
2578: FROM IGS_CA_INST_REL cir3
2579: WHERE (cir3.sup_cal_type,cir3.sup_ci_sequence_number) IN
2580: (SELECT DISTINCT cir4.sub_cal_type,cir4.sub_ci_sequence_number
2581: FROM IGS_CA_INST_REL cir4
2582: WHERE cir4.sup_cal_type = p_cal_type AND
2583: cir4.sup_ci_sequence_number = p_sequence_number)));
2584: CURSOR c_cir5 IS
2585: SELECT *

Line 2586: FROM IGS_CA_INST_REL cir1

2582: WHERE cir4.sup_cal_type = p_cal_type AND
2583: cir4.sup_ci_sequence_number = p_sequence_number)));
2584: CURSOR c_cir5 IS
2585: SELECT *
2586: FROM IGS_CA_INST_REL cir1
2587: WHERE (cir1.sup_cal_type,cir1.sup_ci_sequence_number) IN
2588: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2589: FROM IGS_CA_INST_REL cir2
2590: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN

Line 2589: FROM IGS_CA_INST_REL cir2

2585: SELECT *
2586: FROM IGS_CA_INST_REL cir1
2587: WHERE (cir1.sup_cal_type,cir1.sup_ci_sequence_number) IN
2588: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2589: FROM IGS_CA_INST_REL cir2
2590: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN
2591: (SELECT DISTINCT cir3.sub_cal_type,cir3.sub_ci_sequence_number
2592: FROM IGS_CA_INST_REL cir3
2593: WHERE (cir3.sup_cal_type,cir3.sup_ci_sequence_number) IN

Line 2592: FROM IGS_CA_INST_REL cir3

2588: (SELECT DISTINCT cir2.sub_cal_type,cir2.sub_ci_sequence_number
2589: FROM IGS_CA_INST_REL cir2
2590: WHERE (cir2.sup_cal_type,cir2.sup_ci_sequence_number) IN
2591: (SELECT DISTINCT cir3.sub_cal_type,cir3.sub_ci_sequence_number
2592: FROM IGS_CA_INST_REL cir3
2593: WHERE (cir3.sup_cal_type,cir3.sup_ci_sequence_number) IN
2594: (SELECT DISTINCT cir4.sub_cal_type,cir4.sub_ci_sequence_number
2595: FROM IGS_CA_INST_REL cir4
2596: WHERE (cir4.sup_cal_type,cir4.sup_ci_sequence_number) IN

Line 2595: FROM IGS_CA_INST_REL cir4

2591: (SELECT DISTINCT cir3.sub_cal_type,cir3.sub_ci_sequence_number
2592: FROM IGS_CA_INST_REL cir3
2593: WHERE (cir3.sup_cal_type,cir3.sup_ci_sequence_number) IN
2594: (SELECT DISTINCT cir4.sub_cal_type,cir4.sub_ci_sequence_number
2595: FROM IGS_CA_INST_REL cir4
2596: WHERE (cir4.sup_cal_type,cir4.sup_ci_sequence_number) IN
2597: (SELECT DISTINCT cir5.sub_cal_type,cir5.sub_ci_sequence_number
2598: FROM IGS_CA_INST_REL cir5
2599: WHERE cir5.sup_cal_type = p_cal_type AND

Line 2598: FROM IGS_CA_INST_REL cir5

2594: (SELECT DISTINCT cir4.sub_cal_type,cir4.sub_ci_sequence_number
2595: FROM IGS_CA_INST_REL cir4
2596: WHERE (cir4.sup_cal_type,cir4.sup_ci_sequence_number) IN
2597: (SELECT DISTINCT cir5.sub_cal_type,cir5.sub_ci_sequence_number
2598: FROM IGS_CA_INST_REL cir5
2599: WHERE cir5.sup_cal_type = p_cal_type AND
2600: cir5.sup_ci_sequence_number = p_sequence_number))));
2601: BEGIN
2602: -- Insert rollover calendar instance, its calendar instance relationships