[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:
890: -- Select the object relationship id corresponding to existing mapping
891: CURSOR cur_get_object_relationship_id (l_wp_task_version_id NUMBER )
892: IS
893: SELECT object_relationship_id , record_version_number
894: FROM pa_object_relationships
895: WHERE object_id_from1 = l_wp_task_version_id
896: AND relationship_type = 'M';
897:
898:
1335: paObrel.OBJECT_ID_FROM1 as OBJECT_ID_FROM1
1336: , paObrel.OBJECT_ID_TO1 as OBJECT_ID_TO1
1337: FROM
1338: pa_proj_element_versions elever
1339: , pa_object_relationships paObrel
1340: WHERE elever.PARENT_STRUCTURE_VERSION_ID = l_parent_str_version_id
1341: AND paObrel.OBJECT_ID_FROM1 = elever.element_version_id
1342: AND elever.project_id = l_project_id
1343: AND paObrel.RELATIONSHIP_TYPE = 'M'
1485: IF (l_dest_from_tasks_id_tbl.count > 0 AND l_dest_to_tasks_id_tbl.COUNT > 0)
1486: THEN
1487: FORALL iCounter IN l_dest_from_tasks_id_tbl.FIRST..l_dest_from_tasks_id_tbl.LAST
1488:
1489: INSERT INTO PA_OBJECT_RELATIONSHIPS
1490: (
1491: object_relationship_id,
1492: object_type_from,
1493: object_id_from1,
1515: LAST_UPDATE_LOGIN,
1516: weighting_percentage
1517: )
1518:
1519: VALUES ( pa_object_relationships_s.nextval,
1520: 'PA_TASKS',
1521: l_dest_from_tasks_id_tbl(iCounter),
1522: NULL,
1523: NULL,
1593: END LOOP;
1594:
1595: Pa_Debug.WRITE(g_module_name,'l_from_task_id_tbl.COUNT '||l_from_task_id_tbl.COUNT ,l_debug_level3);
1596:
1597: -- Insert into PA_OBJECT_RELATIONSHIPS
1598: --bug 3574885, the forall should be called only when l_from_dest_task_ver_id is not empty
1599: --rtarway ,bug 3916440, the forall should be called only when l_src_to_tasks_id_tbl is not empty
1600: IF (l_from_dest_task_ver_id.COUNT > 0 AND l_src_to_tasks_id_tbl.count > 0)
1601: THEN
1600: IF (l_from_dest_task_ver_id.COUNT > 0 AND l_src_to_tasks_id_tbl.count > 0)
1601: THEN
1602: FORALL iCounter IN l_from_dest_task_ver_id.FIRST..l_from_dest_task_ver_id.LAST
1603:
1604: INSERT INTO PA_OBJECT_RELATIONSHIPS (
1605: object_relationship_id,
1606: object_type_from,
1607: object_id_from1,
1608: object_id_from2,
1627: LAST_UPDATED_BY,
1628: LAST_UPDATE_DATE,
1629: LAST_UPDATE_LOGIN,
1630: weighting_percentage)
1631: VALUES ( pa_object_relationships_s.nextval,
1632: 'PA_TASKS',
1633: l_from_dest_task_ver_id(iCounter),
1634: NULL,
1635: NULL,
1732: -- Type : Public Procedure
1733: -- Purpose : This API will be called when we change a split mapping project to split no mapping.
1734: -- :
1735: -- Note : 1. Get all the financial tasks of the passed project id.
1736: -- : 2. If any of these tasks is existing in PA_OBJECT_RELATIONSHIPS, with relationship_type 'M'
1737: -- : delete the record in pa_object_relationships
1738: -- Assumptions : The financial structure will have only one version in any case whether versioning enabled or disabled
1739:
1740: -- Parameters Type Required Description and Purpose
1733: -- Purpose : This API will be called when we change a split mapping project to split no mapping.
1734: -- :
1735: -- Note : 1. Get all the financial tasks of the passed project id.
1736: -- : 2. If any of these tasks is existing in PA_OBJECT_RELATIONSHIPS, with relationship_type 'M'
1737: -- : delete the record in pa_object_relationships
1738: -- Assumptions : The financial structure will have only one version in any case whether versioning enabled or disabled
1739:
1740: -- Parameters Type Required Description and Purpose
1741: -- --------------------------- ------ -------- --------------------------------------------------------
1779: pa_proj_element_versions elever1
1780: , pa_proj_element_versions elever2
1781: -- , pa_proj_structure_types projStrType Bug 3693235 Performance Fix
1782: -- , pa_structure_types strType Bug 3693235 Performance Fix
1783: , pa_object_relationships obRel
1784: WHERE
1785: elever1.object_type = 'PA_TASKS'
1786: AND elever1.parent_structure_version_id = elever2.element_version_id
1787: AND elever2.object_type = 'PA_STRUCTURES'
1856: IF (l_mapped_obj_rel_id_tbl IS NOT NULL AND l_mapped_obj_rel_id_tbl.COUNT > 0 )
1857: THEN
1858: FORALL iCounter IN l_mapped_obj_rel_id_tbl.FIRST..l_mapped_obj_rel_id_tbl.LAST
1859:
1860: DELETE FROM PA_OBJECT_RELATIONSHIPS
1861: WHERE
1862: OBJECT_RELATIONSHIP_ID = l_mapped_obj_rel_id_tbl(iCounter);
1863: END IF;
1864: IF (p_commit = FND_API.G_TRUE) THEN