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



in oracle workflow if i want to send a mail to the user after sending if the user didn't approv..

Answer / upendra

By Using Workflow rationalization we can do easily.

Is This Answer Correct ?    0 Yes 0 No

in oracle workflow if i want to send a mail to the user after sending if the user didn't approv..

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

Post New Answer

More Oracle Apps Technical Interview Questions

what are the different calculation columns available in reports?

1 Answers  


What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.

2 Answers   IBM,


In xml report, how to print the headings in every page?

1 Answers   Sierra Atlantica,


WHAT IS REFCURSOR IN ORACLE ?

6 Answers  


What are file in oracle.

0 Answers   IBM, BirlaSoft,






can we execute one concurrent program through another concurrent program?

1 Answers   KPIT,


wht r the basetables of customer interface?

2 Answers  


Can We Create a Synonym On Trigger?

7 Answers   Oracle, Exeter,


How can we import the data into a database using sql * loader?

0 Answers  


How will U link GL with OU in Multi-org environment.

3 Answers   Convergys,


in which table sub inventory related information for item is stored?

3 Answers   Scan Steel, chain sys,


can we use look up type instead of a pofile option?or valueset?is it possible how?

0 Answers   Cap Gemini,






Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (791)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)