DBA Data[Home] [Help]

APPS.GMD_FORMULA_SECURITY_POLICY dependencies on DBMS_RLS

Line 19: dbms_rls.add_policy (

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',

Line 31: dbms_rls.add_policy (

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',

Line 43: dbms_rls.add_policy (

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',

Line 62: dbms_rls.add_policy (

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',

Line 76: dbms_rls.add_policy (

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',

Line 95: dbms_rls.add_policy (

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',

Line 109: dbms_rls.drop_policy (

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;

Line 117: dbms_rls.drop_policy (

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;

Line 125: dbms_rls.drop_policy (

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;

Line 133: dbms_rls.drop_policy (

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;

Line 141: dbms_rls.drop_policy (

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;

Line 149: dbms_rls.drop_policy (

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;

Line 162: dbms_rls.add_policy (

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',

Line 180: dbms_rls.add_policy (

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',

Line 198: dbms_rls.add_policy (

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',

Line 212: dbms_rls.add_policy (

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',

Line 230: dbms_rls.add_policy (

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',

Line 242: dbms_rls.add_policy (

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',

Line 254: dbms_rls.add_policy (

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',

Line 272: dbms_rls.add_policy (

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',

Line 284: dbms_rls.add_policy (

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',

Line 296: dbms_rls.drop_policy (

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;

Line 304: dbms_rls.drop_policy (

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;

Line 312: dbms_rls.drop_policy (

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;

Line 320: dbms_rls.drop_policy (

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;

Line 328: dbms_rls.drop_policy (

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;

Line 336: dbms_rls.drop_policy (

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;

Line 344: dbms_rls.drop_policy (

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;

Line 352: dbms_rls.drop_policy (

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;

Line 360: dbms_rls.drop_policy (

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;