eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_PROJ_FP_OPTIONS

Line 172: ,pa_proj_fp_options fp

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;
176: End If;

Line 263: --,pa_proj_fp_options fp

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
267: --,pa_event_types ev

Line 2608: ,pa_proj_fp_options fp

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
2612: ,pa_rbs_versions_b rvb -- Added for Bug 6450168

Line 2719: * to call the RBS mapping api. So moving the code of updating pa_proj_fp_options at end to first */

2715: l_msg_count := Null;
2716: l_msg_data := Null;
2717:
2718: /* Bug fix: 3977666 As discussed with Vijay Ranganathan, The proj fp options must be updated first and then
2719: * to call the RBS mapping api. So moving the code of updating pa_proj_fp_options at end to first */
2720: /* once all the mapping is done for the project update the fp options at plan Type and project level and version level
2721: */
2722: l_stage := 'Update pa proj fp options with RBS details: FpOptionId['||i.proj_fp_options_id||']BdgtVer['||i.budget_version_id||']';
2723: Print_msg(g_debug_flag,l_stage,l_proc_name);

Line 2722: l_stage := 'Update pa proj fp options with RBS details: FpOptionId['||i.proj_fp_options_id||']BdgtVer['||i.budget_version_id||']';

2718: /* Bug fix: 3977666 As discussed with Vijay Ranganathan, The proj fp options must be updated first and then
2719: * to call the RBS mapping api. So moving the code of updating pa_proj_fp_options at end to first */
2720: /* once all the mapping is done for the project update the fp options at plan Type and project level and version level
2721: */
2722: l_stage := 'Update pa proj fp options with RBS details: FpOptionId['||i.proj_fp_options_id||']BdgtVer['||i.budget_version_id||']';
2723: Print_msg(g_debug_flag,l_stage,l_proc_name);
2724: UPDATE pa_proj_fp_options fp
2725: SET fp.rbs_version_id = p_new_rbs_version_id
2726: ,fp.record_version_number = nvl(fp.record_version_number,0) +1

Line 2724: UPDATE pa_proj_fp_options fp

2720: /* once all the mapping is done for the project update the fp options at plan Type and project level and version level
2721: */
2722: l_stage := 'Update pa proj fp options with RBS details: FpOptionId['||i.proj_fp_options_id||']BdgtVer['||i.budget_version_id||']';
2723: Print_msg(g_debug_flag,l_stage,l_proc_name);
2724: UPDATE pa_proj_fp_options fp
2725: SET fp.rbs_version_id = p_new_rbs_version_id
2726: ,fp.record_version_number = nvl(fp.record_version_number,0) +1
2727: WHERE fp.project_id = i.Project_id
2728: --AND fp.rbs_version_id = p_old_rbs_version_id -- Commented for Bug 6450168