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

Answer / raghav

PL/SQL does not allow forward references. You must declare a variable or constant before referencing it in other statements, including other declarative statements.

Answer / ranjith

The above answer is for "Forward Declaration" and not
for "Forward Reference".

Sorry for the confusion.

Answer / veera

declaring the procedures or functions in the package
specification before using them in package body.

in ap_terms table what data will be stored

1 Answers  

---

What is the difference between BPA AND Contract.

1 Answers   Accenture,

---

P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?

9 Answers   CSC, IBM, KPIT, Oracle,

---

what is the defference between credit memo and debit memo

3 Answers   Wipro,

---

What is Formula Column?

4 Answers  

---

how to create a file in forms?

3 Answers   Wipro,

---

in GL module specifing org_id or not?

1 Answers  

---

Difference between set of books id and ledger id in r12 ?

1 Answers   TCS,

---

what is the difference between credit memo and debit memo?...

2 Answers   Sony,

---

What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?

2 Answers   TCS,

---

AOL?

4 Answers  

---

In interface how u find errors and how to solve. How to fix it?

3 Answers  

---