Index: openacs-4/packages/cms/tcl/workflow-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/tcl/Attic/workflow-procs-oracle.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/cms/tcl/workflow-procs-oracle.xql	19 Nov 2001 18:40:38 -0000	1.5
+++ openacs-4/packages/cms/tcl/workflow-procs-oracle.xql	26 Sep 2002 01:53:18 -0000	1.6
@@ -838,4 +838,78 @@
         </querytext>
 </partialquery>
 
+
+
+<fullquery name="workflow::notify_of_assignments.noa_get_assignments">      
+      <querytext>
+      
+      select
+        transition_name, party_id, 
+        content_item.get_title(i.item_id, 'f') as title,
+        to_char(cd.deadline,'Month DD, YYYY') as deadline_pretty,
+        nvl(party.name(party_id), person.name(party_id)) as name
+      from
+        wf_transitions t, cr_items i,
+        wf_cases c, wf_case_assignments ca, wf_case_deadlines cd,
+    	wf_transition_role_assign_map trans_role
+      where
+        c.workflow_key = 'publishing_wf'
+      and
+        c.workflow_key = t.workflow_key
+      and
+    	ca.role_key = trans_role.assign_role_key
+      and
+    	t.transition_key = trans_role.transition_key
+      and
+        trans_role.transition_key = cd.transition_key
+      and
+        c.case_id = ca.case_id
+      and
+        c.case_id = cd.case_id
+      and
+        c.case_id = :case_id
+      and
+        c.state = 'active'
+      and
+        c.object_id = i.item_id
+    
+      </querytext>
+</fullquery>
+
+<fullquery name="workflow::notify_admin_of_finished_task.naoft_get_name">      
+      <querytext>
+      
+      select person.name( :user_id ) from dual
+    
+      </querytext>
+</fullquery>
+
+<fullquery name="workflow::notify_admin_of_finished_task.naoft_get_task_info">      
+      <querytext>
+      
+      select
+        transition_name, 
+        content_item.get_title(i.item_id,'f') as title,
+        o.creation_user as admin_id,
+        person.name( o.creation_user ) as admin_name,
+        to_char(sysdate,'Mon DD, YYYY') as today
+      from
+        wf_tasks t, wf_transitions tr, wf_cases c,
+        cr_items i, acs_objects o
+      where
+        tr.transition_key = t.transition_key
+      and
+        tr.workflow_key = t.workflow_key
+      and
+        t.case_id = c.case_id
+      and
+        c.object_id = i.item_id
+      and
+        i.item_id = o.object_id
+      and
+        t.task_id = :task_id
+    
+      </querytext>
+</fullquery>
+
 </queryset>