APPS.CN_SYIN_RULES_PKG dependencies on CN_RULES_HIERARCHY

Line 60: INSERT INTO cn_rules_hierarchy

56: x_expense_ccid => x_expense_ccid,
57: x_liability_ccid => x_liability_ccid,
58: x_org_id =>x_org_id);
59:
60: INSERT INTO cn_rules_hierarchy
61: (rule_id, parent_rule_id, sequence_number, ruleset_id,org_id)
62: VALUES (x_rule_id, x_parent_rule_id, x_sequence_number, x_ruleset_id, x_org_id);
63:
64: unsync_ruleset(x_ruleset_id,x_org_id);

Line 294: FROM cn_rules_hierarchy

290: procedure DELETE_ROW (X_RULE_ID in NUMBER,
291: X_RULESET_ID in NUMBER,
292: X_ORG_ID IN NUMBER) IS --RC 2/25/99 Added ruleset id
293: Cursor Cascade IS (SELECT rule_id
294: FROM cn_rules_hierarchy
295: WHERE parent_rule_id = x_rule_id
296: AND ruleset_id = x_ruleset_id AND
297: ORG_ID=X_ORG_ID);
298: BEGIN

Line 304: DELETE cn_rules_hierarchy

300: DELETE cn_attribute_rules
301: WHERE rule_id = x_rule_id
302: AND ruleset_id = x_ruleset_id ;
303:
304: DELETE cn_rules_hierarchy
305: WHERE rule_id = x_rule_id
306: AND ruleset_id = x_ruleset_id;
307:
308: delete from CN_RULES_ALL_TL

Line 332: DELETE cn_rules_hierarchy

328: FOR C in Cascade LOOP
329: Delete_Row(C.rule_id, x_ruleset_id,X_ORG_ID);
330: END Loop;
331:
332: DELETE cn_rules_hierarchy
333: WHERE parent_rule_id = x_rule_id
334: AND ruleset_id = x_ruleset_id AND
335: ORG_ID=X_ORG_ID;
336: