eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_UPGRADE_PKG dependencies on PA_BUDGET_VERSIONS

Line 5: basis_cost_version_id pa_budget_versions.budget_version_id%TYPE

1: PACKAGE pa_fp_upgrade_pkg AS
2: /* $Header: PAFPUPGS.pls 120.3 2007/02/06 10:12:49 dthakker ship $ */
3:
4: TYPE upgrade_elements_rec_type IS RECORD (
5: basis_cost_version_id pa_budget_versions.budget_version_id%TYPE
6: ,basis_rev_version_id pa_budget_versions.budget_version_id%TYPE
7: ,basis_cost_bem pa_budget_versions.budget_entry_method_code%TYPE
8: ,basis_rev_bem pa_budget_versions.budget_entry_method_code%TYPE
9: ,basis_cost_res_list_id pa_budget_versions.resource_list_id%TYPE

Line 6: ,basis_rev_version_id pa_budget_versions.budget_version_id%TYPE

2: /* $Header: PAFPUPGS.pls 120.3 2007/02/06 10:12:49 dthakker ship $ */
3:
4: TYPE upgrade_elements_rec_type IS RECORD (
5: basis_cost_version_id pa_budget_versions.budget_version_id%TYPE
6: ,basis_rev_version_id pa_budget_versions.budget_version_id%TYPE
7: ,basis_cost_bem pa_budget_versions.budget_entry_method_code%TYPE
8: ,basis_rev_bem pa_budget_versions.budget_entry_method_code%TYPE
9: ,basis_cost_res_list_id pa_budget_versions.resource_list_id%TYPE
10: ,basis_rev_res_list_id pa_budget_versions.resource_list_id%TYPE

Line 7: ,basis_cost_bem pa_budget_versions.budget_entry_method_code%TYPE

3:
4: TYPE upgrade_elements_rec_type IS RECORD (
5: basis_cost_version_id pa_budget_versions.budget_version_id%TYPE
6: ,basis_rev_version_id pa_budget_versions.budget_version_id%TYPE
7: ,basis_cost_bem pa_budget_versions.budget_entry_method_code%TYPE
8: ,basis_rev_bem pa_budget_versions.budget_entry_method_code%TYPE
9: ,basis_cost_res_list_id pa_budget_versions.resource_list_id%TYPE
10: ,basis_rev_res_list_id pa_budget_versions.resource_list_id%TYPE
11: ,basis_cost_planning_level pa_budget_entry_methods.entry_level_code%TYPE

Line 8: ,basis_rev_bem pa_budget_versions.budget_entry_method_code%TYPE

4: TYPE upgrade_elements_rec_type IS RECORD (
5: basis_cost_version_id pa_budget_versions.budget_version_id%TYPE
6: ,basis_rev_version_id pa_budget_versions.budget_version_id%TYPE
7: ,basis_cost_bem pa_budget_versions.budget_entry_method_code%TYPE
8: ,basis_rev_bem pa_budget_versions.budget_entry_method_code%TYPE
9: ,basis_cost_res_list_id pa_budget_versions.resource_list_id%TYPE
10: ,basis_rev_res_list_id pa_budget_versions.resource_list_id%TYPE
11: ,basis_cost_planning_level pa_budget_entry_methods.entry_level_code%TYPE
12: ,basis_rev_planning_level pa_budget_entry_methods.entry_level_code%TYPE

Line 9: ,basis_cost_res_list_id pa_budget_versions.resource_list_id%TYPE

5: basis_cost_version_id pa_budget_versions.budget_version_id%TYPE
6: ,basis_rev_version_id pa_budget_versions.budget_version_id%TYPE
7: ,basis_cost_bem pa_budget_versions.budget_entry_method_code%TYPE
8: ,basis_rev_bem pa_budget_versions.budget_entry_method_code%TYPE
9: ,basis_cost_res_list_id pa_budget_versions.resource_list_id%TYPE
10: ,basis_rev_res_list_id pa_budget_versions.resource_list_id%TYPE
11: ,basis_cost_planning_level pa_budget_entry_methods.entry_level_code%TYPE
12: ,basis_rev_planning_level pa_budget_entry_methods.entry_level_code%TYPE
13: ,basis_cost_time_phased_code pa_budget_entry_methods.time_phased_type_code%TYPE

Line 10: ,basis_rev_res_list_id pa_budget_versions.resource_list_id%TYPE

6: ,basis_rev_version_id pa_budget_versions.budget_version_id%TYPE
7: ,basis_cost_bem pa_budget_versions.budget_entry_method_code%TYPE
8: ,basis_rev_bem pa_budget_versions.budget_entry_method_code%TYPE
9: ,basis_cost_res_list_id pa_budget_versions.resource_list_id%TYPE
10: ,basis_rev_res_list_id pa_budget_versions.resource_list_id%TYPE
11: ,basis_cost_planning_level pa_budget_entry_methods.entry_level_code%TYPE
12: ,basis_rev_planning_level pa_budget_entry_methods.entry_level_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

Line 22: ,curr_option_budget_type_code pa_budget_versions.budget_type_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(
26: p_project_id IN pa_proj_fp_options.project_id%TYPE

Line 27: ,p_budget_type_code IN 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
31: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 54: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE

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
58: ,x_upgrade_elements_rec OUT NOCOPY pa_fp_upgrade_pkg.upgrade_elements_rec_type

Line 103: p_project_id IN pa_budget_versions.project_id%TYPE

99: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
100: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
101:
102: PROCEDURE validate_project (
103: p_project_id IN pa_budget_versions.project_id%TYPE
104: ,x_validation_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
105: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
106: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
107: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 110: p_project_id IN pa_budget_versions.project_id%TYPE

106: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
107: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
108:
109: PROCEDURE validate_project_plan_type (
110: p_project_id IN pa_budget_versions.project_id%TYPE
111: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
112: ,x_validation_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
113: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
114: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 111: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE

107: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
108:
109: PROCEDURE validate_project_plan_type (
110: p_project_id IN pa_budget_versions.project_id%TYPE
111: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
112: ,x_validation_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
113: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
114: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
115: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 118: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

114: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
115: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
116:
117: PROCEDURE validate_budget_version (
118: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
119: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
120: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
121: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
122: