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

how can i print random rows in plsql table

2497

---

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

2372

---

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2264

---

is it possible to run the interface without using oracle apps?

1978

---

What is a flexfield? List out its types.

1169

---

How can a process be deployed in soa?

1260

---

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?

1065

---

Do you know what are user profiles in apps. Any examples you can give?

1096

---

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

2104

---

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

2076

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2218

---

Can you explain the difference between architecture followed in 10g & 11g?

1065

---

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

2046

---

What is oracle soa suite?

1230

---

tell me the scenarios of the independent in reports

2625

---