286: -- PROCEDURE TO purge wms TABLES
287: --
288: -- Purpose: Concurrent Program to puge obsolete data from WMS tables
289: -- The following tables are obsoleted
290: -- * wms_device_requests_hist
291: -- * wms_lpn_histories
292: -- * wms_dispatched_tasks_history
293: -- * wms_exceptions
294: -- * wms_lpn_process_temp
322: p_bus_event_id NUMBER DEFAULT NULL,
323: x_return_status OUT NOCOPY VARCHAR2 );
324:
325:
326: FUNCTION select_Device(wdrrec WMS_DEVICE_REQUESTS%ROWTYPE,
327: p_autoenable VARCHAR2,
328: p_parent_request_id NUMBER
329: ) return NUMBER;
330: