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

Name the different Cursor Attributes.

2 Answers   Satyam,


what are the types of interfacing?

3 Answers   TCS,


What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1

25 Answers   IBM, Satyam,


we have 10 records. It's occured error in 6th record how can u find and how to rectify that?

2 Answers  


How You Will display the key flexifields in your report

3 Answers   TCS,






There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.

3 Answers   Satyam,


i have 3 parameters like p1,p2,p3.In p1 i have 2 parameters like a,b.if pass parameter 'a' p2 should be enable and p3 should be disable then if pass parameter 'b' the vice versa.

1 Answers   IBM, Sierra Atlantica,


What is the Lookup's and what is the use of lookup's?

3 Answers   TCS,


why r u transer the data base tables to flat file and what is use

3 Answers   Wipro,


Give a brief overview on OrderManagement.

1 Answers   Zensar,


Give a overview on Aol

2 Answers   Zensar,


What is MO operating units. Why it need to to set this and where .

2 Answers   IBM,






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)