APPS.WSH_PURGE dependencies on WSH_ITM_RESPONSE_HEADERS

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 1510: FROM wsh_itm_response_headers wirh,

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
1513: AND wirc.request_control_id = wirh.request_control_id
1514: AND wirc.service_type_code = 'WSH_EXPORT_COMPLIANCE' );

Line 1523: FROM wsh_itm_response_headers

1519: END IF;
1520: END IF;
1521:
1522: DELETE
1523: FROM wsh_itm_response_headers
1524: WHERE request_control_id IN ( SELECT request_control_id
1525: FROM wsh_itm_request_control
1526: WHERE original_system_reference = l_delivery_id
1527: AND service_type_code = 'WSH_EXPORT_COMPLIANCE' ) ;

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

1527: AND service_type_code = 'WSH_EXPORT_COMPLIANCE' ) ;
1528:
1529: IF SQL%FOUND THEN
1530: IF l_debug_on THEN
1531: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_itm_response_headers: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1532: END IF;
1533: END IF;
1534:
1535: DELETE