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_RULE_PUB

Line 1: PACKAGE BODY CN_Rule_PUB AS

1: PACKAGE BODY CN_Rule_PUB AS
2: --$Header: cnpruleb.pls 120.2 2005/08/25 23:37:44 rramakri noship $
3:
4: --Global Variables
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_Rule_PUB';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_Rule_PUB';

1: PACKAGE BODY CN_Rule_PUB AS
2: --$Header: cnpruleb.pls 120.2 2005/08/25 23:37:44 rramakri noship $
3:
4: --Global Variables
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_Rule_PUB';
6: G_LAST_UPDATE_DATE DATE := Sysdate;
7: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
8: G_CREATION_DATE DATE := Sysdate;
9: G_CREATED_BY NUMBER := fnd_global.user_id;

Line 28: -- CN_Rule_PUB.rule_rec_type

24: -- Default = FND_API.G_FALSE
25: -- p_validation_level IN NUMBER Optional
26: -- Default = FND_API.G_VALID_LEVEL_FULL
27: -- p_rule_rec IN
28: -- CN_Rule_PUB.rule_rec_type
29: --
30: -- OUT : x_return_status OUT VARCHAR2(1)
31: -- x_msg_count OUT NUMBER
32: -- x_msg_data OUT VARCHAR2(2000)

Line 54: p_rule_rec IN OUT NOCOPY CN_Rule_PUB.rule_rec_type

50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,
52: x_msg_data OUT NOCOPY VARCHAR2,
53: x_loading_status OUT NOCOPY VARCHAR2,
54: p_rule_rec IN OUT NOCOPY CN_Rule_PUB.rule_rec_type
55: )
56: IS
57:
58: l_api_name CONSTANT VARCHAR2(30) := 'Create_Rule';

Line 72: l_rule_rec CN_Rule_PUB.rule_rec_type;

68: --
69: -- Declaration for user hooks
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

Line 124: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',

120: -- User hooks
121: --
122:
123: -- customer pre-processing section
124: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',
125: 'CREATE_RULE',
126: 'B',
127: 'C')
128: THEN

Line 129: cn_rule_pub_cuhk.create_rule_pre

125: 'CREATE_RULE',
126: 'B',
127: 'C')
128: THEN
129: cn_rule_pub_cuhk.create_rule_pre
130: (p_api_version => p_api_version,
131: p_init_msg_list => p_init_msg_list,
132: p_commit => p_commit,
133: p_validation_level => p_validation_level,

Line 150: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',

146: END IF;
147: END IF;
148:
149: -- vertical industry pre-processing section
150: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',
151: 'CREATE_RULE',
152: 'B',
153: 'V')
154: THEN

Line 155: cn_rule_pub_vuhk.create_rule_pre

151: 'CREATE_RULE',
152: 'B',
153: 'V')
154: THEN
155: cn_rule_pub_vuhk.create_rule_pre
156: (p_api_version => p_api_version,
157: p_init_msg_list => p_init_msg_list,
158: p_commit => p_commit,
159: p_validation_level => p_validation_level,

Line 416: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',

412:
413: -- SK Start of post processing hooks
414:
415: -- vertical post processing section
416: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',
417: 'CREATE_RULE',
418: 'A',
419: 'V')
420: THEN

Line 421: cn_rule_pub_vuhk.create_rule_post

417: 'CREATE_RULE',
418: 'A',
419: 'V')
420: THEN
421: cn_rule_pub_vuhk.create_rule_post
422: (p_api_version => p_api_version,
423: p_init_msg_list => p_init_msg_list,
424: p_commit => p_commit,
425: p_validation_level => p_validation_level,

Line 442: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',

438: END IF;
439: END IF;
440:
441: -- customer post processing section
442: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',
443: 'CREATE_RULE',
444: 'A',
445: 'C')
446: THEN

Line 447: cn_rule_pub_cuhk.create_rule_post

443: 'CREATE_RULE',
444: 'A',
445: 'C')
446: THEN
447: cn_rule_pub_cuhk.create_rule_post
448: (p_api_version => p_api_version,
449: p_init_msg_list => p_init_msg_list,
450: p_commit => p_commit,
451: p_validation_level => p_validation_level,

Line 470: IF JTF_USR_HKS.Ok_to_execute('CN_RULE_PUB',

466: -- SK End of post processing hooks
467:
468:
469: -- Message generation section.
470: IF JTF_USR_HKS.Ok_to_execute('CN_RULE_PUB',
471: 'CREATE_RULE',
472: 'M',
473: 'M')
474: THEN

Line 475: IF cn_rule_pub_cuhk.ok_to_generate_msg

471: 'CREATE_RULE',
472: 'M',
473: 'M')
474: THEN
475: IF cn_rule_pub_cuhk.ok_to_generate_msg
476: -- (p_rule_rec => l_rule_rec)
477: (p_rule_name => l_rule_rec.rule_name)
478:
479: THEN

Line 598: -- CN_Rule_PUB.rule_rec_type

594: -- Default = FND_API.G_FALSE
595: -- p_validation_level IN NUMBER Optional
596: -- Default = FND_API.G_VALID_LEVEL_FULL
597: -- p_rule_rec_type IN
598: -- CN_Rule_PUB.rule_rec_type
599: --
600: -- OUT : x_return_status OUT VARCHAR2(1)
601: -- x_msg_count OUT NUMBER
602: -- x_msg_data OUT VARCHAR2(2000)

Line 625: p_old_rule_rec IN OUT NOCOPY CN_Rule_PUB.rule_rec_type,

621: x_return_status OUT NOCOPY VARCHAR2,
622: x_msg_count OUT NOCOPY NUMBER,
623: x_msg_data OUT NOCOPY VARCHAR2,
624: x_loading_status OUT NOCOPY VARCHAR2,
625: p_old_rule_rec IN OUT NOCOPY CN_Rule_PUB.rule_rec_type,
626: p_rule_rec IN OUT NOCOPY CN_Rule_PUB.rule_rec_type
627: ) IS
628:
629: l_api_name CONSTANT VARCHAR2(30) := 'Update_Rule';

Line 626: p_rule_rec IN OUT NOCOPY CN_Rule_PUB.rule_rec_type

622: x_msg_count OUT NOCOPY NUMBER,
623: x_msg_data OUT NOCOPY VARCHAR2,
624: x_loading_status OUT NOCOPY VARCHAR2,
625: p_old_rule_rec IN OUT NOCOPY CN_Rule_PUB.rule_rec_type,
626: p_rule_rec IN OUT NOCOPY CN_Rule_PUB.rule_rec_type
627: ) IS
628:
629: l_api_name CONSTANT VARCHAR2(30) := 'Update_Rule';
630: l_api_version CONSTANT NUMBER := 1.0;

Line 641: l_old_rule_rec CN_Rule_PUB.rule_rec_type;

637: --
638: --Declaration for user hooks
639: --
640: l_OAI_array JTF_USR_HKS.oai_data_array_type;
641: l_old_rule_rec CN_Rule_PUB.rule_rec_type;
642: l_rule_rec CN_Rule_PUB.rule_rec_type;
643: l_bind_data_id NUMBER;
644: l_return_code VARCHAR2(1);
645:

Line 642: l_rule_rec CN_Rule_PUB.rule_rec_type;

638: --Declaration for user hooks
639: --
640: l_OAI_array JTF_USR_HKS.oai_data_array_type;
641: l_old_rule_rec CN_Rule_PUB.rule_rec_type;
642: l_rule_rec CN_Rule_PUB.rule_rec_type;
643: l_bind_data_id NUMBER;
644: l_return_code VARCHAR2(1);
645:
646:

Line 705: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',

701: -- User hooks
702: --
703:
704: -- customer pre-processing section
705: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',
706: 'UPDATE_RULE',
707: 'B',
708: 'C')
709: THEN

Line 710: cn_rule_pub_cuhk.update_rule_pre

706: 'UPDATE_RULE',
707: 'B',
708: 'C')
709: THEN
710: cn_rule_pub_cuhk.update_rule_pre
711: (p_api_version => p_api_version,
712: p_init_msg_list => p_init_msg_list,
713: p_commit => p_commit,
714: p_validation_level => p_validation_level,

Line 732: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',

728: END IF;
729: END IF;
730:
731: -- vertical industry pre-processing section
732: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',
733: 'UPDATE_RULE',
734: 'B',
735: 'V')
736: THEN

Line 737: cn_rule_pub_vuhk.update_rule_pre

733: 'UPDATE_RULE',
734: 'B',
735: 'V')
736: THEN
737: cn_rule_pub_vuhk.update_rule_pre
738: (p_api_version => p_api_version,
739: p_init_msg_list => p_init_msg_list,
740: p_commit => p_commit,
741: p_validation_level => p_validation_level,

Line 1081: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',

1077:
1078: -- SK Start of post processing hooks
1079:
1080: -- vertical post processing section
1081: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',
1082: 'UPDATE_RULE',
1083: 'A',
1084: 'V')
1085: THEN

Line 1086: cn_rule_pub_vuhk.update_rule_post

1082: 'UPDATE_RULE',
1083: 'A',
1084: 'V')
1085: THEN
1086: cn_rule_pub_vuhk.update_rule_post
1087: (p_api_version => p_api_version,
1088: p_init_msg_list => p_init_msg_list,
1089: p_commit => p_commit,
1090: p_validation_level => p_validation_level,

Line 1108: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',

1104: END IF;
1105: END IF;
1106:
1107: -- customer post processing section
1108: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',
1109: 'UPDATE_RULE',
1110: 'A',
1111: 'C')
1112: THEN

Line 1113: cn_rule_pub_cuhk.update_rule_post

1109: 'UPDATE_RULE',
1110: 'A',
1111: 'C')
1112: THEN
1113: cn_rule_pub_cuhk.update_rule_post
1114: (p_api_version => p_api_version,
1115: p_init_msg_list => p_init_msg_list,
1116: p_commit => p_commit,
1117: p_validation_level => p_validation_level,

Line 1137: IF JTF_USR_HKS.Ok_to_execute('CN_RULE_PUB',

1133: -- SK End of post processing hooks
1134:
1135:
1136: -- Message generation section.
1137: IF JTF_USR_HKS.Ok_to_execute('CN_RULE_PUB',
1138: 'UPDATE_RULE',
1139: 'M',
1140: 'M')
1141: THEN

Line 1142: IF cn_rule_pub_cuhk.ok_to_generate_msg

1138: 'UPDATE_RULE',
1139: 'M',
1140: 'M')
1141: THEN
1142: IF cn_rule_pub_cuhk.ok_to_generate_msg
1143: -- (p_rule_rec => l_rule_rec)
1144: (p_rule_name => l_rule_rec.rule_name)
1145: THEN
1146:

Line 1360: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',

1356: -- User hooks
1357: --
1358:
1359: -- customer pre-processing section
1360: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',
1361: 'DELETE_RULE',
1362: 'B',
1363: 'C')
1364: THEN

Line 1365: cn_rule_pub_cuhk.delete_rule_pre

1361: 'DELETE_RULE',
1362: 'B',
1363: 'C')
1364: THEN
1365: cn_rule_pub_cuhk.delete_rule_pre
1366: (p_api_version => p_api_version,
1367: p_init_msg_list => p_init_msg_list,
1368: p_commit => p_commit,
1369: p_validation_level => p_validation_level,

Line 1389: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',

1385: END IF;
1386: END IF;
1387:
1388: -- vertical industry pre-processing section
1389: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',
1390: 'DELETE_RULE',
1391: 'B',
1392: 'V')
1393: THEN

Line 1394: cn_rule_pub_vuhk.delete_rule_pre

1390: 'DELETE_RULE',
1391: 'B',
1392: 'V')
1393: THEN
1394: cn_rule_pub_vuhk.delete_rule_pre
1395: (p_api_version => p_api_version,
1396: p_init_msg_list => p_init_msg_list,
1397: p_commit => p_commit,
1398: p_validation_level => p_validation_level,

Line 1484: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',

1480:
1481: -- SK Start of post processing hooks
1482:
1483: -- vertical post processing section
1484: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',
1485: 'DELETE_RULE',
1486: 'A',
1487: 'V')
1488: THEN

Line 1489: cn_rule_pub_vuhk.delete_rule_post

1485: 'DELETE_RULE',
1486: 'A',
1487: 'V')
1488: THEN
1489: cn_rule_pub_vuhk.delete_rule_post
1490: (p_api_version => p_api_version,
1491: p_init_msg_list => p_init_msg_list,
1492: p_commit => p_commit,
1493: p_validation_level => p_validation_level,

Line 1513: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',

1509: END IF;
1510: END IF;
1511:
1512: -- customer post processing section
1513: IF JTF_USR_HKS.Ok_to_Execute('CN_RULE_PUB',
1514: 'DELETE_RULE',
1515: 'A',
1516: 'C')
1517: THEN

Line 1518: cn_rule_pub_cuhk.delete_rule_post

1514: 'DELETE_RULE',
1515: 'A',
1516: 'C')
1517: THEN
1518: cn_rule_pub_cuhk.delete_rule_post
1519: (p_api_version => p_api_version,
1520: p_init_msg_list => p_init_msg_list,
1521: p_commit => p_commit,
1522: p_validation_level => p_validation_level,

Line 1544: IF JTF_USR_HKS.Ok_to_execute('CN_RULE_PUB',

1540: -- SK End of post processing hooks
1541:
1542:
1543: -- Message generation section.
1544: IF JTF_USR_HKS.Ok_to_execute('CN_RULE_PUB',
1545: 'DELETE_RULE',
1546: 'M',
1547: 'M')
1548: THEN

Line 1549: IF cn_rule_pub_cuhk.ok_to_generate_msg

1545: 'DELETE_RULE',
1546: 'M',
1547: 'M')
1548: THEN
1549: IF cn_rule_pub_cuhk.ok_to_generate_msg
1550: (p_rule_name => l_rule_name)
1551: THEN
1552: -- Clear bind variables
1553: -- XMLGEN.clearBindValues;

Line 1703: END CN_Rule_PUB;

1699: return retStr;
1700: end getRuleHierStr;
1701:
1702:
1703: END CN_Rule_PUB;