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.6 -r1.7
--- openacs-4/packages/notifications/sql/oracle/notifications-package-create.sql	19 Aug 2002 20:37:15 -0000	1.6
+++ openacs-4/packages/notifications/sql/oracle/notifications-package-create.sql	25 Feb 2003 10:07:41 -0000	1.7
@@ -230,6 +230,7 @@
       interval_id                       in notification_requests.interval_id%TYPE,
       delivery_method_id                in notification_requests.delivery_method_id%TYPE,
       format                            in notification_requests.format%TYPE,
+      dynamic_p                         in notification_requests.dynamic_p%TYPE,
       creation_date                     in acs_objects.creation_date%TYPE default sysdate,
       creation_user                     in acs_objects.creation_user%TYPE,
       creation_ip                       in acs_objects.creation_ip%TYPE,
@@ -247,7 +248,6 @@
 /
 show errors
 
-
 create or replace package body notification_request
 as
    function new (
@@ -259,6 +259,7 @@
       interval_id                       in notification_requests.interval_id%TYPE,
       delivery_method_id                in notification_requests.delivery_method_id%TYPE,
       format                            in notification_requests.format%TYPE,
+      dynamic_p                         in notification_requests.dynamic_p%TYPE,
       creation_date                     in acs_objects.creation_date%TYPE default sysdate,
       creation_user                     in acs_objects.creation_user%TYPE,
       creation_ip                       in acs_objects.creation_ip%TYPE,
@@ -277,8 +278,8 @@
                       );
 
       insert into notification_requests
-      (request_id, type_id, user_id, object_id, interval_id, delivery_method_id, format) values
-      (v_request_id, type_id, user_id, object_id, interval_id, delivery_method_id, format);
+      (request_id, type_id, user_id, object_id, interval_id, delivery_method_id, format, dynamic_p) values
+      (v_request_id, type_id, user_id, object_id, interval_id, delivery_method_id, format, dynamic_p);
 
       return v_request_id;                          
    end new;
@@ -310,6 +311,8 @@
 
 
 
+
+
 -- the notifications package
 create or replace package notification
 as