DBA Data[Home] [Help]

APPS.CN_RULE_PUB dependencies on JTF_USR_HKS

Line 71: l_OAI_array JTF_USR_HKS.oai_data_array_type;

67:
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:

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 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 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 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 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 489: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;

485: -- XMLGEN.setBindValue('RULE_NAME', l_rule_rec.rule_name);
486:
487:
488: -- get ID for all the bind_variables in a Business Object.
489: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
490:
491: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULE_NAME', l_rule_rec.rule_name, 'S', 'T');
492:
493: -- Message generation API

Line 491: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULE_NAME', l_rule_rec.rule_name, 'S', 'T');

487:
488: -- get ID for all the bind_variables in a Business Object.
489: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
490:
491: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULE_NAME', l_rule_rec.rule_name, 'S', 'T');
492:
493: -- Message generation API
494: JTF_USR_HKS.generate_message
495: (p_prod_code => 'CN',

Line 494: JTF_USR_HKS.generate_message

490:
491: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULE_NAME', l_rule_rec.rule_name, 'S', 'T');
492:
493: -- Message generation API
494: JTF_USR_HKS.generate_message
495: (p_prod_code => 'CN',
496: p_bus_obj_code => 'CRT_RULE',
497: p_action_code => 'I',
498: p_bind_data_id => l_bind_data_id,

Line 512: JTF_USR_HKS.generate_message

508:
509:
510: /*
511: -- Message generation API
512: JTF_USR_HKS.generate_message
513: (p_prod_code => 'CN',
514: p_bus_obj_code => 'CRT_RULE',
515: p_bus_obj_name => 'RULE',
516: p_action_code => 'I',

Line 640: l_OAI_array JTF_USR_HKS.oai_data_array_type;

636:
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);

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 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 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 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 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 1155: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;

1151: -- call this for all bind variables in the business object
1152: -- XMLGEN.setBindValue('RULE_NAME', l_rule_rec.rule_name);
1153:
1154: -- get ID for all the bind_variables in a Business Object.
1155: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
1156:
1157: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULE_NAME', l_rule_rec.rule_name, 'S', 'T');
1158:
1159: -- Message generation API

Line 1157: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULE_NAME', l_rule_rec.rule_name, 'S', 'T');

1153:
1154: -- get ID for all the bind_variables in a Business Object.
1155: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
1156:
1157: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULE_NAME', l_rule_rec.rule_name, 'S', 'T');
1158:
1159: -- Message generation API
1160: JTF_USR_HKS.generate_message
1161: (p_prod_code => 'CN',

Line 1160: JTF_USR_HKS.generate_message

1156:
1157: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULE_NAME', l_rule_rec.rule_name, 'S', 'T');
1158:
1159: -- Message generation API
1160: JTF_USR_HKS.generate_message
1161: (p_prod_code => 'CN',
1162: p_bus_obj_code => 'UPD_RULE',
1163: p_action_code => 'U',
1164: p_bind_data_id => l_bind_data_id,

Line 1178: JTF_USR_HKS.generate_message

1174:
1175:
1176: /*
1177: -- Message generation API
1178: JTF_USR_HKS.generate_message
1179: (p_prod_code => 'CN',
1180: p_bus_obj_code => 'UPD_RULE',
1181: p_bus_obj_name => 'RULE',
1182: p_action_code => 'U',

Line 1313: l_OAI_array JTF_USR_HKS.oai_data_array_type;

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

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 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 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 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 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 1560: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;

1556: -- call this for all bind variables in the business object
1557: -- XMLGEN.setBindValue('RULE_NAME', l_rule_name);
1558:
1559: -- get ID for all the bind_variables in a Business Object.
1560: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
1561:
1562: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULE_NAME', l_rule_name, 'S', 'T');
1563:
1564: -- Message generation API

Line 1562: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULE_NAME', l_rule_name, 'S', 'T');

1558:
1559: -- get ID for all the bind_variables in a Business Object.
1560: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
1561:
1562: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULE_NAME', l_rule_name, 'S', 'T');
1563:
1564: -- Message generation API
1565: JTF_USR_HKS.generate_message
1566: (p_prod_code => 'CN',

Line 1565: JTF_USR_HKS.generate_message

1561:
1562: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULE_NAME', l_rule_name, 'S', 'T');
1563:
1564: -- Message generation API
1565: JTF_USR_HKS.generate_message
1566: (p_prod_code => 'CN',
1567: p_bus_obj_code => 'DEL_RULE',
1568: p_action_code => 'D',
1569: p_bind_data_id => l_bind_data_id,

Line 1582: JTF_USR_HKS.generate_message

1578: END IF;
1579:
1580: /*
1581: -- Message generation API
1582: JTF_USR_HKS.generate_message
1583: (p_prod_code => 'CN',
1584: p_bus_obj_code => 'DEL_RULE',
1585: p_bus_obj_name => 'RULE',
1586: p_action_code => 'D',