Answer / niranjan

Procedure/function (ERRBUF OUT
RETCODE OUT
???????.)
ERRBUF :- Used to write the error message to log
or request file.
RETCODE :- Populate log request file with program
submission details info.

Answer / sreenivasula reddy.bhumireddy

errbuf----> it is used for displaing userdefined message
or system defined message
retcode----> to dispaly the status of the program whether
it is 0--normal
1-->warning
2-->error

Answer / manju

Hi All,

we can use the PL/SQL stored procedure using the parameters
(in,out,in-out)and
suppose our stored procedure register into the Oracle apps
then we will using the 2 mandatory parameters those are
(errbuf ,retcode)

Errbut : error buffer will be used to get back to the error
message.
Retcode: give the error code & compilation status.
0- successful execution .
1- success with warning.
2- Error.

Answer / ravi soma

Stored Procedure parameters are mainly 3 Types
They are IN
OUT
INOUT.

If we register the procedure in Oracle Apps as concurrent
Program then we have to pass above parameters and
additionally 2 more out parameters.

They Are-errbuf out varcher2
-retcode out Number or Varchar2

Answer / tathagat

CREATE OR REPLACE Procedure/function
<Procedure/function_NAME) (ERRBUF OUT NUMBER,RETCODE OUT
VARCHAR2 number ,PARAMETER1 IN <DATATYPE>,..,) AS
BRGIN
........;
........;
END;

ERRBUF :- Used to write the error message to log
or request file.
RETCODE :- Populate log request file with program
submission details info.

Answer / badari

Addition to above answer

Parameters will be classified as follow:

IN
OUT
IN OUT

Answer / sreenivasula reddy.bhumireddy

Diifferent select statements can be associated in a single
cursorname based on one or more tables

syn: type <typename> is refcursor --weak refcurrsor
type <typename> is refcursor with return type ---strong

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

3 Answers   Scan Steel,

when we run payment batch what are the 3 concurrent programs?

1 Answers   Genpact, Wipro,

HOW CAN U KNOW THE STAUS OF PO?

1 Answers   TCS,

how to create requst set in oracle apps and how to send muliple requests at a time,

1 Answers   Genpact,

How can u call a standard interface program from sql or pl/sql code?

3 Answers   Satyam,

What is the link between AP and GL in oracle apps R/12?

4 Answers   Bosch, Collabera, Synechron,

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

0 Answers   IBM,

How You Will display the key flexifields in your report

3 Answers   TCS,

where we will put the control file ,where we will run sql star loader what is the cmd?

1 Answers   Cap Gemini, KPMG,

If we transfer the data from legacy system to oracle base tables. I want to hold the data in interface table how?

4 Answers  

what is the invoice matching

2 Answers  

what is po approval hierarchy?

1 Answers   Cap Gemini,