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?

1206

---

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

1976

---

Tell me where we find the status of order information?

1135

---

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

1175

---

testing tools?

2250

---

What do you understand by concurrent programs?

1097

---

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

2067

---

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

2317

---

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

1073

---

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3062

---

1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?

14959

---

What are the Standard Reports and Forms in HRMS?

2314

---

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

1116

---

how to print multi lay outs,muti currency,muti language in xml publisher

12287

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2632

---