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

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

1125

---

What is instead of trigger in where we will use?

1220

---

Tell me how to find the custom directory in front end?

1155

---

Is soa a part of oracle fusion middleware?

1154

---

What do you understand by concurrent programs?

1145

---

What is a flexfield? List out its types.

1226

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3731

---

What are the Standard Reports and Forms in HRMS?

2377

---

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

1140

---

Tell me how to debug the report?

1171

---

what are the balancing segments in AR?

2149

---

what is pay run id ?

2241

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2437

---

What is count(*) from po_vendors(any table)?

1139

---

What do you understand by soa?

1193

---