APPS.WSH_PURGE dependencies on FTE_MESSAGE_ADDRESS

Line 1321: FROM fte_message_address

1317: END IF;
1318: END IF;
1319:
1320: DELETE
1321: FROM fte_message_address
1322: WHERE transaction_id IN (SELECT transaction_id
1323: FROM fte_shipment_status_headers
1324: WHERE delivery_id = l_delivery_id);
1325:

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

1324: WHERE delivery_id = l_delivery_id);
1325:
1326: IF SQL%FOUND THEN
1327: IF l_debug_on THEN
1328: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_message_address: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1329: END IF;
1330: END IF;
1331:
1332: DELETE