3:
4: PROCEDURE add_rule(p_rule_id NUMBER) IS
5:
6: CURSOR documents IS
7: SELECT doctype_id FROM pon_auc_doctypes;
8:
9: BEGIN
10:
11: FOR doc IN documents LOOP
42:
43: PROCEDURE delete_rule(p_rule_id NUMBER) IS
44:
45: CURSOR documents IS
46: SELECT doctype_id FROM pon_auc_doctypes;
47:
48: BEGIN
49: DELETE FROM pon_auc_doctype_rules WHERE bizrule_id = p_rule_id;
50: END delete_rule;
52:
53: PROCEDURE edit_rule(p_rule_id NUMBER) IS
54:
55: CURSOR documents IS
56: SELECT d.doctype_id FROM pon_auc_doctypes d
57: WHERE NOT EXISTS (select 'FOUND' from pon_auc_doctype_rules
58: where bizrule_id = p_rule_id AND doctype_id = d.doctype_id);
59:
60: BEGIN