Answer Posted / kiran kumar

PL/SQL allows for a special subprogram declaration called a
forward declaration. It consists of the subprogram
specification in the package body terminated by a semicolon.
You can use forward declarations to do the following:
? Define subprograms in logical or alphabetical order.
? Define mutually recursive subprograms.(both calling each
other).
? Group subprograms in a package

Example of forward Declaration:

CREATE OR REPLACE PACKAGE BODY forward_pack
IS
PROCEDURE calc_rating(. . .); -- forward declaration
PROCEDURE award_bonus(. . .)
IS -- subprograms defined
BEGIN -- in alphabetical order
calc_rating(. . .);
. . .
END;

PROCEDURE calc_rating(. . .)
IS
BEGIN
. . .
END;

END forward_pack;

tell me the scenarios of the independent in reports

2059

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

1792

---

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2133

---

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

3000

---

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

1695

---

---

What is instead of trigger in where we will use?

680

---

Can we create tables in apps schema?

642

---

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

1620

---

what is pay run id ?

1714

---

What is oracle soa suite and what are its different components?

654

---

How do you register report in oracle apps?

637

---

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?

647

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2105

---

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

668

---

List the various types of value set.

629

---