DBA Data[Home] [Help]

APPS.CN_RULEATTRIBUTE_PUB dependencies on JTF_USR_HKS

Line 78: l_OAI_array JTF_USR_HKS.oai_data_array_type;

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

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

371: -- call this for all bind variables in the business object
372: -- XMLGEN.setBindValue('RULESET_NAME', l_ruleattribute_rec.ruleset_name);
373:
374: -- get ID for all the bind_variables in a Business Object.
375: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
376:
377: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULESET_NAME', l_ruleattribute_rec.ruleset_name, 'S', 'T');
378:
379: -- Message generation API

Line 377: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULESET_NAME', l_ruleattribute_rec.ruleset_name, 'S', 'T');

373:
374: -- get ID for all the bind_variables in a Business Object.
375: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
376:
377: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULESET_NAME', l_ruleattribute_rec.ruleset_name, 'S', 'T');
378:
379: -- Message generation API
380: JTF_USR_HKS.generate_message
381: (p_prod_code => 'CN',

Line 380: JTF_USR_HKS.generate_message

376:
377: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULESET_NAME', l_ruleattribute_rec.ruleset_name, 'S', 'T');
378:
379: -- Message generation API
380: JTF_USR_HKS.generate_message
381: (p_prod_code => 'CN',
382: p_bus_obj_code => 'CRT_RUAT',
383: p_action_code => 'I',
384: p_bind_data_id => l_bind_data_id,

Line 397: JTF_USR_HKS.generate_message

393: END IF;
394:
395: /*
396: -- Message generation API
397: JTF_USR_HKS.generate_message
398: (p_prod_code => 'CN',
399: p_bus_obj_code => 'CRT_RUAT',
400: p_bus_obj_name => 'RATTR',
401: p_action_code => 'I',

Line 527: l_OAI_array JTF_USR_HKS.oai_data_array_type;

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

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

976: -- call this for all bind variables in the business object
977: -- XMLGEN.setBindValue('RULESET_NAME', l_ruleattribute_rec.ruleset_name);
978:
979: -- get ID for all the bind_variables in a Business Object.
980: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
981:
982: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULESET_NAME', l_ruleattribute_rec.ruleset_name, 'S', 'T');
983:
984: -- Message generation API

Line 982: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULESET_NAME', l_ruleattribute_rec.ruleset_name, 'S', 'T');

978:
979: -- get ID for all the bind_variables in a Business Object.
980: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
981:
982: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULESET_NAME', l_ruleattribute_rec.ruleset_name, 'S', 'T');
983:
984: -- Message generation API
985: JTF_USR_HKS.generate_message
986: (p_prod_code => 'CN',

Line 985: JTF_USR_HKS.generate_message

981:
982: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULESET_NAME', l_ruleattribute_rec.ruleset_name, 'S', 'T');
983:
984: -- Message generation API
985: JTF_USR_HKS.generate_message
986: (p_prod_code => 'CN',
987: p_bus_obj_code => 'UPD_RUAT',
988: p_action_code => 'U',
989: p_bind_data_id => l_bind_data_id,

Line 1002: JTF_USR_HKS.generate_message

998: END IF;
999:
1000: /*
1001: -- Message generation API
1002: JTF_USR_HKS.generate_message
1003: (p_prod_code => 'CN',
1004: p_bus_obj_code => 'UPD_RUAT',
1005: p_bus_obj_name => 'RATTR',
1006: p_action_code => 'I',

Line 1150: l_OAI_array JTF_USR_HKS.oai_data_array_type;

1146: AND org_id = p_org_id;
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:

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

1464: -- call this for all bind variables in the business object
1465: -- XMLGEN.setBindValue('RULESET_NAME', l_ruleattribute_rec.ruleset_name);
1466:
1467: -- get ID for all the bind_variables in a Business Object.
1468: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
1469:
1470: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULESET_NAME', l_ruleattribute_rec.ruleset_name, 'S', 'T');
1471:
1472: -- Message generation API

Line 1470: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULESET_NAME', l_ruleattribute_rec.ruleset_name, 'S', 'T');

1466:
1467: -- get ID for all the bind_variables in a Business Object.
1468: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
1469:
1470: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULESET_NAME', l_ruleattribute_rec.ruleset_name, 'S', 'T');
1471:
1472: -- Message generation API
1473: JTF_USR_HKS.generate_message
1474: (p_prod_code => 'CN',

Line 1473: JTF_USR_HKS.generate_message

1469:
1470: JTF_USR_HKS.load_bind_data(l_bind_data_id, 'RULESET_NAME', l_ruleattribute_rec.ruleset_name, 'S', 'T');
1471:
1472: -- Message generation API
1473: JTF_USR_HKS.generate_message
1474: (p_prod_code => 'CN',
1475: p_bus_obj_code => 'DEL_RUAT',
1476: p_action_code => 'D',
1477: p_bind_data_id => l_bind_data_id,

Line 1490: JTF_USR_HKS.generate_message

1486: END IF;
1487:
1488: /*
1489: -- Message generation API
1490: JTF_USR_HKS.generate_message
1491: (p_prod_code => 'CN',
1492: p_bus_obj_code => 'DEL_RUAT',
1493: p_bus_obj_name => 'RATTR',
1494: p_action_code => 'I',