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?
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 |
what are version control tools used in oracle apps?
While running the concurrent program we will get the status, we have to change the status. How it will be done.
HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT
What r the validation done in ap inbound ?
while running a interface if we get 100 records as erors. how to debug it.
What do you understand by soa and what are the benefits of using this architecture?
What are profile options?
we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?
What is INBOUND and OUT BOUND? (Different types of interfaces)
17 Answers Accenture, Asian Paints, Inbound Solutions, Tech Mahindra,
differentiate between intra & inter UOM class conversion with examples.
Which module is not in multiorg
what are the different types of parameters avialable in reports?