APPS.WSH_PURGE dependencies on FTE_DELIVERY_PROOF

Line 1328: FTE_DELIVERY_PROOF, FTE_SHIPMENT_STATUS_HEADERS

1324:
1325: If FTE is installed,
1326: FTE_SHIPMENT_STATUS_DETAILS, FTE_SHIPMENT_STATUS_EXCEPTIONS,
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

Line 1483: FROM fte_delivery_proof

1479: END IF;
1480:
1481:
1482: DELETE
1483: FROM fte_delivery_proof
1484: WHERE transaction_id IN (SELECT transaction_id
1485: FROM fte_shipment_status_headers
1486: WHERE delivery_id = l_delivery_id);
1487:

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

1486: WHERE delivery_id = l_delivery_id);
1487:
1488: IF SQL%FOUND THEN
1489: IF l_debug_on THEN
1490: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_delivery_proof: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1491: END IF;
1492: END IF;
1493:
1494: