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_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 1724: update PA_PROJ_ELEMENT_VERSIONS

1720: l_new_assoc_child := null;
1721:
1722: if (l_parent_group is not null) then
1723:
1724: update PA_PROJ_ELEMENT_VERSIONS
1725: set PRG_GROUP = l_parent_group,
1726: PRG_LEVEL = l_parent_level
1727: where OBJECT_TYPE = 'PA_STRUCTURES' and
1728: PROJECT_ID = l_parent_project and

Line 1735: update PA_PROJ_ELEMENT_VERSIONS

1731: end if;
1732:
1733: if (l_child_group is not null) then
1734:
1735: update PA_PROJ_ELEMENT_VERSIONS
1736: set PRG_GROUP = l_child_group,
1737: PRG_LEVEL = l_child_level
1738: where OBJECT_TYPE = 'PA_STRUCTURES' and
1739: PROJECT_ID = l_child_project and

Line 1756: update PA_PROJ_ELEMENT_VERSIONS

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

Line 1770: from PA_PROJ_ELEMENT_VERSIONS

1766: -- check if LF or LW link already exists
1767:
1768: select PARENT_STRUCTURE_VERSION_ID
1769: into l_parent_structure_version_id
1770: from PA_PROJ_ELEMENT_VERSIONS
1771: where ELEMENT_VERSION_ID = p_parent_task_version_id;
1772:
1773: select count(*)
1774: into l_count

Line 1784: PA_PROJ_ELEMENT_VERSIONS ver

1780: OBJECT_ID_TO2 = l_child_project and
1781: OBJECT_ID_FROM1 in (select
1782: ver.ELEMENT_VERSION_ID
1783: from
1784: PA_PROJ_ELEMENT_VERSIONS ver
1785: where
1786: ver.PARENT_STRUCTURE_VERSION_ID
1787: = l_parent_structure_version_id) and
1788: OBJECT_ID_TO1 = p_child_structure_version_id and

Line 1835: index(ver, PA_PROJ_ELEMENT_VERSIONS_N5)

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

Line 1870: PA_PROJ_ELEMENT_VERSIONS ver,

1866: null ATTRIBUTE4,
1867: null ATTRIBUTE5,
1868: null ATTRIBUTE6
1869: from
1870: PA_PROJ_ELEMENT_VERSIONS ver,
1871: PA_OBJECT_RELATIONSHIPS rel,
1872: pa_proj_structure_types ppst,
1873: pa_proj_elem_ver_structure ppevs,
1874: pa_projects_all ppa,

Line 2123: PA_PROJ_ELEMENT_VERSIONS ver

2119:
2120: end loop;
2121:
2122: update
2123: PA_PROJ_ELEMENT_VERSIONS ver
2124: set
2125: ver.PRG_LEVEL =
2126: (
2127: select

Line 2177: update PA_PROJ_ELEMENT_VERSIONS

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

Line 2189: update PA_PROJ_ELEMENT_VERSIONS

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

Line 2197: update PA_PROJ_ELEMENT_VERSIONS

2193: OBJECT_TYPE = 'PA_STRUCTURES';
2194:
2195: else
2196:
2197: update PA_PROJ_ELEMENT_VERSIONS
2198: set PRG_GROUP = l_child_group,
2199: PRG_LEVEL = PRG_LEVEL + l_level_adjustment
2200: where OBJECT_TYPE in ('PA_STRUCTURES', 'PA_TASKS') and
2201: PRG_GROUP = l_parent_group;

Line 2211: select PA_PROJ_ELEMENT_VERSIONS_S1.NEXTVAL

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

Line 2215: update PA_PROJ_ELEMENT_VERSIONS

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

Line 2225: update PA_PROJ_ELEMENT_VERSIONS

2221: OBJECT_TYPE = 'PA_TASKS';
2222:
2223: l_child_group := l_parent_group;
2224:
2225: update PA_PROJ_ELEMENT_VERSIONS
2226: set PRG_GROUP = l_parent_group,
2227: PRG_LEVEL = decode(PROJECT_ID, l_parent_project,
2228: l_parent_level,
2229: l_child_level +

Line 2237: update PA_PROJ_ELEMENT_VERSIONS

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

Line 2247: update PA_PROJ_ELEMENT_VERSIONS

2243: OBJECT_TYPE = 'PA_TASKS';
2244:
2245: l_child_group := l_parent_group;
2246:
2247: update PA_PROJ_ELEMENT_VERSIONS
2248: set PRG_GROUP = l_parent_group,
2249: PRG_LEVEL = l_child_level + l_level_adjustment
2250: where PROJECT_ID = l_child_project and
2251: OBJECT_TYPE = 'PA_STRUCTURES';

Line 2255: update PA_PROJ_ELEMENT_VERSIONS

2251: OBJECT_TYPE = 'PA_STRUCTURES';
2252:
2253: elsif (l_parent_group is null) then
2254:
2255: update PA_PROJ_ELEMENT_VERSIONS
2256: set PRG_GROUP = l_child_group,
2257: PRG_LEVEL = PRG_LEVEL + l_level_adjustment
2258: where PRG_GROUP = l_child_group and
2259: OBJECT_TYPE in ('PA_STRUCTURES', 'PA_TASKS');

Line 2261: update PA_PROJ_ELEMENT_VERSIONS

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

Line 2271: update PA_PROJ_ELEMENT_VERSIONS

2267: OBJECT_TYPE = 'PA_TASKS';
2268:
2269: l_parent_group := l_child_group;
2270:
2271: update PA_PROJ_ELEMENT_VERSIONS
2272: set PRG_GROUP = l_child_group,
2273: PRG_LEVEL = l_child_level + l_level_adjustment - 1
2274: where PROJECT_ID = l_parent_project and
2275: OBJECT_TYPE = 'PA_STRUCTURES';

Line 2279: update PA_PROJ_ELEMENT_VERSIONS

2275: OBJECT_TYPE = 'PA_STRUCTURES';
2276:
2277: else
2278:
2279: update PA_PROJ_ELEMENT_VERSIONS
2280: set PRG_GROUP = l_parent_group,
2281: PRG_LEVEL = l_parent_level,
2282: PRG_COUNT = nvl(PRG_COUNT, 0) + 1
2283: where ELEMENT_VERSION_ID in (p_parent_task_version_id,

Line 2287: update PA_PROJ_ELEMENT_VERSIONS

2283: where ELEMENT_VERSION_ID in (p_parent_task_version_id,
2284: l_actual_task_version_id) and
2285: OBJECT_TYPE = 'PA_TASKS';
2286:
2287: update PA_PROJ_ELEMENT_VERSIONS
2288: set PRG_GROUP = l_parent_group,
2289: PRG_LEVEL = PRG_LEVEL + l_level_adjustment
2290: where OBJECT_TYPE in ('PA_STRUCTURES', 'PA_TASKS') and
2291: PRG_GROUP = l_child_group;

Line 2330: index(ver, PA_PROJ_ELEMENT_VERSIONS_N5)

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

Line 2364: PA_PROJ_ELEMENT_VERSIONS ver,

2360: null ATTRIBUTE4,
2361: null ATTRIBUTE5,
2362: null ATTRIBUTE6
2363: from
2364: PA_PROJ_ELEMENT_VERSIONS ver,
2365: PA_OBJECT_RELATIONSHIPS rel,
2366: (
2367: select 'DOWN' INVERT_ID from dual union all
2368: select 'UP' INVERT_ID from dual

Line 2403: update PA_PROJ_ELEMENT_VERSIONS

2399: 'X'),
2400: 'X'),
2401: 'X');
2402:
2403: update PA_PROJ_ELEMENT_VERSIONS
2404: set PRG_GROUP = decode(PRG_COUNT, 1, null, PRG_GROUP),
2405: PRG_LEVEL = decode(PRG_COUNT, 1, null, PRG_LEVEL),
2406: PRG_COUNT = decode(PRG_COUNT, 1, null, PRG_COUNT - 1)
2407: where ELEMENT_VERSION_ID in (p_parent_task_version_id,

Line 2633: PA_PROJ_ELEMENT_VERSIONS ver

2629:
2630: end loop;
2631:
2632: update
2633: PA_PROJ_ELEMENT_VERSIONS ver
2634: set
2635: ver.PRG_LEVEL =
2636: (
2637: select

Line 2676: select PA_PROJ_ELEMENT_VERSIONS_S1.NEXTVAL

2672:
2673: -- This is the last association between the two projects and the
2674: -- group will be divided into two sub-groups.
2675:
2676: select PA_PROJ_ELEMENT_VERSIONS_S1.NEXTVAL
2677: into l_child_group
2678: from DUAL;
2679:
2680: -- stamp the newly created program group

Line 2682: update PA_PROJ_ELEMENT_VERSIONS ver

2678: from DUAL;
2679:
2680: -- stamp the newly created program group
2681:
2682: update PA_PROJ_ELEMENT_VERSIONS ver
2683: set ver.PRG_GROUP = l_child_group
2684: where ver.OBJECT_TYPE in ('PA_STRUCTURES', 'PA_TASKS') and
2685: ver.PRG_GROUP = l_parent_group and
2686: ver.PROJECT_ID in

Line 2707: from PA_PROJ_ELEMENT_VERSIONS

2703: from (select PRG_GROUP,
2704: PRG_LEVEL - 1 PRG_LEVEL
2705: from (select PRG_GROUP,
2706: min(PRG_LEVEL) PRG_LEVEL
2707: from PA_PROJ_ELEMENT_VERSIONS
2708: where OBJECT_TYPE = 'PA_STRUCTURES' and
2709: PRG_GROUP in (l_parent_group,
2710: l_child_group)
2711: group by PRG_GROUP)

Line 2717: update PA_PROJ_ELEMENT_VERSIONS

2713: where ROWNUM = 1;
2714:
2715: if (l_level_adjustment > 0) then
2716:
2717: update PA_PROJ_ELEMENT_VERSIONS
2718: set PRG_LEVEL = PRG_LEVEL - l_level_adjustment
2719: where OBJECT_TYPE in ('PA_STRUCTURES', 'PA_TASKS') and
2720: PRG_GROUP = l_program_group;
2721: