Answer Posted / palaniraman balasubramanian

Special sub program unit declaration called forward
declaration, Consider below the example

In this pacakage, the first program unit is calling the
calc_rating but calc_rating is defined last in the package;
if we are not declared the fwd declaration then it will
raise the error While compiling this package. Package
compilation always happens top to bottom. For resolving
this compilation issue, you should declare the fwd
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;

how do you describe O2C along with tables

2832

---

what are the prerequisites for costing transactions?

3183

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2670

---

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

3518

---

What does appl_top directory contain?

1164

---

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

1128

---

List the various types of value set.

1121

---

Do you know where we can check the status of po?

1361

---

What is sca and how is it useful?

1171

---

In oracle application how do you debug or trace errors?

1175

---

what is the difference between request group and request security in oracle apps?

5974

---

List the types of flexfield?

1087

---

In sequence i want to 11 and 15th values how we will write?

2131

---

What are the benefits of using soa architecture?

1322

---

testing tools?

2299

---