APPS.PA_BUDGET_ATTR_UPGR_PKG dependencies on PA_BUDGET_VERSIONS

Line 6: , p_budget_version_id IN pa_budget_versions.budget_version_id%type

2: /* $Header: PABDGATB.pls 120.0 2005/05/30 11:28:12 appldev noship $ */
3:
4: procedure BUDGET_ATTR_UPGRD(
5: P_PROJECT_ID IN pa_projects_all.project_id%type
6: , p_budget_version_id IN pa_budget_versions.budget_version_id%type
7: , X_RETURN_STATUS OUT NOCOPY VARCHAR2
8: , X_MSG_COUNT OUT NOCOPY NUMBER
9: , X_MSG_DATA OUT NOCOPY VARCHAR2) IS
10:

Line 14: , c_budget_version_id pa_budget_versions.budget_version_id%type) is

10:
11: --Bug 4185180.Given a budget version id as parameter the cursor should bring the PLAN_VERSION, PLAN_TYPE level records for that
12: -- project and budget version.
13: cursor get_fin_plan_ver_csr(c_project_id pa_projects_all.project_id%type
14: , c_budget_version_id pa_budget_versions.budget_version_id%type) is
15: select proj_fp_options_id,fin_plan_version_id,pfo.project_id,
16: fin_plan_option_level_code,cost_time_phased_code,fin_plan_preference_code preference_code,
17: revenue_time_phased_code,all_time_phased_code,cost_period_mask_id,
18: rev_period_mask_id,all_period_mask_id,decode(revenue_time_phased_code,'G',1,'P',2,

Line 23: ,pa_budget_versions pbv

19: decode(cost_time_phased_code,'G',1,'P',2,
20: decode(all_time_phased_code,'G',1,'P',2,null))) time_phased_code,
21: decode(all_resource_list_id,null,decode(cost_resource_list_id,null,revenue_resource_list_id,cost_resource_list_id),all_resource_list_id) resource_list_id
22: from pa_proj_fp_options pfo
23: ,pa_budget_versions pbv
24: where pfo.project_id = c_project_id
25: and pbv.budget_version_id=c_budget_version_id
26: and (fin_plan_version_id = c_budget_version_id OR
27: (pfo.project_id = p_project_id AND

Line 62: l_curr_plan_period pa_budget_versions.current_planning_period%type;

58: index by binary_integer;
59: l_get_rbs_ver_tbl get_rbs_ver_tbl;
60:
61: l_period_mask_id pa_period_masks_b.period_mask_id%type;
62: l_curr_plan_period pa_budget_versions.current_planning_period%type;
63: l_curr_plan_period_b pa_budget_versions.current_planning_period%type;
64: l_rbs_version_id pa_resource_lists_all_bg.migrated_rbs_version_id%type;
65: l_cost_current_planning_period pa_proj_fp_options.cost_current_planning_period%type;
66: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;

Line 63: l_curr_plan_period_b pa_budget_versions.current_planning_period%type;

59: l_get_rbs_ver_tbl get_rbs_ver_tbl;
60:
61: l_period_mask_id pa_period_masks_b.period_mask_id%type;
62: l_curr_plan_period pa_budget_versions.current_planning_period%type;
63: l_curr_plan_period_b pa_budget_versions.current_planning_period%type;
64: l_rbs_version_id pa_resource_lists_all_bg.migrated_rbs_version_id%type;
65: l_cost_current_planning_period pa_proj_fp_options.cost_current_planning_period%type;
66: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%type;
67: l_rev_current_planning_period pa_proj_fp_options.rev_current_planning_period%type;

Line 427: pa_debug.g_err_stage := 'Update Pa_Budget_versions Table.';

423: IF l_get_fin_plan_ver_csr.fin_plan_option_level_code = 'PLAN_VERSION' THEN
424:
425: -- Update budget version table with the above values
426: IF l_debug_mode = 'Y' THEN
427: pa_debug.g_err_stage := 'Update Pa_Budget_versions Table.';
428: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
429: end if;
430:
431: update pa_budget_versions

Line 431: update pa_budget_versions

427: pa_debug.g_err_stage := 'Update Pa_Budget_versions Table.';
428: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
429: end if;
430:
431: update pa_budget_versions
432: set project_structure_version_id = NULL,
433: object_type_code = 'PROJECT',
434: object_id = l_get_fin_plan_ver_csr.project_id,
435: pji_summarized_flag = 'N',