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.

[Home] [Help]

APPS.PA_RELATIONSHIP_PUB dependencies on PA_PROJ_LEVELS_TMP

Line 1820: insert into PA_PROJ_LEVELS_TMP

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

Line 1903: PA_PROJ_LEVELS_TMP

1899: select
1900: FROM_ID,
1901: TO_ID
1902: from
1903: PA_PROJ_LEVELS_TMP
1904: group by
1905: FROM_ID,
1906: TO_ID
1907: having

Line 1926: PA_PROJ_LEVELS_TMP tmp1

1922: select
1923: distinct
1924: tmp1.TO_ID PROJECT_ID
1925: from
1926: PA_PROJ_LEVELS_TMP tmp1
1927: start with
1928: tmp1.ATTRIBUTE1 = 'NEW_ASSOCIATION_DOWN'
1929: connect by
1930: tmp1.DIRECTION = 'D' and

Line 1938: PA_PROJ_LEVELS_TMP tmp2

1934: select
1935: distinct
1936: tmp2.FROM_ID PROJECT_ID
1937: from
1938: PA_PROJ_LEVELS_TMP tmp2
1939: where
1940: tmp2.DIRECTION = 'D'
1941: ) loop
1942:

Line 1952: PA_PROJ_LEVELS_TMP tmp3

1948: (
1949: select
1950: tmp3.TO_ID
1951: from
1952: PA_PROJ_LEVELS_TMP tmp3
1953: start with
1954: tmp3.FROM_ID = leaf_node.PROJECT_ID
1955: connect by
1956: tmp3.DIRECTION = 'U' and

Line 1988: PA_PROJ_LEVELS_TMP tmp4

1984:
1985: -- adjust hierarchy levels
1986:
1987: update
1988: PA_PROJ_LEVELS_TMP tmp4
1989: set
1990: tmp4.FROM_LEVEL = 1
1991: where
1992: tmp4.FROM_LEVEL <> 1 and

Line 2009: PA_PROJ_LEVELS_TMP tmp1

2005: distinct
2006: tmp1.TO_ID PROJECT_ID,
2007: LEVEL PROJECT_LEVEL
2008: from
2009: PA_PROJ_LEVELS_TMP tmp1
2010: start with
2011: tmp1.DIRECTION = 'U'
2012: connect by
2013: tmp1.DIRECTION = 'U' and

Line 2027: PA_PROJ_LEVELS_TMP

2023:
2024: l_count := sql%rowcount;
2025:
2026: update
2027: PA_PROJ_LEVELS_TMP
2028: set
2029: TO_LEVEL = 1
2030: where
2031: TO_LEVEL <> 1 and

Line 2037: PA_PROJ_LEVELS_TMP tmp1

2033: (
2034: select
2035: tmp1.FROM_ID
2036: from
2037: PA_PROJ_LEVELS_TMP tmp1
2038: where
2039: tmp1.FROM_LEVEL = 1
2040: );
2041:

Line 2047: PA_PROJ_LEVELS_TMP tmp

2043:
2044: l_count := 0;
2045:
2046: update
2047: PA_PROJ_LEVELS_TMP tmp
2048: set
2049: tmp.TO_LEVEL = tmp.FROM_LEVEL + 1
2050: where
2051: tmp.FROM_LEVEL <> -1 and

Line 2059: PA_PROJ_LEVELS_TMP tmp

2055:
2056: l_count := l_count + sql%rowcount;
2057:
2058: update
2059: PA_PROJ_LEVELS_TMP tmp
2060: set
2061: tmp.TO_LEVEL = decode(tmp.DIRECTION,
2062: 'U', tmp.FROM_LEVEL - 1,
2063: 'D', tmp.FROM_LEVEL + 1)

Line 2071: PA_PROJ_LEVELS_TMP tmp2

2067:
2068: l_count := l_count + sql%rowcount;
2069:
2070: update
2071: PA_PROJ_LEVELS_TMP tmp2
2072: set
2073: tmp2.TO_LEVEL =
2074: (
2075: select

Line 2078: PA_PROJ_LEVELS_TMP tmp1

2074: (
2075: select
2076: max(tmp1.TO_LEVEL)
2077: from
2078: PA_PROJ_LEVELS_TMP tmp1
2079: where
2080: tmp1.TO_ID = tmp2.TO_ID
2081: )
2082: where

Line 2088: PA_PROJ_LEVELS_TMP tmp1

2084: (
2085: select
2086: max(tmp1.TO_LEVEL)
2087: from
2088: PA_PROJ_LEVELS_TMP tmp1
2089: where
2090: tmp1.TO_ID = tmp2.TO_ID
2091: );
2092:

Line 2094: PA_PROJ_LEVELS_TMP tmp2

2090: tmp1.TO_ID = tmp2.TO_ID
2091: );
2092:
2093: update
2094: PA_PROJ_LEVELS_TMP tmp2
2095: set
2096: tmp2.FROM_LEVEL =
2097: (
2098: select

Line 2101: PA_PROJ_LEVELS_TMP tmp1

2097: (
2098: select
2099: tmp1.TO_LEVEL
2100: from
2101: PA_PROJ_LEVELS_TMP tmp1
2102: where
2103: tmp1.TO_ID = tmp2.FROM_ID and
2104: tmp1.TO_LEVEL <> -1 and
2105: ROWNUM = 1

Line 2113: PA_PROJ_LEVELS_TMP tmp1

2109: (
2110: select
2111: tmp1.TO_LEVEL
2112: from
2113: PA_PROJ_LEVELS_TMP tmp1
2114: where
2115: tmp1.TO_ID = tmp2.FROM_ID and
2116: tmp1.TO_LEVEL <> -1 and
2117: ROWNUM = 1

Line 2130: PA_PROJ_LEVELS_TMP tmp

2126: (
2127: select
2128: tmp.TO_LEVEL
2129: from
2130: PA_PROJ_LEVELS_TMP tmp
2131: where
2132: tmp.TO_ID = ver.PROJECT_ID and
2133: tmp.TO_LEVEL <> -1 and
2134: ROWNUM = 1

Line 2145: PA_PROJ_LEVELS_TMP tmp

2141: select
2142: distinct
2143: tmp.TO_ID
2144: from
2145: PA_PROJ_LEVELS_TMP tmp
2146: ) and
2147: ver.PRG_LEVEL <>
2148: (
2149: select

Line 2152: PA_PROJ_LEVELS_TMP tmp

2148: (
2149: select
2150: tmp.TO_LEVEL
2151: from
2152: PA_PROJ_LEVELS_TMP tmp
2153: where
2154: tmp.TO_ID = ver.PROJECT_ID and
2155: tmp.TO_LEVEL <> -1 and
2156: ROWNUM = 1

Line 2315: insert into PA_PROJ_LEVELS_TMP

2311: end if;
2312:
2313: -- represent program group hierarchy in the form of a directed graph
2314:
2315: insert into PA_PROJ_LEVELS_TMP
2316: (
2317: FROM_ID,
2318: TO_ID,
2319: FROM_LEVEL,

Line 2416: PA_PROJ_LEVELS_TMP tmp

2412: tmp.ATTRIBUTE2
2413: into
2414: l_count
2415: from
2416: PA_PROJ_LEVELS_TMP tmp
2417: where
2418: tmp.ATTRIBUTE1 = 'DROPPED_ASSOCIATION_DOWN';
2419:
2420: if (l_count = 1) then

Line 2425: PA_PROJ_LEVELS_TMP tmp2

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

Line 2437: PA_PROJ_LEVELS_TMP tmp1

2433: (
2434: select
2435: 1
2436: from
2437: PA_PROJ_LEVELS_TMP tmp1
2438: where
2439: tmp1.ATTRIBUTE1 = 'DROPPED_ASSOCIATION_DOWN' and
2440: (tmp2.FROM_ID = tmp1.TO_ID or
2441: tmp2.TO_ID = tmp1.TO_ID)

Line 2447: PA_PROJ_LEVELS_TMP tmp2

2443:
2444: while (sql%rowcount > 0) loop
2445:
2446: update
2447: PA_PROJ_LEVELS_TMP tmp2
2448: set
2449: tmp2.ATTRIBUTE3 = 'CHILD_SUBGROUP'
2450: where
2451: tmp2.ATTRIBUTE1 not in ('DROPPED_ASSOCIATION_DOWN',

Line 2459: PA_PROJ_LEVELS_TMP tmp1

2455: (
2456: select
2457: 1
2458: from
2459: PA_PROJ_LEVELS_TMP tmp1
2460: where
2461: tmp1.ATTRIBUTE3 = 'CHILD_SUBGROUP' and
2462: (tmp2.FROM_ID = tmp1.TO_ID or
2463: tmp2.TO_ID = tmp1.TO_ID)

Line 2473: PA_PROJ_LEVELS_TMP tmp

2469: count(*)
2470: into
2471: l_count
2472: from
2473: PA_PROJ_LEVELS_TMP tmp
2474: where
2475: tmp.TO_ID = l_parent_project and
2476: tmp.ATTRIBUTE3 = 'CHILD_SUBGROUP' and
2477: ROWNUM = 1;

Line 2489: PA_PROJ_LEVELS_TMP tmp4

2485:
2486: -- adjust hierarchy levels
2487:
2488: update
2489: PA_PROJ_LEVELS_TMP tmp4
2490: set
2491: tmp4.FROM_LEVEL = 1
2492: where
2493: tmp4.FROM_LEVEL <> 1 and

Line 2510: PA_PROJ_LEVELS_TMP tmp1

2506: distinct
2507: tmp1.TO_ID PROJECT_ID,
2508: LEVEL PROJECT_LEVEL
2509: from
2510: PA_PROJ_LEVELS_TMP tmp1
2511: start with
2512: tmp1.DIRECTION = 'U' and
2513: tmp1.ATTRIBUTE1 <> 'DROPPED_ASSOCIATION_UP'
2514: connect by

Line 2530: PA_PROJ_LEVELS_TMP

2526:
2527: l_count := sql%rowcount;
2528:
2529: update
2530: PA_PROJ_LEVELS_TMP
2531: set
2532: TO_LEVEL = 1
2533: where
2534: TO_LEVEL <> 1 and

Line 2540: PA_PROJ_LEVELS_TMP tmp1

2536: (
2537: select
2538: tmp1.FROM_ID
2539: from
2540: PA_PROJ_LEVELS_TMP tmp1
2541: where
2542: tmp1.FROM_LEVEL = 1
2543: );
2544:

Line 2550: PA_PROJ_LEVELS_TMP tmp

2546:
2547: l_count := 0;
2548:
2549: update
2550: PA_PROJ_LEVELS_TMP tmp
2551: set
2552: tmp.TO_LEVEL = tmp.FROM_LEVEL + 1
2553: where
2554: tmp.FROM_LEVEL <> -1 and

Line 2563: PA_PROJ_LEVELS_TMP tmp

2559:
2560: l_count := l_count + sql%rowcount;
2561:
2562: update
2563: PA_PROJ_LEVELS_TMP tmp
2564: set
2565: tmp.TO_LEVEL = decode(tmp.DIRECTION,
2566: 'U', tmp.FROM_LEVEL - 1,
2567: 'D', tmp.FROM_LEVEL + 1)

Line 2577: PA_PROJ_LEVELS_TMP tmp2

2573:
2574: l_count := l_count + sql%rowcount;
2575:
2576: update
2577: PA_PROJ_LEVELS_TMP tmp2
2578: set
2579: tmp2.TO_LEVEL =
2580: (
2581: select

Line 2584: PA_PROJ_LEVELS_TMP tmp1

2580: (
2581: select
2582: max(tmp1.TO_LEVEL)
2583: from
2584: PA_PROJ_LEVELS_TMP tmp1
2585: where
2586: tmp1.TO_ID = tmp2.TO_ID
2587: )
2588: where

Line 2596: PA_PROJ_LEVELS_TMP tmp1

2592: (
2593: select
2594: max(tmp1.TO_LEVEL)
2595: from
2596: PA_PROJ_LEVELS_TMP tmp1
2597: where
2598: tmp1.TO_ID = tmp2.TO_ID
2599: );
2600:

Line 2602: PA_PROJ_LEVELS_TMP tmp2

2598: tmp1.TO_ID = tmp2.TO_ID
2599: );
2600:
2601: update
2602: PA_PROJ_LEVELS_TMP tmp2
2603: set
2604: tmp2.FROM_LEVEL =
2605: (
2606: select

Line 2609: PA_PROJ_LEVELS_TMP tmp1

2605: (
2606: select
2607: tmp1.TO_LEVEL
2608: from
2609: PA_PROJ_LEVELS_TMP tmp1
2610: where
2611: tmp1.TO_ID = tmp2.FROM_ID and
2612: tmp1.TO_LEVEL <> -1 and
2613: ROWNUM = 1

Line 2623: PA_PROJ_LEVELS_TMP tmp1

2619: (
2620: select
2621: tmp1.TO_LEVEL
2622: from
2623: PA_PROJ_LEVELS_TMP tmp1
2624: where
2625: tmp1.TO_ID = tmp2.FROM_ID and
2626: tmp1.TO_LEVEL <> -1 and
2627: ROWNUM = 1

Line 2640: PA_PROJ_LEVELS_TMP tmp

2636: (
2637: select
2638: tmp.TO_LEVEL
2639: from
2640: PA_PROJ_LEVELS_TMP tmp
2641: where
2642: tmp.TO_ID = ver.PROJECT_ID and
2643: tmp.TO_LEVEL <> -1 and
2644: ROWNUM = 1

Line 2655: PA_PROJ_LEVELS_TMP tmp

2651: select
2652: distinct
2653: tmp.TO_ID
2654: from
2655: PA_PROJ_LEVELS_TMP tmp
2656: ) and
2657: ver.PRG_LEVEL <>
2658: (
2659: select

Line 2662: PA_PROJ_LEVELS_TMP tmp

2658: (
2659: select
2660: tmp.TO_LEVEL
2661: from
2662: PA_PROJ_LEVELS_TMP tmp
2663: where
2664: tmp.TO_ID = ver.PROJECT_ID and
2665: tmp.TO_LEVEL <> -1 and
2666: ROWNUM = 1

Line 2691: PA_PROJ_LEVELS_TMP tmp

2687: (
2688: select
2689: tmp.TO_ID
2690: from
2691: PA_PROJ_LEVELS_TMP tmp
2692: where
2693: ATTRIBUTE1 = 'DROPPED_ASSOCIATION_DOWN' or
2694: ATTRIBUTE3 = 'CHILD_SUBGROUP'
2695: );

Line 2730: delete from PA_PROJ_LEVELS_TMP;

2726: end if;
2727:
2728: end if;
2729:
2730: delete from PA_PROJ_LEVELS_TMP;
2731:
2732: l_last_update_date := sysdate;
2733: l_last_updated_by := FND_GLOBAL.USER_ID;
2734: l_creation_date := sysdate;