[Home] [Help]
PACKAGE BODY: APPS.GMD_FORMULA_SECURITY_ADMIN
Source
1 PACKAGE BODY gmd_formula_security_admin AS
2 /* $Header: GMDFSADB.pls 115.18 2003/03/18 16:45:28 txdaniel noship $ */
3
4
5 PROCEDURE add_formula_security IS
6 begin
7 gmd_formula_security_policy.add_formula_hdr_sel;
8 gmd_formula_security_policy.add_formula_hdr_ins;
9 gmd_formula_security_policy.add_formula_hdr_upd;
10 gmd_formula_security_policy.add_formula_dtl_sel;
11 gmd_formula_security_policy.add_formula_dtl_ins;
12 gmd_formula_security_policy.add_formula_dtl_upd;
13 gmd_formula_security_policy.add_recipe_sel;
14 gmd_formula_security_policy.add_recipe_ins;
15 gmd_formula_security_policy.add_recipe_upd;
16 -- gmd_formula_security_policy.add_recipe_vr_sel;
17 gmd_formula_security_policy.add_recipe_vr_ins;
18 gmd_formula_security_policy.add_recipe_vr_upd;
19 gmd_formula_security_policy.add_recipe_step_sel;
20 gmd_formula_security_policy.add_recipe_step_ins;
21 gmd_formula_security_policy.add_recipe_step_upd;
22
23 /* BEGIN BUG#2736082 V. Ajay Kumar */
24 /* Removed the reference to apps */
25 gmd_formula_security_policy.formula_activate_upd ('Y');
26 /* END BUG#2736082 */
27 commit;
28 end;
29
30
31 PROCEDURE drop_formula_security IS
32 begin
33 gmd_formula_security_policy.drop_formula_hdr_sel;
34 gmd_formula_security_policy.drop_formula_hdr_ins;
35 gmd_formula_security_policy.drop_formula_hdr_upd;
36 gmd_formula_security_policy.drop_formula_dtl_sel;
37 gmd_formula_security_policy.drop_formula_dtl_ins;
38 gmd_formula_security_policy.drop_formula_dtl_upd;
39 gmd_formula_security_policy.drop_recipe_sel;
40 gmd_formula_security_policy.drop_recipe_ins;
41 gmd_formula_security_policy.drop_recipe_upd;
42 -- gmd_formula_security_policy.drop_recipe_vr_sel;
43 gmd_formula_security_policy.drop_recipe_vr_ins;
44 gmd_formula_security_policy.drop_recipe_vr_upd;
45 gmd_formula_security_policy.drop_recipe_step_sel;
46 gmd_formula_security_policy.drop_recipe_step_ins;
47 gmd_formula_security_policy.drop_recipe_step_upd;
48
49 /* BEGIN BUG#2736082 V. Ajay Kumar */
50 /* Removed the reference to apps */
51 gmd_formula_security_policy.formula_activate_upd ('N');
52 /* END BUG#2736082 */
53 commit;
54 end;
55
56
57 END gmd_formula_security_admin;
58
59