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.

[Home] [Help]

APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_PROJ_FP_OPTIONS

Line 174: ,pa_proj_fp_options fp

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

Line 297: --,pa_proj_fp_options fp

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

Line 2858: ,pa_proj_fp_options fp

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

Line 2888: ,pa_proj_fp_options fp

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

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

3007: l_msg_count := Null;
3008: l_msg_data := Null;
3009:
3010: /* Bug fix: 3977666 As discussed with Vijay Ranganathan, The proj fp options must be updated first and then
3011: * to call the RBS mapping api. So moving the code of updating pa_proj_fp_options at end to first */
3012: /* once all the mapping is done for the project update the fp options at plan Type and project level and version level
3013: */
3014: l_stage := 'Update pa proj fp options with RBS details: FpOptionId['||i.proj_fp_options_id||']BdgtVer['||i.budget_version_id||']';
3015: Print_msg(g_debug_flag,l_stage,l_proc_name);

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

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

Line 3016: UPDATE pa_proj_fp_options fp

3012: /* once all the mapping is done for the project update the fp options at plan Type and project level and version level
3013: */
3014: l_stage := 'Update pa proj fp options with RBS details: FpOptionId['||i.proj_fp_options_id||']BdgtVer['||i.budget_version_id||']';
3015: Print_msg(g_debug_flag,l_stage,l_proc_name);
3016: UPDATE pa_proj_fp_options fp
3017: SET fp.rbs_version_id = p_new_rbs_version_id
3018: ,fp.record_version_number = nvl(fp.record_version_number,0) +1
3019: WHERE fp.project_id = i.Project_id
3020: --AND fp.rbs_version_id = p_old_rbs_version_id -- Commented for Bug 6450168

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

3125: l_msg_count := Null;
3126: l_msg_data := Null;
3127:
3128: /* Bug fix: 3977666 As discussed with Vijay Ranganathan, The proj fp options must be updated first and then
3129: * to call the RBS mapping api. So moving the code of updating pa_proj_fp_options at end to first */
3130: /* once all the mapping is done for the project update the fp options at plan Type and project level and version level
3131: */
3132: l_stage := 'Update pa proj fp options with RBS details: FpOptionId['||i.proj_fp_options_id||']BdgtVer['||i.budget_version_id||']';
3133: Print_msg(g_debug_flag,l_stage,l_proc_name);

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

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

Line 3134: UPDATE pa_proj_fp_options fp

3130: /* once all the mapping is done for the project update the fp options at plan Type and project level and version level
3131: */
3132: l_stage := 'Update pa proj fp options with RBS details: FpOptionId['||i.proj_fp_options_id||']BdgtVer['||i.budget_version_id||']';
3133: Print_msg(g_debug_flag,l_stage,l_proc_name);
3134: UPDATE pa_proj_fp_options fp
3135: SET fp.rbs_version_id = p_new_rbs_version_id
3136: ,fp.record_version_number = nvl(fp.record_version_number,0) +1
3137: WHERE fp.project_id = i.Project_id
3138: --AND fp.rbs_version_id = p_old_rbs_version_id -- Commented for Bug 6450168