prompt Package Header: jr_dependency_purge
create or replace package jr_dependency_purge
is
  --------------------------------------------------------------
  -- Package cursors
  --------------------------------------------------------------
  --------------------------------------------------------------
  -- Package routines
  --------------------------------------------------------------
  -----------------------------------------------------
  -- purge all objects in the  workarea in accordance
  -- with the purging policy identified by policy_name
  -- or policy_id.
  -----------------------------------------------------
  procedure purge_workarea(i_workarea   in number, i_policy_name in varchar2);
  procedure purge_workarea(i_workarea   in number, i_policy_id   in number);

  procedure purge_workarea(i_workarea   in varchar2, i_policy_name in varchar2);
  procedure purge_workarea(i_workarea   in varchar2, i_policy_id   in number);

  --------------------------------------------------------------
  -- Package exceptions
  --------------------------------------------------------------
  WORKAREA_ERROR EXCEPTION;
  POLICY_ERROR EXCEPTION;  
  
  -------------------------------------------------
  --- Allow calls from SQL
  -- WNDS: writes no database state
  -- WNPS: writes no package state
  -------------------------------------------------
  
end;
/