[Home] [Help]
PACKAGE: APPS.PA_FIN_PLAN_MAINT_VER_GLOBAL
Source
1 PACKAGE pa_fin_plan_maint_ver_global AUTHID CURRENT_USER as
2 /* $Header: PAFPMVGS.pls 120.3.12010000.3 2009/06/25 11:02:31 rthumma ship $
3 Start of Comments
4 Package name : PA_FIN_PLAN_MAINT_VER_GLOBAL
5 Purpose : API's for Org Forecast: Maintain 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_LOGIN_PERSON_ID NUMBER;
14
15 G_SECURITY_S VARCHAR2(1); /* Added for bug 5737980 */
16 G_SECURITY_R VARCHAR2(1); /* Added for bug 5737980 */
17 G_SECURITY_B VARCHAR2(1); /* Added for bug 5737980 */
18
19
20 function get_project_id return NUMBER;
21 function get_fin_plan_type_id return NUMBER;
22 function get_login_person_id return NUMBER;
23 function get_fin_plan_security(SecurityType IN VARCHAR2) return VARCHAR2; /* Added for bug 5737980 */
24
25 procedure set_global_finplan_security /* Added for bug 5737980 */
26 ( paFinplanSecType IN VARCHAR2,
27 paFinplanSec IN VARCHAR2 := NULL,
28 x_return_status OUT NOCOPY VARCHAR2,
32 procedure set_global_values
29 x_msg_count OUT NOCOPY NUMBER,
30 x_msg_data OUT NOCOPY VARCHAR2 );
31
33 (p_project_id IN pa_projects_all.project_id%TYPE,
34 p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
35 p_user_id IN VARCHAR2,
36 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
37 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
38 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
39
40 procedure Maintain_Versions_Init
41 (p_project_id IN pa_projects_all.project_id%TYPE,
42 p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
43 p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
44 x_fin_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
45 x_fin_plan_pref_code OUT NOCOPY pa_proj_fp_options.fin_plan_preference_code%TYPE, --File.Sql.39 bug 4440895
46 x_org_project_flag OUT NOCOPY pa_project_types_all.org_project_flag%TYPE, --File.Sql.39 bug 4440895
47 x_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE, --File.Sql.39 bug 4440895
48 x_proj_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
49 x_fin_plan_type_code OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_code%TYPE, --File.Sql.39 bug 4440895
50 x_fin_plan_class_code OUT NOCOPY pa_fin_plan_types_b.plan_class_code%TYPE, --File.Sql.39 bug 4440895
51 x_derive_margin_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE, --File.Sql.39 bug 4440895
52 x_report_labor_hrs_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895
53 x_auto_baseline_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
54 x_ar_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
55 x_plan_type_processing_code OUT NOCOPY pa_proj_fp_options.plan_processing_code%TYPE, --File.Sql.39 bug 4440895
56 x_navg_inc_co_code OUT NOCOPY VARCHAR2,--Bug 5845142
57 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
58 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
59 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
60
61 procedure Create_Working_Copy
62 (p_project_id IN pa_budget_versions.project_id%TYPE,
63 p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
64 p_copy_mode IN VARCHAR2,
65 p_adj_percentage IN NUMBER DEFAULT 0,
66 p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,
67 px_target_version_id IN OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
68 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
69 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
70 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
71
72 PROCEDURE Resubmit_Concurrent_Process
73 (p_project_id IN pa_projects_all.project_id%TYPE,
74 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
75 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
76 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
77
78 END pa_fin_plan_maint_ver_global;