Answer Posted / 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 a value set? List its various types.

1095

---

Can you explain the difference between architecture followed in 10g & 11g?

1058

---

How can you achieve loose coupling in soa framework?

1214

---

What does appl_top directory contain?

1117

---

What is instead of trigger in where we will use?

1164

---

Are you familiar with internet architecture of oracle apps 11i?

1058

---

what are the balancing segments in AR?

2090

---

List the various types of value set.

1076

---

What are file in oracle.

2225

---

How can a process be deployed in soa?

1245

---

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

2121

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1113

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3056

---

How to create a purchase order without a requisition?

1188

---

tell my any difficult situtation you solved in your experience in your company?

2315

---