APPS.PA_FIN_PLAN_UTILS dependencies on PA_PROJECT_STRUCTURE_UTILS

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

10401: l_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
10402:
10403: BEGIN
10404: /* Commented and modified for bug#5614245
10405: SELECT NVL(project_structure_version_id, PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(project_id )) */
10406: SELECT NVL(project_structure_version_id, pa_planning_element_utils.get_fin_struct_id(project_id, budget_version_id) )
10407: INTO l_structure_version_id
10408: FROM pa_budget_versions
10409: WHERE budget_Version_id=p_budget_version_id;

Line 10606: IF (PA_PROJECT_STRUCTURE_UTILS.check_proj_progress_exist

10602: OPEN get_wp_id;
10603: FETCH get_wp_id into l_structure_id;
10604: CLOSE get_wp_id;
10605:
10606: IF (PA_PROJECT_STRUCTURE_UTILS.check_proj_progress_exist
10607: (p_project_id, l_structure_id, 'WORKPLAN') = 'Y') -- Added a new parameter while calling 'check_proj_progress_exist' for the BUG 6914708
10608: THEN
10609: l_progress_exists := 'Y';
10610: ELSE

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

10612: LOOP
10613: FETCH get_tasks INTO l_task_id;
10614: EXIT WHEN get_tasks%NOTFOUND;
10615:
10616: IF (PA_PROJECT_STRUCTURE_UTILS.check_task_progress_exist(l_task_id) = 'Y')
10617: THEN
10618: l_progress_exists := 'Y';
10619: EXIT;
10620: END IF;

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

13081: pa_debug.write(l_module_name, pa_debug.g_err_stage, l_debug_level3);
13082: END IF;
13083:
13084: x_struct_version_id := pa_planning_element_utils.get_fin_struct_id(l_project_id,p_budget_version_id);
13085: x_struct_status_flag := PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(l_project_id, x_struct_version_id);
13086:
13087: IF l_debug_mode = 'Y' THEN
13088: pa_debug.g_err_stage := 'Values returned->';
13089: pa_debug.write(l_module_name, pa_debug.g_err_stage, l_debug_level3);