APPS.WSH_PURGE dependencies on FTE_SHIPMENT_STATUS_EXCEPTIONS

Line 1326: FTE_SHIPMENT_STATUS_DETAILS, FTE_SHIPMENT_STATUS_EXCEPTIONS,

1322: WSH_EXCEPTIONS, WSH_TRANSACTIONS_HISTORY, WSH_DOCUMENT_INSTANCES,
1323: WSH_FREIGHT_COSTS
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,

Line 1422: FROM fte_shipment_status_exceptions

1418: END IF;
1419: END IF;
1420:
1421: DELETE
1422: FROM fte_shipment_status_exceptions
1423: WHERE transaction_id IN (SELECT transaction_id
1424: FROM fte_shipment_status_headers
1425: WHERE delivery_id = l_delivery_id);
1426:

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

1425: WHERE delivery_id = l_delivery_id);
1426:
1427: IF SQL%FOUND THEN
1428: IF l_debug_on THEN
1429: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_shipment_status_exceptions: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1430: END IF;
1431: END IF;
1432:
1433: DELETE