rem HEADER
rem   $Header: wfrmall.sql 26.1 2001/11/05 20:18:22 ctilley ship $
rem NAME
rem   wfrmall.sql - WorkFlow ReMove ALL
rem USAGE
rem   @wfrmall
rem DESCRIPTION
rem
prompt   DANGER *** DANGER *** DANGER *** DANGER *** DANGER *** DANGER
prompt   .
prompt   This Deletes all workflow data. ALL OF IT.  
prompt   .
prompt   DANGER *** DANGER *** DANGER *** DANGER *** DANGER *** DANGER
prompt   .

rem  for 8.0.4 databases, truncate no longer works unless you disable
rem  all foreign keys. To avoid doing this, delete instead of truncate.
rem  Use loops to avoid excessive rollback segments. 
rem  Change the size of the cursors for better performance.

rem  dbdrv: none

prompt Deleting from wf_item_activity_statuses_h            
begin                                                       
 loop                                                       
  delete from wf_item_activity_statuses_h where rownum<1000; 
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_item_activity_statuses              
begin                                                       
 loop                                                       
  delete from wf_item_activity_statuses where rownum<1000;   
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_item_attribute_values               
begin                                                       
 loop                                                       
  delete from wf_item_attribute_values where rownum<1000;    
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_items                               
begin                                                       
 loop                                                       
  delete from wf_items where rownum<1000;                    
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_notification_attributes             
begin                                                       
 loop                                                       
  delete from wf_notification_attributes where rownum<1000;  
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_notifications                       
begin                                                       
 loop                                                       
  delete from wf_notifications where rownum<1000;            
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_routing_rule_attributes             
begin                                                       
 loop                                                       
  delete from wf_routing_rule_attributes where rownum<1000;  
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_routing_rules                       
begin                                                       
 loop                                                       
  delete from wf_routing_rules where rownum<1000;            
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_activity_transitions                
begin                                                       
 loop                                                       
  delete from wf_activity_transitions where rownum<1000;     
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_activity_attr_values                
begin                                                       
 loop                                                       
  delete from wf_activity_attr_values where rownum<1000;     
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_process_activities                  
begin                                                       
 loop                                                       
  delete from wf_process_activities where rownum<1000;       
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_activity_attributes_tl              
begin                                                       
 loop                                                       
  delete from wf_activity_attributes_tl where rownum<1000;   
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_activity_attributes                 
begin                                                       
 loop                                                       
  delete from wf_activity_attributes where rownum<1000;      
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_activities_tl                       
begin                                                       
 loop                                                       
  delete from wf_activities_tl where rownum<1000;            
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_activities                          
begin                                                       
 loop                                                       
  delete from wf_activities where rownum<1000;               
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_message_attributes_tl               
begin                                                       
 loop                                                       
  delete from wf_message_attributes_tl where rownum<1000;    
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_message_attributes                  
begin                                                       
 loop                                                       
  delete from wf_message_attributes where rownum<1000;       
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_messages_tl                         
begin                                                       
 loop                                                       
  delete from wf_messages_tl where rownum<1000;              
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_messages                            
begin                                                       
 loop                                                       
  delete from wf_messages where rownum<1000;                 
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_item_attributes_tl                  
begin                                                       
 loop                                                       
  delete from wf_item_attributes_tl where rownum<1000;       
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_item_attributes                     
begin                                                       
 loop                                                       
  delete from wf_item_attributes where rownum<1000;          
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_lookups_tl                          
begin                                                       
 loop                                                       
  delete from wf_lookups_tl where rownum<1000;               
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_lookup_types_tl                     
begin                                                       
 loop                                                       
  delete from wf_lookup_types_tl where rownum<1000;          
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_item_types_tl                       
begin                                                       
 loop                                                       
  delete from wf_item_types_tl where rownum<1000;            
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            
prompt Deleting from wf_item_types                          
begin                                                       
 loop                                                       
  delete from wf_item_types where rownum<1000;               
  commit;                                                   
  if sql%notfound then exit; end if;                        
 end loop;                                                  
end;                                                        
/                                                           
                                                            

commit;
exit;