APPS.WSH_PURGE dependencies on WSH_TRANSACTIONS_HISTORY

Line 1197: WSH_EXCEPTIONS, WSH_TRANSACTIONS_HISTORY, WSH_DOCUMENT_INSTANCES,

1193: Input: Table of Record Types for Deliveries
1194: Output: Return Status - success or failure
1195: ==============================================================================
1196: Logic: i) Delete records from the following tables:
1197: WSH_EXCEPTIONS, WSH_TRANSACTIONS_HISTORY, WSH_DOCUMENT_INSTANCES,
1198: WSH_FREIGHT_COSTS
1199:
1200: If FTE is installed,
1201: FTE_SHIPMENT_STATUS_DETAILS, FTE_SHIPMENT_STATUS_EXCEPTIONS,

Line 1251: FROM wsh_transactions_history

1247: END IF;
1248: END IF;
1249:
1250: DELETE
1251: FROM wsh_transactions_history
1252: WHERE entity_number = to_char(l_delivery_id)
1253: AND entity_type = 'DLVY';
1254:
1255: IF SQL%FOUND THEN

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

1253: AND entity_type = 'DLVY';
1254:
1255: IF SQL%FOUND THEN
1256: IF l_debug_on THEN
1257: WSH_DEBUG_SV.logmsg(l_module_name,'Deleted from wsh_transactions_history: DELIVERY_ID=' || l_delivery_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1258: END IF;
1259: END IF;
1260:
1261: DELETE