select impl_name from acs_sc_impls, notification_types where acs_sc_impls.impl_id = notification_types.sc_impl_id and type_id= :type_id select type_id from notification_types where short_name = :short_name select type_id, short_name, pretty_name, description from notification_types where short_name = :short_name insert into notification_types_intervals (type_id, interval_id) select :type_id, :interval_id from dual where not exists (select 1 from notification_types_intervals where type_id = :type_id and interval_id = :interval_id) delete from notification_types_intervals where type_id = :type_id and interval_id = :interval_id insert into notification_types_del_methods (type_id, delivery_method_id) select :type_id, :delivery_method_id from dual where not exists (select 1 from notification_types_del_methods where type_id = :type_id and delivery_method_id = :delivery_method_id) delete from notification_types_del_methods where type_id = :type_id and delivery_method_id = :delivery_method_id insert into notification_types_intervals (type_id, interval_id) select :type_id, interval_id from notification_intervals insert into notification_types_del_methods (type_id, delivery_method_id) select :type_id, delivery_method_id from notification_delivery_methods