Answer / kiran kumar

FlexRpt The execution file is wrnitten using the
FlexReport API.

FlexSql The execution file is written using the FlexSql API.

Host The execution file is a host script.

Oracle Reports The execution file is an Oracle Reports file.

PL/SQL Stored Procedure The execution file is a stored
procedure.

SQL*Loader The execution file is a SQL script.

SQL*Plus The execution file is a SQL*Plus script.

SQL*Report The execution file is a SQL*Report script.

Spawned The execution file is a C or Pro*C program.

Immediate The execution file is a program written to
run as a subroutine of the concurrent manager. We recommend
against defining new immediate concurrent programs, and
suggest you use either a PL/SQL Stored Procedure or a
Spawned C Program instead.



Composite Datatypes :
? PL/SQL TABLES
? PL/SQL RECORDS
- Nested TABLE
- VARRAY

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

2 Answers  

---

What is multi org?

6 Answers   Accenture, CTS,

---

name at least five reports in oracle inventory related to transaction ?

3 Answers   Scan Steel,

---

How we will receive the work from the client? what type of documents we will develop in the entire implementation project? plz tell me the total scinario?

2 Answers   Deloitte, Intelligroup,

---

what type of testing u r doing?

2 Answers   Convergys,

---

I want to develop a oracle applications report using report builder 6i. I have two user parameters. How to provide list of values to parameters, which should show me at the time of submitting concurrent program.

1 Answers   Genpact, Y3K Imaginations,

---

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

0 Answers  

---

i have 3 parameters like p1,p2,p3.In p1 i have 2 parameters like a,b.if pass parameter 'a' p2 should be enable and p3 should be disable then if pass parameter 'b' the vice versa.

1 Answers   IBM, Sierra Atlantica,

---

How many typres of Purchase order and what are those.

2 Answers   Accenture,

---

why r u move in the cus_top only why not move another top

4 Answers   Wipro,

---

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)

4 Answers  

---

sourcing in GL

1 Answers   Convergys,

---