1318: Input: Table of Record Types for Deliveries
1319: Output: Return Status - success or failure
1320: ==============================================================================
1321: Logic: i) Delete records from the following tables:
1322: WSH_EXCEPTIONS, WSH_TRANSACTIONS_HISTORY, WSH_DOCUMENT_INSTANCES,
1323: WSH_FREIGHT_COSTS
1324:
1325: If FTE is installed,
1326: FTE_SHIPMENT_STATUS_DETAILS, FTE_SHIPMENT_STATUS_EXCEPTIONS,
1372: END IF;
1373: END IF;
1374:
1375: DELETE
1376: FROM wsh_transactions_history
1377: WHERE entity_number = to_char(l_delivery_id)
1378: AND entity_type = 'DLVY';
1379:
1380: IF SQL%FOUND THEN
1378: AND entity_type = 'DLVY';
1379:
1380: IF SQL%FOUND THEN
1381: IF l_debug_on THEN
1382: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_transactions_history: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1383: END IF;
1384: END IF;
1385:
1386: DELETE