[Home] [Help]
PACKAGE: APPS.PA_FIN_PLAN_CREATE_VER_GLOBAL
Source
1 PACKAGE pa_fin_plan_create_ver_global AUTHID CURRENT_USER as
2 /* $Header: PAFPCVGS.pls 120.1 2005/08/19 16:26:09 mwasowic noship $
3 Start of Comments
4 Package name : PA_FIN_PLAN_CREATE_VER_GLOBAL
5 Purpose : API's for Org Forecast: Create Versions Page
6 History :
7 NOTE :
8 End of Comments
9 */
10
11 G_PROJECT_ID NUMBER;
12 G_FIN_PLAN_TYPE_ID NUMBER;
13 G_BUDGET_VERSION_ID NUMBER;
14
15 function get_project_id return NUMBER;
16 function get_fin_plan_type_id return NUMBER;
17 function get_budget_version_id return NUMBER;
18
19
20 function get_lookup_planning_level
21 (p_planning_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE)
22 return VARCHAR2;
23
24 function get_lookup_time_phase
25 (p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE)
26 return VARCHAR2;
27
28 function get_resource_list_name
29 (p_resource_list_id IN pa_resource_lists.resource_list_id%TYPE)
30 return VARCHAR2;
31
32 /* ==============================================================
33 9/11/02 ADDED FUNCTIONS TO RETRIEVE GL/PA START/END PERIOD
34 NAMES FOR CREATE VERSION PAGE
35 ============================================================== */
36 FUNCTION get_gl_current_start_period
37 (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
38 return VARCHAR2;
39
40 FUNCTION get_gl_current_end_period
41 (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
42 return VARCHAR2;
43
44 FUNCTION get_pa_current_start_period
45 (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
46 return VARCHAR2;
47
48 FUNCTION get_pa_current_end_period
49 (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
50 return VARCHAR2;
51
52
53 procedure set_project_id
54 (p_project_id IN pa_budget_versions.project_id%TYPE,
55 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
56 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
57 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
58
59 procedure set_fin_plan_type_id
60 (p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
61 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
62 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
63 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
64
65 procedure set_budget_version_id
66 (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
67 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
68 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
69 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
70
71 procedure set_global_values
72 (p_project_id IN pa_budget_versions.project_id%TYPE,
73 p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
74 p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
75 p_user_id IN NUMBER,
76 x_locked_by_user_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
77 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
78 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
79 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
80
81 procedure get_start_end_period
82 (x_period_start_date OUT NOCOPY pa_proj_fp_options.fin_plan_start_date%TYPE, --File.Sql.39 bug 4440895
83 x_period_end_date OUT NOCOPY pa_proj_fp_options.fin_plan_end_date%TYPE, --File.Sql.39 bug 4440895
84 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
85 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
86 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
87
88 /* ========================================================
89 HISTORY:
90 8/21/02 -- added nvl to org_project_flag query: null --> 'N'
91 8/22/02 -- added x_fin_plan_pref_code
92 ======================================================== */
93 procedure Create_Versions_Init
94 (p_project_id IN pa_projects_all.project_id%TYPE,
95 p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
96 x_org_project_flag OUT NOCOPY pa_project_types_all.org_project_flag%TYPE, --File.Sql.39 bug 4440895
97 x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
98 x_fin_plan_type_code OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_code%TYPE, --File.Sql.39 bug 4440895
99 x_plan_class_code OUT NOCOPY pa_fin_plan_types_b.plan_class_code%TYPE, --File.Sql.39 bug 4440895
100 x_approved_budget_flag OUT NOCOPY pa_proj_fp_options.approved_cost_plan_type_flag%TYPE, --File.Sql.39 bug 4440895
101 x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895
102 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
103 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
104 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
105
106 END pa_fin_plan_create_ver_global;