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

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

Question Posted / kiran kumar da

3 Answers
16233 Views
Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / sushil

FND_REQUEST.SUBMIT_REQUEST (?PO?,?EXECUTABLE
NAME?,,,,PARAMETERS)

Is This Answer Correct ?

7 Yes

1 No

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

Answer / eldho

We can call from both sql as well as plsql as the interface
program can be called using FND_REQUEST.SUBMIT_REQUEST
function which returns the request ID.

Make sure that we should perform a commit after the function
only then it will be applicable.

Is This Answer Correct ?

3 Yes

0 No

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

Answer / aditya kumar

Any program (whether a standard or custom ) which is
registered as a concurrent can be called by using
SUBMIT_REQUEST function available in FND_REQUEST package.

The syntax is as under

declare
v_req_id_out number;
begin
v_req_id := FND_REQUEST.SUBMIT_REQUEST
('GEMSAP','GE_AP_IND_BILL_DISCOUNT_MAILER',NULL,Null,False,
NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL);
end;

here 'GEMSAP' is the Application Short Name (Can Vary for
ur Program)
'GE_AP_IND_BILL_DISCOUNT_MAILER' is the Program Short Name
and after False there are 100 parameters to pass any value
from parameter.

Is This Answer Correct ?

2 Yes

3 No

Post New Answer

More Oracle Apps Technical Interview Questions

Is it is necessary to create P_CONC_REQUEST_ID parameter in the development of oracle apps reports

2 Answers

Give a brief overview on OrderManagement.

1 Answers Zensar,

how to change the logo in template dynamically?

2 Answers Sierra Atlantica,

WHAT IS THE USE OF SKIP WHERE U WILL GIVE?

3 Answers

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,

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

0 Answers

Form development process?

1 Answers

what is pay run id ?

0 Answers

What is profile and what is level of profile option and it's hierarchy

1 Answers IBM,

what are centralized and decentralized level of control of item attributes?

2 Answers Scan Steel,

What should be the batch size (number of customer records) general guidelines for optimal performance?

1 Answers

What are file in oracle.

0 Answers BirlaSoft, IBM,

For more Oracle Apps Technical Interview Questions Click Here