select option, option_id, title as pretty_name from ams_option_types aot, acs_objects ao where attribute_id = :attribute_id and aot.option_id = ao.object_id and not deprecated_p order by sort_order select * from ams_widgets where active_p is true and widget not in ($sql_list_of_valid_procs) select ams_widget__save ( :widget, :pretty_name, :value_method, :active_p ) select ams_value__text_save ( :text, :text_format ) select ams_value__time_save ( :time ) select ams_value__number_save ( :number ) select ams_value__postal_address_save ( :delivery_address, :municipality, :region, :postal_code, :country_code, :additional_text, :postal_type ) select ams_value__telecom_number_save ( :itu_id, :national_number, :area_city_code, :subscriber_number, :extension, :sms_enabled_p, :best_contact_time, :location, :phone_type_id ) select value_id from ams_option_ids where ams_value__options(value_id) = :options select ams_option__map ( :value_id, :option_id )