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;

how to avoid duplicate data while uploading data from flatfile to staging table? some validations

5 Answers   Amdocs,

---

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?

2 Answers   Cap Gemini,

---

Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that?

3 Answers   Oracle,

---

what is instead of trigger in where u will use?

2 Answers   TCS,

---

WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?

4 Answers  

---

Except the SRS window in which we can submit the concurrent program.

5 Answers   IBM, TCS,

---

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

1 Answers   CTS,

---

Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports

2 Answers  

---

How to write the no data found in XML Publiser Report in apps?

2 Answers   UST,

---

what is organization id

2 Answers   Wipro,

---

Define MultiOrg Structure

5 Answers   Convergys,

---

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

0 Answers  

---