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_RULES

Line 74: l_rule_id cn_rules.rule_id%TYPE;

70: --
71: l_OAI_array JTF_USR_HKS.oai_data_array_type;
72: l_rule_rec CN_Rule_PUB.rule_rec_type;
73:
74: l_rule_id cn_rules.rule_id%TYPE;
75:
76: CURSOR parent_rules
77: (p_ruleset_id NUMBER,
78: p_rule_name cn_rules.name%TYPE,p_org_id cn_rules.org_id%TYPE )IS

Line 78: p_rule_name cn_rules.name%TYPE,p_org_id cn_rules.org_id%TYPE )IS

74: l_rule_id cn_rules.rule_id%TYPE;
75:
76: CURSOR parent_rules
77: (p_ruleset_id NUMBER,
78: p_rule_name cn_rules.name%TYPE,p_org_id cn_rules.org_id%TYPE )IS
79: SELECT rule_id
80: FROM cn_rules
81: WHERE ruleset_id = p_ruleset_id
82: AND name = p_rule_name

Line 80: FROM cn_rules

76: CURSOR parent_rules
77: (p_ruleset_id NUMBER,
78: p_rule_name cn_rules.name%TYPE,p_org_id cn_rules.org_id%TYPE )IS
79: SELECT rule_id
80: FROM cn_rules
81: WHERE ruleset_id = p_ruleset_id
82: AND name = p_rule_name
83: AND ORG_ID=p_org_id;
84:

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 343: FROM cn_rules

339: l_rule_rec_pvt.ORG_ID:=l_rule_rec.ORG_ID;
340: --Validate the parent rule
341: SELECT count(1)
342: INTO l_count
343: FROM cn_rules
344: WHERE name = l_rule_rec.parent_rule_name
345: AND ruleset_id = l_rule_rec_pvt.ruleset_id
346: AND ORG_ID=l_rule_rec_pvt.ORG_ID;
347:

Line 371: select cn_rules_s.nextval

367: LOOP
368:
369: l_rule_rec_pvt.parent_rule_id := i.rule_id;
370:
371: select cn_rules_s.nextval
372: into l_rule_rec_pvt.rule_id
373: from dual;
374:
375: SELECT Nvl(MAX(sequence_number) + 1, 1)

Line 377: FROM cn_rules_hierarchy

373: from dual;
374:
375: SELECT Nvl(MAX(sequence_number) + 1, 1)
376: INTO l_rule_rec_pvt.sequence_number
377: FROM cn_rules_hierarchy
378: WHERE ruleset_id = l_rule_rec_pvt.ruleset_id
379: AND parent_rule_id = l_rule_rec_pvt.parent_rule_id and
380: org_id=l_rule_rec_pvt.org_id;
381:

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 649: FROM cn_rules_v cnrv, cn_rules cnr1, cn_rules cnr2

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
652: AND cnr1.ruleset_id = p_ruleset_id
653: AND cnr2.ruleset_id = p_ruleset_id

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 663: FROM cn_rules

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
666: and org_id=p_org_id;
667:

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 900: FROM cn_rules

896:
897: --Validate old parent rule
898: SELECT count(1)
899: INTO l_count
900: FROM cn_rules
901: WHERE name = l_old_rule_rec.parent_rule_name
902: AND ruleset_id = l_old_rule_rec_pvt.ruleset_id and
903: org_id=l_old_rule_rec_pvt.org_id;
904:

Line 920: FROM cn_rules

916:
917: --Validate new parent rule
918: SELECT count(1)
919: INTO l_count
920: FROM cn_rules
921: WHERE name = l_rule_rec.parent_rule_name
922: AND ruleset_id = l_rule_rec_pvt.ruleset_id
923: and org_id=l_rule_rec_pvt.org_id;
924:

Line 1290: p_rule_name IN cn_rules.name%TYPE,

1286: x_return_status OUT NOCOPY VARCHAR2,
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

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 1305: FROM cn_rules

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
1308: org_id=p_org_id;
1309:

Line 1314: l_rule_name cn_rules.name%TYPE;

1310: --
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;

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;

Line 1659: from cn_rules

1655:
1656: function getRuleHierStr (p_rule_id NUMBER, p_ruleset_id NUMBER) RETURN VARCHAR2 IS
1657: cursor c_rules is
1658: select distinct(name) ruleName
1659: from cn_rules
1660: where rule_id in (
1661: select PARENT_RULE_ID
1662: from cn_rules_hierarchy
1663: where ruleset_id = p_ruleset_id

Line 1662: from cn_rules_hierarchy

1658: select distinct(name) ruleName
1659: from cn_rules
1660: where rule_id in (
1661: select PARENT_RULE_ID
1662: from cn_rules_hierarchy
1663: where ruleset_id = p_ruleset_id
1664: connect by prior PARENT_RULE_ID = rule_id
1665: start with rule_id = p_rule_id);
1666:

Line 1669: from cn_rules

1665: start with rule_id = p_rule_id);
1666:
1667: cursor c_rule_name is
1668: select name
1669: from cn_rules
1670: where rule_id = p_rule_id;
1671:
1672: retStr VARCHAR2(30000);
1673: ruleName cn_rules.name%TYPE;

Line 1673: ruleName cn_rules.name%TYPE;

1669: from cn_rules
1670: where rule_id = p_rule_id;
1671:
1672: retStr VARCHAR2(30000);
1673: ruleName cn_rules.name%TYPE;
1674: i integer := 0;
1675: begin
1676: open c_rule_name;
1677: fetch c_rule_name into ruleName;