APPS.CN_CLASSIFICATION_GEN dependencies on CN_RULES_HIERARCHY

Line 724: X_rule_id cn_rules_hierarchy.rule_id%TYPE,

720:
721: PROCEDURE rules_recurse_call (
722: X_ruleset_id cn_rules.ruleset_id%TYPE,
723: x_org_id cn_rules.org_id%TYPE,
724: X_rule_id cn_rules_hierarchy.rule_id%TYPE,
725: code IN OUT NOCOPY cn_utils.clob_code_type,
726: X_package_count cn_rules.package_id%TYPE) IS
727:
728: X_revenue_class NUMBER;

Line 747: FROM cn_rules_hierarchy crh

743: cn_utils.indent(code, 1);
744:
745: SELECT count(*)
746: INTO dummy
747: FROM cn_rules_hierarchy crh
748: WHERE parent_rule_id = X_rule_id
749: AND org_id=x_org_id
750: AND ruleset_id = x_ruleset_id;
751:

Line 1400: X_rule_id cn_rules_hierarchy.rule_id%TYPE,

1396:
1397: PROCEDURE rules_recurse_gen (
1398: x_ruleset_id cn_rulesets.ruleset_id%TYPE,
1399: x_org_id cn_rulesets.org_id%TYPE,
1400: X_rule_id cn_rules_hierarchy.rule_id%TYPE,
1401: code IN OUT NOCOPY cn_utils.clob_code_type) IS
1402: first_flag VARCHAR2(1);
1403: X_revenue_class NUMBER;
1404: X_expense_ccid number;

Line 1415: FROM cn_rules_hierarchy crh,cn_rules cr

1411: dummy NUMBER(7);
1412:
1413: CURSOR rules IS
1414: SELECT crh.rule_id rule_id,cr.org_id,cr.package_id package_id, cr.ruleset_id ruleset_id
1415: FROM cn_rules_hierarchy crh,cn_rules cr
1416: WHERE parent_rule_id = X_rule_id
1417: AND crh.rule_id = cr.rule_id
1418: AND crh.org_id=cr.org_id
1419: AND crh.org_id=x_org_id

Line 1518: X_rule_id cn_rules_hierarchy.rule_id%TYPE,

1514:
1515: PROCEDURE rules_recurse_assign (
1516: X_ruleset_id cn_rules.ruleset_id%TYPE,
1517: x_org_id cn_rules.org_id %TYPE,
1518: X_rule_id cn_rules_hierarchy.rule_id%TYPE,
1519: code IN OUT NOCOPY cn_utils.clob_code_type,
1520: x_rule_count IN OUT NOCOPY NUMBER,
1521: x_package_count IN OUT NOCOPY NUMBER) IS
1522:

Line 1534: FROM cn_rules_hierarchy crh

1530: dummy NUMBER(7);
1531:
1532: CURSOR rules IS
1533: SELECT rule_id,org_id
1534: FROM cn_rules_hierarchy crh
1535: WHERE parent_rule_id = X_rule_id
1536: AND org_id = x_org_id
1537: AND ruleset_id = X_ruleset_id --RC added condition for multiple classification rulesets
1538: ORDER BY sequence_number;

Line 1596: FROM cn_rules_hierarchy

1592: FOR r in rules LOOP
1593:
1594: SELECT count(*)
1595: INTO dummy
1596: FROM cn_rules_hierarchy
1597: WHERE parent_rule_id = r.rule_id
1598: AND org_id=r.org_id ;
1599:
1600: IF (dummy>0) THEN

Line 1662: FROM cn_rules_hierarchy crh, cn_rules cr

1658: -- Note: this assumes that there is exactly one top-level rule for each
1659: -- ruleset. (This assumption is shared by Tony too)
1660: CURSOR rules IS
1661: SELECT DISTINCT cr.rule_id rule_id,cr.org_id org_id,cr.package_id package_id
1662: FROM cn_rules_hierarchy crh, cn_rules cr
1663: WHERE NOT EXISTS (SELECT rule_id
1664: FROM cn_rules_hierarchy where rule_id = crh.parent_rule_id and org_id=crh.org_id)
1665: AND cr.rule_id = crh.parent_rule_id
1666: AND crh.org_id=cr.org_id

Line 1664: FROM cn_rules_hierarchy where rule_id = crh.parent_rule_id and org_id=crh.org_id)

1660: CURSOR rules IS
1661: SELECT DISTINCT cr.rule_id rule_id,cr.org_id org_id,cr.package_id package_id
1662: FROM cn_rules_hierarchy crh, cn_rules cr
1663: WHERE NOT EXISTS (SELECT rule_id
1664: FROM cn_rules_hierarchy where rule_id = crh.parent_rule_id and org_id=crh.org_id)
1665: AND cr.rule_id = crh.parent_rule_id
1666: AND crh.org_id=cr.org_id
1667: and cr.org_id=x_org_id
1668: AND cr.ruleset_id = X_ruleset_id;

Line 1718: FROM cn_rules_hierarchy

1714: FOR r IN rules LOOP
1715:
1716: SELECT count(*)
1717: INTO dummy
1718: FROM cn_rules_hierarchy
1719: WHERE parent_rule_id = r.rule_id
1720: and org_id=r.org_id;
1721:
1722: IF (dummy>0) THEN

Line 1757: FROM cn_rules_hierarchy

1753: FOR rgen IN rules_gen LOOP
1754:
1755: SELECT count(*)
1756: INTO dummy
1757: FROM cn_rules_hierarchy
1758: WHERE parent_rule_id = rgen.rule_id and
1759: org_id=rgen.org_id;
1760:
1761: IF (dummy>0) THEN