Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 5486 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
Where I can download D2K software?
what are the prerequisite set ups for inter organization transaction?
Can you define an erp system?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
How to link modules in apps
Registering parametric report?
What are the tables in GL?
How to know the number of invoices generated for one PO from front end (navigation)?
what is the standard program for blanket po to process data from interface table to bace table
Can u define exceptions twice in same block?
What are the different components of soa suite?
Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports
Oracle Apps Technical 
