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_DELIVERY_DETAILS_UTILITIES dependencies on WSH_DELIVERY_DETAILS

Line 1: PACKAGE BODY WSH_DELIVERY_DETAILS_UTILITIES as

1: PACKAGE BODY WSH_DELIVERY_DETAILS_UTILITIES as
2: /* $Header: WSHDDUTB.pls 120.7 2008/06/11 08:27:34 brana noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_DETAILS_UTILITIES';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_DETAILS_UTILITIES';

1: PACKAGE BODY WSH_DELIVERY_DETAILS_UTILITIES as
2: /* $Header: WSHDDUTB.pls 120.7 2008/06/11 08:27:34 brana noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_DETAILS_UTILITIES';
6:
7:
8: -- ------------------------------------------------------------------------------------
9: -- Start of comments

Line 36: x_assigned_rows OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,

32: PROCEDURE Auto_Assign_Deliveries(
33: p_line_rows IN OUT NOCOPY wsh_delivery_autocreate.grp_attr_tab_type,
34: p_group_by_header IN VARCHAR2,
35: p_check_fte_compatibility IN VARCHAR2,
36: x_assigned_rows OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,
37: x_unassigned_rows OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
38: x_appended_del_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
39: x_return_status OUT NOCOPY VARCHAR2) IS
40:

Line 118: wsh_delivery_details WDD

114: WHERE d.delivery_id = t.id
115: AND NOT EXISTS (
116: SELECT WDA.delivery_detail_id
117: FROM wsh_delivery_assignments_v WDA,
118: wsh_delivery_details WDD
119: WHERE WDA.delivery_detail_id = WDD.delivery_detail_id
120: AND WDA.delivery_id = t.id
121: AND WDA.delivery_id is not NULL
122: AND WDD.source_code <> 'OE'

Line 413: WSH_DELIVERY_DETAILS_GRP.Delivery_Detail_Action(

409: l_action_prms.caller := 'WSH_DLMG';
410:
411:
412: -- assign delivery details of this sub-group to the delivery
413: WSH_DELIVERY_DETAILS_GRP.Delivery_Detail_Action(
414: p_api_version_number => 1.0,
415: p_init_msg_list => FND_API.G_FALSE,
416: p_commit => FND_API.G_FALSE,
417: x_return_status => l_return_status,

Line 427: WSH_DEBUG_SV.log(l_module_name,'Return status from WSH_DELIVERY_DETAILS_GRP.Delivery_Detail_Action '|| l_return_status);

423: x_defaults => l_defaults,
424: x_action_out_rec => l_action_out_rec);
425:
426: IF l_debug_on THEN
427: WSH_DEBUG_SV.log(l_module_name,'Return status from WSH_DELIVERY_DETAILS_GRP.Delivery_Detail_Action '|| l_return_status);
428: END IF;
429:
430: -- OTM R12 : update delivery
431: l_tms_update := 'N';

Line 950: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Auto_Assign_Deliveries');

946: -- if the cursor is still open then close the cursor
947: IF c_get_deliveries%ISOPEN THEN
948: CLOSE c_get_deliveries;
949: END IF;
950: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Auto_Assign_Deliveries');
951: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
952: IF l_debug_on THEN
953: WSH_DEBUG_SV.pop(l_module_name);
954: END IF;

Line 1014: x_appended_det_tbl OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,

1010: p_group_by_header IN VARCHAR2,
1011: p_commit IN VARCHAR2,
1012: p_lock_rows IN VARCHAR2,
1013: p_check_fte_compatibility IN VARCHAR2,
1014: x_appended_det_tbl OUT NOCOPY WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl,
1015: x_unappended_det_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
1016: x_appended_del_tbl OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
1017: x_return_status OUT NOCOPY VARCHAR2) IS
1018:

Line 1044: FROM wsh_delivery_details wdd,

1040: wdd.source_code,
1041: wdd.lpn_id,
1042: wsp.appending_limit,
1043: wdd.ignore_for_planning --bugfix 7164767
1044: FROM wsh_delivery_details wdd,
1045: wsh_delivery_assignments_v wda,
1046: wsh_shipping_parameters wsp
1047: WHERE wdd.delivery_detail_id = c_detail_id
1048: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 1062: l_assgined_rows WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;

1058:
1059: l_detail_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;
1060:
1061: l_unassigned_rows WSH_UTIL_CORE.Id_Tab_Type;
1062: l_assgined_rows WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;
1063: l_index NUMBER;
1064: l_delivery_detail_id NUMBER;
1065:
1066: l_group_info WSH_DELIVERY_AUTOCREATE.grp_attr_tab_type;

Line 1149: select delivery_detail_id into l_delivery_detail_id from wsh_delivery_details where

1145: CLOSE get_line_details_check;
1146: -- these are the lines that will be grouped
1147: IF p_lock_rows = FND_API.G_TRUE THEN
1148: -- lock the delivery detail record
1149: select delivery_detail_id into l_delivery_detail_id from wsh_delivery_details where
1150: delivery_detail_id = p_delivery_detail_tbl(l_index) for update nowait;
1151: END IF;
1152: IF NVL(p_append_flag, l_appending_limit) = 'N' and WSH_PICK_LIST.G_BATCH_ID is NULL THEN
1153: x_unappended_det_tbl(x_unappended_det_tbl.count+1) := l_detail_info(l_index).entity_id;

Line 1294: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');

1290: CLOSE get_line_details_check;
1291: END IF;
1292:
1293: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1294: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');
1295: IF l_debug_on THEN
1296: wsh_debug_sv.log(l_module_name, 'Unexpected error has occured. Oracle error message is ' || SQLERRM);
1297: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
1298: END IF;

Line 1304: END WSH_DELIVERY_DETAILS_UTILITIES;

1300: END Append_to_Deliveries;
1301:
1302:
1303:
1304: END WSH_DELIVERY_DETAILS_UTILITIES;
1305:
1306: