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
BEGIN
RETURN(get_next_working_date(SYSDATE
,g_number_of_wait_days) -
SYSDATE) * 24 * 60;
END get_timeout_minutes;
PROCEDURE set_wait_days_for_timeout
(
itemtype IN VARCHAR2
,itemkey IN VARCHAR2
,actid IN NUMBER
,funcmode IN VARCHAR2
,RESULT IN OUT VARCHAR2
) IS
n_timeout_in_minutes NUMBER := get_timeout_minutes;
BEGIN
IF (funcmode != 'RUN')
THEN
RETURN;
END IF;
wf_engine.setitemattrnumber(itemtype => itemtype
,itemkey => itemkey
,aname => 'WAIT_DAYS_INCLUSIVE_WEEEKEND_H'
,avalue => n_timeout_in_minutes);
RESULT := 'COMPLETE:Y';
END set_wait_days_for_timeout;
| Is This Answer Correct ? | 0 Yes | 1 No |
how can u link a org-id with a responsibility in reports?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
what are the important table names in purchasing?
Explain the multi-organization structure.
difference between 2 way and 4 way matching
Exception Handilings?
What is REF Cursor?
19 Answers Infosys, Intelligroup,
Attribute data types?
Give a overview on Aol
HOW U DISPLAY THE FLEXFIELD DATA IN APPS?
where do u specify in org_id?
Is that Possible To create package Overloading , If Yes Give any Examples