PACKAGE: APPS.PA_FIN_PLAN_TYPE_GLOBAL

Source

1 PACKAGE pa_fin_plan_type_global AUTHID CURRENT_USER as
2 /* $Header: PAFPPTGS.pls 120.1 2005/08/19 16:28:34 mwasowic noship $
3    Start of Comments
4    Package name     : PA_FIN_PLAN_TYPE_GLOBAL
5    Purpose          : API's for Org Forecast: PLANS Page
6    History          :
7    NOTE             :
8    End of Comments
9 */
10 
11 G_PROJECT_ID		NUMBER;
12 --G_PLAN_CLASS_CODE	VARCHAR2(30);
13 
14 function Get_Project_Id return NUMBER;
15 --function Get_Plan_Class_Code return VARCHAR2;
16 
17 PROCEDURE set_global_variables
18 	(p_project_id	   IN	pa_budget_versions.project_id%TYPE,
19 	 -- p_plan_class_code IN	pa_fin_plan_types_b.plan_class_code%TYPE,
20 	 x_factor_by_code  OUT 	NOCOPY pa_proj_fp_options.factor_by_code%TYPE, --File.Sql.39 bug 4440895
21 	 x_return_status   OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
22 	 x_msg_count	   OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
23 	 x_msg_data	   OUT	NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
24 
25 PROCEDURE pa_fp_get_orgfcst_version_id(p_project_id          IN   NUMBER,
26 	                               p_plan_type_id        IN   NUMBER,
27         	                       p_plan_status_code    IN   VARCHAR2,
28                 	               x_orgfcst_version_id  OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
29                         	       x_return_status       OUT  NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
30                               	       x_msg_count           OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
31                   	               x_msg_data            OUT  NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32                                    );
33 
34 
35 -- this procedure is similar to the above, but used for non-orgfcst plan types
36 -- given a plan type, we retrieve the budget version(s) that are in the
37 -- current working/current baselined status
38 PROCEDURE pa_fp_get_finplan_version_id
39     (p_project_id          IN   NUMBER,
40      p_plan_type_id        IN   NUMBER,
41      p_plan_status_code    IN   VARCHAR2,
42      x_cost_version_id     OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
43      x_rev_version_id      OUT  NOCOPY NUMBER, --File.Sql.39 bug 4440895
44      x_return_status       OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
45      x_msg_count           OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
46      x_msg_data            OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
47 
48 PROCEDURE delete_plan_type_from_project
49     (p_project_id        IN  pa_budget_versions.project_id%TYPE,
50      p_fin_plan_type_id  IN  pa_budget_versions.fin_plan_type_id%TYPE,
51      x_return_status     OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
52      x_msg_count         OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
53      x_msg_data          OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
54 
55 FUNCTION plantype_to_planclass
56     (p_project_id		IN  pa_proj_fp_options.project_id%TYPE,
57      p_fin_plan_type_id    	IN  pa_proj_fp_options.fin_plan_type_id%TYPE)
58 return VARCHAR2;
59 
60 FUNCTION planversion_to_planclass
61     (p_fin_plan_version_id	IN  pa_budget_versions.budget_version_id%TYPE)
62 return VARCHAR2;
63 
64 END pa_fin_plan_type_global;