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.XDP_INTERFACES_PUB dependencies on JTF_USR_HKS

Line 37: l_OAI_array JTF_USR_HKS.OAI_data_array_type ;

33: l_return_code varchar2(1);
34: l_data Varchar2(100);
35: l_count Number;
36: l_sdp_order_id number;
37: l_OAI_array JTF_USR_HKS.OAI_data_array_type ;
38: l_bind_data_id number;
39:
40: BEGIN
41:

Line 68: if JTF_USR_HKS.Ok_to_Execute(

64: lv_ORDER_LINE_LIST := P_ORDER_LINE_LIST;
65: lv_LINE_PARAMETER_LIST := P_LINE_PARAMETER_LIST;
66: l_sdp_order_id := x_SDP_ORDER_ID;
67:
68: if JTF_USR_HKS.Ok_to_Execute(
69: 'XDP_INTERFACES_PO_CUHK',
70: 'PROCESS_ORDER_PRE',
71: 'B',
72: 'C' )

Line 91: if JTF_USR_HKS.Ok_to_Execute(

87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: end if;
89: end if;
90:
91: if JTF_USR_HKS.Ok_to_Execute(
92: 'XDP_INTERFACES_PO_VUHK',
93: 'PROCESS_ORDER_PRE',
94: 'B',
95: 'V' )

Line 145: if JTF_USR_HKS.Ok_to_Execute(

141: /******* Post Processing call *******/
142:
143: l_sdp_order_id := x_SDP_ORDER_ID;
144:
145: if JTF_USR_HKS.Ok_to_Execute(
146: 'XDP_INTERFACES_PO_CUHK',
147: 'PROCESS_ORDER_POST',
148: 'A',
149: 'C' )

Line 167: if JTF_USR_HKS.Ok_to_Execute(

163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: end if;
165: end if;
166:
167: if JTF_USR_HKS.Ok_to_Execute(
168: 'XDP_INTERFACES_PO_VUHK',
169: 'PROCESS_ORDER_POST',
170: 'A',
171: 'V' )

Line 193: if JTF_USR_HKS.Ok_to_Execute('XDP_INTERFACES_PO_CUHK',

189:
190:
191: /******* Message Generation Section ********/
192:
193: if JTF_USR_HKS.Ok_to_Execute('XDP_INTERFACES_PO_CUHK',
194: 'Ok_to_Generate_msg',
195: 'M',
196: 'M'
197: ) then

Line 209: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;

205: )) then
206:
207: -- XMLGEN.clearBindValues;
208: -- XMLGEN.setBindValue('ORDER_ID', l_sdp_order_id);
209: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
210: JTF_USR_HKS.Load_Bind_Data(
211: l_bind_data_id,
212: 'ORDER_ID',
213: TO_CHAR(l_sdp_order_id),

Line 210: JTF_USR_HKS.Load_Bind_Data(

206:
207: -- XMLGEN.clearBindValues;
208: -- XMLGEN.setBindValue('ORDER_ID', l_sdp_order_id);
209: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
210: JTF_USR_HKS.Load_Bind_Data(
211: l_bind_data_id,
212: 'ORDER_ID',
213: TO_CHAR(l_sdp_order_id),
214: 'S',

Line 217: JTF_USR_HKS.generate_message(

213: TO_CHAR(l_sdp_order_id),
214: 'S',
215: 'NUMBER');
216:
217: JTF_USR_HKS.generate_message(
218: p_prod_code => 'XDP',
219: p_bus_obj_code => 'PO',
220: p_action_code => 'I',
221: p_correlation => NULL,

Line 309: l_OAI_array JTF_USR_HKS.OAI_data_array_type ;

305: l_return_code varchar2(1);
306: l_data Varchar2(100);
307: l_count Number;
308: l_sdp_order_id number;
309: l_OAI_array JTF_USR_HKS.OAI_data_array_type ;
310: l_bind_data_id number;
311:
312: BEGIN
313:

Line 338: if JTF_USR_HKS.Ok_to_Execute(

334:
335: l_caller_name := p_caller_name;
336: l_sdp_order_id := P_SDP_ORDER_ID;
337:
338: if JTF_USR_HKS.Ok_to_Execute(
339: 'XDP_INTERFACES_CO_CUHK',
340: 'CANCEL_ORDER_PRE',
341: 'B',
342: 'C' )

Line 357: if JTF_USR_HKS.Ok_to_Execute(

353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
354: end if;
355: end if;
356:
357: if JTF_USR_HKS.Ok_to_Execute(
358: 'XDP_INTERFACES_CO_VUHK',
359: 'CANCEL_ORDER_PRE',
360: 'B',
361: 'V' )

Line 405: if JTF_USR_HKS.Ok_to_Execute(

401: /******* Post Processing call *******/
402:
403: l_sdp_order_id := P_SDP_ORDER_ID;
404:
405: if JTF_USR_HKS.Ok_to_Execute(
406: 'XDP_INTERFACES_CO_CUHK',
407: 'CANCEL_ORDER_POST',
408: 'A',
409: 'C' )

Line 424: if JTF_USR_HKS.Ok_to_Execute(

420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: end if;
422: end if;
423:
424: if JTF_USR_HKS.Ok_to_Execute(
425: 'XDP_INTERFACES_CO_VUHK',
426: 'CANCEL_ORDER_POST',
427: 'A',
428: 'V' )

Line 446: if JTF_USR_HKS.Ok_to_Execute('XDP_INTERFACES_CO_CUHK',

442:
443:
444: /******* Message Generation Section ********/
445:
446: if JTF_USR_HKS.Ok_to_Execute('XDP_INTERFACES_CO_CUHK',
447: 'Ok_to_Generate_msg',
448: 'M',
449: 'M'
450: ) then

Line 460: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;

456:
457: --XMLGEN.clearBindValues;
458: --XMLGEN.setBindValue('ORDER_ID', l_sdp_order_id);
459:
460: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
461: JTF_USR_HKS.Load_Bind_Data(
462: l_bind_data_id,
463: 'ORDER_ID',
464: TO_CHAR(l_sdp_order_id),

Line 461: JTF_USR_HKS.Load_Bind_Data(

457: --XMLGEN.clearBindValues;
458: --XMLGEN.setBindValue('ORDER_ID', l_sdp_order_id);
459:
460: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
461: JTF_USR_HKS.Load_Bind_Data(
462: l_bind_data_id,
463: 'ORDER_ID',
464: TO_CHAR(l_sdp_order_id),
465: 'S',

Line 468: JTF_USR_HKS.generate_message(

464: TO_CHAR(l_sdp_order_id),
465: 'S',
466: 'NUMBER');
467:
468: JTF_USR_HKS.generate_message(
469: p_prod_code => 'XDP',
470: p_bus_obj_code => 'CO',
471: p_action_code => 'I',
472: p_correlation => NULL,

Line 722: l_OAI_array JTF_USR_HKS.OAI_data_array_type ;

718: l_return_code VARCHAR2(1);
719: l_data VARCHAR2(100);
720: l_count NUMBER;
721: l_order_id NUMBER;
722: l_OAI_array JTF_USR_HKS.OAI_data_array_type ;
723: l_bind_data_id NUMBER;
724:
725: lv_order_header XDP_TYPES.SERVICE_ORDER_HEADER;
726: lv_order_param_list XDP_TYPES.SERVICE_ORDER_PARAM_LIST;

Line 763: IF JTF_USR_HKS.Ok_to_Execute(

759: TO_NULL(lv_order_param_list);
760: TO_NULL(lv_order_line_list);
761: TO_NULL(lv_line_param_list);
762:
763: IF JTF_USR_HKS.Ok_to_Execute(
764: 'XDP_INTERFACES_SO_CUHK',
765: 'PROCESS_ORDER_PRE',
766: 'B','C' )
767: THEN

Line 784: IF JTF_USR_HKS.Ok_to_Execute(

780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: END IF;
782: END IF;
783:
784: IF JTF_USR_HKS.Ok_to_Execute(
785: 'XDP_INTERFACES_SO_VUHK',
786: 'PROCESS_ORDER_PRE',
787: 'B','V')
788: THEN

Line 841: IF JTF_USR_HKS.Ok_to_Execute(

837:
838: /******* Post Processing call *******/
839: x_order_id := l_order_id;
840:
841: IF JTF_USR_HKS.Ok_to_Execute(
842: 'XDP_INTERFACES_SO_CUHK',
843: 'PROCESS_ORDER_POST',
844: 'A','C' )
845: THEN

Line 862: IF JTF_USR_HKS.Ok_to_Execute(

858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: END IF;
860: END IF;
861:
862: IF JTF_USR_HKS.Ok_to_Execute(
863: 'XDP_INTERFACES_SO_VUHK',
864: 'PROCESS_ORDER_POST',
865: 'A','V' )
866: THEN

Line 885: IF JTF_USR_HKS.Ok_to_Execute(

881: END IF;
882:
883: /******* Message Generation Section ********/
884:
885: IF JTF_USR_HKS.Ok_to_Execute(
886: 'XDP_INTERFACES_SO_CUHK',
887: 'Ok_to_Generate_msg',
888: 'M','M')
889: THEN

Line 900: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;

896:
897: -- XMLGEN.clearBindValues;
898: -- XMLGEN.setBindValue('ORDER_ID', l_sdp_order_id);
899:
900: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
901: JTF_USR_HKS.Load_Bind_Data(
902: l_bind_data_id,
903: 'ORDER_ID',
904: TO_CHAR(l_order_id),

Line 901: JTF_USR_HKS.Load_Bind_Data(

897: -- XMLGEN.clearBindValues;
898: -- XMLGEN.setBindValue('ORDER_ID', l_sdp_order_id);
899:
900: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
901: JTF_USR_HKS.Load_Bind_Data(
902: l_bind_data_id,
903: 'ORDER_ID',
904: TO_CHAR(l_order_id),
905: 'S',

Line 908: JTF_USR_HKS.generate_message(

904: TO_CHAR(l_order_id),
905: 'S',
906: 'NUMBER');
907:
908: JTF_USR_HKS.generate_message(
909: p_prod_code => 'XDP',
910: p_bus_obj_code => 'PO',
911: p_action_code => 'I',
912: p_correlation => NULL,

Line 1039: IF JTF_USR_HKS.Ok_to_Execute(

1035: l_order_id := p_order_id;
1036: l_order_number := p_order_number;
1037: l_order_version := p_order_version;
1038:
1039: IF JTF_USR_HKS.Ok_to_Execute(
1040: 'XDP_INTERFACES_CS_CUHK',
1041: 'CANCEL_ORDER_PRE',
1042: 'B','C' )
1043: THEN

Line 1059: IF JTF_USR_HKS.Ok_to_Execute(

1055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1056: END IF;
1057: END IF;
1058:
1059: IF JTF_USR_HKS.Ok_to_Execute(
1060: 'XDP_INTERFACES_CS_VUHK',
1061: 'CANCEL_ORDER_PRE',
1062: 'B','V' )
1063: THEN

Line 1129: IF JTF_USR_HKS.Ok_to_Execute(

1125:
1126: /******* Post Processing call *******/
1127:
1128:
1129: IF JTF_USR_HKS.Ok_to_Execute(
1130: 'XDP_INTERFACES_CS_CUHK',
1131: 'CANCEL_ORDER_POST',
1132: 'A','C' )
1133: THEN

Line 1149: IF JTF_USR_HKS.Ok_to_Execute(

1145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1146: END IF;
1147: END IF;
1148:
1149: IF JTF_USR_HKS.Ok_to_Execute(
1150: 'XDP_INTERFACES_CS_VUHK',
1151: 'CANCEL_ORDER_POST',
1152: 'A','V' )
1153: THEN

Line 1171: IF JTF_USR_HKS.Ok_to_Execute(

1167: END IF;
1168:
1169: /******* Message Generation Section ********/
1170:
1171: IF JTF_USR_HKS.Ok_to_Execute(
1172: 'XDP_INTERFACES_CS_CUHK',
1173: 'Ok_to_Generate_msg',
1174: 'M','M')
1175: THEN

Line 1291: IF JTF_USR_HKS.Ok_to_Execute(

1287: l_order_id := p_order_id;
1288: l_order_number := p_order_number;
1289: l_order_version := p_order_version;
1290:
1291: IF JTF_USR_HKS.Ok_to_Execute(
1292: 'XDP_INTERFACES_OD_CUHK',
1293: 'GET_ORDER_DETAILS_PRE',
1294: 'B','C' )
1295: THEN

Line 1314: IF JTF_USR_HKS.Ok_to_Execute(

1310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1311: END IF;
1312: END IF;
1313:
1314: IF JTF_USR_HKS.Ok_to_Execute(
1315: 'XDP_INTERFACES_OD_VUHK',
1316: 'GET_ORDER_DETAILS_PRE',
1317: 'B',
1318: 'V' )

Line 1375: IF JTF_USR_HKS.Ok_to_Execute(

1371:
1372:
1373: /******* Post Processing call *******/
1374:
1375: IF JTF_USR_HKS.Ok_to_Execute(
1376: 'XDP_INTERFACES_OD_CUHK',
1377: 'GET_ORDER_DETAILS_POST',
1378: 'A','C' )
1379: THEN

Line 1398: IF JTF_USR_HKS.Ok_to_Execute(

1394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1395: END IF;
1396: END IF;
1397:
1398: IF JTF_USR_HKS.Ok_to_Execute(
1399: 'XDP_INTERFACES_OD_VUHK',
1400: 'GET_ORDER_DETAILS_POST',
1401: 'A','V' )
1402: THEN

Line 1530: IF JTF_USR_HKS.Ok_to_Execute(

1526: l_order_id := p_order_id;
1527: l_order_number := p_order_number;
1528: l_order_version := p_order_version;
1529:
1530: IF JTF_USR_HKS.Ok_to_Execute(
1531: 'XDP_INTERFACES_OS_CUHK',
1532: 'GET_ORDER_STATUS_PRE',
1533: 'B','C' )
1534: THEN

Line 1550: IF JTF_USR_HKS.Ok_to_Execute(

1546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1547: END IF;
1548: END IF;
1549:
1550: IF JTF_USR_HKS.Ok_to_Execute(
1551: 'XDP_INTERFACES_OS_VUHK',
1552: 'GET_ORDER_STATUS_PRE',
1553: 'B',
1554: 'V' )

Line 1603: IF JTF_USR_HKS.Ok_to_Execute(

1599:
1600:
1601: /******* Post Processing call *******/
1602:
1603: IF JTF_USR_HKS.Ok_to_Execute(
1604: 'XDP_INTERFACES_OS_CUHK',
1605: 'GET_ORDER_STATUS_POST',
1606: 'A','C' )
1607: THEN

Line 1623: IF JTF_USR_HKS.Ok_to_Execute(

1619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1620: END IF;
1621: END IF;
1622:
1623: IF JTF_USR_HKS.Ok_to_Execute(
1624: 'XDP_INTERFACES_OS_VUHK',
1625: 'GET_ORDER_STATUS_POST',
1626: 'A','V' )
1627: THEN