APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_WMS_SYNC_TMP

Line 3109: from wsh_wms_sync_tmp wwst,

3105:
3106: -- LPN CONV rv
3107: cursor l_delete_wms_empty_cnt_csr is
3108: select distinct wwst.delivery_detail_id
3109: from wsh_wms_sync_tmp wwst,
3110: wsh_delivery_details wdd
3111: where wwst.operation_type = 'DELETE'
3112: and wdd.delivery_detail_id = wwst.delivery_detail_id
3113: and wdd.container_flag = 'Y'

Line 7598: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);

7594: THEN
7595: --{
7596: --
7597: IF l_debug_on THEN
7598: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
7599: END IF;
7600: --
7601: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7602: (

Line 7601: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

7597: IF l_debug_on THEN
7598: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
7599: END IF;
7600: --
7601: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7602: (
7603: p_sync_tmp_recTbl => l_sync_tmp_wms_recTbl,
7604: x_return_status => l_return_status
7605: );

Line 7625: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);

7621: THEN
7622: --{
7623: --
7624: IF l_debug_on THEN
7625: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
7626: END IF;
7627: --
7628: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7629: (

Line 7628: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

7624: IF l_debug_on THEN
7625: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
7626: END IF;
7627: --
7628: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7629: (
7630: p_sync_tmp_recTbl => l_sync_tmp_inv_recTbl,
7631: x_return_status => l_return_status
7632: );