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;

What are the different components of soa suite?

713

---

Is soa a part of oracle fusion middleware?

601

---

Tell me how to debug the report?

629

---

Which oracle apps version you are very confident in?

695

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2080

---

---

What are file in oracle.

1801

---

what is global tempory table?

6277

---

tell my any difficult situtation you solved in your experience in your company?

1863

---

What do you understand by concurrent programs?

613

---

What is the concept of soa governance?

760

---

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

624

---

Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

1884

---

How to move the one file from one instance to another instance? And your scripts also?

605

---

tell me the scenarios of the independent in reports

2099

---

q)what are the validations in sql*loader

1731

---