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;

What is the difference between base table and multi-org table?

3 Answers   Infosys,

---

Can you define an erp system?

0 Answers  

---

How do you register report in oracle apps?

0 Answers  

---

Can functions be overloaded ?

2 Answers  

---

how will u do documentation

2 Answers  

---

---

what are the balancing segments in AR?

0 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,

---

If the flat file is having the duplicate records in the interface how can you restrict while transferring the flat file data in to interface tables?

3 Answers   Accenture,

---

types of invoices?

7 Answers   BelAir Store, Convergys, Wings Biotech,

---

What are the Import Programs We need to run after creating Interface table for all modules

1 Answers   Accenture,

---

can we execute one concurrent program through another concurrent program?

1 Answers   KPIT,

---

What is GLOBAL TEMPORARY TABLE and It's significance ?

3 Answers   KPIT,

---