DBA Data[Home] [Help]

APPS.PA_TASKS_MAINT_PVT dependencies on PA_PROJ_ELEMENTS_UTILS

Line 6251: PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_HAS_TRANSACTION

6247: -- CLOSE c_task_exists_in_pa_tasks ;
6248:
6249: -- IF NVL(l_task_exists,'N') ='Y' THEN -- Bug 3735089
6250: --Check if the task has any transaction associated with it
6251: PA_PROJ_ELEMENTS_UTILS.CHECK_TASK_HAS_TRANSACTION
6252: (
6253: p_task_id => l_task_id
6254: , p_project_id => p_project_id -- Added for Performance fix 4903460
6255: , x_return_status => x_return_status

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

6637:
6638: OPEN c_get_task_id ( p_task_version_id , p_project_id );
6639: FETCH c_get_task_id INTO l_task_id;
6640: CLOSE c_get_task_id;
6641: IF (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_id)='Y')
6642: THEN
6643:
6644:
6645: PA_TASKS_MAINT_PUB.DELETE_TASK

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

6674: (
6675: p_project_id => p_project_id
6676: ,p_task_id => l_task_id
6677: );
6678: IF (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_id)='N')
6679: THEN
6680: --Get the task id for the parent_task_version_id
6681: OPEN c_get_task_id ( p_parent_task_version_id , p_project_id );
6682: FETCH c_get_task_id INTO l_parent_task_id;

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

6738: OPEN c_get_task_id ( l_task_version_id , p_project_id );
6739: FETCH c_get_task_id INTO l_task_id;
6740: CLOSE c_get_task_id;
6741: --Check_is_financial_task will return 'Y' when data is there is PA_TASKS
6742: IF (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_id)='Y' AND iCounter.financial_task_flag='N' )
6743: THEN
6744: PA_TASKS_MAINT_PUB.DELETE_TASK
6745: (
6746: p_commit => p_commit

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

6760: THEN
6761: RAISE FND_API.G_EXC_ERROR;
6762: END IF;
6763:
6764: ELSIF (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_task_id)='N' AND iCounter.financial_task_flag='Y')
6765: THEN
6766: --Get the task id for the parent_task_version_id
6767: OPEN c_get_immediate_parent_task_id ( l_task_version_id , p_project_id );
6768: FETCH c_get_immediate_parent_task_id INTO l_parent_task_id;