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
16211 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

difference b/w procedures&functions

2 Answers Oracle, TCS,

HOW U DISPLAY THE FLEXFIELD DATA IN APPS?

2 Answers

Can function be overload?

4 Answers

What are the User PARAMETERS in the Reports?

6 Answers Accenture, CTS,

Is it possible to do purchase order without requisition?

8 Answers

What is multoorg and what is it's level or structure

4 Answers IBM,

in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?

2 Answers Cap Gemini,

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

0 Answers

why do we go for oracle apps technical other than sap and other packages?

2 Answers

What is the difference between BPA AND Contract.

1 Answers Accenture,

what is the difference between varchar and varchar(2)?

4 Answers

How to migrate .rdf file from dev instance to test instance?

3 Answers Accenture, Oracle, TCS, Tech Mahindra, Unisoft Infotech,

For more Oracle Apps Technical Interview Questions Click Here