Index: openacs-4/packages/notifications/sql/oracle/notifications-package-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/oracle/notifications-package-create.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/notifications/sql/oracle/notifications-package-create.sql	29 May 2002 21:47:18 -0000	1.3
+++ openacs-4/packages/notifications/sql/oracle/notifications-package-create.sql	25 Jun 2002 18:58:06 -0000	1.4
@@ -82,6 +82,7 @@
 as
    function new (
       delivery_method_id                in notification_delivery_methods.delivery_method_id%TYPE default null,
+      sc_impl_id                        in notification_delivery_methods.sc_impl_id%TYPE,
       short_name                        in notification_delivery_methods.short_name%TYPE,
       pretty_name                       in notification_delivery_methods.pretty_name%TYPE,
       creation_date                     in acs_objects.creation_date%TYPE default sysdate,
@@ -104,6 +105,7 @@
 as
    function new (
       delivery_method_id                in notification_delivery_methods.delivery_method_id%TYPE default null,
+      sc_impl_id                        in notification_delivery_methods.sc_impl_id%TYPE,
       short_name                        in notification_delivery_methods.short_name%TYPE,
       pretty_name                       in notification_delivery_methods.pretty_name%TYPE,
       creation_date                     in acs_objects.creation_date%TYPE default sysdate,
@@ -124,8 +126,8 @@
                               );
 
       insert into notification_delivery_methods
-      (delivery_method_id, short_name, pretty_name) values
-      (v_delivery_method_id, short_name, pretty_name);
+      (delivery_method_id, sc_impl_id, short_name, pretty_name) values
+      (v_delivery_method_id, sc_impl_id, short_name, pretty_name);
 
       return v_delivery_method_id;
    end new;
@@ -149,6 +151,7 @@
 as
    function new (
       type_id                           in notification_types.type_id%TYPE default null,
+      sc_impl_id                        in notification_types.sc_impl_id%TYPE,
       short_name                        in notification_types.short_name%TYPE,
       pretty_name                       in notification_types.pretty_name%TYPE,
       description                       in notification_types.description%TYPE,
@@ -172,6 +175,7 @@
 as
    function new (
       type_id                           in notification_types.type_id%TYPE default null,
+      sc_impl_id                        in notification_types.sc_impl_id%TYPE,
       short_name                        in notification_types.short_name%TYPE,
       pretty_name                       in notification_types.pretty_name%TYPE,
       description                       in notification_types.description%TYPE,
@@ -193,8 +197,8 @@
                    );
       
       insert into notification_types
-      (type_id, short_name, pretty_name, description) values
-      (v_type_id, short_name, pretty_name, description);
+      (type_id, sc_impl_id, short_name, pretty_name, description) values
+      (v_type_id, sc_impl_id, short_name, pretty_name, description);
       
       return v_type_id;
    end new;
