APPS.PA_PROJ_STRUCTURE_PVT dependencies on PA_TASKS

Line 86: from pa_tasks

82: -- added for Bug: 4537865
83: --
84: CURSOR get_owning_project_id(l_task_id NUMBER) IS
85: select project_id
86: from pa_tasks
87: where task_id = l_task_id;
88: --
89: CURSOR get_task_dates(l_task_id NUMBER) IS
90: select start_date, completion_date

Line 91: from pa_tasks

87: where task_id = l_task_id;
88: --
89: CURSOR get_task_dates(l_task_id NUMBER) IS
90: select start_date, completion_date
91: from pa_tasks
92: where task_id = l_task_id;
93: --
94: CURSOR get_project_dates(l_project_id NUMBER) IS
95: select start_date, completion_date

Line 114: pa_tasks pt

110: CURSOR get_src_task_det(cp_src_task_id NUMBER) IS
111: SELECT ppev.element_version_id src_task_ver_id,ppe.project_id src_proj_id
112: FROM pa_proj_elements ppe,
113: pa_proj_element_versions ppev,
114: pa_tasks pt
115: WHERE ppe.proj_element_id = cp_src_task_id
116: AND ppe.project_id = ppev.project_id
117: AND ppe.proj_element_id = ppev.proj_element_id
118: AND pt.task_id = ppe.proj_element_id

Line 205: p_object_type_from => 'PA_TASKS',

201: ELSE
202: /* call table handler */
203: /*pa_object_relationships_pkg.insert_row(
204: p_user_id => l_user_id,
205: p_object_type_from => 'PA_TASKS',
206: p_object_id_from1 => p_task_id,
207: p_object_id_from2 => l_owning_proj_id,
208: p_object_id_from3 => null,
209: p_object_id_from4 => null,

Line 351: OBJECT_TYPE_FROM = 'PA_TASKS' and

347: from
348: pa_object_relationships
349: where
350: object_id_from1 = l_task_id and
351: OBJECT_TYPE_FROM = 'PA_TASKS' and
352: relationship_type = 'H';
353: --
354: CURSOR get_all_tasks_for_project(l_project_id NUMBER) IS
355: select

Line 373: object_type_from = 'PA_TASKS' and

369: from
370: pa_object_relationships
371: where
372: object_type_to = 'PA_PROJECTS' and
373: object_type_from = 'PA_TASKS' and
374: object_id_to1 = l_project_id and
375: object_id_from1 = l_task_id and
376: relationship_type = 'H';
377: --

Line 383: pa_tasks pt

379: CURSOR get_src_task_det(cp_src_task_id NUMBER) IS
380: SELECT ppev.element_version_id src_task_ver_id,ppe.project_id src_proj_id
381: FROM pa_proj_elements ppe,
382: pa_proj_element_versions ppev,
383: pa_tasks pt
384: WHERE ppe.proj_element_id = cp_src_task_id
385: AND ppe.project_id = ppev.project_id
386: AND ppe.proj_element_id = ppev.proj_element_id
387: AND pt.task_id = ppe.proj_element_id

Line 407: AND pora.object_type_from = 'PA_TASKS'

403: pa_proj_elements ppe
404: WHERE pora.relationship_type = 'S'
405: AND ppev.project_id = cp_src_proj_id
406: AND pora.OBJECT_ID_FROM1 = cp_src_task_ver_id
407: AND pora.object_type_from = 'PA_TASKS'
408: AND pora.OBJECT_ID_to1 = ppev.ELEMENT_VERSION_ID
409: AND ppe.proj_element_id = ppev.proj_element_id
410: AND pora.object_id_to1=porb.object_id_from1
411: AND porb.object_id_to2 <> porb.object_id_from2

Line 431: AND pora.object_type_from = 'PA_TASKS'

427: pa_proj_elements ppe
428: WHERE pora.relationship_type = 'S'
429: AND ppev.project_id = cp_src_proj_id
430: AND pora.OBJECT_ID_FROM1 = cp_src_task_ver_id
431: AND pora.object_type_from = 'PA_TASKS'
432: AND pora.OBJECT_ID_to1 = ppev.ELEMENT_VERSION_ID
433: AND ppe.proj_element_id = ppev.proj_element_id
434: AND pora.object_id_to1=porb.object_id_from1
435: AND porb.object_id_to2 <> porb.object_id_from2

Line 438: AND porb.object_type_from = 'PA_TASKS'

434: AND pora.object_id_to1=porb.object_id_from1
435: AND porb.object_id_to2 <> porb.object_id_from2
436: AND porb.object_id_from2 = cp_src_proj_id
437: AND porb.object_type_to = 'PA_STRUCTURES'
438: AND porb.object_type_from = 'PA_TASKS'
439: AND porb.relationship_type ='LF'
440: AND ppe.link_task_flag = 'Y';
441: --
442: --This is cursor is used when the source task id is not passed to this api

Line 454: AND porb.object_type_from = 'PA_TASKS'

450: WHERE porb.OBJECT_ID_to1 = cp_dest_struct_ver_id
451: AND porb.object_id_from2 = cp_dest_proj_id
452: AND porb.object_id_to2 <> porb.object_id_from2
453: AND porb.object_type_to = 'PA_STRUCTURES'
454: AND porb.object_type_from = 'PA_TASKS'
455: AND porb.relationship_type ='LF';
456: --
457: l_rel_id NUMBER;
458: l_rec_ver_num NUMBER;

Line 500: from pa_tasks

496: /* check if any children has contract associated to it */
497: -- Get task owning project
498: /* select project_id
499: into l_project_from_id
500: from pa_tasks
501: where task_id = p_task_id;*/
502: --
503: -- Bug_9931285: Uncommented the below check.
504: IF (pa_install.is_product_installed('OKE')) THEN

Line 573: from pa_tasks

569: /* If task_id is not null, then delete all relationships that the task is associated with */
570: -- Get task owning project
571: select project_id
572: into l_project_from_id
573: from pa_tasks
574: where task_id = p_task_id;
575: --
576: OPEN get_all_sub_proj_ass_det(l_src_task_ver_id,l_src_proj_id);
577: LOOP