1 PACKAGE OKE_K_SECURITY_PKG AS
2 /* $Header: OKEKSECS.pls 120.0 2005/05/25 17:55:23 appldev noship $ */
3 --
4 -- Global Constants
5 --
6 G_EDIT_ACCESS CONSTANT VARCHAR2(30) := 'EDIT';
7 G_VIEW_ACCESS CONSTANT VARCHAR2(30) := 'VIEW';
8 G_NO_ACCESS CONSTANT VARCHAR2(30) := 'NONE';
9
10 --
11 -- Name : Get_K_Access
12 -- Pre-reqs : FND_GLOBAL.INITIALIZE
13 -- Function : This function returns the access level of
14 -- the current user for the given contract
15 --
16 -- Parameters :
17 -- IN : P_K_HEADER_ID NUMBER
18 -- OUT : None
19 --
20 -- Returns : VARCHAR2
21 --
22 -- Note : The return value is cached for performance
23 -- reasons. If you need to have real-time
24 -- information, you should use the functions
25 -- Get_User_K_Access() or Get_Emp_K_Access() instead.
26 --
27
28 FUNCTION Get_K_Access
29 ( P_K_Header_ID IN NUMBER
30 ) RETURN VARCHAR2;
31
32
33 --
34 -- Name : Get_User_K_Access
35 -- Pre-reqs : FND_GLOBAL.INITIALIZE
36 -- Function : This function returns the access level of
37 -- the given user for the given contract
38 --
39 -- Parameters :
40 -- IN : K_HEADER_ID NUMBER
41 -- K_USER_ID NUMBER
42 -- OUT : None
43 --
44 -- Returns : VARCHAR2
45 --
46
47 FUNCTION Get_User_K_Access
48 ( P_K_Header_ID IN NUMBER
49 , P_User_ID IN NUMBER
50 ) RETURN VARCHAR2;
51
52
53 --
54 -- Name : Get_Emp_K_Access
55 -- Pre-reqs : FND_GLOBAL.INITIALIZE
56 -- Function : This function returns the access level of
57 -- the given employee for the given contract
58 --
59 -- Parameters :
60 -- IN : P_K_HEADER_ID NUMBER
61 -- P_EMP_ID NUMBER
62 -- OUT : None
63 --
64 -- Returns : VARCHAR2
65 --
66
67 FUNCTION Get_Emp_K_Access
68 ( P_K_Header_ID IN NUMBER
69 , P_Emp_ID IN NUMBER
70 ) RETURN VARCHAR2;
71
72
73 --
74 -- Name : Get_K_Role
75 -- Pre-reqs : FND_GLOBAL.INITIALIZE
76 -- Function : This function returns the role of the
77 -- current user for the given contract
78 --
79 -- Parameters :
80 -- IN : P_K_HEADER_ID NUMBER
81 -- OUT : None
82 --
83 -- Returns : VARCHAR2
84 --
85 -- Note : The return value is cached for performance
86 -- reasons. If you need to have real-time
87 -- information, you should use the functions
88 -- Get_User_K_Access() or Get_Emp_K_Access() instead.
89 --
90
91 FUNCTION Get_K_Role
92 ( P_K_Header_ID IN NUMBER
93 ) RETURN VARCHAR2;
94
95
96 --
97 -- Name : Get_User_K_Role
98 -- Pre-reqs : FND_GLOBAL.INITIALIZE
99 -- Function : This function returns the role of the
100 -- given user for the given contract
101 --
102 -- Parameters :
103 -- IN : K_HEADER_ID NUMBER
104 -- K_USER_ID NUMBER
105 -- OUT : None
106 --
107 -- Returns : VARCHAR2
108 --
109
110 FUNCTION Get_User_K_Role
111 ( P_K_Header_ID IN NUMBER
112 , P_User_ID IN NUMBER
113 ) RETURN VARCHAR2;
114
115
116 --
117 -- Name : Get_Emp_K_Role
118 -- Pre-reqs : FND_GLOBAL.INITIALIZE
119 -- Function : This function returns the role of the
120 -- given employee for the given contract
121 --
122 -- Parameters :
123 -- IN : P_K_HEADER_ID NUMBER
124 -- P_EMP_ID NUMBER
125 -- OUT : None
126 --
127 -- Returns : VARCHAR2
128 --
129
130 FUNCTION Get_Emp_K_Role
131 ( P_K_Header_ID IN NUMBER
132 , P_Emp_ID IN NUMBER
133 ) RETURN VARCHAR2;
134
135
136 PROCEDURE Set_Assignment_Date
137 ( P_Date IN DATE
138 );
139
140 FUNCTION Get_Assignment_Date
141 RETURN DATE;
142
143 FUNCTION Function_Allowed
144 ( X_Role_ID IN NUMBER
145 , X_Function_Name IN VARCHAR2
146 ) RETURN VARCHAR2;
147
148 END OKE_K_SECURITY_PKG;