Answer / upendra

By Using Workflow rationalization we can do easily.

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;

which is the table for storing organization information?

9 Answers   Infosys, Scan Steel,

---

What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?

2 Answers   TCS,

---

where we will put the control file ,where we will run sql star loader what is the cmd?

1 Answers   Cap Gemini, KPMG,

---

what is the need of registering table in apps?

5 Answers   TCS,

---

How many types of projects are there in project module?

6 Answers   Fujitsu, Tech Mahindra,

---

what are the difference between 11.5.7 and 11.5.9 in oracle apps

4 Answers  

---

what are the important table names in purchasing?

3 Answers   TCS,

---

in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?

2 Answers   Oracle, Schneider,

---

How will you get the concurrent program output as email?

3 Answers   IBM, KPIT,

---

Which modules of oracle apps have forms and reports? I am a beginner in oracle apps so kindly answer my query.

3 Answers  

---

what are the prerequisite set ups for inter organization transaction?

1 Answers   Scan Steel,

---

How to make Parameter as Mandatory?

2 Answers  

---