Answer / sushil

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

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.

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.

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

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

---

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

0 Answers  

---

what are the tables of auto invoice.

2 Answers  

---

Define multi org structure with example(take any businees).

1 Answers   Oracle, Wipro,

---

35—how to create ldt lct files? 36—how to tranfor on file from one instance to another instance?

2 Answers   Accenture,

---

---

Can you have two stored functions with in the same name?

3 Answers  

---

IN WHICH MODULE THE LEGAL ENTITY COMES?

5 Answers  

---

difference between 2 way and 4 way matching

3 Answers   Convergys, TCS,

---

In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers  

---

Tell me where we find the status of order information?

0 Answers  

---

Steps for DFF registration

2 Answers   IBM, Savvis, Wipro,

---

Name the different Cursor Attributes.

2 Answers   Satyam,

---