APPS.WSH_PURGE dependencies on FTE_MESSAGE_PARTNER

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 1434: FROM fte_message_partner

1430: END IF;
1431: END IF;
1432:
1433: DELETE
1434: FROM fte_message_partner
1435: WHERE transaction_id IN (SELECT transaction_id
1436: FROM fte_shipment_status_headers
1437: WHERE delivery_id = l_delivery_id);
1438:

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

1437: WHERE delivery_id = l_delivery_id);
1438:
1439: IF SQL%FOUND THEN
1440: IF l_debug_on THEN
1441: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_message_partner: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1442: END IF;
1443: END IF;
1444:
1445: DELETE