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_ELEMENT_VERSIONS

Line 599: FROM pa_proj_element_versions

595:
596: CURSOR get_src_str_ver_id
597: IS
598: SELECT parent_structure_version_id
599: FROM pa_proj_element_versions
600: WHERE project_id = p_src_proj_id
601: AND element_version_id = p_src_task_ver_id
602: AND object_type = 'PA_TASKS';
603:

Line 1600: index(ver1, PA_PROJ_ELEMENT_VERSIONS_N3)

1596: l_relationship_type
1597: from
1598: (
1599: select /*+ index(rel, PA_OBJECT_RELATIONSHIPS_U1)
1600: index(ver1, PA_PROJ_ELEMENT_VERSIONS_N3)
1601: index(ver2, PA_PROJ_ELEMENT_VERSIONS_N3) */
1602: rel.OBJECT_ID_FROM1 PARENT_TASK_VERSION_ID,
1603: ver1.PRG_GROUP PARENT_GROUP,
1604: ver1.PRG_LEVEL PARENT_LEVEL,

Line 1601: index(ver2, PA_PROJ_ELEMENT_VERSIONS_N3) */

1597: from
1598: (
1599: select /*+ index(rel, PA_OBJECT_RELATIONSHIPS_U1)
1600: index(ver1, PA_PROJ_ELEMENT_VERSIONS_N3)
1601: index(ver2, PA_PROJ_ELEMENT_VERSIONS_N3) */
1602: rel.OBJECT_ID_FROM1 PARENT_TASK_VERSION_ID,
1603: ver1.PRG_GROUP PARENT_GROUP,
1604: ver1.PRG_LEVEL PARENT_LEVEL,
1605: rel.OBJECT_ID_FROM2 PARENT_PROJECT,

Line 1613: PA_PROJ_ELEMENT_VERSIONS ver1,

1609: rel.OBJECT_ID_TO2 CHILD_PROJECT,
1610: rel.RELATIONSHIP_TYPE RELATIONSHIP_TYPE
1611: from
1612: PA_OBJECT_RELATIONSHIPS rel,
1613: PA_PROJ_ELEMENT_VERSIONS ver1,
1614: PA_PROJ_ELEMENT_VERSIONS ver2
1615: where
1616: rel.OBJECT_RELATIONSHIP_ID = p_object_relationship_id and
1617: ver1.PROJECT_ID = rel.OBJECT_ID_FROM2 and

Line 1614: PA_PROJ_ELEMENT_VERSIONS ver2

1610: rel.RELATIONSHIP_TYPE RELATIONSHIP_TYPE
1611: from
1612: PA_OBJECT_RELATIONSHIPS rel,
1613: PA_PROJ_ELEMENT_VERSIONS ver1,
1614: PA_PROJ_ELEMENT_VERSIONS ver2
1615: where
1616: rel.OBJECT_RELATIONSHIP_ID = p_object_relationship_id and
1617: ver1.PROJECT_ID = rel.OBJECT_ID_FROM2 and
1618: ver1.OBJECT_TYPE = 'PA_STRUCTURES' and

Line 1728: update PA_PROJ_ELEMENT_VERSIONS

1724: l_new_assoc_child := null;
1725:
1726: if (l_parent_group is not null) then
1727:
1728: update PA_PROJ_ELEMENT_VERSIONS
1729: set PRG_GROUP = l_parent_group,
1730: PRG_LEVEL = l_parent_level
1731: where OBJECT_TYPE = 'PA_STRUCTURES' and
1732: PROJECT_ID = l_parent_project and

Line 1739: update PA_PROJ_ELEMENT_VERSIONS

1735: end if;
1736:
1737: if (l_child_group is not null) then
1738:
1739: update PA_PROJ_ELEMENT_VERSIONS
1740: set PRG_GROUP = l_child_group,
1741: PRG_LEVEL = l_child_level
1742: where OBJECT_TYPE = 'PA_STRUCTURES' and
1743: PROJECT_ID = l_child_project and

Line 1760: update PA_PROJ_ELEMENT_VERSIONS

1756: if (p_operation_type = 'ADD') then
1757:
1758: if (l_parent_group = l_child_group) then
1759:
1760: update PA_PROJ_ELEMENT_VERSIONS
1761: set PRG_GROUP = l_parent_group,
1762: PRG_LEVEL = l_parent_level,
1763: PRG_COUNT = nvl(PRG_COUNT, 0) + 1
1764: where ELEMENT_VERSION_ID in (p_parent_task_version_id,

Line 1774: from PA_PROJ_ELEMENT_VERSIONS

1770: -- check if LF or LW link already exists
1771:
1772: select PARENT_STRUCTURE_VERSION_ID
1773: into l_parent_structure_version_id
1774: from PA_PROJ_ELEMENT_VERSIONS
1775: where ELEMENT_VERSION_ID = p_parent_task_version_id;
1776:
1777: select count(*)
1778: into l_count

Line 1788: PA_PROJ_ELEMENT_VERSIONS ver

1784: OBJECT_ID_TO2 = l_child_project and
1785: OBJECT_ID_FROM1 in (select
1786: ver.ELEMENT_VERSION_ID
1787: from
1788: PA_PROJ_ELEMENT_VERSIONS ver
1789: where
1790: ver.PARENT_STRUCTURE_VERSION_ID
1791: = l_parent_structure_version_id) and
1792: OBJECT_ID_TO1 = p_child_structure_version_id and

Line 1839: index(ver, PA_PROJ_ELEMENT_VERSIONS_N5)

1835: ATTRIBUTE5,
1836: ATTRIBUTE6
1837: )
1838: select /*+ ordered
1839: index(ver, PA_PROJ_ELEMENT_VERSIONS_N5)
1840: index(rel, PA_OBJECT_RELATIONSHIPS_U2) use_nl(rel) */
1841: distinct
1842: decode(invert.INVERT_ID, 'DOWN', rel.OBJECT_ID_FROM2,
1843: 'UP', rel.OBJECT_ID_TO2) FROM_ID,

Line 1874: PA_PROJ_ELEMENT_VERSIONS ver,

1870: null ATTRIBUTE4,
1871: null ATTRIBUTE5,
1872: null ATTRIBUTE6
1873: from
1874: PA_PROJ_ELEMENT_VERSIONS ver,
1875: PA_OBJECT_RELATIONSHIPS rel,
1876: pa_proj_structure_types ppst,
1877: pa_proj_elem_ver_structure ppevs,
1878: pa_projects_all ppa,

Line 2127: PA_PROJ_ELEMENT_VERSIONS ver

2123:
2124: end loop;
2125:
2126: update
2127: PA_PROJ_ELEMENT_VERSIONS ver
2128: set
2129: ver.PRG_LEVEL =
2130: (
2131: select

Line 2181: update PA_PROJ_ELEMENT_VERSIONS

2177: if (l_parent_level < l_child_level) then
2178:
2179: l_level_adjustment := l_child_level - l_parent_level - 1;
2180:
2181: update PA_PROJ_ELEMENT_VERSIONS
2182: set PRG_GROUP = l_child_group,
2183: PRG_LEVEL = l_child_level - 1,
2184: PRG_COUNT = nvl(PRG_COUNT, 0) + 1
2185: where ELEMENT_VERSION_ID in (p_parent_task_version_id,

Line 2193: update PA_PROJ_ELEMENT_VERSIONS

2189: if (l_parent_group is null) then
2190:
2191: l_parent_group := l_child_group;
2192:
2193: update PA_PROJ_ELEMENT_VERSIONS
2194: set PRG_GROUP = l_child_group,
2195: PRG_LEVEL = l_parent_level + l_level_adjustment
2196: where PROJECT_ID = l_parent_project and
2197: OBJECT_TYPE = 'PA_STRUCTURES';

Line 2201: update PA_PROJ_ELEMENT_VERSIONS

2197: OBJECT_TYPE = 'PA_STRUCTURES';
2198:
2199: else
2200:
2201: update PA_PROJ_ELEMENT_VERSIONS
2202: set PRG_GROUP = l_child_group,
2203: PRG_LEVEL = PRG_LEVEL + l_level_adjustment
2204: where OBJECT_TYPE in ('PA_STRUCTURES', 'PA_TASKS') and
2205: PRG_GROUP = l_parent_group;

Line 2215: select PA_PROJ_ELEMENT_VERSIONS_S1.NEXTVAL

2211: l_level_adjustment := l_parent_level - l_child_level + 1;
2212:
2213: if (l_parent_group is null and l_child_group is null) then
2214:
2215: select PA_PROJ_ELEMENT_VERSIONS_S1.NEXTVAL
2216: into l_parent_group
2217: from DUAL;
2218:
2219: update PA_PROJ_ELEMENT_VERSIONS

Line 2219: update PA_PROJ_ELEMENT_VERSIONS

2215: select PA_PROJ_ELEMENT_VERSIONS_S1.NEXTVAL
2216: into l_parent_group
2217: from DUAL;
2218:
2219: update PA_PROJ_ELEMENT_VERSIONS
2220: set PRG_GROUP = l_parent_group,
2221: PRG_LEVEL = l_parent_level,
2222: PRG_COUNT = nvl(PRG_COUNT, 0) + 1
2223: where ELEMENT_VERSION_ID in (p_parent_task_version_id,

Line 2229: update PA_PROJ_ELEMENT_VERSIONS

2225: OBJECT_TYPE = 'PA_TASKS';
2226:
2227: l_child_group := l_parent_group;
2228:
2229: update PA_PROJ_ELEMENT_VERSIONS
2230: set PRG_GROUP = l_parent_group,
2231: PRG_LEVEL = decode(PROJECT_ID, l_parent_project,
2232: l_parent_level,
2233: l_child_level +

Line 2241: update PA_PROJ_ELEMENT_VERSIONS

2237: OBJECT_TYPE = 'PA_STRUCTURES';
2238:
2239: elsif (l_child_group is null) then
2240:
2241: update PA_PROJ_ELEMENT_VERSIONS
2242: set PRG_GROUP = l_parent_group,
2243: PRG_LEVEL = l_parent_level,
2244: PRG_COUNT = nvl(PRG_COUNT, 0) + 1
2245: where ELEMENT_VERSION_ID in (p_parent_task_version_id,

Line 2251: update PA_PROJ_ELEMENT_VERSIONS

2247: OBJECT_TYPE = 'PA_TASKS';
2248:
2249: l_child_group := l_parent_group;
2250:
2251: update PA_PROJ_ELEMENT_VERSIONS
2252: set PRG_GROUP = l_parent_group,
2253: PRG_LEVEL = l_child_level + l_level_adjustment
2254: where PROJECT_ID = l_child_project and
2255: OBJECT_TYPE = 'PA_STRUCTURES';

Line 2259: update PA_PROJ_ELEMENT_VERSIONS

2255: OBJECT_TYPE = 'PA_STRUCTURES';
2256:
2257: elsif (l_parent_group is null) then
2258:
2259: update PA_PROJ_ELEMENT_VERSIONS
2260: set PRG_GROUP = l_child_group,
2261: PRG_LEVEL = PRG_LEVEL + l_level_adjustment
2262: where PRG_GROUP = l_child_group and
2263: OBJECT_TYPE in ('PA_STRUCTURES', 'PA_TASKS');

Line 2265: update PA_PROJ_ELEMENT_VERSIONS

2261: PRG_LEVEL = PRG_LEVEL + l_level_adjustment
2262: where PRG_GROUP = l_child_group and
2263: OBJECT_TYPE in ('PA_STRUCTURES', 'PA_TASKS');
2264:
2265: update PA_PROJ_ELEMENT_VERSIONS
2266: set PRG_GROUP = l_child_group,
2267: PRG_LEVEL = l_child_level + l_level_adjustment - 1,
2268: PRG_COUNT = nvl(PRG_COUNT, 0) + 1
2269: where ELEMENT_VERSION_ID in (p_parent_task_version_id,

Line 2275: update PA_PROJ_ELEMENT_VERSIONS

2271: OBJECT_TYPE = 'PA_TASKS';
2272:
2273: l_parent_group := l_child_group;
2274:
2275: update PA_PROJ_ELEMENT_VERSIONS
2276: set PRG_GROUP = l_child_group,
2277: PRG_LEVEL = l_child_level + l_level_adjustment - 1
2278: where PROJECT_ID = l_parent_project and
2279: OBJECT_TYPE = 'PA_STRUCTURES';

Line 2283: update PA_PROJ_ELEMENT_VERSIONS

2279: OBJECT_TYPE = 'PA_STRUCTURES';
2280:
2281: else
2282:
2283: update PA_PROJ_ELEMENT_VERSIONS
2284: set PRG_GROUP = l_parent_group,
2285: PRG_LEVEL = l_parent_level,
2286: PRG_COUNT = nvl(PRG_COUNT, 0) + 1
2287: where ELEMENT_VERSION_ID in (p_parent_task_version_id,

Line 2291: update PA_PROJ_ELEMENT_VERSIONS

2287: where ELEMENT_VERSION_ID in (p_parent_task_version_id,
2288: l_actual_task_version_id) and
2289: OBJECT_TYPE = 'PA_TASKS';
2290:
2291: update PA_PROJ_ELEMENT_VERSIONS
2292: set PRG_GROUP = l_parent_group,
2293: PRG_LEVEL = PRG_LEVEL + l_level_adjustment
2294: where OBJECT_TYPE in ('PA_STRUCTURES', 'PA_TASKS') and
2295: PRG_GROUP = l_child_group;

Line 2334: index(ver, PA_PROJ_ELEMENT_VERSIONS_N5)

2330: ATTRIBUTE5,
2331: ATTRIBUTE6
2332: )
2333: select /*+ ordered
2334: index(ver, PA_PROJ_ELEMENT_VERSIONS_N5)
2335: index(rel, PA_OBJECT_RELATIONSHIPS_U2) use_nl(rel) */
2336: decode(invert.INVERT_ID, 'DOWN', rel.OBJECT_ID_FROM2,
2337: 'UP', rel.OBJECT_ID_TO2) FROM_ID,
2338: decode(invert.INVERT_ID, 'DOWN', rel.OBJECT_ID_TO2,

Line 2368: PA_PROJ_ELEMENT_VERSIONS ver,

2364: null ATTRIBUTE4,
2365: null ATTRIBUTE5,
2366: null ATTRIBUTE6
2367: from
2368: PA_PROJ_ELEMENT_VERSIONS ver,
2369: PA_OBJECT_RELATIONSHIPS rel,
2370: (
2371: select 'DOWN' INVERT_ID from dual union all
2372: select 'UP' INVERT_ID from dual

Line 2407: update PA_PROJ_ELEMENT_VERSIONS

2403: 'X'),
2404: 'X'),
2405: 'X');
2406:
2407: update PA_PROJ_ELEMENT_VERSIONS
2408: set PRG_GROUP = decode(PRG_COUNT, 1, null, PRG_GROUP),
2409: PRG_LEVEL = decode(PRG_COUNT, 1, null, PRG_LEVEL),
2410: PRG_COUNT = decode(PRG_COUNT, 1, null, PRG_COUNT - 1)
2411: where ELEMENT_VERSION_ID in (p_parent_task_version_id,

Line 2691: PA_PROJ_ELEMENT_VERSIONS ver

2687:
2688: end loop;
2689:
2690: update
2691: PA_PROJ_ELEMENT_VERSIONS ver
2692: set
2693: ver.PRG_LEVEL =
2694: (
2695: select

Line 2734: select PA_PROJ_ELEMENT_VERSIONS_S1.NEXTVAL

2730:
2731: -- This is the last association between the two projects and the
2732: -- group will be divided into two sub-groups.
2733:
2734: select PA_PROJ_ELEMENT_VERSIONS_S1.NEXTVAL
2735: into l_child_group
2736: from DUAL;
2737:
2738: -- stamp the newly created program group

Line 2754: update PA_PROJ_ELEMENT_VERSIONS ver

2750:
2751: -- Bug 6778370
2752: If nvl(l_subgrp_exist,'N') = 'Y' then
2753:
2754: update PA_PROJ_ELEMENT_VERSIONS ver
2755: set ver.PRG_GROUP = l_child_group
2756: where ver.OBJECT_TYPE in ('PA_STRUCTURES', 'PA_TASKS') and
2757: ver.PRG_GROUP = l_parent_group and
2758: ver.PROJECT_ID in

Line 2779: from PA_PROJ_ELEMENT_VERSIONS

2775: from (select PRG_GROUP,
2776: PRG_LEVEL - 1 PRG_LEVEL
2777: from (select PRG_GROUP,
2778: min(PRG_LEVEL) PRG_LEVEL
2779: from PA_PROJ_ELEMENT_VERSIONS
2780: where OBJECT_TYPE = 'PA_STRUCTURES' and
2781: PRG_GROUP in (l_parent_group,
2782: l_child_group)
2783: group by PRG_GROUP)

Line 2789: update PA_PROJ_ELEMENT_VERSIONS

2785: where ROWNUM = 1;
2786:
2787: if (l_level_adjustment > 0) then
2788:
2789: update PA_PROJ_ELEMENT_VERSIONS
2790: set PRG_LEVEL = PRG_LEVEL - l_level_adjustment
2791: where OBJECT_TYPE in ('PA_STRUCTURES', 'PA_TASKS') and
2792: PRG_GROUP = l_program_group;
2793: