APPS.WSH_PURGE dependencies on FTE_MESSAGE_CONTACT

Line 1327: FTE_MESSAGE_PARTNER, FTE_MESSAGE_CONTACT, FTE_MESSAGE_LOCATION,

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,
1331: WSH_ITM_RESPONSE_LINES, WSH_ITM_RESPONSE_HEADERS, WSH_ITM_REQUEST_CONTROL,

Line 1458: FROM fte_message_contact

1454: END IF;
1455: END IF;
1456:
1457: DELETE
1458: FROM fte_message_contact
1459: WHERE transaction_id IN (SELECT transaction_id
1460: FROM fte_shipment_status_headers
1461: WHERE delivery_id = l_delivery_id);
1462:

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

1461: WHERE delivery_id = l_delivery_id);
1462:
1463: IF SQL%FOUND THEN
1464: IF l_debug_on THEN
1465: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_message_contact: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1466: END IF;
1467: END IF;
1468:
1469: DELETE