--
-- The Notifications Package
--
-- @author Ben Adida (ben@openforce.net)
-- @version $Id: notifications-init.sql,v 1.1 2002/07/09 17:35:10 rmello Exp $
--
-- Copyright OpenForce, 2002.
--
-- GNU GPL v2
--

-- initialize some stuff
declare
    v_foo   integer;
begin

    v_foo:= notification_interval.new(
        name => 'daily',
        n_seconds => 3600 * 24,
        creation_user => null,
        creation_ip => null
    );

    v_foo:= notification_interval.new(
        name => 'hourly',
        n_seconds => 3600,
        creation_user => null,
        creation_ip => null
    );

    v_foo:= notification_interval.new(
        name => 'instant',
        n_seconds => 0,
        creation_user => null,
        creation_ip => null
    );
           
-- This now done by email-sc-impl-create.sql
-- 
--     v_foo:= notification_delivery_method.new(
--         short_name => 'email',
--         pretty_name => 'Email',
--         creation_user => null,
--         creation_ip => null
--     );

end;
/
show errors