بسم الله الرحمن الرحيم

 

السلام عليكم ورحمة الله وبركاته

 

عايز أضيف على ال workflow توقيع جديد Another Approval ..والمفروض أعمل procedure او function بتشوف مين ال requester  وتجيب ال ID بتاعه ويروح في جدول أنا عامله يشوف مين المدير بتاع الrequester ده ويبعت notification للمدير ووالمدير يعمل Approve أو  reject

 

المشكلة في حاجتين

 

الprocedure هل ليها شكل معين علشان أعرف أنادي على ال requester جوة ال workflow

 

ثانيا: أضيف الfunction دي في أنهي process بالظبط علشان ال workflow كله ميضربش

 

وجزاكم الله خيرا

 

First) The Workflow Procedure have the following syntax:PROCEDURE My_Procedure_Name( itemtype in varchar2, itemkey in varchar2, actid in number, funcmode in varchar2, resultout in out varchar2);where:ItemType and Itemkey are workflow process instance identifieractid is the activity IDfuncmode is "Run","Cancel" or "Timeout"...usually you will execute your code only in "run" mode.resultout used for return the result of the procedureto get the requestor ID :vUserid := to_number(wf_engine.getItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'REQUESTOR_ID'));and 'REQUESTOR_ID' may differ from one case to another depending on the workflow processthen get the employee ID and his supervisor Second: the place to put your procedure is up to you to decide based on the nature of the workflow process.you may refer to oracle workflow materials but I would recommend the following book "The ABCs of Workflow for E-Business Suite Release 11i and Release 12".Hope this may help