APPS.WSH_PURGE dependencies on WSH_ITM_REQUEST_CONTROL

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

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

Line 1400: FROM wsh_itm_request_control

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

Line 1411: FROM wsh_itm_request_control

1407: END IF;
1408: END IF;
1409:
1410: DELETE
1411: FROM wsh_itm_request_control
1412: WHERE original_system_reference = l_delivery_id
1413: AND service_type_code = 'WSH_EXPORT_COMPLIANCE';
1414:
1415: IF SQL%FOUND THEN

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

1413: AND service_type_code = 'WSH_EXPORT_COMPLIANCE';
1414:
1415: IF SQL%FOUND THEN
1416: IF l_debug_on THEN
1417: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_itm_request_control: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1418: END IF;
1419: END IF;
1420:
1421: DELETE