APPS.WSH_PURGE dependencies on WSH_ITM_REQUEST_CONTROL

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 1511: wsh_itm_request_control wirc

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' );
1515:

Line 1525: FROM wsh_itm_request_control

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' ) ;
1528:
1529: IF SQL%FOUND THEN

Line 1536: FROM wsh_itm_request_control

1532: END IF;
1533: END IF;
1534:
1535: DELETE
1536: FROM wsh_itm_request_control
1537: WHERE original_system_reference = l_delivery_id
1538: AND service_type_code = 'WSH_EXPORT_COMPLIANCE';
1539:
1540: IF SQL%FOUND THEN

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

1538: AND service_type_code = 'WSH_EXPORT_COMPLIANCE';
1539:
1540: IF SQL%FOUND THEN
1541: IF l_debug_on THEN
1542: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_itm_request_control: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1543: END IF;
1544: END IF;
1545:
1546: DELETE