Answer / siddharth

Package overloading: Packages can contain multiple iterations of procedures with the same name using different parameters. This is called 'overloading'.
Package overloading is possible in Oracle.

Example:
Identify An Overloaded PACKAGE

SELECT overload, position, argument_name, in_out, data_type
FROM all_arguments
ORDER BY overload, position;


CREATE OR REPLACE PACKAGE overload_pkgIS
PROCEDURE insby(namein VARCHAR2);
PROCEDURE insby(numbin PLS_INTEGER);
END overload_pkg;
/

Explain what are the tables of auto invoice?

0 Answers  

---

what is difference between API and Interface?

2 Answers   Infogain,

---

What is a value set? List its various types.

0 Answers  

---

how to get the on hand quantity of an item across all organizations? name the underlying tables.

2 Answers   Ranves IT Solutions, Scan Steel,

---

How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP client?

1 Answers  

---

How to print invoice from APPS(front end).if we have invoice number in hand with us???

1 Answers  

---

Do you know where we can check the status of po?

0 Answers  

---

what is the differences between internal requisition and internal sales order?

0 Answers   Accenture,

---

What is GLOBAL TEMPORARY TABLE and It's significance ?

3 Answers   KPIT,

---

what are stock locators and how to define them? name the tables where the stock locator information is stored. at least two.

3 Answers   Scan Steel,

---

what is difference between d2k report and oracle apps report

2 Answers   iFlex, TCS,

---

Hi Anil, When we importing the journals in GL module we need to insert the one row into GL_INTERFACE_CONTROL for each group_id.Now my question is what is the use of inserting the data into GL_INTERFACE_CONTROL table and if I not inserted into GL_INTERFACE_CONTROL what will happen

2 Answers   TCS,

---