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.WSH_INTERFACE_EXT_GRP dependencies on WSH_INTERFACE_EXT_GRP

Line 1: PACKAGE BODY WSH_INTERFACE_EXT_GRP as

1: PACKAGE BODY WSH_INTERFACE_EXT_GRP as
2: /* $Header: WSHEXGPB.pls 120.4.12010000.2 2010/02/10 11:22:06 anvarshn ship $ */
3:
4: --===================
5: -- CONSTANTS

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_INTERFACE_EXT_GRP';

3:
4: --===================
5: -- CONSTANTS
6: --===================
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_INTERFACE_EXT_GRP';
8: -- add your constants here if any
9: --===================
10: -- PUBLIC VARS
11: --===================

Line 176: p_in_rec IN WSH_INTERFACE_EXT_GRP.del_action_parameters_rectype,

172: raise;
173: END Handle_missing_info;
174:
175: Procedure Map_del_act_params_rectype(
176: p_in_rec IN WSH_INTERFACE_EXT_GRP.del_action_parameters_rectype,
177: x_out_rec OUT NOCOPY WSH_DELIVERIES_GRP.action_parameters_rectype) IS
178:
179: Begin
180: x_out_rec.caller := p_in_rec.caller ;

Line 226: x_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Action_Out_Rec_Type) IS

222:
223:
224: Procedure Map_del_act_OutRecType(
225: p_in_rec IN WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type,
226: x_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Action_Out_Rec_Type) IS
227:
228:
229: Begin
230:

Line 262: p_action_prms IN WSH_INTERFACE_EXT_GRP.del_action_parameters_rectype,

258: PROCEDURE Delivery_Action
259: ( p_api_version_number IN NUMBER,
260: p_init_msg_list IN VARCHAR2,
261: p_commit IN VARCHAR2 , -- default fnd_api.g_false
262: p_action_prms IN WSH_INTERFACE_EXT_GRP.del_action_parameters_rectype,
263: p_delivery_id_tab IN wsh_util_core.id_tab_type,
264: x_delivery_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Action_Out_Rec_Type,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,

Line 264: x_delivery_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Action_Out_Rec_Type,

260: p_init_msg_list IN VARCHAR2,
261: p_commit IN VARCHAR2 , -- default fnd_api.g_false
262: p_action_prms IN WSH_INTERFACE_EXT_GRP.del_action_parameters_rectype,
263: p_delivery_id_tab IN wsh_util_core.id_tab_type,
264: x_delivery_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Action_Out_Rec_Type,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2)
268: IS

Line 296: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.DELIVERY_ACTION');

292: EXCEPTION
293: --
294: WHEN OTHERS THEN
295: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
296: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.DELIVERY_ACTION');
297: --
298: END Delivery_Action;
299:
300: Procedure Map_Del_InRecType(

Line 301: p_in_rec IN WSH_INTERFACE_EXT_GRP.Del_In_Rec_Type,

297: --
298: END Delivery_Action;
299:
300: Procedure Map_Del_InRecType(
301: p_in_rec IN WSH_INTERFACE_EXT_GRP.Del_In_Rec_Type,
302: x_out_rec OUT NOCOPY WSH_DELIVERIES_GRP.Del_In_Rec_Type) IS
303:
304: Begin
305:

Line 313: p_in_tab IN WSH_INTERFACE_EXT_GRP.Delivery_Attr_Tbl_Type,

309:
310: End Map_Del_InRecType;
311:
312: Procedure Map_Del_Attr_Tbl_Type (
313: p_in_tab IN WSH_INTERFACE_EXT_GRP.Delivery_Attr_Tbl_Type,
314: x_out_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type) Is
315:
316: Begin
317:

Line 467: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Out_Tbl_Type) IS

463:
464:
465: Procedure Map_Del_OutTblType(
466: p_in_tab IN WSH_DELIVERIES_GRP.Del_Out_Tbl_Type,
467: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Out_Tbl_Type) IS
468:
469:
470: Begin
471:

Line 507: p_in_rec IN WSH_INTERFACE_EXT_GRP.Del_In_Rec_Type,

503: PROCEDURE Create_Update_Delivery
504: ( p_api_version_number IN NUMBER,
505: p_init_msg_list IN VARCHAR2,
506: p_commit IN VARCHAR2 , -- default fnd_api.g_false
507: p_in_rec IN WSH_INTERFACE_EXT_GRP.Del_In_Rec_Type,
508: p_rec_attr_tab IN WSH_INTERFACE_EXT_GRP.Delivery_Attr_Tbl_Type,
509: x_del_out_rec_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Out_Tbl_Type,
510: x_return_status OUT NOCOPY VARCHAR2,
511: x_msg_count OUT NOCOPY NUMBER,

Line 508: p_rec_attr_tab IN WSH_INTERFACE_EXT_GRP.Delivery_Attr_Tbl_Type,

504: ( p_api_version_number IN NUMBER,
505: p_init_msg_list IN VARCHAR2,
506: p_commit IN VARCHAR2 , -- default fnd_api.g_false
507: p_in_rec IN WSH_INTERFACE_EXT_GRP.Del_In_Rec_Type,
508: p_rec_attr_tab IN WSH_INTERFACE_EXT_GRP.Delivery_Attr_Tbl_Type,
509: x_del_out_rec_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Out_Tbl_Type,
510: x_return_status OUT NOCOPY VARCHAR2,
511: x_msg_count OUT NOCOPY NUMBER,
512: x_msg_data OUT NOCOPY VARCHAR2)

Line 509: x_del_out_rec_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Out_Tbl_Type,

505: p_init_msg_list IN VARCHAR2,
506: p_commit IN VARCHAR2 , -- default fnd_api.g_false
507: p_in_rec IN WSH_INTERFACE_EXT_GRP.Del_In_Rec_Type,
508: p_rec_attr_tab IN WSH_INTERFACE_EXT_GRP.Delivery_Attr_Tbl_Type,
509: x_del_out_rec_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.Del_Out_Tbl_Type,
510: x_return_status OUT NOCOPY VARCHAR2,
511: x_msg_count OUT NOCOPY NUMBER,
512: x_msg_data OUT NOCOPY VARCHAR2)
513: IS

Line 544: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_DELIVERY');

540: EXCEPTION
541: --
542: WHEN OTHERS THEN
543: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
544: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_DELIVERY');
545: --
546:
547: END Create_Update_Delivery;
548: --========================================================================

Line 554: p_in_rec IN WSH_INTERFACE_EXT_GRP.det_action_parameters_rec_type,

550: -- I Harmonization: rvishnuv ******* Create/Update ******
551:
552:
553: Procedure map_det_act_params_rec_type(
554: p_in_rec IN WSH_INTERFACE_EXT_GRP.det_action_parameters_rec_type,
555: x_out_rec OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type) IS
556:
557: Begin
558:

Line 582: x_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.det_action_out_rec_type) IS

578:
579:
580: Procedure map_det_act_OutRecType(
581: p_in_rec IN wsh_glbl_var_strct_grp.dd_action_out_rec_type,
582: x_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.det_action_out_rec_type) IS
583:
584: Begin
585:
586: x_out_rec.valid_id_tab := p_in_rec.valid_id_tab ;

Line 620: p_action_prms IN WSH_INTERFACE_EXT_GRP.det_action_parameters_rec_type,

616: x_msg_data OUT NOCOPY VARCHAR2,
617:
618: -- Procedure specific Parameters
619: p_detail_id_tab IN WSH_UTIL_CORE.id_tab_type,
620: p_action_prms IN WSH_INTERFACE_EXT_GRP.det_action_parameters_rec_type,
621: x_action_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.det_action_out_rec_type
622: ) IS
623:
624: --

Line 621: x_action_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.det_action_out_rec_type

617:
618: -- Procedure specific Parameters
619: p_detail_id_tab IN WSH_UTIL_CORE.id_tab_type,
620: p_action_prms IN WSH_INTERFACE_EXT_GRP.det_action_parameters_rec_type,
621: x_action_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.det_action_out_rec_type
622: ) IS
623:
624: --
625: l_det_act_params_rec_type wsh_glbl_var_strct_grp.dd_action_parameters_rec_type;

Line 652: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_EXT_GRP.Delivery_Detail_Action');

648: --
649: EXCEPTION
650: --
651: WHEN OTHERS THEN
652: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_EXT_GRP.Delivery_Detail_Action');
653: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: --
656: END Delivery_Detail_Action;

Line 660: p_in_tab IN WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type,

656: END Delivery_Detail_Action;
657:
658:
659: Procedure map_det_Attr_tbl_Type(
660: p_in_tab IN WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type,
661: x_out_tab OUT NOCOPY wsh_glbl_var_strct_grp.delivery_details_Attr_tbl_Type,
662: p_action IN VARCHAR2) IS
663:
664: l_entity VARCHAR2(4):='DLVB';

Line 842: p_in_rec IN WSH_INTERFACE_EXT_GRP.detailInRecType,

838: END LOOP;
839: End map_det_Attr_tbl_Type;
840:
841: Procedure Map_detailInRecType(
842: p_in_rec IN WSH_INTERFACE_EXT_GRP.detailInRecType,
843: x_out_rec OUT NOCOPY wsh_glbl_var_strct_grp.detailInRecType) IS
844:
845: Begin
846:

Line 867: x_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.detailOutRecType) IS

863: End Map_detailInRecType;
864:
865: Procedure Map_detailOutRecType(
866: p_in_rec IN wsh_glbl_var_strct_grp.detailOutRecType,
867: x_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.detailOutRecType) IS
868:
869: BEGIN
870:
871: x_out_rec.detail_ids := p_in_rec.detail_ids;

Line 897: p_detail_info_tab IN WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type,

893: x_msg_count OUT NOCOPY NUMBER,
894: x_msg_data OUT NOCOPY VARCHAR2,
895:
896: -- Procedure Specific Parameters
897: p_detail_info_tab IN WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type,
898: p_IN_rec IN WSH_INTERFACE_EXT_GRP.detailInRecType,
899: x_OUT_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.detailOutRecType
900: ) IS
901:

Line 898: p_IN_rec IN WSH_INTERFACE_EXT_GRP.detailInRecType,

894: x_msg_data OUT NOCOPY VARCHAR2,
895:
896: -- Procedure Specific Parameters
897: p_detail_info_tab IN WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type,
898: p_IN_rec IN WSH_INTERFACE_EXT_GRP.detailInRecType,
899: x_OUT_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.detailOutRecType
900: ) IS
901:
902: l_det_Attr_tbl_Type wsh_glbl_var_strct_grp.delivery_details_Attr_tbl_Type;

Line 899: x_OUT_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.detailOutRecType

895:
896: -- Procedure Specific Parameters
897: p_detail_info_tab IN WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type,
898: p_IN_rec IN WSH_INTERFACE_EXT_GRP.detailInRecType,
899: x_OUT_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.detailOutRecType
900: ) IS
901:
902: l_det_Attr_tbl_Type wsh_glbl_var_strct_grp.delivery_details_Attr_tbl_Type;
903: l_detailInRecType wsh_glbl_var_strct_grp.detailInRecType;

Line 950: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail');

946:
947: --
948: EXCEPTION
949: WHEN OTHERS THEN
950: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail');
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952: END Create_Update_Delivery_Detail;
953:
954:

Line 956: p_in_rec IN WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype,

952: END Create_Update_Delivery_Detail;
953:
954:
955: Procedure Map_trip_act_params_rectype(
956: p_in_rec IN WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype,
957: x_out_rec OUT NOCOPY WSH_TRIPS_GRP.action_parameters_rectype) IS
958:
959: Begin
960:

Line 986: x_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.tripActionOutRecType) IS

982:
983:
984: Procedure map_tripActionOutRecType(
985: p_in_rec IN WSH_TRIPS_GRP.tripActionOutRecType,
986: x_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.tripActionOutRecType) IS
987:
988: Begin
989:
990: x_out_rec.result_id_tab := p_in_rec.result_id_tab ;

Line 1008: p_action_prms IN WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype,

1004: ( p_api_version_number IN NUMBER,
1005: p_init_msg_list IN VARCHAR2,
1006: p_commit IN VARCHAR2,
1007: p_entity_id_tab IN wsh_util_core.id_tab_type,
1008: p_action_prms IN WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype,
1009: x_trip_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.tripActionOutRecType,
1010: x_return_status OUT NOCOPY VARCHAR2,
1011: x_msg_count OUT NOCOPY NUMBER,
1012: x_msg_data OUT NOCOPY VARCHAR2)

Line 1009: x_trip_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.tripActionOutRecType,

1005: p_init_msg_list IN VARCHAR2,
1006: p_commit IN VARCHAR2,
1007: p_entity_id_tab IN wsh_util_core.id_tab_type,
1008: p_action_prms IN WSH_INTERFACE_EXT_GRP.trip_action_parameters_rectype,
1009: x_trip_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.tripActionOutRecType,
1010: x_return_status OUT NOCOPY VARCHAR2,
1011: x_msg_count OUT NOCOPY NUMBER,
1012: x_msg_data OUT NOCOPY VARCHAR2)
1013: IS

Line 1045: p_in_rec IN WSH_INTERFACE_EXT_GRP.stop_action_parameters_rectype,

1041: END Trip_Action;
1042:
1043:
1044: Procedure map_stop_act_params_rectype(
1045: p_in_rec IN WSH_INTERFACE_EXT_GRP.stop_action_parameters_rectype,
1046: x_out_rec OUT NOCOPY WSH_TRIP_STOPS_GRP.action_parameters_rectype) IS
1047:
1048: Begin
1049:

Line 1065: x_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.stopActionOutRecType) IS

1061:
1062:
1063: Procedure map_stopActionOutRecType(
1064: p_in_rec IN WSH_TRIP_STOPS_GRP.stopActionOutRecType,
1065: x_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.stopActionOutRecType) IS
1066:
1067: Begin
1068:
1069: x_out_rec.result_id_tab := p_in_rec.result_id_tab ;

Line 1084: p_action_prms IN WSH_INTERFACE_EXT_GRP.stop_action_parameters_rectype,

1080: ( p_api_version_number IN NUMBER,
1081: p_init_msg_list IN VARCHAR2,
1082: p_commit IN VARCHAR2,
1083: p_entity_id_tab IN wsh_util_core.id_tab_type,
1084: p_action_prms IN WSH_INTERFACE_EXT_GRP.stop_action_parameters_rectype,
1085: x_stop_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.stopActionOutRecType,
1086: x_return_status OUT NOCOPY VARCHAR2,
1087: x_msg_count OUT NOCOPY NUMBER,
1088: x_msg_data OUT NOCOPY VARCHAR2)

Line 1085: x_stop_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.stopActionOutRecType,

1081: p_init_msg_list IN VARCHAR2,
1082: p_commit IN VARCHAR2,
1083: p_entity_id_tab IN wsh_util_core.id_tab_type,
1084: p_action_prms IN WSH_INTERFACE_EXT_GRP.stop_action_parameters_rectype,
1085: x_stop_out_rec OUT NOCOPY WSH_INTERFACE_EXT_GRP.stopActionOutRecType,
1086: x_return_status OUT NOCOPY VARCHAR2,
1087: x_msg_count OUT NOCOPY NUMBER,
1088: x_msg_data OUT NOCOPY VARCHAR2)
1089: IS

Line 1124: p_in_rec IN WSH_INTERFACE_EXT_GRP.stopInRecType,

1120: --heali
1121:
1122:
1123: Procedure Map_stopInRecType(
1124: p_in_rec IN WSH_INTERFACE_EXT_GRP.stopInRecType,
1125: x_out_rec OUT NOCOPY WSH_TRIP_STOPS_GRP.stopInRecType) IS
1126:
1127: Begin
1128:

Line 1137: p_in_tab IN WSH_INTERFACE_EXT_GRP.Stop_Attr_Tbl_Type,

1133: END Map_stopInRecType;
1134:
1135:
1136: Procedure map_Stop_Attr_Tbl_Type(
1137: p_in_tab IN WSH_INTERFACE_EXT_GRP.Stop_Attr_Tbl_Type,
1138: x_out_tab OUT NOCOPY WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type) IS
1139:
1140: Begin
1141:

Line 1225: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.stop_out_tab_type) IS

1221: End Map_Stop_Attr_Tbl_Type;
1222:
1223: Procedure map_stop_out_tab_type(
1224: p_in_tab IN WSH_TRIP_STOPS_GRP.stop_out_tab_type,
1225: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.stop_out_tab_type) IS
1226:
1227: Begin
1228:
1229: for i in 1..p_in_tab.count LOOP

Line 1258: p_in_rec IN WSH_INTERFACE_EXT_GRP.stopInRecType,

1254: PROCEDURE CREATE_UPDATE_STOP(
1255: p_api_version_number IN NUMBER,
1256: p_init_msg_list IN VARCHAR2,
1257: p_commit IN VARCHAR2,
1258: p_in_rec IN WSH_INTERFACE_EXT_GRP.stopInRecType,
1259: p_rec_attr_tab IN WSH_INTERFACE_EXT_GRP.Stop_Attr_Tbl_Type,
1260: x_stop_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.stop_out_tab_type,
1261: x_return_status OUT NOCOPY VARCHAR2,
1262: x_msg_count OUT NOCOPY NUMBER,

Line 1259: p_rec_attr_tab IN WSH_INTERFACE_EXT_GRP.Stop_Attr_Tbl_Type,

1255: p_api_version_number IN NUMBER,
1256: p_init_msg_list IN VARCHAR2,
1257: p_commit IN VARCHAR2,
1258: p_in_rec IN WSH_INTERFACE_EXT_GRP.stopInRecType,
1259: p_rec_attr_tab IN WSH_INTERFACE_EXT_GRP.Stop_Attr_Tbl_Type,
1260: x_stop_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.stop_out_tab_type,
1261: x_return_status OUT NOCOPY VARCHAR2,
1262: x_msg_count OUT NOCOPY NUMBER,
1263: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1260: x_stop_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.stop_out_tab_type,

1256: p_init_msg_list IN VARCHAR2,
1257: p_commit IN VARCHAR2,
1258: p_in_rec IN WSH_INTERFACE_EXT_GRP.stopInRecType,
1259: p_rec_attr_tab IN WSH_INTERFACE_EXT_GRP.Stop_Attr_Tbl_Type,
1260: x_stop_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.stop_out_tab_type,
1261: x_return_status OUT NOCOPY VARCHAR2,
1262: x_msg_count OUT NOCOPY NUMBER,
1263: x_msg_data OUT NOCOPY VARCHAR2) IS
1264:

Line 1289: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_STOP');

1285: --
1286: EXCEPTION
1287: WHEN OTHERS THEN
1288: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1289: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_STOP');
1290: --
1291: END Create_Update_Stop;
1292:
1293:

Line 1295: p_in_tab IN WSH_INTERFACE_EXT_GRP.Trip_Attr_Tbl_Type,

1291: END Create_Update_Stop;
1292:
1293:
1294: Procedure Map_Trip_Attr_Tbl_Type(
1295: p_in_tab IN WSH_INTERFACE_EXT_GRP.Trip_Attr_Tbl_Type,
1296: x_out_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type) IS
1297:
1298: Begin
1299: for i in 1..p_in_tab.count LOOP

Line 1372: p_in_rec IN WSH_INTERFACE_EXT_GRP.tripInRecType,

1368: End Map_Trip_Attr_Tbl_Type;
1369:
1370:
1371: Procedure map_tripInRecType(
1372: p_in_rec IN WSH_INTERFACE_EXT_GRP.tripInRecType,
1373: x_out_rec OUT NOCOPY WSH_TRIPS_GRP.tripInRecType) IS
1374:
1375: Begin
1376:

Line 1386: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.trip_Out_Tab_Type) Is

1382: End map_tripInRecType;
1383:
1384: Procedure map_trip_Out_Tab_Type(
1385: p_in_tab IN WSH_TRIPS_GRP.trip_Out_Tab_Type,
1386: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.trip_Out_Tab_Type) Is
1387:
1388: Begin
1389:
1390: for i in 1..p_in_tab.count LOOP

Line 1421: p_trip_info_tab IN WSH_INTERFACE_EXT_GRP.Trip_Attr_Tbl_Type,

1417: p_commit IN VARCHAR2,
1418: x_return_status OUT NOCOPY VARCHAR2,
1419: x_msg_count OUT NOCOPY NUMBER,
1420: x_msg_data OUT NOCOPY VARCHAR2,
1421: p_trip_info_tab IN WSH_INTERFACE_EXT_GRP.Trip_Attr_Tbl_Type,
1422: p_In_rec IN WSH_INTERFACE_EXT_GRP.tripInRecType,
1423: x_Out_Tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.trip_Out_Tab_Type) IS
1424:
1425: l_Trip_Attr_Tbl_Type WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

Line 1422: p_In_rec IN WSH_INTERFACE_EXT_GRP.tripInRecType,

1418: x_return_status OUT NOCOPY VARCHAR2,
1419: x_msg_count OUT NOCOPY NUMBER,
1420: x_msg_data OUT NOCOPY VARCHAR2,
1421: p_trip_info_tab IN WSH_INTERFACE_EXT_GRP.Trip_Attr_Tbl_Type,
1422: p_In_rec IN WSH_INTERFACE_EXT_GRP.tripInRecType,
1423: x_Out_Tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.trip_Out_Tab_Type) IS
1424:
1425: l_Trip_Attr_Tbl_Type WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1426: l_tripInRecType WSH_TRIPS_GRP.tripInRecType;

Line 1423: x_Out_Tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.trip_Out_Tab_Type) IS

1419: x_msg_count OUT NOCOPY NUMBER,
1420: x_msg_data OUT NOCOPY VARCHAR2,
1421: p_trip_info_tab IN WSH_INTERFACE_EXT_GRP.Trip_Attr_Tbl_Type,
1422: p_In_rec IN WSH_INTERFACE_EXT_GRP.tripInRecType,
1423: x_Out_Tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.trip_Out_Tab_Type) IS
1424:
1425: l_Trip_Attr_Tbl_Type WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1426: l_tripInRecType WSH_TRIPS_GRP.tripInRecType;
1427: l_trip_Out_Tab_Type WSH_TRIPS_GRP.trip_Out_Tab_Type;

Line 1449: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_TRIP');

1445:
1446: EXCEPTION
1447: WHEN OTHERS THEN
1448: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1449: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_TRIP');
1450: --
1451: END Create_Update_Trip;
1452:
1453:

Line 1455: p_in_tab IN WSH_INTERFACE_EXT_GRP.freight_rec_tab_type,

1451: END Create_Update_Trip;
1452:
1453:
1454: Procedure map_freight_rec_tab_type(
1455: p_in_tab IN WSH_INTERFACE_EXT_GRP.freight_rec_tab_type,
1456: x_out_tab OUT NOCOPY WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type) IS
1457:
1458: Begin
1459:

Line 1522: p_in_rec IN WSH_INTERFACE_EXT_GRP.freightInRecType,

1518: End map_freight_rec_tab_type;
1519:
1520:
1521: Procedure map_freightInRecType(
1522: p_in_rec IN WSH_INTERFACE_EXT_GRP.freightInRecType,
1523: x_out_rec OUT NOCOPY WSH_FREIGHT_COSTS_GRP.freightInRecType) IS
1524:
1525: Begin
1526:

Line 1536: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.freight_out_tab_type) IS

1532:
1533:
1534: Procedure map_freight_out_tab_type(
1535: p_in_tab IN WSH_FREIGHT_COSTS_GRP.freight_out_tab_type,
1536: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.freight_out_tab_type) IS
1537:
1538: Begin
1539:
1540:

Line 1557: p_freight_info_tab IN WSH_INTERFACE_EXT_GRP.freight_rec_tab_type,

1553: p_commit IN VARCHAR2,
1554: x_return_status OUT NOCOPY VARCHAR2,
1555: x_msg_count OUT NOCOPY NUMBER,
1556: x_msg_data OUT NOCOPY VARCHAR2,
1557: p_freight_info_tab IN WSH_INTERFACE_EXT_GRP.freight_rec_tab_type,
1558: p_in_rec IN WSH_INTERFACE_EXT_GRP.freightInRecType,
1559: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.freight_out_tab_type) IS
1560:
1561: l_freight_rec_tab_type WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;

Line 1558: p_in_rec IN WSH_INTERFACE_EXT_GRP.freightInRecType,

1554: x_return_status OUT NOCOPY VARCHAR2,
1555: x_msg_count OUT NOCOPY NUMBER,
1556: x_msg_data OUT NOCOPY VARCHAR2,
1557: p_freight_info_tab IN WSH_INTERFACE_EXT_GRP.freight_rec_tab_type,
1558: p_in_rec IN WSH_INTERFACE_EXT_GRP.freightInRecType,
1559: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.freight_out_tab_type) IS
1560:
1561: l_freight_rec_tab_type WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;
1562: l_freightInRecType WSH_FREIGHT_COSTS_GRP.freightInRecType;

Line 1559: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.freight_out_tab_type) IS

1555: x_msg_count OUT NOCOPY NUMBER,
1556: x_msg_data OUT NOCOPY VARCHAR2,
1557: p_freight_info_tab IN WSH_INTERFACE_EXT_GRP.freight_rec_tab_type,
1558: p_in_rec IN WSH_INTERFACE_EXT_GRP.freightInRecType,
1559: x_out_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.freight_out_tab_type) IS
1560:
1561: l_freight_rec_tab_type WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type;
1562: l_freightInRecType WSH_FREIGHT_COSTS_GRP.freightInRecType;
1563: l_freight_out_tab_type WSH_FREIGHT_COSTS_GRP.freight_out_tab_type;

Line 1585: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_FREIGHT_COSTS');

1581: --
1582: EXCEPTION
1583: WHEN OTHERS THEN
1584: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1585: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.CREATE_UPDATE_FREIGHT_COSTS');
1586: END Create_Update_Freight_costs;
1587: --heali
1588:
1589: PROCEDURE Get_Exceptions (

Line 1602: x_exceptions_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.XC_TAB_TYPE

1598: p_logging_entity_id IN NUMBER,
1599: p_logging_entity_name IN VARCHAR2,
1600:
1601: -- program specific out parameters
1602: x_exceptions_tab OUT NOCOPY WSH_INTERFACE_EXT_GRP.XC_TAB_TYPE
1603: )
1604: IS
1605:
1606: BEGIN

Line 1614: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Get_Exceptions');

1610: --
1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1614: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Get_Exceptions');
1615: END Get_Exceptions;
1616:
1617:
1618: PROCEDURE Exception_Action (

Line 1627: p_exception_rec IN OUT NOCOPY WSH_INTERFACE_EXT_GRP.XC_ACTION_REC_TYPE,

1623: x_msg_count OUT NOCOPY NUMBER,
1624: x_msg_data OUT NOCOPY VARCHAR2,
1625: x_return_status OUT NOCOPY VARCHAR2,
1626:
1627: p_exception_rec IN OUT NOCOPY WSH_INTERFACE_EXT_GRP.XC_ACTION_REC_TYPE,
1628: p_action IN VARCHAR2
1629: )
1630:
1631: IS

Line 1641: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Exception_Action');

1637: --
1638: EXCEPTION
1639: WHEN OTHERS THEN
1640: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1641: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Exception_Action');
1642: END Exception_Action;
1643:
1644:
1645:

Line 1651: p_action_prms IN WSH_INTERFACE_EXT_GRP.dlvy_leg_action_prms_rectype,

1647: p_api_version_number IN NUMBER,
1648: p_init_msg_list IN VARCHAR2,
1649: p_commit IN VARCHAR2,
1650: p_dlvy_leg_id_tab IN wsh_util_core.id_tab_type,
1651: p_action_prms IN WSH_INTERFACE_EXT_GRP.dlvy_leg_action_prms_rectype,
1652: x_action_out_rec IN OUT NOCOPY WSH_INTERFACE_EXT_GRP.dlvy_leg_action_out_rec_type,
1653: x_return_status OUT NOCOPY VARCHAR2,
1654: x_msg_count OUT NOCOPY NUMBER,
1655: x_msg_data OUT NOCOPY VARCHAR2

Line 1652: x_action_out_rec IN OUT NOCOPY WSH_INTERFACE_EXT_GRP.dlvy_leg_action_out_rec_type,

1648: p_init_msg_list IN VARCHAR2,
1649: p_commit IN VARCHAR2,
1650: p_dlvy_leg_id_tab IN wsh_util_core.id_tab_type,
1651: p_action_prms IN WSH_INTERFACE_EXT_GRP.dlvy_leg_action_prms_rectype,
1652: x_action_out_rec IN OUT NOCOPY WSH_INTERFACE_EXT_GRP.dlvy_leg_action_out_rec_type,
1653: x_return_status OUT NOCOPY VARCHAR2,
1654: x_msg_count OUT NOCOPY NUMBER,
1655: x_msg_data OUT NOCOPY VARCHAR2
1656: ) IS

Line 1666: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Delivery_Leg_Action');

1662: --
1663: EXCEPTION
1664: WHEN OTHERS THEN
1665: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1666: wsh_util_core.default_handler('WSH_INTERFACE_EXT_GRP.Delivery_Leg_Action');
1667: END Delivery_Leg_Action;
1668:
1669:
1670: --OTM R12

Line 1876: WSH_UTIL_CORE.Default_Handler('WSH_INTERFACE_EXT_GRP.OTM_PRE_SHIP_CONFIRM', l_module_name);

1872: END IF;
1873:
1874: WHEN Others THEN
1875:
1876: WSH_UTIL_CORE.Default_Handler('WSH_INTERFACE_EXT_GRP.OTM_PRE_SHIP_CONFIRM', l_module_name);
1877: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1878:
1879: IF l_debug_on THEN
1880: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1887: END WSH_INTERFACE_EXT_GRP;

1883:
1884: END OTM_PRE_SHIP_CONFIRM;
1885: --END OTM R12
1886:
1887: END WSH_INTERFACE_EXT_GRP;