[Home] [Help]
75: where task_id = c_task_id;
76:
77: cursor Is_Same_Struc(c_elem_ver_from NUMBER, c_elem_ver_to NUMBER) IS
78: select '1'
79: from pa_proj_elements pe1,
80: pa_proj_element_versions pev1a,
81: pa_proj_element_versions pev1b,
82: pa_proj_element_versions pev2a,
83: pa_proj_element_versions pev2b
92: avoid Non-mergable view issue and use EXISTS rather than IN */
93:
94: /* cursor Is_Diff_Version_Linked(c_elem_ver_from NUMBER, c_elem_ver_to NUMBER) IS
95: select '1'
96: from pa_proj_elements pe1,
97: pa_proj_element_versions pev1a,
98: pa_proj_element_versions pev1b,
99: pa_object_relationships r
100: where pev1a.element_version_id = c_elem_ver_from
103: and pe1.proj_element_id = pev1b.proj_element_id
104: and pev1b.element_version_id = r.object_id_to1
105: and r.object_id_from1 IN
106: (select pev2b.element_version_id
107: from pa_proj_elements pe2,
108: pa_proj_element_versions pev2a,
109: pa_proj_element_versions pev2b
110: where pev2a.element_version_id = c_elem_ver_to
111: and pev2a.proj_element_id = pe2.proj_element_id
114: */
115:
116: cursor Is_Diff_Version_Linked(c_elem_ver_from NUMBER, c_elem_ver_to NUMBER) IS
117: select '1'
118: from pa_proj_elements pe1,
119: pa_proj_element_versions pev1a,
120: pa_proj_element_versions pev1b,
121: pa_object_relationships r
122: where pev1a.element_version_id = c_elem_ver_from
125: and pe1.proj_element_id = pev1b.proj_element_id
126: and pev1b.element_version_id = r.object_id_to1
127: and EXISTS
128: (select pev2b.element_version_id
129: from pa_proj_elements pe2,
130: pa_proj_element_versions pev2a,
131: pa_proj_element_versions pev2b
132: where pev2a.element_version_id = c_elem_ver_to
133: and pev2a.proj_element_id = pe2.proj_element_id
191: intersect
192: (
193: select pev1b.element_version_id
194: from pa_proj_element_versions pev1b,
195: pa_proj_elements pe1,
196: pa_proj_element_versions pev1a
197: where pev1b.project_id = pe1.project_id
198: and pev1b.proj_element_id = pe1.proj_element_id
199: and pev1a.proj_element_id = pe1.proj_element_id
262: -- IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
263: --1c. check if from object is lowest task.
264: -- if no, create new task.
265:
266: -- IF (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_element_version_id_from) = 'N') THEN
267: -- --check if there is transaction to this task.
268: -- --if transaction exists, return error.
269: -- x_return_status := 'T';
270: -- ELSE
532:
533: CURSOR cur_parent_lp_link
534: IS
535: SELECT 'Y'
536: FROM pa_proj_elements ppe
537: ,pa_proj_element_versions ppv1 /* to get link task version id */
538: ,pa_proj_element_versions ppv2 /* to get sub project structure version ids */
539: ,pa_object_relationships por
540: WHERE ppe.project_id = p_parent_project_id
1064: CURSOR cur_task_names( c_element_version_id NUMBER )
1065: IS
1066: SELECT ppe.name task_name
1067: FROM pa_proj_element_versions ppev,
1068: pa_proj_elements ppe
1069: WHERE ppev.proj_element_id = ppe.proj_element_id
1070: and ppev.project_id = ppe.project_id
1071: AND ppev.element_version_id IN (SELECT object_id_to1
1072: FROM pa_object_relationships por
1327:
1328: CURSOR get_parent_sub_proj(c_project_id NUMBER) IS
1329: SELECT ppa.sys_program_flag
1330: FROM pa_proj_element_versions ppev,
1331: pa_proj_elements ppe,
1332: pa_projects_all ppa
1333: WHERE ppe.project_id = ppev.project_id
1334: AND ppe.proj_element_id = ppev.proj_element_id
1335: AND ppev.object_type = 'PA_TASKS'
1600: IS
1601: cursor c1 is
1602: select ppwa.AUTO_ROLLUP_SUBPROJ_FLAG
1603: from pa_proj_workplan_attr ppwa,
1604: pa_proj_elements ppe,
1605: pa_proj_structure_types ppst,
1606: pa_structure_types pst
1607: where ppe.project_id = p_project_id
1608: and ppe.object_type = 'PA_STRUCTURES'
1630: select por2.object_relationship_id, por2.relationship_type, ppev.element_version_id
1631: from pa_object_relationships por1,
1632: pa_object_relationships por2,
1633: pa_proj_element_versions ppev,
1634: pa_proj_elements ppe
1635: where ppe.proj_element_id = p_task_id
1636: and ppe.proj_element_id = ppev.proj_element_id
1637: and ppe.project_id = ppev.project_id
1638: and ppev.element_version_id = por1.object_id_from1
1674: select por2.object_relationship_id, por2.relationship_type, ppev.element_version_id
1675: from pa_object_relationships por1,
1676: pa_object_relationships por2,
1677: pa_proj_element_versions ppev,
1678: pa_proj_elements ppe
1679: where ppe.proj_element_id = p_task_id
1680: and ppe.proj_element_id = ppev.proj_element_id
1681: and ppe.project_id = ppev.project_id
1682: and ppev.element_version_id = por1.object_id_from1