DBA Data[Home] [Help]

APPS.PA_FP_AUTO_BASELINE_PKG dependencies on PA_BUDGET_VERSIONS

Line 15: ( p_project_id IN pa_budget_versions.project_id%TYPE

11:
12: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
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

Line 16: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

12: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
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

Line 18: ,p_version_name IN pa_budget_versions.version_name%TYPE

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
22: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL

Line 19: ,p_description IN pa_budget_versions.description%TYPE

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
22: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
23: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL

Line 22: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL

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
22: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
23: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
24: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
25: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
26: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL

Line 23: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL

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
22: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
23: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
24: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
25: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
26: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
27: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE -- FP.M

Line 24: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL

20: ,p_funding_bl_tab IN pa_fp_auto_baseline_pkg.funding_bl_tab
21: -- Start of additional columns for Bug :- 2634900
22: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
23: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
24: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
25: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
26: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
27: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE -- FP.M
28: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL

Line 25: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL

21: -- Start of additional columns for Bug :- 2634900
22: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
23: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
24: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
25: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
26: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
27: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE -- FP.M
28: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
29: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL

Line 26: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL

22: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
23: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
24: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
25: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
26: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
27: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE -- FP.M
28: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
29: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL
30: -- End of additional columns for Bug :- 2634900

Line 27: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE -- FP.M

23: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
24: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
25: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
26: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
27: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE -- FP.M
28: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
29: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL
30: -- End of additional columns for Bug :- 2634900
31: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895

Line 29: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL

25: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
26: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
27: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE -- FP.M
28: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
29: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL
30: -- End of additional columns for Bug :- 2634900
31: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
32: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
33: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 31: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895

27: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE -- FP.M
28: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
29: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL
30: -- End of additional columns for Bug :- 2634900
31: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
32: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
33: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
34: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
35: AS

Line 55: l_baselined_version_id pa_budget_versions.budget_version_id%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;
59:

Line 56: l_record_version_number pa_budget_versions.record_version_number%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;
59:
60: l_fp_mc_cols pa_proj_fp_options_pub.FP_MC_COLS;

Line 57: l_orig_record_version_number pa_budget_versions.record_version_number%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;
59:
60: l_fp_mc_cols pa_proj_fp_options_pub.FP_MC_COLS;
61:

Line 58: l_created_version_id pa_budget_versions.budget_version_id%TYPE;

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;
59:
60: l_fp_mc_cols pa_proj_fp_options_pub.FP_MC_COLS;
61:
62: