187: begin
188: --
189: select 1
190: into dummy
191: from sys.dual
192: where exists ( select null
193: from wf_notifications
194: where notification_id = nid
195: and status = 'OPEN'
673: -- get the item key from sequence
674: -- Get the next item key from the sequence
675: select hr_workflow_item_key_s.nextval
676: into p_itemKey
677: from sys.dual;
678:
679: -- Create the Workflow Process
680: wf_engine.CreateProcess
681: (itemtype => p_itemType