APPS.PA_FIN_PLAN_UTILS dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 10411: SELECT NVL(project_structure_version_id, PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(project_id )) */

10407: l_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
10408:
10409: BEGIN
10410: /* Commented and modified for bug#5614245
10411: SELECT NVL(project_structure_version_id, PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(project_id )) */
10412: SELECT NVL(project_structure_version_id, pa_planning_element_utils.get_fin_struct_id(project_id, budget_version_id) )
10413: INTO l_structure_version_id
10414: FROM pa_budget_versions
10415: WHERE budget_Version_id=p_budget_version_id;

Line 10612: IF (PA_PROJECT_STRUCTURE_UTILS.check_proj_progress_exist

10608: OPEN get_wp_id;
10609: FETCH get_wp_id into l_structure_id;
10610: CLOSE get_wp_id;
10611:
10612: IF (PA_PROJECT_STRUCTURE_UTILS.check_proj_progress_exist
10613: (p_project_id, l_structure_id, 'WORKPLAN') = 'Y') -- Added a new parameter while calling 'check_proj_progress_exist' for the BUG 6914708
10614: THEN
10615: l_progress_exists := 'Y';
10616: ELSE

Line 10622: IF (PA_PROJECT_STRUCTURE_UTILS.check_task_progress_exist(l_task_id) = 'Y')

10618: LOOP
10619: FETCH get_tasks INTO l_task_id;
10620: EXIT WHEN get_tasks%NOTFOUND;
10621:
10622: IF (PA_PROJECT_STRUCTURE_UTILS.check_task_progress_exist(l_task_id) = 'Y')
10623: THEN
10624: l_progress_exists := 'Y';
10625: EXIT;
10626: END IF;

Line 13091: x_struct_status_flag := PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(l_project_id, x_struct_version_id);

13087: pa_debug.write(l_module_name, pa_debug.g_err_stage, l_debug_level3);
13088: END IF;
13089:
13090: x_struct_version_id := pa_planning_element_utils.get_fin_struct_id(l_project_id,p_budget_version_id);
13091: x_struct_status_flag := PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(l_project_id, x_struct_version_id);
13092:
13093: IF l_debug_mode = 'Y' THEN
13094: pa_debug.g_err_stage := 'Values returned->';
13095: pa_debug.write(l_module_name, pa_debug.g_err_stage, l_debug_level3);