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.

explain registration steps of a concurrent program.

1 Answers   TCS,

---

How will U link GL with OU in Multi-org environment.

3 Answers   Convergys,

---

what is organization id

3 Answers  

---

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

1 Answers   Cap Gemini, KPMG,

---

If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

5 Answers   Wipro,

---

Please let me know the differance between Master Item and organization Item in Inventory.

5 Answers   Wipro,

---

How to print invoice from APPS(front end).if we have invoice number in hand with us???

1 Answers  

---

IN WHICH MODULE THE LEGAL ENTITY COMES?

5 Answers  

---

Need Training & Internship with guaranteed Job in ERP - Oracle Apps Tech?

4 Answers   Zensar,

---

Explain what are the tables of auto invoice?

0 Answers  

---

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

0 Answers  

---

Difference between Bind and Lexical parameters?

3 Answers  

---