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.

Oder of firing triggers in form

7 Answers   Oracle, Zensar,

---

what is pick selection list generation report.

3 Answers  

---

List the various types of value set.

0 Answers  

---

What are ad-hoc reports?

1 Answers  

---

what is Flex mode and Confine mode?

2 Answers   Rapidigm,

---

---

can we get profile values in report without using user exists is it possible how?

0 Answers   Cap Gemini,

---

While running the concurrent program we will get the status, we have to change the status. How it will be done.

2 Answers   Zensar,

---

how many groups we can create for query?

3 Answers  

---

In Per_all_people_f table what is the significance of '_f ' ?

6 Answers   HCL,

---

what do u mean by debit/credit memo invoices?

3 Answers   ACC, Convergys, Mascon,

---

What does appl_top directory contain?

0 Answers  

---

where the accounting related data is stored ? all type of accounting related data costing etc...

3 Answers  

---