Answer / mukesh rathi

Package is a named anonymus block.
It is collection of varible, procedure,function.
There is need of package specification and body and there
name should be same for creating package.
We can also declare global,local procedure function within
the package.
Due to the use of package the performace improved because
it directly interact with the memory location avilable to
the package.

Answer / kiran kumar

---- Group logically related pl/sql types, items and
subprograms.
1) package specification
2) package body
Advantages of a package:

? Modularity
? Easier Application Design
? Information Hiding
? Overloading

What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter

12 Answers   TCS,

---

Is soa a part of oracle fusion middleware?

0 Answers  

---

Can u define DFF with in the DFF,How?

1 Answers   Satyam,

---

what is difference between po_headers_all and po_headers

5 Answers   Deloitte, Wipro,

---

what is meant by Table space?

2 Answers  

---

what is difference between procedure and function

5 Answers   E Logic,

---

FLEX FIELDS?

2 Answers  

---

LOCKS?

1 Answers  

---

Give a brief overview on OrderManagement.

1 Answers   Zensar,

---

What is GLOBAL TEMPORARY TABLE and It's significance ?

3 Answers   KPIT,

---

How to link between inventory and OrderManagement.

1 Answers   Zensar,

---

what is tuning in oracle apps technical

3 Answers   TCS,

---