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
tell me the scenarios of the independent in reports
tell my any difficult situtation you solved in your experience in your company?
What are the different components of soa suite?
How do you register report in oracle apps?
What is instead of trigger in where we will use?
what is global tempory table?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
Can u give the Documentation of Custom.pll in oracle apps
please send me forms, xml pulisher questions,answers
What do you understand by soa?
Do you know where we can check the status of po?
What do you understand by soa and what are the benefits of using this architecture?
What are do's and dont's of Interface?
List the types of flexfield?