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.

Which one Module is Biggest Module in oracle apps?

3 Answers   Questam,

---

what are the steps to develop a new report?

7 Answers   Infotech, Satyam,

---

In interface process we have 1000 records i want to commit every 100 records how? How i can commit every 100 records?

2 Answers  

---

while registering executable and concurent program we register both with application name|<oracle purchasing>? so my question is why we are defining in both concurent program and executable?

9 Answers  

---

How many schemas we have? how many you have used?

0 Answers  

---

what is inbound and outbound interface?

2 Answers  

---

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

0 Answers  

---

What are Mandatory triggers to write in the block, which is created on view?

5 Answers   Oracle,

---

In xml report, how to print the headings in every page?

1 Answers   Sierra Atlantica,

---

in ap_terms table what data will be stored

1 Answers  

---

Can function be overload?

4 Answers  

---

How can a process be deployed in soa?

0 Answers  

---