APPS.WSH_PURGE dependencies on WSH_INBOUND_TXN_HISTORY

Line 1207: WSH_INBOUND_TXN_HISTORY

1203: FTE_DELIVERY_PROOF, FTE_SHIPMENT_STATUS_HEADERS
1204:
1205: If ITM Screening is done,
1206: WSH_ITM_RESPONSE_LINES, WSH_ITM_RESPONSE_HEADERS, WSH_ITM_REQUEST_CONTROL,
1207: WSH_INBOUND_TXN_HISTORY
1208: and finally WSH_NEW_DELIVERIES.
1209: -----------------------------------------------------------------------------*/
1210:
1211: PROCEDURE Purge_Deliveries( p_tbl_delivery_purge_set Delivery_ID_Tbl_Type,

Line 1422: FROM wsh_inbound_txn_history

1418: END IF;
1419: END IF;
1420:
1421: DELETE
1422: FROM wsh_inbound_txn_history
1423: WHERE shipment_header_id IN ( SELECT rcv_shipment_header_id
1424: FROM wsh_new_deliveries
1425: WHERE delivery_id = l_delivery_id) ;
1426:

Line 1429: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_inbound_txn_history: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);

1425: WHERE delivery_id = l_delivery_id) ;
1426:
1427: IF SQL%FOUND THEN
1428: IF l_debug_on THEN
1429: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_inbound_txn_history: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1430: END IF;
1431: END IF;
1432:
1433: DELETE