[Home] [Help]
PACKAGE: APPS.PA_FP_SHORTCUTS_PKG
Source
1 PACKAGE pa_fp_shortcuts_pkg AUTHID CURRENT_USER AS
2 /* $Header: PAFPSHPS.pls 120.3 2006/06/26 09:04:01 nkumbi noship $ */
3
4 PROCEDURE identify_plan_version_id(
5 p_project_id IN pa_projects_all.project_id%TYPE,
6 p_function_code IN VARCHAR2,
7 p_context IN VARCHAR2 DEFAULT NULL,
8 p_user_id IN NUMBER,
9 p_same_org_id_flag IN VARCHAR2, -- DEFAULT 'N', Bug 5276024
10 px_fin_plan_type_id IN OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
11 x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
12 x_redirect_url OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
13 x_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE, --File.Sql.39 bug 4440895
14 x_plan_processing_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE, --File.Sql.39 bug 4440895
15 x_proj_fp_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
16 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
17 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
18 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
19
20 PROCEDURE get_app_budget_pt_id(
21 p_project_id IN pa_projects_all.project_id%TYPE,
22 p_version_type IN pa_budget_versions.version_type%TYPE,
23 p_context IN VARCHAR2,
24 p_function_code IN VARCHAR2 DEFAULT NULL,
25 x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
26 x_redirect_url OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
27 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
28 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
29 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
30
31
32 PROCEDURE get_fcst_plan_type_id(
33 p_project_id IN pa_projects_all.project_id%TYPE,
34 p_version_type IN pa_budget_versions.version_type%TYPE,
35 p_context IN VARCHAR2,
36 p_function_code IN VARCHAR2 DEFAULT NULL,
37 x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
38 x_redirect_url OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
39 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
40 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
41 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
42
43 procedure get_cw_version(
44 p_project_id IN pa_projects_all.project_id%TYPE,
45 p_plan_class_code IN pa_fin_plan_types_b.plan_class_Code%TYPE,
46 p_version_type IN pa_budget_versions.version_type%TYPE,
47 p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE,
48 p_edit_in_excel_Flag IN VARCHAR2,
49 p_user_id IN NUMBER,
50 p_context IN VARCHAR2,
51 x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
52 x_redirect_url OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
53 x_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE, --File.Sql.39 bug 4440895
54 x_plan_processing_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE, --File.Sql.39 bug 4440895
55 x_proj_fp_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
56 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
57 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
58 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
59 END pa_fp_shortcuts_pkg;