APPS.PA_RLMI_RBS_MAP_PUB dependencies on PA_PPR_CONCURRENT_PROGRAM

Line 2895: --ANd fp.project_id = PA_ppr_concurrent_program.g_project_id -- Bug 16841995 - The templates should also be updated with the latest rbs_version_id

2891: ,pa_fin_plan_types_tl fptyp
2892: ,pa_rbs_versions_b rvb -- Added for Bug 6450168
2893: WHERE bv.budget_version_id (+) = fp.fin_plan_version_id
2894: AND nvl(bv.project_id,fp.project_id) = fp.project_id
2895: --ANd fp.project_id = PA_ppr_concurrent_program.g_project_id -- Bug 16841995 - The templates should also be updated with the latest rbs_version_id
2896: AND fp.project_id = pp.project_id
2897: AND fp.rbs_version_id = rvb.rbs_version_id -- Added for Bug 6450168
2898: AND rvb.rbs_header_id = PA_ppr_concurrent_program.g_rbs_header_id -- Added for Bug 6450168
2899: -- AND rbs.PROJECT_ACTIVE_FLAG = 'Y' --commented for bug 4579741

Line 2898: AND rvb.rbs_header_id = PA_ppr_concurrent_program.g_rbs_header_id -- Added for Bug 6450168

2894: AND nvl(bv.project_id,fp.project_id) = fp.project_id
2895: --ANd fp.project_id = PA_ppr_concurrent_program.g_project_id -- Bug 16841995 - The templates should also be updated with the latest rbs_version_id
2896: AND fp.project_id = pp.project_id
2897: AND fp.rbs_version_id = rvb.rbs_version_id -- Added for Bug 6450168
2898: AND rvb.rbs_header_id = PA_ppr_concurrent_program.g_rbs_header_id -- Added for Bug 6450168
2899: -- AND rbs.PROJECT_ACTIVE_FLAG = 'Y' --commented for bug 4579741
2900: -- AND rbs.WORKER_ID = p_worker_id
2901: AND fp.fin_plan_type_id = fptyp.fin_plan_type_id (+)
2902: AND NVL(fptyp.language,userenv('LANG')) = userenv('LANG')

Line 2971: IF PA_ppr_concurrent_program.g_project_id IS NULL THEN --OLAP

2967: l_stage := 'Begin of RBS_PUSH API: IN Param OldRbsVer['||p_old_rbs_version_id||']NewRbsVer['||p_new_rbs_version_id||']';
2968: Print_msg(g_debug_flag,l_stage,l_proc_name);
2969:
2970: /* this initializes the tmp table */
2971: IF PA_ppr_concurrent_program.g_project_id IS NULL THEN --OLAP
2972: l_worker_id := PJI_PJP_EXTRACTION_UTILS.GET_WORKER_ID;
2973:
2974: /* Added for Bug 6450168 - START */
2975: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(l_worker_id);

Line 2985: l_rbs_header_id := PA_ppr_concurrent_program.g_rbs_header_id;

2981: Raise Invalid_params;
2982: END If;
2983: ELSE
2984:
2985: l_rbs_header_id := PA_ppr_concurrent_program.g_rbs_header_id;
2986: If p_old_rbs_version_id is NULL OR p_new_rbs_version_id is NULL Then
2987: print_msg(g_debug_flag,'Invalid Params',l_proc_name);
2988: Raise Invalid_params;
2989: END If;

Line 3001: IF PA_ppr_concurrent_program.g_project_id IS NULL THEN -- OLAP

2997: * the rbs_element_id from the tmp table on proj_fp_options, budget versions, and resource assignments
2998: * table
2999: */
3000: l_prev_project_id := NULL;
3001: IF PA_ppr_concurrent_program.g_project_id IS NULL THEN -- OLAP
3002:
3003: FOR i IN cur_rbsVersions(l_worker_id,l_rbs_header_id) LOOP --{
3004: l_stage := 'Inside loop For Finplanlevel['||i.finplan_option_level||']Project['||i.project_id||']Bdgt['||i.budget_version_id||']';
3005: Print_msg(g_debug_flag,l_stage,l_proc_name);