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_RULES

Line 68: CURSOR get_rules(p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,p_org_id IN cn_rulesets.org_id%TYPE) IS

64: l_bind_data_id NUMBER;
65: l_return_code VARCHAR2(1);
66:
67:
68: CURSOR get_rules(p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,p_org_id IN cn_rulesets.org_id%TYPE) IS
69: SELECT rule_id
70: FROM cn_rules
71: WHERE ruleset_id = p_ruleset_id
72: AND name = p_ruleattribute_rec.rule_name

Line 70: FROM cn_rules

66:
67:
68: CURSOR get_rules(p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,p_org_id IN cn_rulesets.org_id%TYPE) IS
69: SELECT rule_id
70: FROM cn_rules
71: WHERE ruleset_id = p_ruleset_id
72: AND name = p_ruleattribute_rec.rule_name
73: AND org_id=p_org_id;
74:

Line 239: FROM cn_rulesets

235: FROM dual;
236:
237: SELECT count(1)
238: INTO l_count
239: FROM cn_rulesets
240: WHERE name = l_ruleattribute_rec.ruleset_name
241: AND start_date = l_ruleattribute_rec.start_date
242: AND end_date = l_ruleattribute_rec.end_date
243: and org_id=l_RuleAttribute_rec.org_id;

Line 258: FROM cn_rulesets

254: RAISE FND_API.G_EXC_ERROR;
255: ELSE
256: SELECT ruleset_id
257: INTO l_ruleattribute_rec_pvt.ruleset_id
258: FROM cn_rulesets
259: WHERE name = l_ruleattribute_rec.ruleset_name
260: AND start_date = l_ruleattribute_rec.start_date
261: AND end_date = l_ruleattribute_rec.end_date and
262: org_id=l_RuleAttribute_rec.org_id;

Line 534: CURSOR get_rules(p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,

530: l_bind_data_id NUMBER;
531: l_return_code VARCHAR2(1);
532:
533:
534: CURSOR get_rules(p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
535: p_rule_name IN cn_rules.name%TYPE,
536: p_org_id IN cn_rules.org_id%TYPE) IS
537: SELECT rule_id
538: FROM cn_rules

Line 535: p_rule_name IN cn_rules.name%TYPE,

531: l_return_code VARCHAR2(1);
532:
533:
534: CURSOR get_rules(p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
535: p_rule_name IN cn_rules.name%TYPE,
536: p_org_id IN cn_rules.org_id%TYPE) IS
537: SELECT rule_id
538: FROM cn_rules
539: WHERE ruleset_id = p_ruleset_id

Line 536: p_org_id IN cn_rules.org_id%TYPE) IS

532:
533:
534: CURSOR get_rules(p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
535: p_rule_name IN cn_rules.name%TYPE,
536: p_org_id IN cn_rules.org_id%TYPE) IS
537: SELECT rule_id
538: FROM cn_rules
539: WHERE ruleset_id = p_ruleset_id
540: AND name = p_rule_name and

Line 538: FROM cn_rules

534: CURSOR get_rules(p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
535: p_rule_name IN cn_rules.name%TYPE,
536: p_org_id IN cn_rules.org_id%TYPE) IS
537: SELECT rule_id
538: FROM cn_rules
539: WHERE ruleset_id = p_ruleset_id
540: AND name = p_rule_name and
541: org_id=p_org_id;
542:

Line 543: CURSOR get_attribute_rules(p_rule_id IN cn_rules.rule_id%TYPE,

539: WHERE ruleset_id = p_ruleset_id
540: AND name = p_rule_name and
541: org_id=p_org_id;
542:
543: CURSOR get_attribute_rules(p_rule_id IN cn_rules.rule_id%TYPE,
544: p_column_id IN
545: cn_attribute_rules.column_id%TYPE,
546: p_org_id IN cn_rules.org_id%TYPE) IS
547: SELECT attribute_rule_id

Line 546: p_org_id IN cn_rules.org_id%TYPE) IS

542:
543: CURSOR get_attribute_rules(p_rule_id IN cn_rules.rule_id%TYPE,
544: p_column_id IN
545: cn_attribute_rules.column_id%TYPE,
546: p_org_id IN cn_rules.org_id%TYPE) IS
547: SELECT attribute_rule_id
548: FROM cn_attribute_rules
549: WHERE rule_id = p_rule_id
550: AND column_id = p_column_id and

Line 776: FROM cn_rulesets

772: l_count := 0;
773:
774: SELECT count(1)
775: INTO l_count
776: FROM cn_rulesets
777: WHERE name = l_ruleattribute_rec.ruleset_name
778: AND start_date = l_ruleattribute_rec.start_date
779: AND end_date = l_ruleattribute_rec.end_date;
780:

Line 794: FROM cn_rulesets

790: RAISE FND_API.G_EXC_ERROR;
791: ELSE
792: SELECT ruleset_id
793: INTO l_ruleattribute_rec_pvt.ruleset_id
794: FROM cn_rulesets
795: WHERE name = l_ruleattribute_rec.ruleset_name
796: AND start_date = l_ruleattribute_rec.start_date
797: AND end_date = l_ruleattribute_rec.end_date;
798: END IF;

Line 804: FROM cn_rulesets

800: l_count := 0;
801:
802: SELECT count(1)
803: INTO l_count
804: FROM cn_rulesets
805: WHERE name = l_old_ruleattribute_rec.ruleset_name
806: AND start_date = l_old_ruleattribute_rec.start_date
807: AND end_date = l_old_ruleattribute_rec.end_date;
808:

Line 822: FROM cn_rulesets

818: RAISE FND_API.G_EXC_ERROR;
819: ELSE
820: SELECT ruleset_id
821: INTO l_old_ruleattribute_rec_pvt.ruleset_id
822: FROM cn_rulesets
823: WHERE name = l_old_ruleattribute_rec.ruleset_name
824: AND start_date = l_old_ruleattribute_rec.start_date
825: AND end_date = l_old_ruleattribute_rec.end_date and
826: org_id=l_old_ruleattribute_rec.org_id;

Line 1130: (p_ruleset_id IN cn_rulesets.ruleset_id%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,
1132: p_org_id IN cn_rules.org_id%TYPE) IS
1133: SELECT rule_id
1134: FROM cn_rules

Line 1131: p_rule_name IN cn_rules.name%TYPE,

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,
1132: p_org_id IN cn_rules.org_id%TYPE) IS
1133: SELECT rule_id
1134: FROM cn_rules
1135: WHERE ruleset_id = p_ruleset_id

Line 1132: p_org_id IN cn_rules.org_id%TYPE) IS

1128:
1129: CURSOR get_rules
1130: (p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
1131: p_rule_name IN cn_rules.name%TYPE,
1132: p_org_id IN cn_rules.org_id%TYPE) IS
1133: SELECT rule_id
1134: FROM cn_rules
1135: WHERE ruleset_id = p_ruleset_id
1136: AND name = p_rule_name

Line 1134: FROM cn_rules

1130: (p_ruleset_id IN cn_rulesets.ruleset_id%TYPE,
1131: p_rule_name IN cn_rules.name%TYPE,
1132: p_org_id IN cn_rules.org_id%TYPE) IS
1133: SELECT rule_id
1134: FROM cn_rules
1135: WHERE ruleset_id = p_ruleset_id
1136: AND name = p_rule_name
1137: AND org_id = p_org_id;
1138:

Line 1139: CURSOR get_attribute_rules(p_rule_id IN cn_rules.rule_id%TYPE,

1135: WHERE ruleset_id = p_ruleset_id
1136: AND name = p_rule_name
1137: AND org_id = p_org_id;
1138:
1139: CURSOR get_attribute_rules(p_rule_id IN cn_rules.rule_id%TYPE,
1140: p_column_id IN cn_attribute_rules.column_id%TYPE,
1141: p_org_id IN cn_rules.org_id%TYPE) IS
1142: SELECT attribute_rule_id,object_version_number
1143: FROM cn_attribute_rules

Line 1141: p_org_id IN cn_rules.org_id%TYPE) IS

1137: AND org_id = p_org_id;
1138:
1139: CURSOR get_attribute_rules(p_rule_id IN cn_rules.rule_id%TYPE,
1140: p_column_id IN cn_attribute_rules.column_id%TYPE,
1141: p_org_id IN cn_rules.org_id%TYPE) IS
1142: SELECT attribute_rule_id,object_version_number
1143: FROM cn_attribute_rules
1144: WHERE rule_id = p_rule_id
1145: AND column_id = p_column_id

Line 1312: FROM cn_rulesets

1308: l_count := 0;
1309:
1310: SELECT count(1)
1311: INTO l_count
1312: FROM cn_rulesets
1313: WHERE name = l_ruleattribute_rec.ruleset_name
1314: AND start_date = l_ruleattribute_rec.start_date
1315: AND end_date = l_ruleattribute_rec.end_date;
1316:

Line 1330: FROM cn_rulesets

1326: RAISE FND_API.G_EXC_ERROR;
1327: ELSE
1328: SELECT ruleset_id
1329: INTO l_ruleattribute_rec_pvt.ruleset_id
1330: FROM cn_rulesets
1331: WHERE name = l_ruleattribute_rec.ruleset_name
1332: AND start_date = l_ruleattribute_rec.start_date
1333: AND end_date = l_ruleattribute_rec.end_date;
1334: END IF;