select acs_object__new ( null, 'events_venue', now(), :user_id, :creation_ip, :context_id ) select events_venue__new( :venue_id, 'events_venue', :venue_name, :address1, :address2, :city, :phone_number, :fax_number, :email, :needs_reserve_p, :max_people, :description, :creation_date, null, null, null, ) select events_venue__delete(:venue_id); select 1 from events_events where venue_id = :venue_id limit 1 select 1 from events_venues where $parent_id in ([events::venue::all_parents_or_children -venue_id $child_id -package_id $package_id -sql_p "t" -parent_p "t"]) limit 1