APPS.PA_RELATIONSHIP_PUB dependencies on PA_OBJECT_RELATIONSHIPS

Line 1548: -- PA_OBJECT_RELATIONSHIPS

1544: -- function UPDATE_PROGRAM_GROUPS
1545: --
1546: -- p_operation_type = 'ADD' ==> This API must be called after the
1547: -- association row has been added in
1548: -- PA_OBJECT_RELATIONSHIPS
1549: --
1550: -- p_operation_type = 'DROP' ==> This API must be called before the
1551: -- association row has been removed
1552: -- from PA_OBJECT_RELATIONSHIPS

Line 1552: -- from PA_OBJECT_RELATIONSHIPS

1548: -- PA_OBJECT_RELATIONSHIPS
1549: --
1550: -- p_operation_type = 'DROP' ==> This API must be called before the
1551: -- association row has been removed
1552: -- from PA_OBJECT_RELATIONSHIPS
1553: --
1554: -- After this API looks up the association information it calls the
1555: -- other API UPDATE_PROGRAM_GROUPS with the relevant parameters.
1556: --

Line 1599: select /*+ index(rel, PA_OBJECT_RELATIONSHIPS_U1)

1595: l_child_project,
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,

Line 1612: PA_OBJECT_RELATIONSHIPS rel,

1608: ver2.PRG_LEVEL CHILD_LEVEL,
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

Line 1746: from PA_OBJECT_RELATIONSHIPS

1742: end if;
1743:
1744: select OBJECT_ID_FROM1
1745: into l_actual_task_version_id
1746: from PA_OBJECT_RELATIONSHIPS
1747: where OBJECT_TYPE_FROM = 'PA_TASKS' and
1748: OBJECT_TYPE_TO = 'PA_TASKS' and
1749: RELATIONSHIP_TYPE = 'S' and
1750: OBJECT_ID_TO1 = p_parent_task_version_id;

Line 1775: from PA_OBJECT_RELATIONSHIPS

1771: where ELEMENT_VERSION_ID = p_parent_task_version_id;
1772:
1773: select count(*)
1774: into l_count
1775: from PA_OBJECT_RELATIONSHIPS
1776: where RELATIONSHIP_TYPE = p_relationship_type and
1777: OBJECT_TYPE_FROM = 'PA_TASKS' and
1778: OBJECT_TYPE_TO = 'PA_STRUCTURES' and
1779: OBJECT_ID_FROM2 = l_parent_project and

Line 1800: from PA_OBJECT_RELATIONSHIPS

1796: end if;
1797:
1798: select count(*)
1799: into l_count
1800: from PA_OBJECT_RELATIONSHIPS
1801: where RELATIONSHIP_TYPE in ('LF', 'LW') and
1802: OBJECT_TYPE_FROM = 'PA_TASKS' and
1803: OBJECT_TYPE_TO = 'PA_STRUCTURES' and
1804: OBJECT_ID_FROM2 = l_parent_project and

Line 1836: index(rel, PA_OBJECT_RELATIONSHIPS_U2) use_nl(rel) */

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,
1840: decode(invert.INVERT_ID, 'DOWN', rel.OBJECT_ID_TO2,

Line 1871: PA_OBJECT_RELATIONSHIPS rel,

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,
1875: (

Line 2331: index(rel, PA_OBJECT_RELATIONSHIPS_U2) use_nl(rel) */

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,
2335: 'UP', rel.OBJECT_ID_FROM2) TO_ID,

Line 2365: PA_OBJECT_RELATIONSHIPS rel,

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
2369: ) invert