APPS.WMS_CONTAINER2_PUB dependencies on WMS_LPN_HISTORIES

Line 147: DELETE FROM WMS_LPN_HISTORIES

143: /* Check if the LPN history of this should be deleted or not */
144: IF (p_purge_history = 1) THEN
145: -- If this value is other than 1, we will just assume that no
146: -- LPN history records shall be purged
147: DELETE FROM WMS_LPN_HISTORIES
148: WHERE lpn_id = p_lpn_id
149: OR parent_lpn_id = p_lpn_id;
150: END IF;
151:

Line 156: DELETE FROM wms_lpn_histories

152: -- If the entire history is not to be purged, check if some of
153: -- the past history records should be deleted or not
154: IF ((p_purge_history <> 1) AND
155: (p_del_history_days_old IS NOT NULL)) THEN
156: DELETE FROM wms_lpn_histories
157: WHERE (lpn_id = p_lpn_id
158: OR parent_lpn_id = p_lpn_id)
159: AND (SYSDATE - creation_date >= p_del_history_days_old);
160: END IF;