[Home] [Help]
PACKAGE: APPS.CS_KB_SECURITY_PVT
Source
1 PACKAGE CS_KB_SECURITY_PVT AS
2 /* $Header: cskvkss.pls 120.1 2006/03/27 15:26:40 allau noship $ */
3
4 INVALID_IN_PARAMETERS EXCEPTION;
5 INSERT_FAILED EXCEPTION;
6 UPDATE_FAILED EXCEPTION;
7 DUPLICATE_VISIBILITY EXCEPTION;
8 DUPLICATE_CATEGORY_GROUP EXCEPTION;
9 DUP_CATEGORY_GROUP_MEMBER EXCEPTION;
10 UNABLE_TO_DELETE_VIS EXCEPTION;
11 DELETE_FAILED EXCEPTION;
12 CG_MEMBERS_EXIST EXCEPTION;
13 CG_FLOWS_EXIST EXCEPTION;
14 INV_SEC_CAT_GRP EXCEPTION;
15 INV_SEC_SOLN_VIS EXCEPTION;
16 INV_SEC_STMT_VIS EXCEPTION;
17 INDEX_SYNC_FAILED EXCEPTION;
18 CG_NOT_FOUND EXCEPTION;
19
20 procedure CREATE_VISIBILITY (
21 P_VISIBILITY_ID IN NUMBER,
22 P_ADD_BEFORE_VISIBILITY IN NUMBER,
23 P_ADD_AFTER_VISIBILITY IN NUMBER,
24 P_START_DATE_ACTIVE IN DATE,
25 P_END_DATE_ACTIVE IN DATE,
26 P_NAME IN VARCHAR2,
27 P_DESCRIPTION IN VARCHAR2,
28 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
29 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
30 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
31 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
32 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
33 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
34 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
35 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
36 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
37 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
38 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
39 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
40 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
41 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
42 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
43 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
44 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
45 X_MSG_DATA OUT NOCOPY VARCHAR2,
46 X_MSG_COUNT OUT NOCOPY NUMBER
47 );
48
49 PROCEDURE UPDATE_VISIBILITY (
50 P_VISIBILITY_ID IN NUMBER,
51 P_POSITION IN NUMBER,
52 P_START_DATE_ACTIVE IN DATE,
53 P_END_DATE_ACTIVE IN DATE,
54 P_NAME IN VARCHAR2,
55 P_DESCRIPTION IN VARCHAR2,
56 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
57 P_ATTRIBUTE1 IN VARCHAR2,
58 P_ATTRIBUTE2 IN VARCHAR2,
59 P_ATTRIBUTE3 IN VARCHAR2,
60 P_ATTRIBUTE4 IN VARCHAR2,
61 P_ATTRIBUTE5 IN VARCHAR2,
62 P_ATTRIBUTE6 IN VARCHAR2,
63 P_ATTRIBUTE7 IN VARCHAR2,
64 P_ATTRIBUTE8 IN VARCHAR2,
65 P_ATTRIBUTE9 IN VARCHAR2,
66 P_ATTRIBUTE10 IN VARCHAR2,
67 P_ATTRIBUTE11 IN VARCHAR2,
68 P_ATTRIBUTE12 IN VARCHAR2,
69 P_ATTRIBUTE13 IN VARCHAR2,
70 P_ATTRIBUTE14 IN VARCHAR2,
71 P_ATTRIBUTE15 IN VARCHAR2,
72 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
73 X_MSG_DATA OUT NOCOPY VARCHAR2,
74 X_MSG_COUNT OUT NOCOPY NUMBER
75 );
76
77 procedure DELETE_VISIBILITY (
78 P_VISIBILITY_ID IN NUMBER,
79 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
80 X_MSG_DATA OUT NOCOPY VARCHAR2,
81 X_MSG_COUNT OUT NOCOPY NUMBER
82 );
83
84 PROCEDURE CREATE_CATEGORY_GROUP (
85 P_CATEGORY_GROUP_ID IN NUMBER,
86 P_START_DATE_ACTIVE IN DATE,
87 P_END_DATE_ACTIVE IN DATE,
88 P_NAME IN VARCHAR,
89 P_DESCRIPTION IN VARCHAR,
90 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
91 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
92 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
93 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
94 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
95 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
96 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
97 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
98 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
99 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
100 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
101 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
102 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
103 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
104 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
105 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
106 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
107 X_MSG_DATA OUT NOCOPY VARCHAR2,
108 X_MSG_COUNT OUT NOCOPY NUMBER
109 );
110
111 PROCEDURE UPDATE_CATEGORY_GROUP (
112 P_CATEGORY_GROUP_ID IN NUMBER,
113 P_START_DATE_ACTIVE IN DATE,
114 P_END_DATE_ACTIVE IN DATE,
115 P_NAME IN VARCHAR,
116 P_DESCRIPTION IN VARCHAR,
117 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
118 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
119 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
120 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
121 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
122 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
123 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
124 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
125 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
126 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
127 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
128 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
129 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
130 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
131 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
132 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
133 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
134 X_MSG_DATA OUT NOCOPY VARCHAR2,
135 X_MSG_COUNT OUT NOCOPY NUMBER
136 );
137
138 PROCEDURE DELETE_CATEGORY_GROUP (
139 P_CATEGORY_GROUP_ID IN NUMBER,
140 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
141 X_MSG_DATA OUT NOCOPY VARCHAR2,
142 X_MSG_COUNT OUT NOCOPY NUMBER
143 );
144
145 FUNCTION POPULATE_CAT_GRP_DENORM (
146 P_CATEGORY_GROUP_ID NUMBER
147 )RETURN VARCHAR2;
148
149 FUNCTION REPOPULATE_CAT_GRP_DENORM
150 RETURN VARCHAR2;
151
152 /*
153 PROCEDURE UPDATE_DENORM_VIS_POSITION (
154 P_VISIBILITY_ID NUMBER,
155 P_NEW_POSITION NUMBER );
156 */
157
158 PROCEDURE CREATE_CATEGORY_GROUP_MEMBER (
159 P_CATEGORY_GROUP_ID IN NUMBER,
160 P_CATEGORY_ID IN NUMBER,
161 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
162 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
163 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
164 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
165 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
166 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
167 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
168 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
169 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
170 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
171 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
172 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
173 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
174 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
175 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
176 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
177 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
178 X_MSG_DATA OUT NOCOPY VARCHAR2,
179 X_MSG_COUNT OUT NOCOPY NUMBER
180 );
181
182 PROCEDURE DELETE_CATEGORY_GROUP_MEMBER (
183 P_CATEGORY_GROUP_ID IN NUMBER,
184 P_CATEGORY_ID IN NUMBER,
185 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
186 X_MSG_DATA OUT NOCOPY VARCHAR2,
187 X_MSG_COUNT OUT NOCOPY NUMBER
188 );
189 /*
190 PROCEDURE CREATE_CATEGORY_GROUP_FLOW (
191 P_FLOW_ID IN NUMBER,
192 P_CATEGORY_GROUP_ID IN NUMBER,
193 P_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
194 P_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
195 P_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
196 P_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
197 P_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
198 P_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
199 P_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
200 P_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
201 P_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
202 P_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
203 P_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
204 P_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
205 P_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
206 P_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
207 P_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
208 P_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
209 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
210 X_MSG_DATA OUT NOCOPY VARCHAR2,
211 X_MSG_COUNT OUT NOCOPY NUMBER
212 );
213 */
214 FUNCTION Get_Category_Group_Id return number;
215 FUNCTION Get_Soln_Visibility_Position return number;
216 FUNCTION Get_Stmt_Visibility_Position return number;
217
218 PROCEDURE ADD_CAT_GRP_MEMBER_TO_DENORM ( P_CATEGORY_GROUP_ID NUMBER,
219 P_CATEGORY_ID NUMBER);
220
221 PROCEDURE ADD_CATEGORY_TO_DENORM (
222 P_CATEGORY_ID IN NUMBER,
223 P_PARENT_CATEGORY_ID IN NUMBER,
224 P_VISIBILITY_ID IN NUMBER,
225 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
226 X_MSG_DATA OUT NOCOPY VARCHAR2,
227 X_MSG_COUNT OUT NOCOPY NUMBER
228 );
229
230 PROCEDURE REMOVE_CG_MEMBER_FROM_DENORM ( P_CATEGORY_GROUP_ID NUMBER,
231 P_CATEGORY_ID NUMBER);
232
233 PROCEDURE UPDATE_CATEGORY_TO_DENORM (
234 P_CATEGORY_ID IN NUMBER,
235 P_VISIBILITY_ID IN NUMBER,
236 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
237 X_MSG_DATA OUT NOCOPY VARCHAR2,
238 X_MSG_COUNT OUT NOCOPY NUMBER
239 );
240
241 PROCEDURE REMOVE_CATEGORY_FROM_CAT_GROUP (
242 P_CATEGORY_ID IN NUMBER,
243 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
244 X_MSG_DATA OUT NOCOPY VARCHAR2,
245 X_MSG_COUNT OUT NOCOPY NUMBER
246 );
247
248 PROCEDURE GET_SECURITY_PROFILES (
249 X_CATEGORY_GROUP_ID OUT NOCOPY NUMBER,
250 X_SOLN_VISIBILITY_POSITION OUT NOCOPY NUMBER,
251 X_STMT_VISIBILITY_POSITION OUT NOCOPY NUMBER,
252 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
253 X_MSG_DATA OUT NOCOPY VARCHAR2,
254 X_MSG_COUNT OUT NOCOPY NUMBER
255 );
256
257 PROCEDURE MOVE_CATEGORY_IN_DENORM (
258 P_CATEGORY_ID IN NUMBER,
259 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
260 X_MSG_DATA OUT NOCOPY VARCHAR2,
261 X_MSG_COUNT OUT NOCOPY NUMBER
262 );
263
264 FUNCTION IS_COMPLETE_SOLUTION_VISIBLE ( P_USER_ID NUMBER,
265 P_SET_ID NUMBER) RETURN VARCHAR2;
266
267 END CS_KB_SECURITY_PVT;