eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_RULEATTRIBUTE_PUB dependencies on CN_OBJECTS

Line 63: l_object_id cn_objects.object_id%TYPE;

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:
67:

Line 228: FROM cn_objects

224: END IF;
225:
226: SELECT object_id
227: INTO l_object_id
228: FROM cn_objects
229: WHERE name = l_RuleAttribute_rec.object_name
230: AND table_id = -11803 and
231: org_id=l_RuleAttribute_rec.org_id;
232:

Line 520: l_object_id cn_objects.object_id%TYPE;

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:
524: --

Line 521: l_old_object_id cn_objects.object_id%TYPE;

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:
524: --
525: --Declaration for user hooks

Line 761: FROM cn_objects

757:
758: -- l_old_ruleattribute_rec.object_name := p_old_ruleattribute_rec.object_name;
759: SELECT object_id
760: INTO l_old_object_id
761: FROM cn_objects
762: WHERE name = l_old_RuleAttribute_rec.object_name
763: AND table_id = -11803;
764:
765: -- l_ruleattribute_rec.object_name := l_ruleattribute_rec.object_name;

Line 768: FROM cn_objects

764:
765: -- l_ruleattribute_rec.object_name := l_ruleattribute_rec.object_name;
766: SELECT object_id
767: INTO l_object_id
768: FROM cn_objects
769: WHERE name = l_RuleAttribute_rec.object_name
770: AND table_id = -11803;
771:
772: l_count := 0;

Line 1127: l_object_id cn_objects.object_id%TYPE;

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
1130: (p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
1131: p_rule_name IN cn_rules.name%TYPE,

Line 1303: FROM cn_objects

1299:
1300: -- l_ruleattribute_rec.object_name := p_ruleattribute_rec.object_name;
1301: SELECT object_id
1302: INTO l_object_id
1303: FROM cn_objects
1304: WHERE name = l_RuleAttribute_rec.object_name
1305: AND table_id = -11803
1306: and org_id = l_RuleAttribute_rec.org_id;
1307: