APPS.PA_TASKS_MAINT_PVT dependencies on PA_PROJ_ELEMENTS

Line 6183: PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_HAS_TRANSACTION

6179: -- CLOSE c_task_exists_in_pa_tasks ;
6180:
6181: -- IF NVL(l_task_exists,'N') ='Y' THEN -- Bug 3735089
6182: --Check if the task has any transaction associated with it
6183: PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_HAS_TRANSACTION
6184: (
6185: p_task_id => l_task_id
6186: , p_project_id => p_project_id -- Added for Performance fix 4903460
6187: , x_return_status => x_return_status

Line 6405: pa_proj_elements

6401: IS
6402: SELECT
6403: name, element_number
6404: FROM
6405: pa_proj_elements
6406: WHERE
6407: proj_element_id = l_element_id
6408: AND
6409: project_id = l_project_id;

Line 6438: pa_proj_elements elements

6434: elements.name
6435: , elements.element_number
6436:
6437: FROM
6438: pa_proj_elements elements
6439: , pa_proj_element_versions elever
6440: WHERE
6441: elever.element_version_id = l_element_version_id
6442: AND

Line 6542: IF (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_id)='Y')

6538:
6539: OPEN c_get_task_id ( p_task_version_id , p_project_id );
6540: FETCH c_get_task_id INTO l_task_id;
6541: CLOSE c_get_task_id;
6542: IF (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_id)='Y')
6543: THEN
6544:
6545:
6546: PA_TASKS_MAINT_PUB.DELETE_TASK

Line 6579: IF (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_id)='N')

6575: (
6576: p_project_id => p_project_id
6577: ,p_task_id => l_task_id
6578: );
6579: IF (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_id)='N')
6580: THEN
6581: --Get the task id for the parent_task_version_id
6582: OPEN c_get_task_id ( p_parent_task_version_id , p_project_id );
6583: FETCH c_get_task_id INTO l_parent_task_id;

Line 6585: --Get the task name from pa_proj_elements

6581: --Get the task id for the parent_task_version_id
6582: OPEN c_get_task_id ( p_parent_task_version_id , p_project_id );
6583: FETCH c_get_task_id INTO l_parent_task_id;
6584: CLOSE c_get_task_id;
6585: --Get the task name from pa_proj_elements
6586: OPEN c_get_task_name_and_number ( l_task_id , p_project_id );
6587: FETCH c_get_task_name_and_number INTO l_task_name, l_task_number;
6588: CLOSE c_get_task_name_and_number ;
6589:

Line 6643: IF (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_id)='Y' AND iCounter.financial_task_flag='N' )

6639: OPEN c_get_task_id ( l_task_version_id , p_project_id );
6640: FETCH c_get_task_id INTO l_task_id;
6641: CLOSE c_get_task_id;
6642: --Check_is_financial_task will return 'Y' when data is there is PA_TASKS
6643: IF (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_id)='Y' AND iCounter.financial_task_flag='N' )
6644: THEN
6645: PA_TASKS_MAINT_PUB.DELETE_TASK
6646: (
6647: p_commit => p_commit

Line 6665: ELSIF (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_id)='N' AND iCounter.financial_task_flag='Y')

6661: THEN
6662: RAISE FND_API.G_EXC_ERROR;
6663: END IF;
6664:
6665: ELSIF (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_id)='N' AND iCounter.financial_task_flag='Y')
6666: THEN
6667: --Get the task id for the parent_task_version_id
6668: OPEN c_get_immediate_parent_task_id ( l_task_version_id , p_project_id );
6669: FETCH c_get_immediate_parent_task_id INTO l_parent_task_id;

Line 6671: --Get the task name from pa_proj_elements

6667: --Get the task id for the parent_task_version_id
6668: OPEN c_get_immediate_parent_task_id ( l_task_version_id , p_project_id );
6669: FETCH c_get_immediate_parent_task_id INTO l_parent_task_id;
6670: CLOSE c_get_immediate_parent_task_id;
6671: --Get the task name from pa_proj_elements
6672: OPEN c_get_task_name_number_frm_ver ( l_task_version_id, p_project_id );
6673: FETCH c_get_task_name_number_frm_ver INTO l_task_name, l_task_number;
6674: CLOSE c_get_task_name_number_frm_ver ;
6675: