--
-- packages/library/sql/library-workflow-drop.sql
--
-- 
-- @author Dirk Gomez (sharenet@dirkgomez.de)
-- @author Timo Hentschel (timo@arsidigta.com)
-- 
-- @creation-date 2002-02-22
--
-- @cvs-id $Id: library-workflow-drop.sql,v 1.1 2003/07/02 12:19:42 peterm Exp $
--

truncate table wf_library_notifications;
truncate table wf_ttracker_notifications;

begin
    workflow.delete_cases('library_approval_wf');
end;
/
show errors

drop table wf_library_approval_cases;
begin
    workflow.drop_workflow('library_approval_wf');
end;
/
show errors

drop table wf_library_notifications;
drop sequence library_notification_id_seq;