APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_BUDGET_VERSIONS

Line 171: From pa_budget_versions bv

167: Into g_resource_list_id
168: ,g_rbs_version_id
169: ,g_project_id
170: ,g_budget_version_id
171: From pa_budget_versions bv
172: ,pa_proj_fp_options fp
173: Where bv.budget_version_id = p_budget_version_id
174: And fp.fin_plan_version_id (+) = bv.budget_version_id
175: and rownum = 1;

Line 184: From pa_budget_versions

180: print_msg(g_debug_flag,l_stage);
181: If p_budget_version_id is NOT NULL and p_project_id is NULL Then
182: Select NVL(p_project_id,project_id)
183: Into g_project_id
184: From pa_budget_versions
185: Where budget_version_id = p_budget_version_id;
186: Else
187: g_project_id := p_project_id;
188: End If;

Line 262: --,pa_budget_versions bv

258: decode(nvl(ra.incur_by_res_class_code,ra.resource_class_code),'EQUIPMENT',ra.bom_resource_id,NULL))
259: ,nvl(ra.incur_by_role_id,ra.project_role_id)
260: ,ra.person_type_code
261: FROM pa_resource_assignments ra
262: --,pa_budget_versions bv
263: --,pa_proj_fp_options fp
264: --,pa_expenditure_types et
265: --,pa_non_labor_resources nlr
266: --,pa_expenditure_categories ec

Line 523: l_struct_ver_id pa_budget_versions.project_structure_version_id%TYPE;

519: ,x_return_status OUT NOCOPY varchar2 ) IS
520:
521: l_NumRecInserted Number := 0;
522: l_stage Varchar2(1000);
523: l_struct_ver_id pa_budget_versions.project_structure_version_id%TYPE;
524:
525: CURSOR Cur_projStrVer IS
526: SELECT decode(nvl(wp_version_flag,'N'),
527: 'N',PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID( project_id ),

Line 529: FROM pa_budget_versions

525: CURSOR Cur_projStrVer IS
526: SELECT decode(nvl(wp_version_flag,'N'),
527: 'N',PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID( project_id ),
528: project_structure_version_id)
529: FROM pa_budget_versions
530: WHERE budget_version_id = p_budget_version_id;
531: l_uncategorized_flag VARCHAR2(1);
532: l_financial_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
533: BEGIN

Line 2607: FROM pa_budget_versions bv

2603: ,fp.proj_fp_options_id
2604: ,pp.segment1 project_name
2605: ,bv.version_name version_name
2606: ,fptyp.name plan_type_name
2607: FROM pa_budget_versions bv
2608: ,pa_proj_fp_options fp
2609: ,pji_pjp_proj_batch_map rbs
2610: ,pa_projects_all pp
2611: ,pa_fin_plan_types_tl fptyp

Line 2817: l_stage := 'Update pa_budget_versions with recordVerNum:BdgtVer['||i.budget_version_id||']';

2813: If l_return_status = 'S' Then
2814: /* update the budget version recod version nubmer, so that any changes in the rbs version related to
2815: * old budget version should be in synch with these changes
2816: */
2817: l_stage := 'Update pa_budget_versions with recordVerNum:BdgtVer['||i.budget_version_id||']';
2818: Print_msg(g_debug_flag,l_stage);
2819: UPDATE pa_budget_versions bv
2820: SET bv.record_version_number = nvl(bv.record_version_number,0) +1
2821: WHERE bv.budget_version_id = i.budget_version_id;

Line 2819: UPDATE pa_budget_versions bv

2815: * old budget version should be in synch with these changes
2816: */
2817: l_stage := 'Update pa_budget_versions with recordVerNum:BdgtVer['||i.budget_version_id||']';
2818: Print_msg(g_debug_flag,l_stage);
2819: UPDATE pa_budget_versions bv
2820: SET bv.record_version_number = nvl(bv.record_version_number,0) +1
2821: WHERE bv.budget_version_id = i.budget_version_id;
2822:
2823: End If;