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?
Answer Posted / 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 |
Post New Answer View All Answers
What do you understand by a set of books?
What is a value set? List its various types.
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
Do you know where we can check the status of po?
How can we import the data into a database using sql * loader?
Do you know what are user profiles in apps. Any examples you can give?
what is the difference between request group and request security in oracle apps?
q)what are the validations in sql*loader
What is the concept of soa governance?
In sequence i want to 11 and 15th values how we will write?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
what is pay run id ?
How is choreography different from orchestration?
How many schemas we have? how many you have used?
What are the benefits of using soa architecture?