APPS.PA_DELIVERABLE_PUB dependencies on PA_TASKS

Line 931: l_task_id PA_TASKS.TASK_ID%TYPE; --added bug 3651538

927: l_actual_finish_date DATE;
928: l_dlvr_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
929: l_status_code PA_PROJ_ELEMENTS.STATUS_CODE%TYPE;
930: l_dlvr_type_id PA_PROJ_ELEMENTS.TYPE_ID%TYPE;
931: l_task_id PA_TASKS.TASK_ID%TYPE; --added bug 3651538
932: l_deliverable_reference PA_PROJ_ELEMENTS.PM_SOURCE_CODE%TYPE; -- added for bug# 3749447
933:
934: l_structure_type VARCHAR2(150) := 'DELIVERABLE';
935: l_structure_id NUMBER;

Line 1915: -- p_task_or_dlv will be 'PA_TASKS'

1911: -- p_element_number_tbl will have selected deliverables name
1912: -- p_task_or_dlv_elt_id will have Task Id
1913: -- p_task_or_dlv_ver_id will have task version id
1914: -- p_project_id will have project id
1915: -- p_task_or_dlv will be 'PA_TASKS'
1916: -- When called from ASSOCIATE TASKS page
1917: -- p_element_id_tbl will have all the element id of selected tasks
1918: -- p_version_id_tbl will have all the version id of selected tasks
1919: -- p_element_name_tbl will have selected tasks name

Line 1942: ,p_task_or_dlv IN VARCHAR2 := 'PA_TASKS'

1938: ,p_element_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1939: ,p_task_or_dlv_elt_id IN NUMBER
1940: ,p_task_or_dlv_ver_id IN NUMBER
1941: ,p_project_id IN pa_projects_all.project_id%TYPE
1942: ,p_task_or_dlv IN VARCHAR2 := 'PA_TASKS'
1943: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1944: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1945: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1946: )

Line 2232: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'

2228: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2229: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2230: ,p_debug_mode IN VARCHAR2 :='N'
2231: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2232: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
2233: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2234: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2235: ,p_project_id IN pa_projects_all.project_id%TYPE
2236: ,p_delete_or_validate IN VARCHAR2 := 'B' -- 3955848 V- Validate , D - Delete, B - Validate and Delete

Line 2684: AND obj.object_type_from = 'PA_TASKS'

2680: ,pa_proj_element_versions pev2
2681: ,pa_object_relationships obj
2682: WHERE pev2.element_version_id = c_task_version_id
2683: AND obj.object_id_from2 = pev2.proj_element_id
2684: AND obj.object_type_from = 'PA_TASKS'
2685: AND obj.object_type_to = 'PA_DELIVERABLES'
2686: AND obj.relationship_type = 'A'
2687: AND obj.relationship_subtype = 'TASK_TO_DELIVERABLE'
2688: AND obj.object_id_to2 = ppe.proj_element_id

Line 2756: ,p_task_or_dlv => 'PA_TASKS'

2752: ,p_element_number_tbl => l_element_number_tbl
2753: ,p_task_or_dlv_elt_id => l_task_element_id -- 3461959 changed from l_proj_element_id to l_task_element_id
2754: ,p_task_or_dlv_ver_id => p_dest_task_versions_tab(i)
2755: ,p_project_id => l_project_id
2756: ,p_task_or_dlv => 'PA_TASKS'
2757: ,x_return_status => x_return_status
2758: ,x_msg_count => x_msg_count
2759: ,x_msg_data => x_msg_data
2760: ) ;