APPS.WSH_PURGE dependencies on WSH_ITM_RESPONSE_HEADERS

Line 1206: WSH_ITM_RESPONSE_LINES, WSH_ITM_RESPONSE_HEADERS, WSH_ITM_REQUEST_CONTROL,

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

Line 1385: FROM wsh_itm_response_headers wirh,

1381:
1382: DELETE
1383: FROM wsh_itm_response_lines
1384: WHERE response_header_id IN ( SELECT wirh.response_header_id
1385: FROM wsh_itm_response_headers wirh,
1386: wsh_itm_request_control wirc
1387: WHERE wirc.original_system_reference = l_delivery_id
1388: AND wirc.request_control_id = wirh.request_control_id
1389: AND wirc.service_type_code = 'WSH_EXPORT_COMPLIANCE' );

Line 1398: FROM wsh_itm_response_headers

1394: END IF;
1395: END IF;
1396:
1397: DELETE
1398: FROM wsh_itm_response_headers
1399: WHERE request_control_id IN ( SELECT request_control_id
1400: FROM wsh_itm_request_control
1401: WHERE original_system_reference = l_delivery_id
1402: AND service_type_code = 'WSH_EXPORT_COMPLIANCE' ) ;

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

1402: AND service_type_code = 'WSH_EXPORT_COMPLIANCE' ) ;
1403:
1404: IF SQL%FOUND THEN
1405: IF l_debug_on THEN
1406: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_itm_response_headers: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1407: END IF;
1408: END IF;
1409:
1410: DELETE