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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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:
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 */
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 */
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');
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:
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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:
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 */
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 */
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');
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: