Procurement - EBS (MOSC)

MOSC Banner

PO Approval Workflow through back end

in Procurement - EBS (MOSC) 13 commentsAnswered ✓

Hi All,

Has anyone tried to call PO Approval Workflow through back end using pl sql.

I got one reference but am not very sure about the parameters .




declare

v_itemtype VARCHAR2(50);

v_itemkey VARCHAR2(50);

v_process VARCHAR2(50);

v_userkey VARCHAR2(50);

begin

 

v_itemtype := ‘DEMOIT’;

v_itemkey := ‘1233’;

v_userkey := ‘1233’;

v_process := ‘DEMOPROCESS’;

WF_ENGINE.Threshold := -1;

WF_ENGINE.CREATEPROCESS(v_itemtype, v_itemkey, v_process);

wf_engine.setitemuserkey(v_itemtype, v_itemkey, v_userkey );

wf_engine.setitemowner (v_itemtype, v_itemkey,’SYSADMIN’);

WF_ENGINE.STARTPROCESS(v_itemtype, v_itemkey);

commit;

exception when others

then

dbms_output.put_line(SQLERRM);

end;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center