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.PA_RELATIONSHIP_PUB dependencies on PA_PROJ_LEVELS_TMP

Line 1824: insert into PA_PROJ_LEVELS_TMP

1820: if (l_count = 0) then
1821:
1822: -- represent program group hierarchy in the form of a directed graph
1823:
1824: insert into PA_PROJ_LEVELS_TMP
1825: (
1826: FROM_ID,
1827: TO_ID,
1828: FROM_LEVEL,

Line 1907: PA_PROJ_LEVELS_TMP

1903: select
1904: FROM_ID,
1905: TO_ID
1906: from
1907: PA_PROJ_LEVELS_TMP
1908: group by
1909: FROM_ID,
1910: TO_ID
1911: having

Line 1930: PA_PROJ_LEVELS_TMP tmp1

1926: select
1927: distinct
1928: tmp1.TO_ID PROJECT_ID
1929: from
1930: PA_PROJ_LEVELS_TMP tmp1
1931: start with
1932: tmp1.ATTRIBUTE1 = 'NEW_ASSOCIATION_DOWN'
1933: connect by
1934: tmp1.DIRECTION = 'D' and

Line 1942: PA_PROJ_LEVELS_TMP tmp2

1938: select
1939: distinct
1940: tmp2.FROM_ID PROJECT_ID
1941: from
1942: PA_PROJ_LEVELS_TMP tmp2
1943: where
1944: tmp2.DIRECTION = 'D'
1945: ) loop
1946:

Line 1956: PA_PROJ_LEVELS_TMP tmp3

1952: (
1953: select
1954: tmp3.TO_ID
1955: from
1956: PA_PROJ_LEVELS_TMP tmp3
1957: start with
1958: tmp3.FROM_ID = leaf_node.PROJECT_ID
1959: connect by
1960: tmp3.DIRECTION = 'U' and

Line 1992: PA_PROJ_LEVELS_TMP tmp4

1988:
1989: -- adjust hierarchy levels
1990:
1991: update
1992: PA_PROJ_LEVELS_TMP tmp4
1993: set
1994: tmp4.FROM_LEVEL = 1
1995: where
1996: tmp4.FROM_LEVEL <> 1 and

Line 2013: PA_PROJ_LEVELS_TMP tmp1

2009: distinct
2010: tmp1.TO_ID PROJECT_ID,
2011: LEVEL PROJECT_LEVEL
2012: from
2013: PA_PROJ_LEVELS_TMP tmp1
2014: start with
2015: tmp1.DIRECTION = 'U'
2016: connect by
2017: tmp1.DIRECTION = 'U' and

Line 2031: PA_PROJ_LEVELS_TMP

2027:
2028: l_count := sql%rowcount;
2029:
2030: update
2031: PA_PROJ_LEVELS_TMP
2032: set
2033: TO_LEVEL = 1
2034: where
2035: TO_LEVEL <> 1 and

Line 2041: PA_PROJ_LEVELS_TMP tmp1

2037: (
2038: select
2039: tmp1.FROM_ID
2040: from
2041: PA_PROJ_LEVELS_TMP tmp1
2042: where
2043: tmp1.FROM_LEVEL = 1
2044: );
2045:

Line 2051: PA_PROJ_LEVELS_TMP tmp

2047:
2048: l_count := 0;
2049:
2050: update
2051: PA_PROJ_LEVELS_TMP tmp
2052: set
2053: tmp.TO_LEVEL = tmp.FROM_LEVEL + 1
2054: where
2055: tmp.FROM_LEVEL <> -1 and

Line 2063: PA_PROJ_LEVELS_TMP tmp

2059:
2060: l_count := l_count + sql%rowcount;
2061:
2062: update
2063: PA_PROJ_LEVELS_TMP tmp
2064: set
2065: tmp.TO_LEVEL = decode(tmp.DIRECTION,
2066: 'U', tmp.FROM_LEVEL - 1,
2067: 'D', tmp.FROM_LEVEL + 1)

Line 2075: PA_PROJ_LEVELS_TMP tmp2

2071:
2072: l_count := l_count + sql%rowcount;
2073:
2074: update
2075: PA_PROJ_LEVELS_TMP tmp2
2076: set
2077: tmp2.TO_LEVEL =
2078: (
2079: select

Line 2082: PA_PROJ_LEVELS_TMP tmp1

2078: (
2079: select
2080: max(tmp1.TO_LEVEL)
2081: from
2082: PA_PROJ_LEVELS_TMP tmp1
2083: where
2084: tmp1.TO_ID = tmp2.TO_ID
2085: )
2086: where

Line 2092: PA_PROJ_LEVELS_TMP tmp1

2088: (
2089: select
2090: max(tmp1.TO_LEVEL)
2091: from
2092: PA_PROJ_LEVELS_TMP tmp1
2093: where
2094: tmp1.TO_ID = tmp2.TO_ID
2095: );
2096:

Line 2098: PA_PROJ_LEVELS_TMP tmp2

2094: tmp1.TO_ID = tmp2.TO_ID
2095: );
2096:
2097: update
2098: PA_PROJ_LEVELS_TMP tmp2
2099: set
2100: tmp2.FROM_LEVEL =
2101: (
2102: select

Line 2105: PA_PROJ_LEVELS_TMP tmp1

2101: (
2102: select
2103: tmp1.TO_LEVEL
2104: from
2105: PA_PROJ_LEVELS_TMP tmp1
2106: where
2107: tmp1.TO_ID = tmp2.FROM_ID and
2108: tmp1.TO_LEVEL <> -1 and
2109: ROWNUM = 1

Line 2117: PA_PROJ_LEVELS_TMP tmp1

2113: (
2114: select
2115: tmp1.TO_LEVEL
2116: from
2117: PA_PROJ_LEVELS_TMP tmp1
2118: where
2119: tmp1.TO_ID = tmp2.FROM_ID and
2120: tmp1.TO_LEVEL <> -1 and
2121: ROWNUM = 1

Line 2134: PA_PROJ_LEVELS_TMP tmp

2130: (
2131: select
2132: tmp.TO_LEVEL
2133: from
2134: PA_PROJ_LEVELS_TMP tmp
2135: where
2136: tmp.TO_ID = ver.PROJECT_ID and
2137: tmp.TO_LEVEL <> -1 and
2138: ROWNUM = 1

Line 2149: PA_PROJ_LEVELS_TMP tmp

2145: select
2146: distinct
2147: tmp.TO_ID
2148: from
2149: PA_PROJ_LEVELS_TMP tmp
2150: ) and
2151: ver.PRG_LEVEL <>
2152: (
2153: select

Line 2156: PA_PROJ_LEVELS_TMP tmp

2152: (
2153: select
2154: tmp.TO_LEVEL
2155: from
2156: PA_PROJ_LEVELS_TMP tmp
2157: where
2158: tmp.TO_ID = ver.PROJECT_ID and
2159: tmp.TO_LEVEL <> -1 and
2160: ROWNUM = 1

Line 2319: insert into PA_PROJ_LEVELS_TMP

2315: end if;
2316:
2317: -- represent program group hierarchy in the form of a directed graph
2318:
2319: insert into PA_PROJ_LEVELS_TMP
2320: (
2321: FROM_ID,
2322: TO_ID,
2323: FROM_LEVEL,

Line 2420: PA_PROJ_LEVELS_TMP tmp

2416: tmp.ATTRIBUTE2
2417: into
2418: l_count
2419: from
2420: PA_PROJ_LEVELS_TMP tmp
2421: where
2422: tmp.ATTRIBUTE1 = 'DROPPED_ASSOCIATION_DOWN';
2423:
2424: if (l_count = 1) then

Line 2429: PA_PROJ_LEVELS_TMP tmp2

2425:
2426: -- check whether or not removing this association divides the group
2427:
2428: update
2429: PA_PROJ_LEVELS_TMP tmp2
2430: set
2431: tmp2.ATTRIBUTE3 = 'CHILD_SUBGROUP'
2432: where
2433: tmp2.ATTRIBUTE1 not in ('DROPPED_ASSOCIATION_DOWN',

Line 2436: ( TMP2.FROM_ID in (select TMP1.TO_ID from PA_PROJ_LEVELS_TMP TMP1 WHERE TMP1.ATTRIBUTE1 = 'DROPPED_ASSOCIATION_DOWN')

2432: where
2433: tmp2.ATTRIBUTE1 not in ('DROPPED_ASSOCIATION_DOWN',
2434: 'DROPPED_ASSOCIATION_UP') and
2435: tmp2.ATTRIBUTE3 <> 'CHILD_SUBGROUP' and
2436: ( TMP2.FROM_ID in (select TMP1.TO_ID from PA_PROJ_LEVELS_TMP TMP1 WHERE TMP1.ATTRIBUTE1 = 'DROPPED_ASSOCIATION_DOWN')
2437: or
2438: TMP2.TO_ID in (select TMP1.TO_ID from PA_PROJ_LEVELS_TMP TMP1 WHERE TMP1.ATTRIBUTE1 = 'DROPPED_ASSOCIATION_DOWN')
2439: );
2440: /* commented for bug 6778370

Line 2438: TMP2.TO_ID in (select TMP1.TO_ID from PA_PROJ_LEVELS_TMP TMP1 WHERE TMP1.ATTRIBUTE1 = 'DROPPED_ASSOCIATION_DOWN')

2434: 'DROPPED_ASSOCIATION_UP') and
2435: tmp2.ATTRIBUTE3 <> 'CHILD_SUBGROUP' and
2436: ( TMP2.FROM_ID in (select TMP1.TO_ID from PA_PROJ_LEVELS_TMP TMP1 WHERE TMP1.ATTRIBUTE1 = 'DROPPED_ASSOCIATION_DOWN')
2437: or
2438: TMP2.TO_ID in (select TMP1.TO_ID from PA_PROJ_LEVELS_TMP TMP1 WHERE TMP1.ATTRIBUTE1 = 'DROPPED_ASSOCIATION_DOWN')
2439: );
2440: /* commented for bug 6778370
2441: exists
2442: (

Line 2446: PA_PROJ_LEVELS_TMP tmp1

2442: (
2443: select
2444: 1
2445: from
2446: PA_PROJ_LEVELS_TMP tmp1
2447: where
2448: tmp1.ATTRIBUTE1 = 'DROPPED_ASSOCIATION_DOWN' and
2449: (tmp2.FROM_ID = tmp1.TO_ID or
2450: tmp2.TO_ID = tmp1.TO_ID)

Line 2456: PA_PROJ_LEVELS_TMP tmp2

2452:
2453: while (sql%rowcount > 0) loop
2454:
2455: update
2456: PA_PROJ_LEVELS_TMP tmp2
2457: set
2458: tmp2.ATTRIBUTE3 = 'CHILD_SUBGROUP'
2459: where
2460: tmp2.ATTRIBUTE1 not in ('DROPPED_ASSOCIATION_DOWN',

Line 2463: ( tmp2.FROM_ID in (select tmp1.TO_ID from PA_PROJ_LEVELS_TMP tmp1 where tmp1.ATTRIBUTE3 = 'CHILD_SUBGROUP')

2459: where
2460: tmp2.ATTRIBUTE1 not in ('DROPPED_ASSOCIATION_DOWN',
2461: 'DROPPED_ASSOCIATION_UP') and
2462: tmp2.ATTRIBUTE3 <> 'CHILD_SUBGROUP' and
2463: ( tmp2.FROM_ID in (select tmp1.TO_ID from PA_PROJ_LEVELS_TMP tmp1 where tmp1.ATTRIBUTE3 = 'CHILD_SUBGROUP')
2464: or
2465: tmp2.TO_ID in (select tmp1.TO_ID from PA_PROJ_LEVELS_TMP tmp1 where tmp1.ATTRIBUTE3 = 'CHILD_SUBGROUP')
2466: );
2467: /* commented for bug 6778370

Line 2465: tmp2.TO_ID in (select tmp1.TO_ID from PA_PROJ_LEVELS_TMP tmp1 where tmp1.ATTRIBUTE3 = 'CHILD_SUBGROUP')

2461: 'DROPPED_ASSOCIATION_UP') and
2462: tmp2.ATTRIBUTE3 <> 'CHILD_SUBGROUP' and
2463: ( tmp2.FROM_ID in (select tmp1.TO_ID from PA_PROJ_LEVELS_TMP tmp1 where tmp1.ATTRIBUTE3 = 'CHILD_SUBGROUP')
2464: or
2465: tmp2.TO_ID in (select tmp1.TO_ID from PA_PROJ_LEVELS_TMP tmp1 where tmp1.ATTRIBUTE3 = 'CHILD_SUBGROUP')
2466: );
2467: /* commented for bug 6778370
2468: exists
2469: (

Line 2473: PA_PROJ_LEVELS_TMP tmp1

2469: (
2470: select
2471: 1
2472: from
2473: PA_PROJ_LEVELS_TMP tmp1
2474: where
2475: tmp1.ATTRIBUTE3 = 'CHILD_SUBGROUP' and
2476: (tmp2.FROM_ID = tmp1.TO_ID or
2477: tmp2.TO_ID = tmp1.TO_ID)

Line 2487: PA_PROJ_LEVELS_TMP tmp

2483: count(*)
2484: into
2485: l_count
2486: from
2487: PA_PROJ_LEVELS_TMP tmp
2488: where
2489: tmp.TO_ID = l_parent_project and
2490: tmp.ATTRIBUTE3 = 'CHILD_SUBGROUP' and
2491: ROWNUM = 1;

Line 2505: from PA_PROJ_LEVELS_TMP tmp

2501: -- adjust hierarchy levels
2502: l_hier_count := 0 ;
2503: select /*+ NO_USE_NL(tmp, tmp1) */ count(*)
2504: into l_hier_count
2505: from PA_PROJ_LEVELS_TMP tmp
2506: where tmp.TO_ID in
2507: (select tmp1.from_id
2508: from PA_PROJ_LEVELS_TMP tmp1
2509: where tmp1.DIRECTION = 'U' and

Line 2508: from PA_PROJ_LEVELS_TMP tmp1

2504: into l_hier_count
2505: from PA_PROJ_LEVELS_TMP tmp
2506: where tmp.TO_ID in
2507: (select tmp1.from_id
2508: from PA_PROJ_LEVELS_TMP tmp1
2509: where tmp1.DIRECTION = 'U' and
2510: tmp1.ATTRIBUTE1 <> 'DROPPED_ASSOCIATION_UP'
2511: )
2512: and tmp.DIRECTION = 'U'

Line 2520: PA_PROJ_LEVELS_TMP tmp4

2516: If l_hier_count >0 then
2517:
2518:
2519: update
2520: PA_PROJ_LEVELS_TMP tmp4
2521: set
2522: tmp4.FROM_LEVEL = 1
2523: where
2524: tmp4.FROM_LEVEL <> 1 and

Line 2541: PA_PROJ_LEVELS_TMP tmp1

2537: distinct
2538: tmp1.TO_ID PROJECT_ID,
2539: LEVEL PROJECT_LEVEL
2540: from
2541: PA_PROJ_LEVELS_TMP tmp1
2542: start with
2543: tmp1.DIRECTION = 'U' and
2544: tmp1.ATTRIBUTE1 <> 'DROPPED_ASSOCIATION_UP'
2545: and exists /* bug 6778370 */

Line 2548: PA_PROJ_LEVELS_TMP tmp5

2544: tmp1.ATTRIBUTE1 <> 'DROPPED_ASSOCIATION_UP'
2545: and exists /* bug 6778370 */
2546: (
2547: select 1 from
2548: PA_PROJ_LEVELS_TMP tmp5
2549: where tmp1.to_id = tmp5.from_id and
2550: tmp5.DIRECTION = 'U' and
2551: tmp5.ATTRIBUTE1 <> 'DROPPED_ASSOCIATION_UP'
2552: )

Line 2568: PA_PROJ_LEVELS_TMP tmp4

2564: );
2565:
2566: else /* bug 6778370 */
2567: update
2568: PA_PROJ_LEVELS_TMP tmp4
2569: set
2570: tmp4.FROM_LEVEL = 1
2571: where
2572: tmp4.FROM_LEVEL <> 1 and

Line 2574: PA_PROJ_LEVELS_TMP tmp1

2570: tmp4.FROM_LEVEL = 1
2571: where
2572: tmp4.FROM_LEVEL <> 1 and
2573: tmp4.FROM_ID = ( select tmp1.to_id from
2574: PA_PROJ_LEVELS_TMP tmp1
2575: where tmp1.DIRECTION = 'U' and
2576: tmp1.ATTRIBUTE1 <> 'DROPPED_ASSOCIATION_UP' and
2577: rownum = 1
2578: );

Line 2585: PA_PROJ_LEVELS_TMP

2581:
2582: l_count := sql%rowcount;
2583:
2584: update
2585: PA_PROJ_LEVELS_TMP
2586: set
2587: TO_LEVEL = 1
2588: where
2589: TO_LEVEL <> 1 and

Line 2595: PA_PROJ_LEVELS_TMP tmp1

2591: (
2592: select
2593: tmp1.FROM_ID
2594: from
2595: PA_PROJ_LEVELS_TMP tmp1
2596: where
2597: tmp1.FROM_LEVEL = 1
2598: );
2599:

Line 2605: PA_PROJ_LEVELS_TMP tmp

2601:
2602: l_count := 0;
2603:
2604: update
2605: PA_PROJ_LEVELS_TMP tmp
2606: set
2607: tmp.TO_LEVEL = tmp.FROM_LEVEL + 1
2608: where
2609: tmp.FROM_LEVEL <> -1 and

Line 2618: PA_PROJ_LEVELS_TMP tmp

2614:
2615: l_count := l_count + sql%rowcount;
2616:
2617: update
2618: PA_PROJ_LEVELS_TMP tmp
2619: set
2620: tmp.TO_LEVEL = decode(tmp.DIRECTION,
2621: 'U', tmp.FROM_LEVEL - 1,
2622: 'D', tmp.FROM_LEVEL + 1)

Line 2632: PA_PROJ_LEVELS_TMP tmp2

2628:
2629: l_count := l_count + sql%rowcount;
2630:
2631: update
2632: PA_PROJ_LEVELS_TMP tmp2
2633: set
2634: tmp2.TO_LEVEL =
2635: nvl((
2636: select

Line 2639: PA_PROJ_LEVELS_TMP tmp1

2635: nvl((
2636: select
2637: max(tmp1.TO_LEVEL)
2638: from
2639: PA_PROJ_LEVELS_TMP tmp1
2640: where
2641: tmp1.TO_ID = tmp2.TO_ID
2642: ),tmp2.TO_LEVEL)
2643: where

Line 2652: PA_PROJ_LEVELS_TMP tmp1

2648: (
2649: select
2650: max(tmp1.TO_LEVEL)
2651: from
2652: PA_PROJ_LEVELS_TMP tmp1
2653: where
2654: tmp1.TO_ID = tmp2.TO_ID
2655: ); commented for bug 6778370*/
2656:

Line 2658: PA_PROJ_LEVELS_TMP tmp2

2654: tmp1.TO_ID = tmp2.TO_ID
2655: ); commented for bug 6778370*/
2656:
2657: update
2658: PA_PROJ_LEVELS_TMP tmp2
2659: set
2660: tmp2.FROM_LEVEL =
2661: nvl((
2662: select

Line 2665: PA_PROJ_LEVELS_TMP tmp1

2661: nvl((
2662: select
2663: tmp1.TO_LEVEL
2664: from
2665: PA_PROJ_LEVELS_TMP tmp1
2666: where
2667: tmp1.TO_ID = tmp2.FROM_ID and
2668: tmp1.TO_LEVEL <> -1 and
2669: ROWNUM = 1

Line 2681: PA_PROJ_LEVELS_TMP tmp1

2677: (
2678: select
2679: tmp1.TO_LEVEL
2680: from
2681: PA_PROJ_LEVELS_TMP tmp1
2682: where
2683: tmp1.TO_ID = tmp2.FROM_ID and
2684: tmp1.TO_LEVEL <> -1 and
2685: ROWNUM = 1

Line 2698: PA_PROJ_LEVELS_TMP tmp

2694: (
2695: select
2696: tmp.TO_LEVEL
2697: from
2698: PA_PROJ_LEVELS_TMP tmp
2699: where
2700: tmp.TO_ID = ver.PROJECT_ID and
2701: tmp.TO_LEVEL <> -1 and
2702: ROWNUM = 1

Line 2713: PA_PROJ_LEVELS_TMP tmp

2709: select
2710: distinct
2711: tmp.TO_ID
2712: from
2713: PA_PROJ_LEVELS_TMP tmp
2714: ) and
2715: ver.PRG_LEVEL <>
2716: (
2717: select

Line 2720: PA_PROJ_LEVELS_TMP tmp

2716: (
2717: select
2718: tmp.TO_LEVEL
2719: from
2720: PA_PROJ_LEVELS_TMP tmp
2721: where
2722: tmp.TO_ID = ver.PROJECT_ID and
2723: tmp.TO_LEVEL <> -1 and
2724: ROWNUM = 1

Line 2743: where exists ( select 1 from PA_PROJ_LEVELS_TMP tmp

2739: -- Bug 6778370
2740: begin
2741: select 'Y' into l_subgrp_exist
2742: from dual
2743: where exists ( select 1 from PA_PROJ_LEVELS_TMP tmp
2744: where
2745: ATTRIBUTE1 = 'DROPPED_ASSOCIATION_DOWN' or
2746: tmp.ATTRIBUTE3 = 'CHILD_SUBGROUP');
2747: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 2763: PA_PROJ_LEVELS_TMP tmp

2759: (
2760: select
2761: tmp.TO_ID
2762: from
2763: PA_PROJ_LEVELS_TMP tmp
2764: where
2765: ATTRIBUTE1 = 'DROPPED_ASSOCIATION_DOWN' or
2766: ATTRIBUTE3 = 'CHILD_SUBGROUP'
2767: );

Line 2802: delete from PA_PROJ_LEVELS_TMP;

2798: end if;
2799:
2800: end if;
2801:
2802: delete from PA_PROJ_LEVELS_TMP;
2803:
2804: l_last_update_date := sysdate;
2805: l_last_updated_by := FND_GLOBAL.USER_ID;
2806: l_creation_date := sysdate;