select calendar_name from calendars where owner_id = :user_id select calendar_id,package_id from calendars where owner_id = :from_user_id select count(*) from calendars where owner_id = :to_user_id and package_id = :l_pkg_id update calendars set owner_id = :to_user_id where owner_id = :from_user_id and calendar_id = :l_cal_id select calendar_id from calendars where package_id = :l_pkg_id and owner_id = :to_user_id update cal_items set on_which_calendar = :to_cal_id where on_which_calendar = :l_cal_id delete from calendars where calendar_id = :l_cal_id