DBA Data[Home] [Help]

APPS.PA_TASK_UTILS dependencies on PA_PROJ_ELEMENTS

Line 1770: -- the following API : PA_PROJ_ELEMENTS_UTILS.perform_task_validations

1766: end;
1767: */
1768: -- Start of code for Performance Fix 4903460
1769: -- All commented validations in this API for this perf fix are done in
1770: -- the following API : PA_PROJ_ELEMENTS_UTILS.perform_task_validations
1771:
1772: -- Added the following api call to get the project_id and pass it to perform_task_validations. Done for Bug#4964992
1773: l_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id);
1774: -- End of changes for Bug#4964992

Line 1776: PA_PROJ_ELEMENTS_UTILS.perform_task_validations

1772: -- Added the following api call to get the project_id and pass it to perform_task_validations. Done for Bug#4964992
1773: l_project_id := pa_proj_tsk_utils.get_task_project_id(x_task_id);
1774: -- End of changes for Bug#4964992
1775:
1776: PA_PROJ_ELEMENTS_UTILS.perform_task_validations
1777: (
1778: p_project_id => l_project_id
1779: ,p_task_id => x_task_id
1780: ,x_error_code => x_err_code

Line 2065: FROM pa_proj_elements

2061: --Bug 3617393
2062: DECLARE
2063: CURSOR get_task_project_id(c_task_id IN NUMBER) IS
2064: SELECT project_id
2065: FROM pa_proj_elements
2066: WHERE proj_element_id = c_task_id;
2067: BEGIN
2068:
2069: x_err_stage := 'PA_PROJ_STRUC_MAPPING_UTILS.Check_Task_Has_Mapping'||x_task_id;

Line 2073: --Bug 3617393 : Retrieve project id from pa_proj_elements rather than pa_tasks since

2069: x_err_stage := 'PA_PROJ_STRUC_MAPPING_UTILS.Check_Task_Has_Mapping'||x_task_id;
2070:
2071: -- Get project id
2072: x_err_stage := 'get project id of '|| x_task_id;
2073: --Bug 3617393 : Retrieve project id from pa_proj_elements rather than pa_tasks since
2074: --the data has already been deleted from pa_tasks in delete_project flow
2075: /*x_project_id :=
2076: pa_proj_tsk_utils.get_task_project_id(x_task_id);*/
2077: OPEN get_task_project_id(x_task_id);