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.

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

2 Answers   Accenture,

---

What is the interface?

3 Answers  

---

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

6 Answers   HCL,

---

where is setup of business group done?

2 Answers   TCS,

---

Cycle of requestion to receving transaction.

1 Answers   Accenture,

---

---

what is the difference between procedure and function

4 Answers  

---

how many sections are there in report?

1 Answers  

---

While registering the concurrent program we first do the executable concurrent program and then define it . So why we need to give the application name twice in executable and as well as definitions

3 Answers   IBM,

---

If we transfer the data from legacy system to oracle base tables. I want to hold the data in interface table how?

4 Answers  

---

what is the differences between internal requisition and internal sales order?

0 Answers   Accenture,

---

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

0 Answers   IBM,

---

WHAT IS THE FORWARDREFERENCE IN PL/SQL?

4 Answers   IBM,

---