Index: openacs-4/packages/workflow/tcl/case-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/case-procs-oracle.xql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/workflow/tcl/case-procs-oracle.xql	1 Dec 2005 14:11:44 -0000	1.11
+++ openacs-4/packages/workflow/tcl/case-procs-oracle.xql	21 Nov 2017 13:05:13 -0000	1.12
@@ -2,44 +2,6 @@
 <queryset>
   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
-  <fullquery name="workflow::case::fsm::get_info_not_cached.select_case_info">
-    <querytext>
-      select c.case_id,
-             c.workflow_id,
-             c.object_id,
-             s.state_id,
-             s.short_name as state_short_name,
-             s.pretty_name as pretty_state,
-             s.hide_fields as state_hide_fields
-      from   workflow_cases c,
-             workflow_case_fsm cfsm,
-             workflow_fsm_states s
-      where  c.case_id = :case_id
-      and    cfsm.case_id = c.case_id
-      and    cfsm.current_state = s.state_id (+)
-      and    cfsm.parent_enabled_action_id = :parent_enabled_action_id
-    </querytext>
-  </fullquery>
-
-  <fullquery name="workflow::case::fsm::get_info_not_cached.select_case_info_null_parent_id">
-    <querytext>
-      select c.case_id,
-             c.workflow_id,
-             c.object_id,
-             s.state_id,
-             s.short_name as state_short_name,
-             s.pretty_name as pretty_state,
-             s.hide_fields as state_hide_fields
-      from   workflow_cases c,
-             workflow_case_fsm cfsm,
-             workflow_fsm_states s
-      where  c.case_id = :case_id
-      and    cfsm.case_id = c.case_id
-      and    cfsm.current_state = s.state_id (+)
-      and    cfsm.parent_enabled_action_id is null
-    </querytext>
-  </fullquery>
-
   <fullquery name="workflow::case::role::get_assignees_not_cached.select_assignees">
     <querytext>
         select m.party_id, 
@@ -53,50 +15,6 @@
     </querytext>
   </fullquery>
 
-  <fullquery name="workflow::case::get_activity_log_info_not_cached.select_log">
-    <querytext>
-        select l.entry_id,
-               l.case_id,
-               l.action_id,
-               a.short_name as action_short_name,
-               a.pretty_past_tense as action_pretty_past_tense,
-               io.creation_user,
-               iou.first_names as user_first_names,
-               iou.last_name as user_last_name,
-               iou.email as user_email,
-               io.creation_date,
-               to_char(io.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_pretty,
-               blob_to_string(r.content) as comment_string, -- needs il8-ing...
-               r.mime_type as comment_mime_type,
-               d.key,
-               d.value
-        from   workflow_case_log l,
-               workflow_actions a,
-               cr_items i,
-               acs_objects io,
-               acs_users_all iou,
-               cr_revisions r,
-               workflow_case_log_data d
-        where  l.case_id = :case_id
-          and  l.action_id = a.action_id
-          and  i.item_id = l.entry_id
-          and  io.object_id = i.item_id
-          and  iou.user_id (+) = io.creation_user
-          and  r.revision_id = i.live_revision
-          and  d.entry_id (+) = l.entry_id
-        order  by creation_date
-    </querytext>
-  </fullquery>
-
-  <fullquery name="workflow::case::timed_actions_sweeper.select_timed_out_actions">
-    <querytext>
-        select enabled_action_id
-        from   workflow_case_enabled_actions
-        where  execution_time <= sysdate
-        and    completed_p = 'f'
-    </querytext>
-  </fullquery>
-
   <fullquery name="workflow::case::action::notify.select_object_name">
     <querytext>
         select acs_object.name(:object_id) as name from dual
@@ -149,36 +67,4 @@
     </querytext>
   </fullquery>
 
-  <fullquery name="workflow::case::action::enabled_p.select_enabled_p">
-    <querytext>
-      select q.*
-      from  (select 1
-             from   workflow_case_enabled_actions ean
-             where  ean.action_id = :action_id
-             and    ean.case_id = :case_id
-             and    completed_p = 'f'
-            ) q
-      where rownum = 1
-    </querytext>
-  </fullquery>
-
-  <fullquery name="workflow::case::enabled_action_get.select_enabled_action">
-    <querytext>
-        select enabled_action_id,
-               case_id,
-               action_id,
-               assigned_p,
-               completed_p,
-               parent_enabled_action_id,
-               to_char(execution_time, 'YYYY-MM-DD HH24:MI:SS') as execution_time_ansi,
-               nvl((select a2.trigger_type
-                from   workflow_case_enabled_actions e2,
-                       workflow_actions a2
-                where  e2.enabled_action_id = e.parent_enabled_action_id
-                and    a2.action_id = e2.action_id), 'workflow') as parent_trigger_type
-        from   workflow_case_enabled_actions e
-        where  enabled_action_id = :enabled_action_id
-    </querytext>
-  </fullquery>    
-
 </queryset>