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