APPS.WSH_PURGE dependencies on WSH_INBOUND_TXN_HISTORY

Line 1332: WSH_INBOUND_TXN_HISTORY

1328: FTE_DELIVERY_PROOF, FTE_SHIPMENT_STATUS_HEADERS
1329:
1330: If ITM Screening is done,
1331: WSH_ITM_RESPONSE_LINES, WSH_ITM_RESPONSE_HEADERS, WSH_ITM_REQUEST_CONTROL,
1332: WSH_INBOUND_TXN_HISTORY
1333: and finally WSH_NEW_DELIVERIES.
1334: -----------------------------------------------------------------------------*/
1335:
1336: PROCEDURE Purge_Deliveries( p_tbl_delivery_purge_set Delivery_ID_Tbl_Type,

Line 1547: FROM wsh_inbound_txn_history

1543: END IF;
1544: END IF;
1545:
1546: DELETE
1547: FROM wsh_inbound_txn_history
1548: WHERE shipment_header_id IN ( SELECT rcv_shipment_header_id
1549: FROM wsh_new_deliveries
1550: WHERE delivery_id = l_delivery_id) ;
1551:

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

1550: WHERE delivery_id = l_delivery_id) ;
1551:
1552: IF SQL%FOUND THEN
1553: IF l_debug_on THEN
1554: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_inbound_txn_history: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1555: END IF;
1556: END IF;
1557:
1558: DELETE