2 Interesting Oracle Workflow APIs

Abort Process

BEGIN
 wf_engine.abortprocess
               (itemtype =>l_item_type,
                itemkey=>l_item_key );
  exception
            when others then
                update wf_items
                   set end_date = sysdate
                 where item_type = l_item_type
                   and item_key = l_item_key;
 END ;



BEGIN
    wf_purge.items
        (itemtype => l_item_type,
         itemkey  => l_item_key,
         docommit=>false,
         force=>true);
END;