APPS.PA_TASKS_MAINT_PVT dependencies on PA_PROJ_ELEMENTS

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 6504: pa_proj_elements

6500: IS
6501: SELECT
6502: name, element_number
6503: FROM
6504: pa_proj_elements
6505: WHERE
6506: proj_element_id = l_element_id
6507: AND
6508: project_id = l_project_id;

Line 6537: pa_proj_elements elements

6533: elements.name
6534: , elements.element_number
6535:
6536: FROM
6537: pa_proj_elements elements
6538: , pa_proj_element_versions elever
6539: WHERE
6540: elever.element_version_id = l_element_version_id
6541: AND

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 6684: --Get the task name from pa_proj_elements

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;
6683: CLOSE c_get_task_id;
6684: --Get the task name from pa_proj_elements
6685: OPEN c_get_task_name_and_number ( l_task_id , p_project_id );
6686: FETCH c_get_task_name_and_number INTO l_task_name, l_task_number;
6687: CLOSE c_get_task_name_and_number ;
6688:

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;

Line 6770: --Get the task name from pa_proj_elements

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;
6769: CLOSE c_get_immediate_parent_task_id;
6770: --Get the task name from pa_proj_elements
6771: OPEN c_get_task_name_number_frm_ver ( l_task_version_id, p_project_id );
6772: FETCH c_get_task_name_number_frm_ver INTO l_task_name, l_task_number;
6773: CLOSE c_get_task_name_number_frm_ver ;
6774: