DBA Data[Home] [Help]

APPS.PA_FP_AUTO_BASELINE_PKG dependencies on PA_BUDGET_VERSIONS

Line 27: ( p_project_id IN pa_budget_versions.project_id%TYPE

23: /* PLSQL Table Types */
24:
25:
26: PROCEDURE CREATE_BASELINED_VERSION
27: ( p_project_id IN pa_budget_versions.project_id%TYPE
28: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
29: ,p_funding_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
30: ,p_version_name IN pa_budget_versions.version_name%TYPE
31: ,p_description IN pa_budget_versions.description%TYPE

Line 28: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

24:
25:
26: PROCEDURE CREATE_BASELINED_VERSION
27: ( p_project_id IN pa_budget_versions.project_id%TYPE
28: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
29: ,p_funding_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
30: ,p_version_name IN pa_budget_versions.version_name%TYPE
31: ,p_description IN pa_budget_versions.description%TYPE
32: ,p_funding_bl_tab IN pa_fp_auto_baseline_pkg.funding_bl_tab

Line 30: ,p_version_name IN pa_budget_versions.version_name%TYPE

26: PROCEDURE CREATE_BASELINED_VERSION
27: ( p_project_id IN pa_budget_versions.project_id%TYPE
28: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
29: ,p_funding_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
30: ,p_version_name IN pa_budget_versions.version_name%TYPE
31: ,p_description IN pa_budget_versions.description%TYPE
32: ,p_funding_bl_tab IN pa_fp_auto_baseline_pkg.funding_bl_tab
33: -- Start of additional columns for Bug :- 2634900
34: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL

Line 31: ,p_description IN pa_budget_versions.description%TYPE

27: ( p_project_id IN pa_budget_versions.project_id%TYPE
28: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
29: ,p_funding_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
30: ,p_version_name IN pa_budget_versions.version_name%TYPE
31: ,p_description IN pa_budget_versions.description%TYPE
32: ,p_funding_bl_tab IN pa_fp_auto_baseline_pkg.funding_bl_tab
33: -- Start of additional columns for Bug :- 2634900
34: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
35: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL

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

30: ,p_version_name IN pa_budget_versions.version_name%TYPE
31: ,p_description IN pa_budget_versions.description%TYPE
32: ,p_funding_bl_tab IN pa_fp_auto_baseline_pkg.funding_bl_tab
33: -- Start of additional columns for Bug :- 2634900
34: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
35: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
36: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
37: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
38: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL

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

31: ,p_description IN pa_budget_versions.description%TYPE
32: ,p_funding_bl_tab IN pa_fp_auto_baseline_pkg.funding_bl_tab
33: -- Start of additional columns for Bug :- 2634900
34: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
35: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
36: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
37: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
38: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
39: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL -- FP.M

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

32: ,p_funding_bl_tab IN pa_fp_auto_baseline_pkg.funding_bl_tab
33: -- Start of additional columns for Bug :- 2634900
34: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
35: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
36: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
37: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
38: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
39: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL -- FP.M
40: ,p_impacted_task_id IN pa_tasks.task_id%TYPE := NULL

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

33: -- Start of additional columns for Bug :- 2634900
34: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
35: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
36: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
37: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
38: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
39: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL -- FP.M
40: ,p_impacted_task_id IN pa_tasks.task_id%TYPE := NULL
41: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE := NULL

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

34: ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
35: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
36: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
37: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
38: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
39: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL -- FP.M
40: ,p_impacted_task_id IN pa_tasks.task_id%TYPE := NULL
41: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE := NULL
42: -- End of additional columns for Bug :- 2634900

Line 39: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL -- FP.M

35: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
36: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
37: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
38: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
39: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL -- FP.M
40: ,p_impacted_task_id IN pa_tasks.task_id%TYPE := NULL
41: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE := NULL
42: -- End of additional columns for Bug :- 2634900
43: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895

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

37: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
38: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
39: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL -- FP.M
40: ,p_impacted_task_id IN pa_tasks.task_id%TYPE := NULL
41: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE := NULL
42: -- End of additional columns for Bug :- 2634900
43: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
44: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
45: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

39: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL -- FP.M
40: ,p_impacted_task_id IN pa_tasks.task_id%TYPE := NULL
41: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE := NULL
42: -- End of additional columns for Bug :- 2634900
43: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
44: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
45: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
46: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
47: