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

Are there any alternate tools other than sql* loader to load data into oracle apps tables from external systems

5 Answers   Deloitte, IBM,

---

what is pl/sql table and pl/sql records? what is the use of that?

3 Answers   Intelligroup,

---

Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers   iGate,

---

what are the important table names in purchasing?

3 Answers   TCS,

---

35—how to create ldt lct files? 36—how to tranfor on file from one instance to another instance?

2 Answers   Accenture,

---

Can we run a package with out specification?If yes how?

4 Answers  

---

what is difference between po_headers_all and po_headers

2 Answers   NTT Data,

---

What is SET-OF-BOOKS?

3 Answers  

---

The Task is that to register a Form into Oracle Apps on a particular responsiblity. - First i moved the FMX & FMB file into the custom_top through FTP - Using Application Developer i registered the Form through Form menu then Function then Menu..... as we do regularly.. - When i get into the particular responsiblity i can see the Form name getting listed. But when i click that to open..... i cant able to see the form. I need any one your help in advicing me...what would be the problem.

7 Answers   SGS,

---

How can we import the data into a database using sql * loader?

0 Answers  

---

IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?

7 Answers   Accenture,

---

what is organization id

2 Answers   Wipro,

---