DBA Data[Home] [Help]

APPS.PA_TASKS_MAINT_PVT dependencies on PA_PROJ_ELEMENTS_UTILS

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 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 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;