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;

List the various types of value set.

1123

---

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

2113

---

What is a value set? List its various types.

1144

---

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

1128

---

What are the different components you should consider while defining a responsibility in oracle apps?

1126

---

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

1173

---

List the types of flexfield?

1087

---

tell me the scenarios of the independent in reports

2658

---

How is choreography different from orchestration?

1175

---

In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

3078

---

how can i print random rows in plsql table

2571

---

Plz anybody send me Technical specification for AP Interface

2617

---

What is oracle soa suite?

1299

---

What are file in oracle.

2287

---

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2158

---