APPS.PON_BIZRULE_PKG dependencies on PON_AUC_DOCTYPE_RULES

Line 12: INSERT INTO PON_AUC_DOCTYPE_RULES

8:
9: BEGIN
10:
11: FOR doc IN documents LOOP
12: INSERT INTO PON_AUC_DOCTYPE_RULES
13: (BIZRULE_ID,
14: DOCTYPE_ID,
15: DISPLAY_FLAG,
16: REQUIRED_FLAG,

Line 49: DELETE FROM pon_auc_doctype_rules WHERE bizrule_id = p_rule_id;

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;
51:
52:
53: PROCEDURE edit_rule(p_rule_id NUMBER) IS

Line 57: WHERE NOT EXISTS (select 'FOUND' from pon_auc_doctype_rules

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
61:

Line 63: INSERT INTO PON_AUC_DOCTYPE_RULES

59:
60: BEGIN
61:
62: FOR doc IN documents LOOP
63: INSERT INTO PON_AUC_DOCTYPE_RULES
64: (BIZRULE_ID,
65: DOCTYPE_ID,
66: DISPLAY_FLAG,
67: REQUIRED_FLAG,