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 162: FROM pa_object_relationships

158: -- Bug 9662785
159: CURSOR c_get_all_object_id
160: IS
161: SELECT object_id_to1 object_id
162: FROM pa_object_relationships
163: WHERE relationship_type ='S'
164: AND relationship_subtype ='TASK_TO_TASK'
165: START WITH object_id_from1 = p_task_version_id_WP
166: AND object_type_from = 'PA_TASKS'

Line 173: FROM pa_object_relationships

169: AND object_type_from = PRIOR object_type_to
170: AND relationship_type = PRIOR relationship_type
171: UNION
172: SELECT object_id_from1 object_id
173: FROM pa_object_relationships
174: WHERE relationship_type = 'S'
175: AND relationship_subtype = 'TASK_TO_TASK'
176: START WITH object_id_to1 = p_task_version_id_WP
177: AND object_type_to = 'PA_TASKS'

Line 194: FROM PA_OBJECT_RELATIONSHIPS

190: FROM dual
191: WHERE EXISTS
192: (
193: SELECT NULL
194: FROM PA_OBJECT_RELATIONSHIPS
195: WHERE relationship_type ='M'
196: AND object_id_from1 = l_from_task_id
197: );
198:

Line 435: from pa_object_relationships

431: ,p_structure_sharing_code IN VARCHAR2) RETURN NUMBER
432: IS
433: cursor C1 (evid number) is
434: select object_id_from1,object_id_to1
435: from pa_object_relationships
436: where relationship_type='S'
437: and object_type_to='PA_TASKS'
438: connect by prior object_id_from1 = object_id_to1
439: and prior relationship_type = relationship_type -- Bug # 4621730.

Line 452: from pa_object_relationships

448: for l_c1rec in C1(p_element_version_id)
449: LOOP
450: BEGIN -- Added exception block for Bug# 6411931
451: select object_id_to1 into l_mapped_fin_task_version_id
452: from pa_object_relationships
453: where relationship_type='M'
454: and object_type_from='PA_TASKS'
455: and object_type_to='PA_TASKS'
456: and object_id_from1 = l_c1rec.object_id_to1;

Line 553: pa_object_relationships por_mapping

549: select ppe.name
550: from
551: pa_proj_elements ppe,
552: pa_proj_element_versions ppev,
553: pa_object_relationships por_mapping
554: where
555: ppe.proj_element_id=ppev.proj_element_id
556: and
557: ppe.project_id = ppev.project_id

Line 601: pa_object_relationships por_mapping

597: select ppe.proj_element_id
598: from
599: pa_proj_elements ppe,
600: pa_proj_element_versions ppev,
601: pa_object_relationships por_mapping
602: where
603: ppe.proj_element_id=ppev.proj_element_id
604: and
605: ppe.project_id = ppev.project_id

Line 648: pa_object_relationships por_mapping

644: select ppe.proj_element_id
645: from
646: pa_proj_elements ppe,
647: pa_proj_element_versions ppev,
648: pa_object_relationships por_mapping
649: where
650: ppe.proj_element_id=ppev.proj_element_id
651: and
652: ppe.project_id = ppev.project_id

Line 691: pa_object_relationships por_mapping

687: select ppe.name
688: from
689: pa_proj_elements ppe,
690: pa_proj_element_versions ppev,
691: pa_object_relationships por_mapping
692: where
693: ppe.proj_element_id=ppev.proj_element_id
694: and
695: ppe.project_id = ppev.project_id