1. Categories >> Software >> ERP CRM >> Oracle Apps >> Oracle Apps Technical
  2. Suggest New Category

How can u call a standard interface program from sql or
pl/sql code?

Question Posted / aditya kumar

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a purchase order without a requisition?

634

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3088

what is global tempory table?

6317

Tell me how to find the custom directory in front end?

668

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1806




What is oracle soa suite and what are its different components?

652

Can you differentiate between mediator and osb?

634

please send me forms, xml pulisher questions,answers

1661

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

1694

In oracle application how do you debug or trace errors?

643

Is soa a part of oracle fusion middleware?

613

what is pay run id ?

1712

What do you understand by a set of books?

650

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2099

How is choreography different from orchestration?

660