APPS.CN_RULEATTRIBUTE_PUB dependencies on CN_RULEATTRIBUTE_PVT

Line 62: l_ruleattribute_rec_pvt cn_ruleattribute_pvt.ruleattribute_rec_type;

58:
59: l_api_name CONSTANT VARCHAR2(30) := 'Create_RuleAttribute';
60: l_api_version CONSTANT NUMBER := 1.0;
61: l_count NUMBER;
62: l_ruleattribute_rec_pvt cn_ruleattribute_pvt.ruleattribute_rec_type;
63: l_object_id cn_objects.object_id%TYPE;
64: l_bind_data_id NUMBER;
65: l_return_code VARCHAR2(1);
66:

Line 276: cn_ruleattribute_pvt.create_ruleattribute

272: FOR i IN get_rules(l_ruleattribute_rec_pvt.ruleset_id,l_ruleattribute_rec_pvt.org_id)
273: LOOP
274: l_ruleattribute_rec_pvt.rule_id := i.rule_id;
275:
276: cn_ruleattribute_pvt.create_ruleattribute
277: (p_api_version => p_api_version,
278: p_init_msg_list => p_init_msg_list,
279: p_commit => p_commit,
280: p_validation_level => p_validation_level,

Line 518: l_ruleattribute_rec_pvt cn_ruleattribute_pvt.ruleattribute_rec_type;

514: ) IS
515:
516: l_api_name CONSTANT VARCHAR2(30) := 'Update_RuleAttribute';
517: l_api_version CONSTANT NUMBER := 1.0;
518: l_ruleattribute_rec_pvt cn_ruleattribute_pvt.ruleattribute_rec_type;
519: l_old_ruleattribute_rec_pvt cn_ruleattribute_pvt.ruleattribute_rec_type;
520: l_object_id cn_objects.object_id%TYPE;
521: l_old_object_id cn_objects.object_id%TYPE;
522: l_count NUMBER;

Line 519: l_old_ruleattribute_rec_pvt cn_ruleattribute_pvt.ruleattribute_rec_type;

515:
516: l_api_name CONSTANT VARCHAR2(30) := 'Update_RuleAttribute';
517: l_api_version CONSTANT NUMBER := 1.0;
518: l_ruleattribute_rec_pvt cn_ruleattribute_pvt.ruleattribute_rec_type;
519: l_old_ruleattribute_rec_pvt cn_ruleattribute_pvt.ruleattribute_rec_type;
520: l_object_id cn_objects.object_id%TYPE;
521: l_old_object_id cn_objects.object_id%TYPE;
522: l_count NUMBER;
523:

Line 874: cn_ruleattribute_pvt.update_ruleattribute

870: LOOP
871: l_ruleattribute_rec_pvt.attribute_rule_id := j.attribute_rule_id;
872: l_old_ruleattribute_rec_pvt.attribute_rule_id := j.attribute_rule_id;
873:
874: cn_ruleattribute_pvt.update_ruleattribute
875: (p_api_version => p_api_version,
876: p_init_msg_list => p_init_msg_list,
877: p_commit => p_commit,
878: p_validation_level => p_validation_level,

Line 1125: l_ruleattribute_rec_pvt cn_ruleattribute_pvt.ruleattribute_rec_type;

1121:
1122:
1123: l_api_name CONSTANT VARCHAR2(30) := 'Delete_RuleAttribute';
1124: l_api_version CONSTANT NUMBER := 1.0;
1125: l_ruleattribute_rec_pvt cn_ruleattribute_pvt.ruleattribute_rec_type;
1126: l_count NUMBER;
1127: l_object_id cn_objects.object_id%TYPE;
1128:
1129: CURSOR get_rules

Line 1364: cn_ruleattribute_pvt.delete_ruleattribute

1360: FOR j IN get_attribute_rules(i.rule_id, l_object_id,l_ruleattribute_rec_pvt.org_id)
1361: LOOP
1362: l_ruleattribute_rec_pvt.attribute_rule_id := j.attribute_rule_id;
1363: l_ruleattribute_rec_pvt.object_version_number := j.object_version_number;
1364: cn_ruleattribute_pvt.delete_ruleattribute
1365: (p_api_version => p_api_version,
1366: p_init_msg_list => p_init_msg_list,
1367: p_commit => p_commit,
1368: p_validation_level => p_validation_level,