Answer Posted / ranjith

If a stored procedure(Function or Procedure) need to be
called inside another stored procedure in the same package
then the called procedure should be declared before the
calling procedure. This declartion is called Forward
Reference.

Example:

CREATE OR REPLACE PACKAGE BODY pkg_FR_Test
.
.
Begin
prc_FR_Procedure(p_P1 NUMBER, p_P2 VARCHAR2);--> FR
.
.
prc_Call_Procedure(p_Param1 NUMBER)
BEGIN
.
.
prc_FR_Procedure(20, 'Account');
.
.
END prc_FR_Procedure;
END

Tell me where we find the status of order information?

914

---

testing tools?

1963

---

how can i print random rows in plsql table

2137

---

Explain oracle apps architecture.

1001

---

What is a value set? List its various types.

849

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2151

---

What do you understand by soa?

894

---

Can u give the Documentation of Custom.pll in oracle apps

3223

---

How can a process be deployed in soa?

894

---

What do you understand by concurrent programs?

800

---

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

1804

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1968

---

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

822

---

What is oracle soa suite?

970

---

what is global tempory table?

6748

---