Index: openacs-4/contrib/obsolete-packages/ticket-tracker/sql/oracle/ticket-tracker-packages.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/sql/oracle/ticket-tracker-packages.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/contrib/obsolete-packages/ticket-tracker/sql/oracle/ticket-tracker-packages.sql	13 Aug 2001 21:31:07 -0000	1.4
+++ openacs-4/contrib/obsolete-packages/ticket-tracker/sql/oracle/ticket-tracker-packages.sql	10 Oct 2001 03:43:18 -0000	1.5
@@ -796,6 +796,7 @@
     )
     is
         v_url           varchar2(1000);
+        v_request_id    integer;
         cursor ticket_cur is
             select tt.ticket_id,
                    tt.subject,
@@ -818,12 +819,24 @@
         end if;
         close ticket_cur;
 	
-	party_from := ttracker_util.notification_sender(ticket_rec.package_id);
+        party_from := ttracker_util.notification_sender(ticket_rec.package_id);
         subject := 'Ticket #'||ticket_rec.ticket_id||' -- '||custom_arg;
         body := 'Subject: '||ticket_rec.subject||'
 '||'To do: '||custom_arg||'
 '||'Manage via: '||ttracker_util.workflow_url||'task?task_id='||task_id;
  
+		-- notification call moved from acs-workflow to here
+		-- to retain consistency with postgres version
+
+        v_request_id := acs_mail_nt.post_request (       
+            party_from => notification.party_from,
+            party_to => notification.party_to,
+            expand_group => 'f' ,
+            subject => notification.subject,
+            message => notification.body,
+            max_retries => 0
+        );
+
     end notification;                                                 
                     
     procedure notify_admin (
Index: openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-tracker-packages.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-tracker-packages.sql,v
diff -u -r1.7 -r1.8
--- openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-tracker-packages.sql	30 Aug 2001 04:59:48 -0000	1.7
+++ openacs-4/contrib/obsolete-packages/ticket-tracker/sql/postgresql/ticket-tracker-packages.sql	10 Oct 2001 03:43:18 -0000	1.8
@@ -663,7 +663,19 @@
 '' || ''To do: '' || p_custom_arg || ''
 '' || ''Manage via: '' || ttracker_util__workflow_url(''t'') || ''task?task_id='' || p_task_id;
 
---FIXME: need to figure out the in-out parameters
+   -- acs-workflow has been changed. actual notification
+   -- should be sent from callback now, thus it is called now
+   --  vinodk
+
+   perform acs_mail_nt__post_request (       
+		   v_party_from,                 -- party_from
+		   p_party_to,					 -- party_to
+		   ''f'',                        -- expand_group
+		   v_subject,                    -- subject
+		   v_body,                       -- message
+		   0                             -- max_retries
+	);
+
 	return 0;
 end;' language 'plpgsql';