Answer Posted / 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;
/

Do you know what are user profiles in apps. Any examples you can give?

654

---

Tell me how to find the custom directory in front end?

658

---

What is instead of trigger in where we will use?

674

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

627

---

Can you explain the difference between architecture followed in 10g & 11g?

652

---

---

how to print multi lay outs,muti currency,muti language in xml publisher

10717

---

Explain oracle apps architecture.

758

---

How is choreography different from orchestration?

646

---

Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

626

---

What do you understand by soa?

687

---

Tell me how to debug the report?

634

---

Are you familiar with internet architecture of oracle apps 11i?

624

---

What is count(*) from po_vendors(any table)?

637

---

Can you differentiate between mediator and osb?

621

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3074

---