in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?
Answers were Sorted based on User's Feedback
Answer / upendra
By Using Workflow rationalization we can do easily.
|Is This Answer Correct ?||0 Yes||0 No|
Answer / vasu
We can Caliculate time and based on time we can able to send a notification
FUNCTION get_timeout_minutes RETURN NUMBER IS
SYSDATE) * 24 * 60;
itemtype IN VARCHAR2
,itemkey IN VARCHAR2
,actid IN NUMBER
,funcmode IN VARCHAR2
,RESULT IN OUT VARCHAR2
n_timeout_in_minutes NUMBER := get_timeout_minutes;
IF (funcmode != 'RUN')
wf_engine.setitemattrnumber(itemtype => itemtype
,itemkey => itemkey
,aname => 'WAIT_DAYS_INCLUSIVE_WEEEKEND_H'
,avalue => n_timeout_in_minutes);
RESULT := 'COMPLETE:Y';
|Is This Answer Correct ?||0 Yes||1 No|
what are the different calculation columns available in reports?
What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.
In xml report, how to print the headings in every page?
WHAT IS REFCURSOR IN ORACLE ?
What are file in oracle.
can we execute one concurrent program through another concurrent program?
wht r the basetables of customer interface?
Can We Create a Synonym On Trigger?
How can we import the data into a database using sql * loader?
How will U link GL with OU in Multi-org environment.
in which table sub inventory related information for item is stored?
can we use look up type instead of a pofile option?or valueset?is it possible how?