Answer Posted / 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

In hierarchical structure of a database? we have write query from where we should start?

2247

---

What are do's and dont's of Interface?

2430

---

What does appl_top directory contain?

1123

---

tell me the scenarios of the independent in reports

2503

---

Do you know what is applysys in oracle application database schema, what is apps?

1179

---

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

2069

---

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

1125

---

What is a flexfield? List out its types.

1173

---

What are file in oracle.

2238

---

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

1219

---

Tell me where we find the status of order information?

1140

---

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

2378

---

what is the differences between internal requisition and internal sales order?

2661

---

What do you understand by a set of books?

1116

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2634

---