APPS.CN_RULEATTRIBUTE_PVT dependencies on CN_RULES

Line 34: FROM cn_rules

30: l_date_value DATE;
31:
32: cursor get_rules IS
33: SELECT name
34: FROM cn_rules
35: WHERE rule_id = p_rule_id
36: AND ruleset_id = p_ruleset_id AND
37: ORG_ID=p_org_id;
38:

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 47: l_rule_name cn_rules.name%TYPE;

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:
51: BEGIN

Line 271: p_rule_id IN cn_rules.rule_id%TYPE,

267: p_value_1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_value_2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
269: p_data_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_object_name IN cn_objects.name%TYPE,
271: p_rule_id IN cn_rules.rule_id%TYPE,
272: p_org_id IN cn_attribute_rules.org_id%TYPE,
273: p_attribute_rule_id IN cn_attribute_rules.attribute_rule_id%TYPE := NULL,
274: x_attribute_rule_id OUT NOCOPY cn_attribute_rules.attribute_rule_id%TYPE,
275: p_loading_status IN VARCHAR2,

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.