--
-- workflow_case_pkg__delete/1
--
create or replace function workflow_case_pkg__delete(
  integer
) returns int4 as $$

declare
  delete_case_id                alias for $1;
  rec                           record;
begin
    -- All workflow data cascades from the case id
    delete from workflow_cases
      where case_id = delete_case_id;    

  return 0; 
end;$$ language plpgsql;