APPS.PA_FP_AUTO_BASELINE_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 17: ,p_funding_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

13:
14: PROCEDURE CREATE_BASELINED_VERSION
15: ( p_project_id IN pa_budget_versions.project_id%TYPE
16: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
17: ,p_funding_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
18: ,p_version_name IN pa_budget_versions.version_name%TYPE
19: ,p_description IN pa_budget_versions.description%TYPE
20: ,p_funding_bl_tab IN pa_fp_auto_baseline_pkg.funding_bl_tab
21: -- Start of additional columns for Bug :- 2634900

Line 40: l_uncateg_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;

36: -- Bug Fix: 4569365. Removed MRC code.
37: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE; /* Bug# 2674353 */
38: l_calling_context VARCHAR2(30) ;
39:
40: l_uncateg_resource_list_id pa_proj_fp_options.cost_resource_list_id%TYPE;
41: l_uncateg_rlm_id pa_resource_assignments.resource_list_member_id%TYPE;
42: l_uncateg_resource_id pa_resource_list_members.resource_id%TYPE;
43: l_uncateg_trk_as_labor_flg pa_resource_list_members.track_as_labor_flag%TYPE;
44: l_err_code pa_debug.G_Err_Code%TYPE;

Line 47: l_plan_in_mc_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

43: l_uncateg_trk_as_labor_flg pa_resource_list_members.track_as_labor_flag%TYPE;
44: l_err_code pa_debug.G_Err_Code%TYPE;
45: l_err_stage pa_debug.g_err_stage%TYPE;
46:
47: l_plan_in_mc_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
48: l_budget_lines_tab pa_fin_plan_pvt.budget_lines_tab;
49:
50: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
51: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

Line 54: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

50: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
51: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
52: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
53:
54: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
55: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
56: l_record_version_number pa_budget_versions.record_version_number%TYPE;
57: l_orig_record_version_number pa_budget_versions.record_version_number%TYPE;
58: l_created_version_id pa_budget_versions.budget_version_id%TYPE;

Line 60: l_fp_mc_cols pa_proj_fp_options_pub.FP_MC_COLS;

56: l_record_version_number pa_budget_versions.record_version_number%TYPE;
57: l_orig_record_version_number pa_budget_versions.record_version_number%TYPE;
58: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
59:
60: l_fp_mc_cols pa_proj_fp_options_pub.FP_MC_COLS;
61:
62:
63: l_msg_count NUMBER := 0;
64: l_data VARCHAR2(2000);

Line 184: l_fp_options_id := pa_proj_fp_options_pub.get_fp_option_id( p_project_id => p_project_id

180: IF P_PA_DEBUG_MODE = 'Y' THEN
181: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
182: END IF;
183:
184: l_fp_options_id := pa_proj_fp_options_pub.get_fp_option_id( p_project_id => p_project_id
185: ,p_plan_type_id => p_fin_plan_type_id
186: ,p_plan_version_id => NULL );
187:
188: pa_debug.g_err_stage:= 'plan type option id is ' || l_fp_options_id;

Line 193: l_fp_mc_cols := pa_proj_fp_options_pub.Get_FP_Proj_Mc_Options(p_proj_fp_options_id => l_fp_options_id);

189: IF P_PA_DEBUG_MODE = 'Y' THEN
190: pa_debug.write('CREATE_BASELINED_VERSION: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
191: END IF;
192:
193: l_fp_mc_cols := pa_proj_fp_options_pub.Get_FP_Proj_Mc_Options(p_proj_fp_options_id => l_fp_options_id);
194:
195:
196: pa_debug.g_err_stage:= 'Prepare the budget lines tab from funding lines tab';
197: IF P_PA_DEBUG_MODE = 'Y' THEN