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
- 5714 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
Plz anybody send me Technical specification for AP Interface
What are the Standard Reports and Forms in HRMS?
How do you register report in oracle apps?
how can i print random rows in plsql table
In support project one ticket alloted which steps follows manualy tell me ?
A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.
where to define interorganization transaction charges and what are the different options?
how to print multi lay outs,muti currency,muti language in xml publisher
Which oracle apps version you are very confident in?
Do you know where we can check the status of po?
How can you achieve loose coupling in soa framework?
What do you understand by soa and what are the benefits of using this architecture?
In oracle application how do you debug or trace errors?
What is oracle soa suite and what are its different components?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
