[Home] [Help]
PACKAGE: APPS.PA_PM_FUNCTION_SECURITY_PUB
Source
1 PACKAGE PA_PM_FUNCTION_SECURITY_PUB AUTHID DEFINER AS
2 /*$Header: PAPMFSPS.pls 120.2 2005/08/19 16:42:43 mwasowic ship $*/
3
4 G_PKG_NAME VARCHAR2(80) := 'PA_PM_FUNCTION_SECURITY_PUB';
5 -- Global variables to be used to avoid repeated calls to
6 -- PA_PM_FUNCTION_SECURITY_PUB.check_function_security,
7 -- thus improving the performance.
8
9 G_Create_Project VARCHAR2(1) := NULL;
10 G_Update_Project VARCHAR2(1) := NULL;
11 G_Delete_Project VARCHAR2(1) := NULL;
12
13 G_Update_Proj_Progress VARCHAR2(1) := NULL;
14
15 G_Add_Task VARCHAR2(1) := NULL;
16 G_Update_Task VARCHAR2(1) := NULL;
17 G_Modify_Top_Task VARCHAR2(1) := NULL;
18 G_Delete_Task VARCHAR2(1) := NULL;
19
20 G_Create_Draft_Budget VARCHAR2(1) := NULL;
21 G_Update_Budget VARCHAR2(1) := NULL;
22 G_Baseline_Budget VARCHAR2(1) := NULL;
23 G_Delete_Draft_Budget VARCHAR2(1) := NULL;
24
25 G_Add_Budget_Line VARCHAR2(1) := NULL;
26 G_Update_Budget_Line VARCHAR2(1) := NULL;
27 G_Delete_Budget_Line VARCHAR2(1) := NULL;
28
29 G_Update_Earned_Value VARCHAR2(1) := NULL;
30
31 G_Create_Res_List VARCHAR2(1) := NULL;
32 G_Update_Res_List VARCHAR2(1) := NULL;
33 G_Delete_Res_List VARCHAR2(1) := NULL;
34
35 G_Add_Res_List_Member VARCHAR2(1) := NULL;
36 G_Update_Res_List_Member VARCHAR2(1) := NULL;
37 G_Delete_Res_List_Member VARCHAR2(1) := NULL;
38
39 G_Create_Agreement VARCHAR2(1) := NULL;
40 G_Delete_Agreement VARCHAR2(1) := NULL;
41 G_Update_Agreement VARCHAR2(1) := NULL;
42 G_Add_Funding VARCHAR2(1) := NULL;
43 G_Delete_Funding VARCHAR2(1) := NULL;
44 G_Update_Funding VARCHAR2(1) := NULL;
45 G_Init_Agreement VARCHAR2(1) := NULL;
46 G_Load_Agreement VARCHAR2(1) := NULL;
47 G_Load_Funding VARCHAR2(1) := NULL;
48 G_Exe_Cre_Agmt VARCHAR2(1) := NULL;
49 G_Exe_Upd_Agmt VARCHAR2(1) := NULL;
50 G_Fetch_Funding VARCHAR2(1) := NULL;
51 G_Clear_Agreement VARCHAR2(1) := NULL;
52 G_Check_Del_Agmt_Ok VARCHAR2(1) := NULL;
53 G_Check_Add_Fund_Ok VARCHAR2(1) := NULL;
54 G_Check_Del_Fund_Ok VARCHAR2(1) := NULL;
55 G_Check_Upd_Fund_Ok VARCHAR2(1) := NULL;
56
57 G_found_or_not VARCHAR2(1) := 'N';
58
59 /* Start of code for bug #4317792 */
60 G_FP_Maintain_AC_Plan VARCHAR2(1) := NULL;
61 G_FP_Maintain_C_Plan VARCHAR2(1) := NULL;
62 G_FP_Maintain_FC_Plan VARCHAR2(1) := NULL;
63 G_FP_Maintain_AR_Plan VARCHAR2(1) := NULL;
64 G_FP_Maintain_R_Plan VARCHAR2(1) := NULL;
65 G_FP_Maintain_FR_Plan VARCHAR2(1) := NULL;
66 G_FP_Baseline_AC_Plan VARCHAR2(1) := NULL;
67 G_FP_Baseline_C_Plan VARCHAR2(1) := NULL;
68 G_FP_Baseline_FC_Plan VARCHAR2(1) := NULL;
69 G_FP_Baseline_AR_Plan VARCHAR2(1) := NULL;
70 G_FP_Baseline_R_Plan VARCHAR2(1) := NULL;
71 G_FP_Baseline_FR_Plan VARCHAR2(1) := NULL;
72 G_FP_Maintain_AC_AR_Plan_Lines VARCHAR2(1) := NULL;
73 G_FP_Maintain_Plan_Lines VARCHAR2(1) := NULL;
74 G_FP_Maintain_FC_FR_Plan_Lines VARCHAR2(1) := NULL;
75 /* End of code for bug #4317792 */
76
77 Procedure check_function_security
78 (p_api_version_number IN NUMBER,
79 p_responsibility_id IN NUMBER,
80 p_function_name IN VARCHAR2,
81 p_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
82 p_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
83 p_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
84 p_function_allowed OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
85
86 -- Included Procedure Check_Global_Vars, to check for global variables and
87 -- see if check_function_security function has already been called once.
88 -- This way, we are avoiding multiple calls to this function
89 -- check_function_security S Sanckar 09-Jul-99
90
91 Procedure Check_Global_Vars
92 (p_function_name IN VARCHAR2,
93 p_function_allowed OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
94 p_found_or_not OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
95
96 -- Included call to Set_Global_Vars, to set the global variables
97 -- which are used in checking if check_function_security function has
98 -- already been called. This way, we are avoiding multiple calls to
99 -- this function check_function_security S Sanckar 09-Jul-99
100
101 Procedure Set_Global_Vars
102 (p_function_name IN VARCHAR2,
103 p_function_allowed IN VARCHAR2);
104
105 --This method is called to check whether the user has
106 --privileges to call various public apis in pa_budget_pub
107
108 PROCEDURE CHECK_BUDGET_SECURITY (
109 p_api_version_number IN NUMBER,
110 p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
111 p_fin_plan_type_id IN PA_FIN_PLAN_TYPES_B.FIN_PLAN_TYPE_ID%TYPE DEFAULT NULL, /* Bug 3139924 */
112 p_calling_context IN VARCHAR2,
113 p_function_name IN VARCHAR2,
114 p_version_type IN VARCHAR2,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_ret_code OUT NOCOPY VARCHAR2 );
117 END PA_PM_FUNCTION_SECURITY_PUB;