APPS.PA_PROJ_STRUC_MAPPING_UTILS dependencies on PA_OBJECT_RELATIONSHIPS

Line 11: -- : If its not shared, we check in PA_OBJECT_RELATIONSHIPS for the passed project elem id

7: -- Type : Public Function
8: -- Purpose : The function will check whether the mapping exists for the passed financial task_id. Returns 'Y'
9: -- : if mapping exists
10: -- NOTE : This first checks whether it is shared or not.
11: -- : If its not shared, we check in PA_OBJECT_RELATIONSHIPS for the passed project elem id
12: -- : if any relationship exists with type 'M'.
13: -- : If there is any row, 'Y' is returned else 'N' is returned
14: -- Assumptions : 1. This API will return always N in case of shared structure as mapping is not
15: -- possible in shared structure.

Line 45: -- This cursor will select 'X' if any version of FP task exists in PA_OBJECT_RELATIONSHIPS

41: WHERE elver.proj_element_id = p_proj_element_id
42: AND elver.object_type='PA_TASKS'
43: AND elver.project_id = p_project_id;
44:
45: -- This cursor will select 'X' if any version of FP task exists in PA_OBJECT_RELATIONSHIPS
46: -- for Mapping type relation and passed task ver id
47:
48: CURSOR c_mapping_exists (l_elem_version_id NUMBER)
49: IS

Line 54: FROM PA_OBJECT_RELATIONSHIPS

50: SELECT 'X'
51: FROM DUAL
52: WHERE EXISTS
53: ( SELECT NULL
54: FROM PA_OBJECT_RELATIONSHIPS
55: WHERE OBJECT_ID_TO1 = l_elem_version_id
56: AND relationship_type = 'M'
57: );
58:

Line 161: FROM pa_object_relationships

157: -- This cursor selects all task ids in the parent ladder and lower level ladder for the passed workplan task id.
158: CURSOR c_get_all_object_id
159: IS
160: SELECT object_id_to1 object_id
161: FROM pa_object_relationships
162: WHERE relationship_type ='S'
163: AND relationship_subtype ='TASK_TO_TASK'
164: START WITH object_id_from1 = p_task_version_id_WP
165: CONNECT BY object_id_from1 = PRIOR object_id_to1

Line 168: FROM pa_object_relationships

164: START WITH object_id_from1 = p_task_version_id_WP
165: CONNECT BY object_id_from1 = PRIOR object_id_to1
166: UNION
167: SELECT object_id_from1 object_id
168: FROM pa_object_relationships
169: WHERE relationship_type = 'S'
170: AND relationship_subtype = 'TASK_TO_TASK'
171: START WITH object_id_to1 = p_task_version_id_WP
172: CONNECT BY Object_id_to1 = PRIOR object_id_from1

Line 185: FROM PA_OBJECT_RELATIONSHIPS

181: FROM dual
182: WHERE EXISTS
183: (
184: SELECT NULL
185: FROM PA_OBJECT_RELATIONSHIPS
186: WHERE relationship_type ='M'
187: AND object_id_from1 = l_from_task_id
188: );
189:

Line 426: from pa_object_relationships

422: ,p_structure_sharing_code IN VARCHAR2) RETURN NUMBER
423: IS
424: cursor C1 (evid number) is
425: select object_id_from1,object_id_to1
426: from pa_object_relationships
427: where relationship_type='S'
428: and object_type_to='PA_TASKS'
429: connect by prior object_id_from1 = object_id_to1
430: and prior relationship_type = relationship_type -- Bug # 4621730.

Line 443: from pa_object_relationships

439: for l_c1rec in C1(p_element_version_id)
440: LOOP
441: BEGIN -- Added exception block for Bug# 6411931
442: select object_id_to1 into l_mapped_fin_task_version_id
443: from pa_object_relationships
444: where relationship_type='M'
445: and object_type_from='PA_TASKS'
446: and object_type_to='PA_TASKS'
447: and object_id_from1 = l_c1rec.object_id_to1;

Line 544: pa_object_relationships por_mapping

540: select ppe.name
541: from
542: pa_proj_elements ppe,
543: pa_proj_element_versions ppev,
544: pa_object_relationships por_mapping
545: where
546: ppe.proj_element_id=ppev.proj_element_id
547: and
548: ppe.project_id = ppev.project_id

Line 592: pa_object_relationships por_mapping

588: select ppe.proj_element_id
589: from
590: pa_proj_elements ppe,
591: pa_proj_element_versions ppev,
592: pa_object_relationships por_mapping
593: where
594: ppe.proj_element_id=ppev.proj_element_id
595: and
596: ppe.project_id = ppev.project_id

Line 639: pa_object_relationships por_mapping

635: select ppe.proj_element_id
636: from
637: pa_proj_elements ppe,
638: pa_proj_element_versions ppev,
639: pa_object_relationships por_mapping
640: where
641: ppe.proj_element_id=ppev.proj_element_id
642: and
643: ppe.project_id = ppev.project_id

Line 682: pa_object_relationships por_mapping

678: select ppe.name
679: from
680: pa_proj_elements ppe,
681: pa_proj_element_versions ppev,
682: pa_object_relationships por_mapping
683: where
684: ppe.proj_element_id=ppev.proj_element_id
685: and
686: ppe.project_id = ppev.project_id