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;

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

2 Answers  

---

what is the difference between oracle applications ebs 11.5.9 and 11.5.10.2 and can anyone suggest the release dates of the versions

1 Answers  

---

in one report using two layout models.if yes how to do

3 Answers   Wipro,

---

q)what are the validations in sql*loader

0 Answers   Accenture,

---

how can i print random rows in plsql table

0 Answers   Fujitsu, KPIT,

---

---

what is aim methodolozy

1 Answers  

---

In xml report, how to print the headings in every page?

1 Answers   Sierra Atlantica,

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

0 Answers   Tech Mahindra,

---

how to change the logo in template dynamically?

2 Answers   Sierra Atlantica,

---

what are the sql attributes?

2 Answers  

---

There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.

3 Answers   Satyam,

---

Tell me where we find the status of order information?

0 Answers  

---