update cr_revisions set publish_date = sysdate where revision_id = :latest_revision_id update acs_objects set modifying_user = :user_id, last_modified = sysdate where object_id = :latest_revision_id