select title, acs_object_id_seq.nextval as new_item_id, owner_id as old_owner_id, message_type, title, description, content, content_format from contact_messages where item_id = :item_id update contact_message_items set owner_id = :owner_id where item_id = :item_id select title from contact_messages where owner_id = :owner_id and upper(title) like upper('${sql_title}%') update cr_items set publish_status = 'expired' where item_id = :item_id