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_SPLITTER_PKG dependencies on WSH_NEW_DELIVERIES

Line 48: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;

44: l_num_warn NUMBER;
45: l_return_status VARCHAR2(1);
46: l_msg_count NUMBER;
47: l_msg_data VARCHAR2(32767);
48: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;
49: unexp_error EXCEPTION;
50:
51: l_debug_on BOOLEAN;
52: --

Line 285: l_current_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE; -- variable used to track delivery weight

281: FROM WSH_DELIVERY_LEGS
282: WHERE delivery_id = p_delivery_id
283: AND rownum = 1;
284:
285: l_current_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE; -- variable used to track delivery weight
286: l_content_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE; -- variable used to track total content weight
287:
288: -- variable used to track delivery weight for new delivery
289: l_new_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;

Line 286: l_content_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE; -- variable used to track total content weight

282: WHERE delivery_id = p_delivery_id
283: AND rownum = 1;
284:
285: l_current_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE; -- variable used to track delivery weight
286: l_content_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE; -- variable used to track total content weight
287:
288: -- variable used to track delivery weight for new delivery
289: l_new_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
290: l_line_and_container_id WSH_UTIL_CORE.ID_TAB_TYPE;

Line 289: l_new_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;

285: l_current_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE; -- variable used to track delivery weight
286: l_content_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE; -- variable used to track total content weight
287:
288: -- variable used to track delivery weight for new delivery
289: l_new_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
290: l_line_and_container_id WSH_UTIL_CORE.ID_TAB_TYPE;
291: l_line_and_container_weight WSH_UTIL_CORE.ID_TAB_TYPE;
292: l_line_status WSH_UTIL_CORE.COLUMN_TAB_TYPE;
293:

Line 304: l_new_delivery_name WSH_NEW_DELIVERIES.NAME%TYPE; -- new delivery id

300:
301: l_temp_ids WSH_UTIL_CORE.ID_TAB_TYPE;
302: l_parameter_info WSH_SHIPPING_PARAMS_PVT.PARAMETER_REC_TYP;
303: l_global_param_info WSH_SHIPPING_PARAMS_PVT.GLOBAL_PARAMETERS_REC_TYP;
304: l_new_delivery_name WSH_NEW_DELIVERIES.NAME%TYPE; -- new delivery id
305: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
306: l_temp_num NUMBER;
307:
308: l_num_error NUMBER;

Line 314: l_delivery_info WSH_NEW_DELIVERIES_PVT.DELIVERY_REC_TYPE;

310: l_return_status VARCHAR2(1);
311: l_msg_count NUMBER;
312: l_msg_data VARCHAR2(32767);
313:
314: l_delivery_info WSH_NEW_DELIVERIES_PVT.DELIVERY_REC_TYPE;
315: i NUMBER;
316: j NUMBER;
317: k NUMBER;
318: z NUMBER;

Line 458: l_delivery_info.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED OR

454:
455: --accept all delete required or ignore for planning deliveries, no need to split
456: --Bug 7148914 added OR condition so that same flow is followed for delivery with tms_interface_flag 'DP'
457: IF (l_delivery_info.ignore_for_planning = 'Y' OR
458: l_delivery_info.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED OR
459: l_delivery_info.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS ) THEN
460:
461:
462: IF l_debug_on THEN

Line 459: l_delivery_info.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS ) THEN

455: --accept all delete required or ignore for planning deliveries, no need to split
456: --Bug 7148914 added OR condition so that same flow is followed for delivery with tms_interface_flag 'DP'
457: IF (l_delivery_info.ignore_for_planning = 'Y' OR
458: l_delivery_info.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED OR
459: l_delivery_info.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS ) THEN
460:
461:
462: IF l_debug_on THEN
463: wsh_debug_sv.logmsg(l_module_name, 'accepted delivery ' || p_delivery_tab(i).entity_id || ' because ignore for planning, DR or DP status');

Line 1132: l_new_delivery_name := WSH_NEW_DELIVERIES_PVT.get_name(l_temp_ids(z)); --newly created delivery

1128: z := l_temp_ids.FIRST;
1129:
1130: WHILE z IS NOT NULL LOOP
1131:
1132: l_new_delivery_name := WSH_NEW_DELIVERIES_PVT.get_name(l_temp_ids(z)); --newly created delivery
1133:
1134: --logging tms exception for the new delivery
1135: IF l_debug_on THEN
1136: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1247: l_new_delivery_name := WSH_NEW_DELIVERIES_PVT.get_name(l_temp_ids(z)); --newly created delivery

1243: z := l_temp_ids.FIRST;
1244:
1245: WHILE z IS NOT NULL LOOP
1246:
1247: l_new_delivery_name := WSH_NEW_DELIVERIES_PVT.get_name(l_temp_ids(z)); --newly created delivery
1248:
1249: --log tms exceptions for the new delivery
1250: IF l_debug_on THEN
1251: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);