[Home] [Help]
62: SELECT
63: obj.object_relationship_id
64: , obj.record_version_number
65: FROM
66: PA_OBJECT_RELATIONSHIPS obj
67: WHERE obj.object_id_from1 = l_wp_task_version_id
68: AND obj.relationship_type='M';
69:
70: --This cursor selects relationship id , record version number from pa_object_relationship for the passed work plan and financial task
74: SELECT
75: object_relationship_id
76: , record_version_number
77: FROM
78: PA_OBJECT_RELATIONSHIPS
79: WHERE
80: object_id_to1 = l_fp_task_version_id
81: AND relationship_type='M';
82:
86: SELECT
87: obj.object_relationship_id
88: , obj.record_version_number
89: FROM
90: PA_OBJECT_RELATIONSHIPS obj
91: WHERE obj.object_id_from1 = l_wp_task_version_id
92: AND obj.object_id_to1 = l_fp_task_version_id
93: AND obj.relationship_type='M';
94:
921: -- Select the object relationship id corresponding to existing mapping
922: CURSOR cur_get_object_relationship_id (l_wp_task_version_id NUMBER )
923: IS
924: SELECT object_relationship_id , record_version_number
925: FROM pa_object_relationships
926: WHERE object_id_from1 = l_wp_task_version_id
927: AND relationship_type = 'M';
928:
929:
1373: paObrel.OBJECT_ID_FROM1 as OBJECT_ID_FROM1
1374: , paObrel.OBJECT_ID_TO1 as OBJECT_ID_TO1
1375: FROM
1376: pa_proj_element_versions elever
1377: , pa_object_relationships paObrel
1378: WHERE elever.PARENT_STRUCTURE_VERSION_ID = l_parent_str_version_id
1379: AND paObrel.OBJECT_ID_FROM1 = elever.element_version_id
1380: AND elever.project_id = l_project_id
1381: AND paObrel.RELATIONSHIP_TYPE = 'M'
1523: IF (l_dest_from_tasks_id_tbl.count > 0 AND l_dest_to_tasks_id_tbl.COUNT > 0)
1524: THEN
1525: FORALL iCounter IN l_dest_from_tasks_id_tbl.FIRST..l_dest_from_tasks_id_tbl.LAST
1526:
1527: INSERT INTO PA_OBJECT_RELATIONSHIPS
1528: (
1529: object_relationship_id,
1530: object_type_from,
1531: object_id_from1,
1553: LAST_UPDATE_LOGIN,
1554: weighting_percentage
1555: )
1556:
1557: VALUES ( pa_object_relationships_s.nextval,
1558: 'PA_TASKS',
1559: l_dest_from_tasks_id_tbl(iCounter),
1560: NULL,
1561: NULL,
1631: END LOOP;
1632:
1633: Pa_Debug.WRITE(g_module_name,'l_from_task_id_tbl.COUNT '||l_from_task_id_tbl.COUNT ,l_debug_level3);
1634:
1635: -- Insert into PA_OBJECT_RELATIONSHIPS
1636: --bug 3574885, the forall should be called only when l_from_dest_task_ver_id is not empty
1637: --rtarway ,bug 3916440, the forall should be called only when l_src_to_tasks_id_tbl is not empty
1638: IF (l_from_dest_task_ver_id.COUNT > 0 AND l_src_to_tasks_id_tbl.count > 0)
1639: THEN
1638: IF (l_from_dest_task_ver_id.COUNT > 0 AND l_src_to_tasks_id_tbl.count > 0)
1639: THEN
1640: FORALL iCounter IN l_from_dest_task_ver_id.FIRST..l_from_dest_task_ver_id.LAST
1641:
1642: INSERT INTO PA_OBJECT_RELATIONSHIPS (
1643: object_relationship_id,
1644: object_type_from,
1645: object_id_from1,
1646: object_id_from2,
1665: LAST_UPDATED_BY,
1666: LAST_UPDATE_DATE,
1667: LAST_UPDATE_LOGIN,
1668: weighting_percentage)
1669: VALUES ( pa_object_relationships_s.nextval,
1670: 'PA_TASKS',
1671: l_from_dest_task_ver_id(iCounter),
1672: NULL,
1673: NULL,
1770: -- Type : Public Procedure
1771: -- Purpose : This API will be called when we change a split mapping project to split no mapping.
1772: -- :
1773: -- Note : 1. Get all the financial tasks of the passed project id.
1774: -- : 2. If any of these tasks is existing in PA_OBJECT_RELATIONSHIPS, with relationship_type 'M'
1775: -- : delete the record in pa_object_relationships
1776: -- Assumptions : The financial structure will have only one version in any case whether versioning enabled or disabled
1777:
1778: -- Parameters Type Required Description and Purpose
1771: -- Purpose : This API will be called when we change a split mapping project to split no mapping.
1772: -- :
1773: -- Note : 1. Get all the financial tasks of the passed project id.
1774: -- : 2. If any of these tasks is existing in PA_OBJECT_RELATIONSHIPS, with relationship_type 'M'
1775: -- : delete the record in pa_object_relationships
1776: -- Assumptions : The financial structure will have only one version in any case whether versioning enabled or disabled
1777:
1778: -- Parameters Type Required Description and Purpose
1779: -- --------------------------- ------ -------- --------------------------------------------------------
1817: pa_proj_element_versions elever1
1818: , pa_proj_element_versions elever2
1819: -- , pa_proj_structure_types projStrType Bug 3693235 Performance Fix
1820: -- , pa_structure_types strType Bug 3693235 Performance Fix
1821: , pa_object_relationships obRel
1822: WHERE
1823: elever1.object_type = 'PA_TASKS'
1824: AND elever1.parent_structure_version_id = elever2.element_version_id
1825: AND elever2.object_type = 'PA_STRUCTURES'
1894: IF (l_mapped_obj_rel_id_tbl IS NOT NULL AND l_mapped_obj_rel_id_tbl.COUNT > 0 )
1895: THEN
1896: FORALL iCounter IN l_mapped_obj_rel_id_tbl.FIRST..l_mapped_obj_rel_id_tbl.LAST
1897:
1898: DELETE FROM PA_OBJECT_RELATIONSHIPS
1899: WHERE
1900: OBJECT_RELATIONSHIP_ID = l_mapped_obj_rel_id_tbl(iCounter);
1901: END IF;
1902: IF (p_commit = FND_API.G_TRUE) THEN