APPS.WSH_INTERFACE_MESSAGE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22

  SELECT 1
  FROM wsh_new_del_interface
  WHERE delivery_interface_id  = p_delivery_interface_id
  FOR UPDATE NOWAIT;

Line: 29

  SELECT 1
  FROM wsh_del_details_interface
  WHERE delivery_detail_interface_id  = p_delivery_detail_interface_id
  FOR UPDATE NOWAIT;

Line: 69

   fnd_message.set_name('FND', 'FND_RECORD_DELETED_ERROR');