[Home] [Help]
PACKAGE BODY: APPS.GMD_FORMULA_SECURITY_POLICY
Source
1 PACKAGE BODY gmd_formula_security_policy AS
2 /* $Header: GMDFSPLB.pls 120.1 2005/09/14 05:05:21 kshukla noship $ */
3
4 PROCEDURE formula_activate_upd (
5 active_formula_ind IN varchar2 )
6 IS
7
8 l_active_formula_ind varchar2(1);
9
10 begin
11 l_active_formula_ind := active_formula_ind;
12 update gmd_vpd_security
13 set active_formula_ind = l_active_formula_ind;
14 commit;
15 end;
16
17 PROCEDURE add_formula_hdr_sel IS
18 BEGIN
19 dbms_rls.add_policy (
20 'gmd',
21 'fm_form_mst_b',
22 'gmd_formula_hdr_sel',
23 'apps',
24 'gmd_security_policy.secure_formula_sel',
25 'select',
26 TRUE,
27 TRUE);
28 END;
29 PROCEDURE add_formula_hdr_ins IS
30 BEGIN
31 dbms_rls.add_policy (
32 'gmd',
33 'fm_form_mst_b',
34 'gmd_formula_hdr_ins',
35 'apps',
36 'gmd_security_policy.secure_formula_ins',
37 'insert',
38 TRUE,
39 TRUE);
40 END;
41 PROCEDURE add_formula_hdr_upd IS
42 BEGIN
43 dbms_rls.add_policy (
44 'gmd',
45 'fm_form_mst_b',
46 'gmd_formula_hdr_upd',
47 'apps',
48 'gmd_security_policy.secure_formula_upd',
49 'update',
50 TRUE,
51 TRUE);
52 END;
53
54 PROCEDURE add_formula_dtl_sel IS
55 /****************************************************************************************************
56 Change History
57 Who When What
58 kkillams 16-FEB-04 Predicate function has been replaced gmd_security_policy.secure_formula_sel with
59 gmd_security_policy.secure_formula_dtl_sel w.r.t. bug 3344335.
60 ******************************************************************************************************/
61 begin
62 dbms_rls.add_policy (
63 'gmd',
64 'fm_matl_dtl',
65 'gmd_formula_dtl_sel',
66 'apps',
67 'gmd_security_policy.secure_formula_dtl_sel',
68 'select',
69 TRUE,
70 TRUE);
71 end;
72
73
74 PROCEDURE add_formula_dtl_ins IS
75 begin
76 dbms_rls.add_policy (
77 'gmd',
78 'fm_matl_dtl',
79 'gmd_formula_dtl_ins',
80 'apps',
81 'gmd_security_policy.secure_formula_dtl_ins',
82 'insert',
83 TRUE,
84 TRUE);
85 end;
86
87 /****************************************************************************************************
88 Change History
89 Who When What
90 kkillams 30-MAR-04 Predicate function has been replaced gmd_security_policy.secure_formula_dtl_upd with
91 gmd_security_policy.secure_formula_dtl_ins w.r.t. bug 3344335.
92 ******************************************************************************************************/
93 PROCEDURE add_formula_dtl_upd IS
94 begin
95 dbms_rls.add_policy (
96 'gmd',
97 'fm_matl_dtl',
98 'gmd_formula_dtl_upd',
99 'apps',
100 'gmd_security_policy.secure_formula_dtl_ins',
101 'update',
102 TRUE,
103 TRUE);
104 end;
105
106
107 PROCEDURE drop_formula_hdr_sel IS
108 begin
109 dbms_rls.drop_policy (
110 'gmd',
111 'fm_form_mst_b',
112 'gmd_formula_hdr_sel');
113 end;
114
115 PROCEDURE drop_formula_hdr_ins IS
116 begin
117 dbms_rls.drop_policy (
118 'gmd',
119 'fm_form_mst_b',
120 'gmd_formula_hdr_ins');
121 end;
122
123 PROCEDURE drop_formula_hdr_upd IS
124 begin
125 dbms_rls.drop_policy (
126 'gmd',
127 'fm_form_mst_b',
128 'gmd_formula_hdr_upd');
129 end;
130
131 PROCEDURE drop_formula_dtl_sel IS
132 begin
133 dbms_rls.drop_policy (
134 'gmd',
135 'fm_matl_dtl',
136 'gmd_formula_dtl_sel');
137 end;
138
139 PROCEDURE drop_formula_dtl_ins IS
140 begin
141 dbms_rls.drop_policy (
142 'gmd',
143 'fm_matl_dtl',
144 'gmd_formula_dtl_ins');
145 end;
146
147 PROCEDURE drop_formula_dtl_upd IS
148 begin
149 dbms_rls.drop_policy (
150 'gmd',
151 'fm_matl_dtl',
152 'gmd_formula_dtl_upd');
153 end;
154 PROCEDURE add_recipe_sel IS
155 /****************************************************************************************************
156 Change History
157 Who When What
158 kkillams 02-MAR-04 Predicate function has been replaced gmd_security_policy.secure_formula_sel with
159 gmd_security_policy.secure_formula_dtl_sel w.r.t. bug 3344335.
160 ******************************************************************************************************/
161 BEGIN
162 dbms_rls.add_policy (
163 'gmd',
164 'gmd_recipes_b',
165 'gmd_recipe_sel',
166 'apps',
167 'gmd_security_policy.secure_formula_dtl_sel',
168 'select',
169 TRUE,
170 TRUE);
171 END;
172 PROCEDURE add_recipe_ins IS
173 /****************************************************************************************************
174 Change History
175 Who When What
176 kkillams 02-MAR-04 Predicate function has been replaced gmd_security_policy.secure_formula_sel with
177 gmd_security_policy.secure_formula_dtl_sel w.r.t. bug 3344335.
178 ******************************************************************************************************/
179 BEGIN
180 dbms_rls.add_policy (
181 'gmd',
182 'gmd_recipes_b',
183 'gmd_recipe_ins',
184 'apps',
185 'gmd_security_policy.secure_formula_dtl_sel',
186 'insert',
187 TRUE,
188 TRUE);
189 END;
190 PROCEDURE add_recipe_upd IS
191 /****************************************************************************************************
192 Change History
193 Who When What
194 kkillams 02-MAR-04 Predicate function has been replaced gmd_security_policy.secure_formula_sel with
195 gmd_security_policy.secure_formula_dtl_sel w.r.t. bug 3344335.
196 ******************************************************************************************************/
197 BEGIN
198 dbms_rls.add_policy (
199 'gmd',
200 'gmd_recipes_b',
201 'gmd_recipe_upd',
202 'apps',
203 'gmd_security_policy.secure_formula_dtl_sel',
204 'update',
205 TRUE,
206 TRUE);
207 END;
208
209
210 PROCEDURE add_recipe_step_sel IS
211 BEGIN
212 dbms_rls.add_policy (
213 'gmd',
214 'gmd_recipe_step_materials',
215 'gmd_recipe_step_sel',
216 'apps',
217 'gmd_security_policy.secure_recipe_sel',
218 'select',
219 TRUE,
220 TRUE);
221 END;
222 PROCEDURE add_recipe_step_ins IS
223 /****************************************************************************************************
224 Change History
225 Who When What
226 kkillams 16-FEB-04 Predicate function has been replaced gmd_security_policy.secure_recipe_ins with
227 gmd_security_policy.secure_recipe_sel w.r.t. bug 3344335.
228 ******************************************************************************************************/
229 BEGIN
230 dbms_rls.add_policy (
231 'gmd',
232 'gmd_recipe_step_materials',
233 'gmd_recipe_step_ins',
234 'apps',
235 'gmd_security_policy.secure_recipe_sel',
236 'insert',
237 TRUE,
238 TRUE);
239 END;
240 PROCEDURE add_recipe_step_upd IS
241 BEGIN
242 dbms_rls.add_policy (
243 'gmd',
244 'gmd_recipe_step_materials',
245 'gmd_recipe_step_upd',
246 'apps',
247 'gmd_security_policy.secure_recipe_sel',
248 'update',
249 TRUE,
250 TRUE);
251 END;
252 PROCEDURE add_recipe_vr_sel IS
253 BEGIN
254 dbms_rls.add_policy (
255 'gmd',
256 'gmd_recipe_validity_rules',
257 'gmd_recipe_vr_sel',
258 'apps',
259 'gmd_security_policy.secure_recipe_sel',
260 'select',
261 TRUE,
262 TRUE);
263 END;
264 PROCEDURE add_recipe_vr_ins IS
265 /****************************************************************************************************
266 Change History
267 Who When What
268 kkillams 09-MAR-04 Predicate function has been replaced gmd_security_policy.secure_recipe_upd with
269 gmd_security_policy.secure_recipe_sel w.r.t. bug 3344335.
270 ******************************************************************************************************/
271 BEGIN
272 dbms_rls.add_policy (
273 'gmd',
274 'gmd_recipe_validity_rules',
275 'gmd_recipe_vr_ins',
276 'apps',
277 'gmd_security_policy.secure_recipe_sel',
278 'insert',
279 TRUE,
280 TRUE);
281 END;
282 PROCEDURE add_recipe_vr_upd IS
283 BEGIN
284 dbms_rls.add_policy (
285 'gmd',
286 'gmd_recipe_validity_rules',
287 'gmd_recipe_vr_upd',
288 'apps',
289 'gmd_security_policy.secure_recipe_sel',
290 'update',
291 TRUE,
292 TRUE);
293 END;
294 PROCEDURE drop_recipe_sel IS
295 begin
296 dbms_rls.drop_policy (
297 'gmd',
298 'gmd_recipes_b',
299 'gmd_recipe_sel');
300 end;
301
302 PROCEDURE drop_recipe_ins IS
303 begin
304 dbms_rls.drop_policy (
305 'gmd',
306 'gmd_recipes_b',
307 'gmd_recipe_ins');
308 end;
309
310 PROCEDURE drop_recipe_upd IS
311 begin
312 dbms_rls.drop_policy (
313 'gmd',
314 'gmd_recipes_b',
315 'gmd_recipe_upd');
316 end;
317
318 PROCEDURE drop_recipe_step_sel IS
319 begin
320 dbms_rls.drop_policy (
321 'gmd',
322 'gmd_recipe_step_materials',
323 'gmd_recipe_step_sel');
324 end;
325
326 PROCEDURE drop_recipe_step_ins IS
327 begin
328 dbms_rls.drop_policy (
329 'gmd',
330 'gmd_recipe_step_materials',
331 'gmd_recipe_step_ins');
332 end;
333
334 PROCEDURE drop_recipe_step_upd IS
335 begin
336 dbms_rls.drop_policy (
337 'gmd',
338 'gmd_recipe_step_materials',
339 'gmd_recipe_step_upd');
340 end;
341
342 PROCEDURE drop_recipe_vr_sel IS
343 begin
344 dbms_rls.drop_policy (
345 'gmd',
346 'gmd_recipe_validity_rules',
347 'gmd_recipe_vr_sel');
348 end;
349
350 PROCEDURE drop_recipe_vr_ins IS
351 begin
352 dbms_rls.drop_policy (
353 'gmd',
354 'gmd_recipe_validity_rules',
355 'gmd_recipe_vr_ins');
356 end;
357
358 PROCEDURE drop_recipe_vr_upd IS
359 begin
360 dbms_rls.drop_policy (
361 'gmd',
362 'gmd_recipe_validity_rules',
363 'gmd_recipe_vr_upd');
364 end;
365 END gmd_formula_security_policy;
366