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
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?
What are file in oracle.
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
Tell me where we find the status of order information?
In oracle application how do you debug or trace errors?
tell me the scenarios of the independent in reports
What is sca and how is it useful?
what are the prerequisites for costing transactions?
please send me forms, xml pulisher questions,answers
In sequence i want to 11 and 15th values how we will write?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
is it possible to run the interface without using oracle apps?
do you know is it possible to run the interface without using oracle apps?
what are the different transaction clauses in AR?
pls send me out bound code of supplers,site,bankiformation code pls as soon as