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;

Can u give the Documentation of Custom.pll in oracle apps

0 Answers  

---

do i need to declare bind parameter before using in the query?

2 Answers   Satyam,

---

What are the validations you don in .CTL file in inbound interface process?

1 Answers  

---

what is the difference between request group and request security in oracle apps?

1 Answers  

---

What is the most critical part which you had faced in your project ?

1 Answers   LG, Satyam, Tech Mahindra,

---

what is latest version in reports

8 Answers  

---

How will u register concurrent request ?

1 Answers   Convergys,

---

what are the receipt types in Po?

2 Answers   Evosys, UST,

---

wheather discard file is automatically created or explicty created?can u mention it?

1 Answers   CTS,

---

What are the files you have used in the part of Conversion and Interfaces?

2 Answers   Tech Mahindra,

---

q)what are the validations in sql*loader

0 Answers   Accenture,

---

what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference

4 Answers   IBM,

---