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 1750: from PA_OBJECT_RELATIONSHIPS

1746: end if;
1747:
1748: select OBJECT_ID_FROM1
1749: into l_actual_task_version_id
1750: from PA_OBJECT_RELATIONSHIPS
1751: where OBJECT_TYPE_FROM = 'PA_TASKS' and
1752: OBJECT_TYPE_TO = 'PA_TASKS' and
1753: RELATIONSHIP_TYPE = 'S' and
1754: OBJECT_ID_TO1 = p_parent_task_version_id;

Line 1779: from PA_OBJECT_RELATIONSHIPS

1775: where ELEMENT_VERSION_ID = p_parent_task_version_id;
1776:
1777: select count(*)
1778: into l_count
1779: from PA_OBJECT_RELATIONSHIPS
1780: where RELATIONSHIP_TYPE = p_relationship_type and
1781: OBJECT_TYPE_FROM = 'PA_TASKS' and
1782: OBJECT_TYPE_TO = 'PA_STRUCTURES' and
1783: OBJECT_ID_FROM2 = l_parent_project and

Line 1804: from PA_OBJECT_RELATIONSHIPS

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

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

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

Line 1875: PA_OBJECT_RELATIONSHIPS rel,

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

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

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

Line 2369: PA_OBJECT_RELATIONSHIPS rel,

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