The following lines contain the word 'select', 'insert', 'update' or 'delete':
ELSIF (p_action = G_LPN_PURGE_ACTION_DELETE) THEN
-- Validate then delete
-- Call WMS_PURGE_PVT.Check_Purge_LPNs
-- with p_lock_flag as 'Y'
-- Then call WMS_PURGE_PVT.Purge_LPNs to delete LPNs
IF (l_debug = 1 ) THEN
mdebug('Validate, Calling WMS_PURGE_PVT.Check_Purge_LPNs with p_lock_flag as Y');