APPS.WSH_PURGE dependencies on FTE_MESSAGE_PARTNER

Line 1202: FTE_MESSAGE_PARTNER, FTE_MESSAGE_CONTACT, FTE_MESSAGE_LOCATION,

1198: WSH_FREIGHT_COSTS
1199:
1200: If FTE is installed,
1201: FTE_SHIPMENT_STATUS_DETAILS, FTE_SHIPMENT_STATUS_EXCEPTIONS,
1202: FTE_MESSAGE_PARTNER, FTE_MESSAGE_CONTACT, FTE_MESSAGE_LOCATION,
1203: FTE_DELIVERY_PROOF, FTE_SHIPMENT_STATUS_HEADERS
1204:
1205: If ITM Screening is done,
1206: WSH_ITM_RESPONSE_LINES, WSH_ITM_RESPONSE_HEADERS, WSH_ITM_REQUEST_CONTROL,

Line 1309: FROM fte_message_partner

1305: END IF;
1306: END IF;
1307:
1308: DELETE
1309: FROM fte_message_partner
1310: WHERE transaction_id IN (SELECT transaction_id
1311: FROM fte_shipment_status_headers
1312: WHERE delivery_id = l_delivery_id);
1313:

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

1312: WHERE delivery_id = l_delivery_id);
1313:
1314: IF SQL%FOUND THEN
1315: IF l_debug_on THEN
1316: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from fte_message_partner: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1317: END IF;
1318: END IF;
1319:
1320: DELETE