APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_BUDGET_VERSIONS

Line 173: From pa_budget_versions bv

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

Line 186: From pa_budget_versions

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

Line 296: --,pa_budget_versions bv

292: decode(nvl(ra.incur_by_res_class_code,ra.resource_class_code),'EQUIPMENT',ra.bom_resource_id,NULL))
293: ,nvl(ra.incur_by_role_id,ra.project_role_id)
294: ,ra.person_type_code
295: FROM pa_resource_assignments ra
296: --,pa_budget_versions bv
297: --,pa_proj_fp_options fp
298: --,pa_expenditure_types et
299: --,pa_non_labor_resources nlr
300: --,pa_expenditure_categories ec

Line 714: l_struct_ver_id pa_budget_versions.project_structure_version_id%TYPE;

710: ,x_return_status OUT NOCOPY varchar2 ) IS
711:
712: l_NumRecInserted Number := 0;
713: l_stage Varchar2(1000);
714: l_struct_ver_id pa_budget_versions.project_structure_version_id%TYPE;
715:
716: CURSOR Cur_projStrVer IS
717: SELECT decode(nvl(wp_version_flag,'N'),
718: 'N',PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID( project_id ),

Line 720: FROM pa_budget_versions

716: CURSOR Cur_projStrVer IS
717: SELECT decode(nvl(wp_version_flag,'N'),
718: 'N',PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID( project_id ),
719: project_structure_version_id)
720: FROM pa_budget_versions
721: WHERE budget_version_id = p_budget_version_id;
722: l_uncategorized_flag VARCHAR2(1);
723: l_financial_res_class_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
724: BEGIN

Line 2857: FROM pa_budget_versions bv

2853: ,fp.proj_fp_options_id
2854: ,pp.segment1 project_name
2855: ,bv.version_name version_name
2856: ,fptyp.name plan_type_name
2857: FROM pa_budget_versions bv
2858: ,pa_proj_fp_options fp
2859: -- ,pji_pjp_proj_batch_map rbs -- Bug 16841995 - The templates should also be updated with the latest rbs_version_id
2860: ,pa_projects_all pp
2861: ,pa_fin_plan_types_tl fptyp

Line 2887: FROM pa_budget_versions bv

2883: ,fp.proj_fp_options_id
2884: ,pp.segment1 project_name
2885: ,bv.version_name version_name
2886: ,fptyp.name plan_type_name
2887: FROM pa_budget_versions bv
2888: ,pa_proj_fp_options fp
2889: --,pji_pjp_proj_batch_map rbs
2890: ,pa_projects_all pp
2891: ,pa_fin_plan_types_tl fptyp

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

3105: If l_return_status = 'S' Then
3106: /* update the budget version recod version nubmer, so that any changes in the rbs version related to
3107: * old budget version should be in synch with these changes
3108: */
3109: l_stage := 'Update pa_budget_versions with recordVerNum:BdgtVer['||i.budget_version_id||']';
3110: Print_msg(g_debug_flag,l_stage);
3111: UPDATE pa_budget_versions bv
3112: SET bv.record_version_number = nvl(bv.record_version_number,0) +1
3113: WHERE bv.budget_version_id = i.budget_version_id;

Line 3111: UPDATE pa_budget_versions bv

3107: * old budget version should be in synch with these changes
3108: */
3109: l_stage := 'Update pa_budget_versions with recordVerNum:BdgtVer['||i.budget_version_id||']';
3110: Print_msg(g_debug_flag,l_stage);
3111: UPDATE pa_budget_versions bv
3112: SET bv.record_version_number = nvl(bv.record_version_number,0) +1
3113: WHERE bv.budget_version_id = i.budget_version_id;
3114:
3115: End If;

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

3223: If l_return_status = 'S' Then
3224: /* update the budget version recod version nubmer, so that any changes in the rbs version related to
3225: * old budget version should be in synch with these changes
3226: */
3227: l_stage := 'Update pa_budget_versions with recordVerNum:BdgtVer['||i.budget_version_id||']';
3228: Print_msg(g_debug_flag,l_stage);
3229: UPDATE pa_budget_versions bv
3230: SET bv.record_version_number = nvl(bv.record_version_number,0) +1
3231: WHERE bv.budget_version_id = i.budget_version_id;

Line 3229: UPDATE pa_budget_versions bv

3225: * old budget version should be in synch with these changes
3226: */
3227: l_stage := 'Update pa_budget_versions with recordVerNum:BdgtVer['||i.budget_version_id||']';
3228: Print_msg(g_debug_flag,l_stage);
3229: UPDATE pa_budget_versions bv
3230: SET bv.record_version_number = nvl(bv.record_version_number,0) +1
3231: WHERE bv.budget_version_id = i.budget_version_id;
3232:
3233: End If;