APPS.WSH_PURGE dependencies on FTE_MESSAGE_ADDRESS

Line 1446: FROM fte_message_address

1442: END IF;
1443: END IF;
1444:
1445: DELETE
1446: FROM fte_message_address
1447: WHERE transaction_id IN (SELECT transaction_id
1448: FROM fte_shipment_status_headers
1449: WHERE delivery_id = l_delivery_id);
1450:

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

1449: WHERE delivery_id = l_delivery_id);
1450:
1451: IF SQL%FOUND THEN
1452: IF l_debug_on THEN
1453: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_message_address: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1454: END IF;
1455: END IF;
1456:
1457: DELETE