/*=======================================================================+
 |  Copyright (c) 1995 Oracle Corporation Redwood Shores, California, USA|
 |                            All rights reserved.                       |
 +=======================================================================+
 | FILENAME
 |   wfdemod.sql
 |
 | DESCRIPTION
 |	drop workflow Demonstration tables and packages
 |
 | NOTES
 |
 | MODIFIED    30-OCT-97  rseiden  Added delete of demo users and roles from
 |                                 wf_local_users, wf_local_roles, and
 |                                 wf_local_user_roles.
 | MODIFIED    18-NOV-98  rseiden  replaced user names with Vision database
 |                                 compliant names according to:
 |                                 JANDERSON => BLEWIS
 |                                 MBEECH    => CDOUGLAS
 |                                 DMCKEE    => KWALKER
 |                                 JRUSH     => SPIERSON
 |                                 Removed user name JSMITH from demo.
 *=======================================================================*/

/* $Header: wfdemod.sql 26.0 2000/07/05 22:08:46 kma ship $ */

whenever sqlerror continue;
drop package wf_demo;
drop package wf_reqdemo;

drop table WF_REQDEMO_EMP_HIERARCHY;

drop table WF_REQDEMO_EMP_AUTHORITY;

delete from wf_local_user_roles
where role_name in ('ADMIN','MANAGERS','OTHERS','WORKERS');

delete from wf_local_users
where name in 
('SYSADMIN','WFADMIN','KWALKER','BLEWIS','SPIERSON','CDOUGLAS');

delete from wf_local_roles
where name in
('ADMIN','MANAGERS','OTHERS','WORKERS');

exit;