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_RULEATTRIBUTE_PUB

Line 1: PACKAGE BODY CN_RuleAttribute_PUB AS

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

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

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

Line 29: -- CN_RuleAttribute_PUB.RuleAttribute_rec_type

25: -- Default = FND_API.G_FALSE
26: -- p_validation_level IN NUMBER Optional
27: -- Default = FND_API.G_VALID_LEVEL_FULL
28: -- p_RuleAttribute_rec IN
29: -- CN_RuleAttribute_PUB.RuleAttribute_rec_type
30: --
31: -- OUT : x_return_status OUT VARCHAR2(1)
32: -- x_msg_count OUT NUMBER
33: -- x_msg_data OUT VARCHAR2(2000)

Line 55: p_RuleAttribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type

51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,
54: x_loading_status OUT NOCOPY VARCHAR2,
55: p_RuleAttribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
56: )
57: IS
58:
59: l_api_name CONSTANT VARCHAR2(30) := 'Create_RuleAttribute';

Line 79: l_ruleattribute_rec CN_RuleAttribute_PUB.RuleAttribute_rec_type;

75: --
76: -- Declaration for user hooks
77: --
78: l_OAI_array JTF_USR_HKS.oai_data_array_type;
79: l_ruleattribute_rec CN_RuleAttribute_PUB.RuleAttribute_rec_type;
80:
81: BEGIN
82:
83: -- Standard Start of API savepoint

Line 116: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',

112: -- User hooks
113: --
114:
115: -- customer pre-processing section
116: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',
117: 'CREATE_RULEATTRIBUTE',
118: 'B',
119: 'C')
120: THEN

Line 121: cn_ruleattribute_pub_cuhk.create_ruleattribute_pre

117: 'CREATE_RULEATTRIBUTE',
118: 'B',
119: 'C')
120: THEN
121: cn_ruleattribute_pub_cuhk.create_ruleattribute_pre
122: (p_api_version => p_api_version,
123: p_init_msg_list => p_init_msg_list,
124: p_commit => p_commit,
125: p_validation_level => p_validation_level,

Line 142: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',

138: END IF;
139: END IF;
140:
141: -- vertical industry pre-processing section
142: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',
143: 'CREATE_RULEATTRIBUTE',
144: 'B',
145: 'V')
146: THEN

Line 147: cn_ruleattribute_pub_vuhk.create_ruleattribute_pre

143: 'CREATE_RULEATTRIBUTE',
144: 'B',
145: 'V')
146: THEN
147: cn_ruleattribute_pub_vuhk.create_ruleattribute_pre
148: (p_api_version => p_api_version,
149: p_init_msg_list => p_init_msg_list,
150: p_commit => p_commit,
151: p_validation_level => p_validation_level,

Line 307: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',

303:
304: -- SK Start of post processing hooks
305:
306: -- vertical post processing section
307: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',
308: 'CREATE_RULEATTRIBUTE',
309: 'A',
310: 'V')
311: THEN

Line 312: cn_ruleattribute_pub_vuhk.create_ruleattribute_post

308: 'CREATE_RULEATTRIBUTE',
309: 'A',
310: 'V')
311: THEN
312: cn_ruleattribute_pub_vuhk.create_ruleattribute_post
313: (p_api_version => p_api_version,
314: p_init_msg_list => p_init_msg_list,
315: p_commit => p_commit,
316: p_validation_level => p_validation_level,

Line 333: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',

329: END IF;
330: END IF;
331:
332: -- customer post processing section
333: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',
334: 'CREATE_RULEATTRIBUTE',
335: 'A',
336: 'C')
337: THEN

Line 338: cn_ruleattribute_pub_cuhk.create_ruleattribute_post

334: 'CREATE_RULEATTRIBUTE',
335: 'A',
336: 'C')
337: THEN
338: cn_ruleattribute_pub_cuhk.create_ruleattribute_post
339: (p_api_version => p_api_version,
340: p_init_msg_list => p_init_msg_list,
341: p_commit => p_commit,
342: p_validation_level => p_validation_level,

Line 359: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',

355: END IF;
356: END IF;
357:
358: -- Message generation section.
359: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',
360: 'CREATE_RULEATTRIBUTE',
361: 'M',
362: 'M')
363: THEN

Line 364: IF cn_ruleattribute_pub_cuhk.ok_to_generate_msg

360: 'CREATE_RULEATTRIBUTE',
361: 'M',
362: 'M')
363: THEN
364: IF cn_ruleattribute_pub_cuhk.ok_to_generate_msg
365: (p_ruleattribute_rec => l_ruleattribute_rec)
366: THEN
367: -- Clear bind variables
368: -- XMLGEN.clearBindValues;

Line 483: -- CN_RuleAttribute_PUB.rule_rec_type

479: -- Default = FND_API.G_FALSE
480: -- p_validation_level IN NUMBER Optional
481: -- Default = FND_API.G_VALID_LEVEL_FULL
482: -- p_rule_rec_type IN
483: -- CN_RuleAttribute_PUB.rule_rec_type
484: -- p_RuleAttribute_rec_type IN
485: -- CN_RuleAttribute_PUB.RuleAttribute_rec_type
486: --
487: -- OUT : x_return_status OUT VARCHAR2(1)

Line 485: -- CN_RuleAttribute_PUB.RuleAttribute_rec_type

481: -- Default = FND_API.G_VALID_LEVEL_FULL
482: -- p_rule_rec_type IN
483: -- CN_RuleAttribute_PUB.rule_rec_type
484: -- p_RuleAttribute_rec_type IN
485: -- CN_RuleAttribute_PUB.RuleAttribute_rec_type
486: --
487: -- OUT : x_return_status OUT VARCHAR2(1)
488: -- x_msg_count OUT NUMBER
489: -- x_msg_data OUT VARCHAR2(2000)

Line 512: p_old_RuleAttribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type,

508: x_return_status OUT NOCOPY VARCHAR2,
509: x_msg_count OUT NOCOPY NUMBER,
510: x_msg_data OUT NOCOPY VARCHAR2,
511: x_loading_status OUT NOCOPY VARCHAR2,
512: p_old_RuleAttribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type,
513: p_RuleAttribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
514: ) IS
515:
516: l_api_name CONSTANT VARCHAR2(30) := 'Update_RuleAttribute';

Line 513: p_RuleAttribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type

509: x_msg_count OUT NOCOPY NUMBER,
510: x_msg_data OUT NOCOPY VARCHAR2,
511: x_loading_status OUT NOCOPY VARCHAR2,
512: p_old_RuleAttribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type,
513: p_RuleAttribute_rec IN CN_RuleAttribute_PUB.RuleAttribute_rec_type
514: ) IS
515:
516: l_api_name CONSTANT VARCHAR2(30) := 'Update_RuleAttribute';
517: l_api_version CONSTANT NUMBER := 1.0;

Line 528: l_old_RuleAttribute_rec CN_RuleAttribute_PUB.RuleAttribute_rec_type;

524: --
525: --Declaration for user hooks
526: --
527: l_OAI_array JTF_USR_HKS.oai_data_array_type;
528: l_old_RuleAttribute_rec CN_RuleAttribute_PUB.RuleAttribute_rec_type;
529: l_RuleAttribute_rec CN_RuleAttribute_PUB.RuleAttribute_rec_type;
530: l_bind_data_id NUMBER;
531: l_return_code VARCHAR2(1);
532:

Line 529: l_RuleAttribute_rec CN_RuleAttribute_PUB.RuleAttribute_rec_type;

525: --Declaration for user hooks
526: --
527: l_OAI_array JTF_USR_HKS.oai_data_array_type;
528: l_old_RuleAttribute_rec CN_RuleAttribute_PUB.RuleAttribute_rec_type;
529: l_RuleAttribute_rec CN_RuleAttribute_PUB.RuleAttribute_rec_type;
530: l_bind_data_id NUMBER;
531: l_return_code VARCHAR2(1);
532:
533:

Line 589: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',

585: -- User hooks
586: --
587:
588: -- customer pre-processing section
589: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',
590: 'UPDATE_RULEATTRIBUTE',
591: 'B',
592: 'C')
593: THEN

Line 594: cn_ruleattribute_pub_cuhk.update_ruleattribute_pre

590: 'UPDATE_RULEATTRIBUTE',
591: 'B',
592: 'C')
593: THEN
594: cn_ruleattribute_pub_cuhk.update_ruleattribute_pre
595: (p_api_version => p_api_version,
596: p_init_msg_list => p_init_msg_list,
597: p_commit => p_commit,
598: p_validation_level => p_validation_level,

Line 616: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',

612: END IF;
613: END IF;
614:
615: -- vertical industry pre-processing section
616: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',
617: 'UPDATE_RULEATTRIBUTE',
618: 'B',
619: 'V')
620: THEN

Line 621: cn_ruleattribute_pub_vuhk.update_ruleattribute_pre

617: 'UPDATE_RULEATTRIBUTE',
618: 'B',
619: 'V')
620: THEN
621: cn_ruleattribute_pub_vuhk.update_ruleattribute_pre
622: (p_api_version => p_api_version,
623: p_init_msg_list => p_init_msg_list,
624: p_commit => p_commit,
625: p_validation_level => p_validation_level,

Line 907: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',

903:
904: -- SK Start of post processing hooks
905:
906: -- vertical industry pre-processing section
907: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',
908: 'UPDATE_RULEATTRIBUTE',
909: 'A',
910: 'V')
911: THEN

Line 912: cn_ruleattribute_pub_vuhk.update_ruleattribute_post

908: 'UPDATE_RULEATTRIBUTE',
909: 'A',
910: 'V')
911: THEN
912: cn_ruleattribute_pub_vuhk.update_ruleattribute_post
913: (p_api_version => p_api_version,
914: p_init_msg_list => p_init_msg_list,
915: p_commit => p_commit,
916: p_validation_level => p_validation_level,

Line 935: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',

931: END IF;
932:
933:
934: -- customer pre-processing section
935: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',
936: 'UPDATE_RULEATTRIBUTE',
937: 'A',
938: 'C')
939: THEN

Line 940: cn_ruleattribute_pub_cuhk.update_ruleattribute_post

936: 'UPDATE_RULEATTRIBUTE',
937: 'A',
938: 'C')
939: THEN
940: cn_ruleattribute_pub_cuhk.update_ruleattribute_post
941: (p_api_version => p_api_version,
942: p_init_msg_list => p_init_msg_list,
943: p_commit => p_commit,
944: p_validation_level => p_validation_level,

Line 964: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',

960: -- SK End of post processing hooks
961:
962:
963: -- Message generation section.
964: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',
965: 'UPDATE_RULEATTRIBUTE',
966: 'M',
967: 'M')
968: THEN

Line 969: IF cn_ruleattribute_pub_cuhk.ok_to_generate_msg

965: 'UPDATE_RULEATTRIBUTE',
966: 'M',
967: 'M')
968: THEN
969: IF cn_ruleattribute_pub_cuhk.ok_to_generate_msg
970: (p_ruleattribute_rec => l_ruleattribute_rec)
971: THEN
972: -- Clear bind variables
973: -- XMLGEN.clearBindValues;

Line 1087: -- CN_RuleAttribute_PUB.rule_rec_type

1083: -- Default = FND_API.G_FALSE
1084: -- p_validation_level IN NUMBER Optional
1085: -- Default = FND_API.G_VALID_LEVEL_FULL
1086: -- p_rule_rec_type IN
1087: -- CN_RuleAttribute_PUB.rule_rec_type
1088: -- p_rule_attr_rec_type IN
1089: -- CN_RuleAttribute_PUB.rule_attr_rec_type
1090: --
1091: -- OUT : x_return_status OUT VARCHAR2(1)

Line 1089: -- CN_RuleAttribute_PUB.rule_attr_rec_type

1085: -- Default = FND_API.G_VALID_LEVEL_FULL
1086: -- p_rule_rec_type IN
1087: -- CN_RuleAttribute_PUB.rule_rec_type
1088: -- p_rule_attr_rec_type IN
1089: -- CN_RuleAttribute_PUB.rule_attr_rec_type
1090: --
1091: -- OUT : x_return_status OUT VARCHAR2(1)
1092: -- x_msg_count OUT NUMBER
1093: -- x_msg_data OUT VARCHAR2(2000)

Line 1119: p_ruleattribute_rec IN CN_RuleAttribute_PUB.ruleattribute_rec_type

1115: x_return_status OUT NOCOPY VARCHAR2,
1116: x_msg_count OUT NOCOPY NUMBER,
1117: x_msg_data OUT NOCOPY VARCHAR2,
1118: x_loading_status OUT NOCOPY VARCHAR2,
1119: p_ruleattribute_rec IN CN_RuleAttribute_PUB.ruleattribute_rec_type
1120: ) IS
1121:
1122:
1123: l_api_name CONSTANT VARCHAR2(30) := 'Delete_RuleAttribute';

Line 1151: l_ruleattribute_rec CN_RuleAttribute_PUB.RuleAttribute_rec_type;

1147: --
1148: -- Declaration for user hooks
1149: --
1150: l_OAI_array JTF_USR_HKS.oai_data_array_type;
1151: l_ruleattribute_rec CN_RuleAttribute_PUB.RuleAttribute_rec_type;
1152: l_bind_data_id NUMBER;
1153: l_return_code VARCHAR2(1);
1154:
1155:

Line 1190: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',

1186: -- User hooks
1187: --
1188:
1189: -- customer pre-processing section
1190: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',
1191: 'DELETE_RULEATTRIBUTE',
1192: 'B',
1193: 'C')
1194: THEN

Line 1195: cn_ruleattribute_pub_cuhk.delete_ruleattribute_pre

1191: 'DELETE_RULEATTRIBUTE',
1192: 'B',
1193: 'C')
1194: THEN
1195: cn_ruleattribute_pub_cuhk.delete_ruleattribute_pre
1196: (p_api_version => p_api_version,
1197: p_init_msg_list => p_init_msg_list,
1198: p_commit => p_commit,
1199: p_validation_level => p_validation_level,

Line 1216: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',

1212: END IF;
1213: END IF;
1214:
1215: -- vertical industry pre-processing section
1216: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',
1217: 'DELETE_RULEATTRIBUTE',
1218: 'B',
1219: 'V')
1220: THEN

Line 1221: cn_ruleattribute_pub_vuhk.delete_ruleattribute_pre

1217: 'DELETE_RULEATTRIBUTE',
1218: 'B',
1219: 'V')
1220: THEN
1221: cn_ruleattribute_pub_vuhk.delete_ruleattribute_pre
1222: (p_api_version => p_api_version,
1223: p_init_msg_list => p_init_msg_list,
1224: p_commit => p_commit,
1225: p_validation_level => p_validation_level,

Line 1400: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',

1396:
1397: -- SK Start of post processing hooks
1398:
1399: -- vertical post processing section
1400: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',
1401: 'DELETE_RULEATTRIBUTE',
1402: 'A',
1403: 'V')
1404: THEN

Line 1405: cn_ruleattribute_pub_vuhk.delete_ruleattribute_pre

1401: 'DELETE_RULEATTRIBUTE',
1402: 'A',
1403: 'V')
1404: THEN
1405: cn_ruleattribute_pub_vuhk.delete_ruleattribute_pre
1406: (p_api_version => p_api_version,
1407: p_init_msg_list => p_init_msg_list,
1408: p_commit => p_commit,
1409: p_validation_level => p_validation_level,

Line 1426: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',

1422: END IF;
1423: END IF;
1424:
1425: -- customer post processing section
1426: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',
1427: 'DELETE_RULEATTRIBUTE',
1428: 'A',
1429: 'C')
1430: THEN

Line 1431: cn_ruleattribute_pub_cuhk.delete_ruleattribute_pre

1427: 'DELETE_RULEATTRIBUTE',
1428: 'A',
1429: 'C')
1430: THEN
1431: cn_ruleattribute_pub_cuhk.delete_ruleattribute_pre
1432: (p_api_version => p_api_version,
1433: p_init_msg_list => p_init_msg_list,
1434: p_commit => p_commit,
1435: p_validation_level => p_validation_level,

Line 1452: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',

1448: END IF;
1449: END IF;
1450:
1451: -- Message generation section.
1452: IF JTF_USR_HKS.Ok_to_Execute('CN_RULEATTRIBUTE_PUB',
1453: 'DELETE_RULEATTRIBUTE',
1454: 'M',
1455: 'M')
1456: THEN

Line 1457: IF cn_ruleattribute_pub_cuhk.ok_to_generate_msg

1453: 'DELETE_RULEATTRIBUTE',
1454: 'M',
1455: 'M')
1456: THEN
1457: IF cn_ruleattribute_pub_cuhk.ok_to_generate_msg
1458: (p_ruleattribute_rec => l_ruleattribute_rec)
1459: THEN
1460: -- Clear bind variables
1461: -- XMLGEN.clearBindValues;

Line 1557: END CN_RuleAttribute_PUB;

1553: p_data => x_msg_data,
1554: p_encoded => fnd_api.g_false
1555: );
1556: END;
1557: END CN_RuleAttribute_PUB;