APPS.CN_RULEATTRIBUTE_PVT dependencies on CN_RULESETS

Line 41: FROM cn_rulesets

37: ORG_ID=p_org_id;
38:
39: cursor get_rulesets IS
40: SELECT name
41: FROM cn_rulesets
42: WHERE ruleset_id = p_ruleset_id AND
43: ORG_ID=p_org_id;
44:
45:

Line 46: l_ruleset_name cn_rulesets.name%TYPE;

42: WHERE ruleset_id = p_ruleset_id AND
43: ORG_ID=p_org_id;
44:
45:
46: l_ruleset_name cn_rulesets.name%TYPE;
47: l_rule_name cn_rules.name%TYPE;
48:
49: cn_obj_recs get_cn_obj_curs%ROWTYPE;
50:

Line 838: cn_rulesets_pkg.Unsync_ruleset(x_ruleset_id_in => p_RuleAttribute_rec.ruleset_id,

834: -- Added the Code to unsync the rules if any rules added deleted or update
835: -- Added by Kumar Sivasankaran
836: -- Date: 01/30/02
837: --
838: cn_rulesets_pkg.Unsync_ruleset(x_ruleset_id_in => p_RuleAttribute_rec.ruleset_id,
839: x_ruleset_status_in => l_ruleset_status,
840: x_org_id =>p_RuleAttribute_rec.org_id);
841:
842: -- Standard check of p_commit.

Line 1255: cn_rulesets_pkg.Unsync_ruleset(x_ruleset_id_in => p_RuleAttribute_rec.ruleset_id,

1251: -- Added the Code to unsync the rules if any rules added deleted or update
1252: -- Added by Kumar Sivasankaran
1253: -- Date: 01/30/02
1254: --
1255: cn_rulesets_pkg.Unsync_ruleset(x_ruleset_id_in => p_RuleAttribute_rec.ruleset_id,
1256: x_ruleset_status_in => l_ruleset_status,
1257: x_org_id =>p_RuleAttribute_rec.org_id);
1258:
1259:

Line 1482: cn_rulesets_pkg.Unsync_ruleset(x_ruleset_id_in => p_ruleset_id,

1478: -- Added the Code to unsync the rules if any rules added deleted or update
1479: -- Added by Kumar Sivasankaran
1480: -- Date: 01/30/02
1481: --
1482: cn_rulesets_pkg.Unsync_ruleset(x_ruleset_id_in => p_ruleset_id,
1483: x_ruleset_status_in => l_ruleset_status,
1484: x_org_id =>l_org_id);
1485:
1486: -- End of API body.