DBA Data[Home] [Help]

APPS.PA_FP_UPGRADE_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 17: ,curr_option_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE

13: ,basis_cost_time_phased_code pa_budget_entry_methods.time_phased_type_code%TYPE
14: ,basis_rev_time_phased_code pa_budget_entry_methods.time_phased_type_code%TYPE
15: ,basis_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE
16: ,basis_rev_amount_Set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE
17: ,curr_option_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE
18: ,curr_option_project_id pa_proj_fp_options.project_id%TYPE
19: ,curr_option_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE
20: ,curr_option_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE
21: ,curr_option_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE

Line 18: ,curr_option_project_id pa_proj_fp_options.project_id%TYPE

14: ,basis_rev_time_phased_code pa_budget_entry_methods.time_phased_type_code%TYPE
15: ,basis_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE
16: ,basis_rev_amount_Set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE
17: ,curr_option_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE
18: ,curr_option_project_id pa_proj_fp_options.project_id%TYPE
19: ,curr_option_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE
20: ,curr_option_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE
21: ,curr_option_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE
22: ,curr_option_budget_type_code pa_budget_versions.budget_type_code%TYPE

Line 19: ,curr_option_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE

15: ,basis_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE
16: ,basis_rev_amount_Set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE
17: ,curr_option_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE
18: ,curr_option_project_id pa_proj_fp_options.project_id%TYPE
19: ,curr_option_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE
20: ,curr_option_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE
21: ,curr_option_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE
22: ,curr_option_budget_type_code pa_budget_versions.budget_type_code%TYPE
23: );

Line 20: ,curr_option_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE

16: ,basis_rev_amount_Set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE
17: ,curr_option_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE
18: ,curr_option_project_id pa_proj_fp_options.project_id%TYPE
19: ,curr_option_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE
20: ,curr_option_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE
21: ,curr_option_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE
22: ,curr_option_budget_type_code pa_budget_versions.budget_type_code%TYPE
23: );
24:

Line 21: ,curr_option_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE

17: ,curr_option_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE
18: ,curr_option_project_id pa_proj_fp_options.project_id%TYPE
19: ,curr_option_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE
20: ,curr_option_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE
21: ,curr_option_level_code pa_proj_fp_options.fin_plan_option_level_code%TYPE
22: ,curr_option_budget_type_code pa_budget_versions.budget_type_code%TYPE
23: );
24:
25: Procedure Populate_Local_Variables(

Line 26: p_project_id IN pa_proj_fp_options.project_id%TYPE

22: ,curr_option_budget_type_code pa_budget_versions.budget_type_code%TYPE
23: );
24:
25: Procedure Populate_Local_Variables(
26: p_project_id IN pa_proj_fp_options.project_id%TYPE
27: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
28: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
29: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE
30: ,x_upgrade_elements_rec OUT NOCOPY pa_fp_upgrade_pkg.upgrade_elements_rec_type

Line 28: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE

24:
25: Procedure Populate_Local_Variables(
26: p_project_id IN pa_proj_fp_options.project_id%TYPE
27: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
28: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
29: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE
30: ,x_upgrade_elements_rec OUT NOCOPY pa_fp_upgrade_pkg.upgrade_elements_rec_type
31: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 29: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE

25: Procedure Populate_Local_Variables(
26: p_project_id IN pa_proj_fp_options.project_id%TYPE
27: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
28: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
29: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE
30: ,x_upgrade_elements_rec OUT NOCOPY pa_fp_upgrade_pkg.upgrade_elements_rec_type
31: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
33: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 53: p_project_id IN pa_proj_fp_options.project_id%TYPE

49: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
50: ,x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
51:
52: PROCEDURE Create_fp_options(
53: p_project_id IN pa_proj_fp_options.project_id%TYPE
54: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
55: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
56: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE
57: ,x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895

Line 55: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE

51:
52: PROCEDURE Create_fp_options(
53: p_project_id IN pa_proj_fp_options.project_id%TYPE
54: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
55: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
56: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE
57: ,x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
58: ,x_upgrade_elements_rec OUT NOCOPY pa_fp_upgrade_pkg.upgrade_elements_rec_type
59: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 56: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE

52: PROCEDURE Create_fp_options(
53: p_project_id IN pa_proj_fp_options.project_id%TYPE
54: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
55: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
56: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE
57: ,x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
58: ,x_upgrade_elements_rec OUT NOCOPY pa_fp_upgrade_pkg.upgrade_elements_rec_type
59: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
60: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 57: ,x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895

53: p_project_id IN pa_proj_fp_options.project_id%TYPE
54: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
55: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
56: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE
57: ,x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
58: ,x_upgrade_elements_rec OUT NOCOPY pa_fp_upgrade_pkg.upgrade_elements_rec_type
59: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
60: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
61: ,x_msg_data OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895

Line 134: ( p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE

130: -- bug 5144013: added a new Added a new IN parameter p_calling_module in the
131: -- with a default value of 'UI_FLOW'.
132:
133: PROCEDURE Apply_Calculate_FPM_Rules
134: ( p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
135: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
136: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
137: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
138: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type