-- -- The Research Paper Package -- -- @author ben@openforce -- @creation-date 2002-11-03 -- -- -- the integration with Notifications declare impl_id integer; v_foo integer; begin -- the notification type impl impl_id := acs_sc_impl.new ( 'NotificationType', 'research_author_notif_type', 'research_papers' ); v_foo := acs_sc_impl.new_alias ( 'NotificationType', 'research_author_notif_type', 'GetURL', 'research_paper::notification::get_url', 'TCL' ); v_foo := acs_sc_impl.new_alias ( 'NotificationType', 'research_author_notif_type', 'ProcessReply', 'research_paper::notification::process_reply', 'TCL' ); acs_sc_binding.new ( contract_name => 'NotificationType', impl_name => 'research_author_notif_type' ); v_foo:= notification_type.new ( short_name => 'research_author_notif', sc_impl_id => impl_id, pretty_name => 'Research Author Notification', description => 'Notifications for Research Authors', creation_user => NULL, creation_ip => NULL ); -- enable the various intervals and delivery methods insert into notification_types_intervals (type_id, interval_id) select v_foo, interval_id from notification_intervals where name in ('instant','hourly','daily'); insert into notification_types_del_methods (type_id, delivery_method_id) select v_foo, delivery_method_id from notification_delivery_methods where short_name in ('email'); end; / show errors