APPS.WSH_PURGE dependencies on WSH_ITM_RESPONSE_LINES

Line 1331: WSH_ITM_RESPONSE_LINES, WSH_ITM_RESPONSE_HEADERS, WSH_ITM_REQUEST_CONTROL,

1327: FTE_MESSAGE_PARTNER, FTE_MESSAGE_CONTACT, FTE_MESSAGE_LOCATION,
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:

Line 1508: FROM wsh_itm_response_lines

1504: END IF;
1505: END IF;
1506:
1507: DELETE
1508: FROM wsh_itm_response_lines
1509: WHERE response_header_id IN ( SELECT wirh.response_header_id
1510: FROM wsh_itm_response_headers wirh,
1511: wsh_itm_request_control wirc
1512: WHERE wirc.original_system_reference = l_delivery_id

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

1514: AND wirc.service_type_code = 'WSH_EXPORT_COMPLIANCE' );
1515:
1516: IF SQL%FOUND THEN
1517: IF l_debug_on THEN
1518: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_itm_response_lines: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1519: END IF;
1520: END IF;
1521:
1522: DELETE