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_RULE_PUB dependencies on CN_RULESETS

Line 237: FROM cn_rulesets

233:
234: --Now check if the ruleset exists.
235: SELECT count(1)
236: INTO l_count
237: FROM cn_rulesets
238: WHERE name = l_rule_rec.ruleset_name
239: AND start_date = l_rule_rec.start_date
240: AND end_date = l_rule_rec.end_date and
241: org_id=l_rule_rec.org_id;

Line 256: FROM cn_rulesets

252: RAISE FND_API.G_EXC_ERROR;
253: ELSE
254: SELECT ruleset_id
255: INTO l_rule_rec_pvt.ruleset_id
256: FROM cn_rulesets
257: WHERE name = l_rule_rec.ruleset_name
258: AND start_date = l_rule_rec.start_date
259: AND end_date = l_rule_rec.end_date and
260: org_id=l_rule_rec.org_id;

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

643: l_bind_data_id NUMBER;
644: l_return_code VARCHAR2(1);
645:
646:
647: CURSOR get_rules(p_ruleset_id cn_rulesets.ruleset_id%TYPE,p_org_id cn_rulesets.org_id%TYPE) IS
648: SELECT cnrv.rule_id, cnrv.parent_rule_id
649: FROM cn_rules_v cnrv, cn_rules cnr1, cn_rules cnr2
650: WHERE cnr1.name = l_old_rule_rec.rule_name
651: AND cnr2.name = l_old_rule_rec.parent_rule_name

Line 661: CURSOR parent_rules(p_ruleset_id cn_rulesets.ruleset_id%TYPE,p_org_id cn_rulesets.org_id%TYPE) IS

657: and cnr1.org_id = cnr2.org_id
658: and cnrv.org_id = p_org_id;
659:
660:
661: CURSOR parent_rules(p_ruleset_id cn_rulesets.ruleset_id%TYPE,p_org_id cn_rulesets.org_id%TYPE) IS
662: SELECT rule_id
663: FROM cn_rules
664: WHERE name = l_rule_rec.parent_rule_name
665: AND ruleset_id = p_ruleset_id

Line 848: FROM cn_rulesets

844:
845: --Check if the old ruleset exists.
846: SELECT count(1)
847: INTO l_count
848: FROM cn_rulesets
849: WHERE name = l_old_rule_rec.ruleset_name
850: AND start_date = l_old_rule_rec.start_date
851: AND end_date = l_old_rule_rec.end_date;
852: IF l_count = 0

Line 865: FROM cn_rulesets

861: RAISE FND_API.G_EXC_ERROR;
862: ELSE
863: SELECT ruleset_id,org_id
864: INTO l_old_rule_rec_pvt.ruleset_id,l_old_rule_rec_pvt.org_id
865: FROM cn_rulesets
866: WHERE name = l_old_rule_rec.ruleset_name
867: AND start_date = l_old_rule_rec.start_date
868: AND end_date = l_old_rule_rec.end_date;
869: END IF;

Line 874: FROM cn_rulesets

870:
871: --Check if the new ruleset exists.
872: SELECT count(1)
873: INTO l_count
874: FROM cn_rulesets
875: WHERE name = l_rule_rec.ruleset_name
876: AND start_date = l_rule_rec.start_date
877: AND end_date = l_rule_rec.end_date;
878: IF l_count = 0

Line 891: FROM cn_rulesets

887: RAISE FND_API.G_EXC_ERROR;
888: ELSE
889: SELECT ruleset_id,org_id
890: INTO l_rule_rec_pvt.ruleset_id,l_rule_rec_pvt.org_id
891: FROM cn_rulesets
892: WHERE name = l_rule_rec.ruleset_name
893: AND start_date = l_rule_rec.start_date
894: AND end_date = l_rule_rec.end_date;
895: END IF;

Line 1291: p_ruleset_name IN cn_rulesets.name%TYPE,

1287: x_msg_count OUT NOCOPY NUMBER,
1288: x_msg_data OUT NOCOPY VARCHAR2,
1289: x_loading_status OUT NOCOPY VARCHAR2,
1290: p_rule_name IN cn_rules.name%TYPE,
1291: p_ruleset_name IN cn_rulesets.name%TYPE,
1292: p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
1293: p_ruleset_end_date IN cn_rulesets.end_date%TYPE
1294: ) IS
1295:

Line 1292: p_ruleset_start_date IN cn_rulesets.start_date%TYPE,

1288: x_msg_data OUT NOCOPY VARCHAR2,
1289: x_loading_status OUT NOCOPY VARCHAR2,
1290: p_rule_name IN cn_rules.name%TYPE,
1291: p_ruleset_name IN cn_rulesets.name%TYPE,
1292: p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
1293: p_ruleset_end_date IN cn_rulesets.end_date%TYPE
1294: ) IS
1295:
1296:

Line 1293: p_ruleset_end_date IN cn_rulesets.end_date%TYPE

1289: x_loading_status OUT NOCOPY VARCHAR2,
1290: p_rule_name IN cn_rules.name%TYPE,
1291: p_ruleset_name IN cn_rulesets.name%TYPE,
1292: p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
1293: p_ruleset_end_date IN cn_rulesets.end_date%TYPE
1294: ) IS
1295:
1296:
1297: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Rule';

Line 1300: l_ruleset_id cn_rulesets.ruleset_id%TYPE;

1296:
1297: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Rule';
1298: l_api_version CONSTANT NUMBER := 1.0;
1299: l_count NUMBER;
1300: l_ruleset_id cn_rulesets.ruleset_id%TYPE;
1301: l_org_id cn_rulesets.org_id%TYPE;
1302:
1303: CURSOR get_rules(p_ruleset_id cn_rulesets.ruleset_id%TYPE,p_org_id cn_rulesets.org_id%TYPE) IS
1304: SELECT rule_id

Line 1301: l_org_id cn_rulesets.org_id%TYPE;

1297: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Rule';
1298: l_api_version CONSTANT NUMBER := 1.0;
1299: l_count NUMBER;
1300: l_ruleset_id cn_rulesets.ruleset_id%TYPE;
1301: l_org_id cn_rulesets.org_id%TYPE;
1302:
1303: CURSOR get_rules(p_ruleset_id cn_rulesets.ruleset_id%TYPE,p_org_id cn_rulesets.org_id%TYPE) IS
1304: SELECT rule_id
1305: FROM cn_rules

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

1299: l_count NUMBER;
1300: l_ruleset_id cn_rulesets.ruleset_id%TYPE;
1301: l_org_id cn_rulesets.org_id%TYPE;
1302:
1303: CURSOR get_rules(p_ruleset_id cn_rulesets.ruleset_id%TYPE,p_org_id cn_rulesets.org_id%TYPE) IS
1304: SELECT rule_id
1305: FROM cn_rules
1306: WHERE ruleset_id = p_ruleset_id
1307: AND name = p_rule_name AND

Line 1315: l_ruleset_name cn_rulesets.name%TYPE;

1311: --Declaration for user hooks
1312: --
1313: l_OAI_array JTF_USR_HKS.oai_data_array_type;
1314: l_rule_name cn_rules.name%TYPE;
1315: l_ruleset_name cn_rulesets.name%TYPE;
1316: l_ruleset_start_date cn_rulesets.start_date%TYPE;
1317: l_ruleset_end_date cn_rulesets.end_date%TYPE;
1318: l_bind_data_id NUMBER;
1319: l_return_code VARCHAR2(1);

Line 1316: l_ruleset_start_date cn_rulesets.start_date%TYPE;

1312: --
1313: l_OAI_array JTF_USR_HKS.oai_data_array_type;
1314: l_rule_name cn_rules.name%TYPE;
1315: l_ruleset_name cn_rulesets.name%TYPE;
1316: l_ruleset_start_date cn_rulesets.start_date%TYPE;
1317: l_ruleset_end_date cn_rulesets.end_date%TYPE;
1318: l_bind_data_id NUMBER;
1319: l_return_code VARCHAR2(1);
1320:

Line 1317: l_ruleset_end_date cn_rulesets.end_date%TYPE;

1313: l_OAI_array JTF_USR_HKS.oai_data_array_type;
1314: l_rule_name cn_rules.name%TYPE;
1315: l_ruleset_name cn_rulesets.name%TYPE;
1316: l_ruleset_start_date cn_rulesets.start_date%TYPE;
1317: l_ruleset_end_date cn_rulesets.end_date%TYPE;
1318: l_bind_data_id NUMBER;
1319: l_return_code VARCHAR2(1);
1320:
1321:

Line 1423: FROM cn_rulesets

1419: -- API body
1420: --
1421: SELECT COUNT(1)
1422: INTO l_count
1423: FROM cn_rulesets
1424: WHERE name = l_ruleset_name
1425: AND start_date = l_ruleset_start_date
1426: AND end_date = l_ruleset_end_date;
1427:

Line 1442: FROM cn_rulesets

1438: RAISE FND_API.G_EXC_ERROR;
1439: ELSE
1440: SELECT ruleset_id,org_id
1441: INTO l_ruleset_id,l_org_id
1442: FROM cn_rulesets
1443: WHERE name = l_ruleset_name
1444: AND start_date = l_ruleset_start_date
1445: AND end_date = l_ruleset_end_date;
1446: END IF;