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;

Steps for DFF registration

2 Answers   IBM, Savvis, Wipro,

---

What is the use of format trigger?

4 Answers   Cap Gemini, IBM,

---

I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????

4 Answers   Satyam,

---

how to find the custom directory in front end.

1 Answers   IBM, Sierra Atlantica,

---

What is the difference between buyer&employee in PO module?

7 Answers   TCS,

---

What are the requests groups?

3 Answers  

---

We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?

3 Answers   IBM,

---

What is FORWARD DECLARATION in Packages?

6 Answers   British Telecom BT, HCL, Tech Mahindra,

---

how to customize the report,please tell me customization steps

5 Answers   Accenture,

---

What is oracle soa suite?

0 Answers  

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

0 Answers   Tech Mahindra,

---

P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?

9 Answers   CSC, IBM, KPIT, Oracle,

---