Answer / abhi choudary

procedure may or may not return a value, but function must return a value.
procedure can not be used in select statement but function can use except one situation whenever select stmt contains dml operation thats time not possible to use

Answer / raghu

procedure may or may not return a value.
function return a value
procedure will be storeed in db as a compiled object
but funtion will be stored as text what we written

what is trace file? what is the use of that?

4 Answers  

---

Explain the multi-organization structure.

1 Answers   Accenture,

---

WHAT IS USE OF APPS API?

3 Answers  

---

What and Who is the best Institute or Trainer for Oracle Apps Technical ?

2 Answers  

---

A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.

0 Answers   Accenture,

---

types of invoices?

7 Answers   BelAir Store, Convergys, Wings Biotech,

---

in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?

1 Answers   KPMG,

---

Can u attach Request set with in the Request set?

2 Answers   Satyam,

---

sourcing in GL

1 Answers   Convergys,

---

Oder of firing triggers in form

7 Answers   Oracle, Zensar,

---

what are the steps to develop a new report?

7 Answers   Infotech, Satyam,

---

we have clients in different countries, we can run report in different places, if i want to display particular language,country,currency everything displays for that country how?

1 Answers  

---