How can u call a standard interface program from sql or
pl/sql code?
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
How to move the one file from one instance to another instance? And your scripts also?
Can you define an erp system?
what is the differences between internal requisition and internal sales order?
What do you understand by soa?
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
How can we import the data into a database using sql * loader?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
What are the different components you should consider while defining a responsibility in oracle apps?
Do you know what are user profiles in apps. Any examples you can give?
What are the benefits of using soa architecture?
In oracle application how do you debug or trace errors?
how do you describe O2C along with tables
What is count(*) from po_vendors(any table)?
How is choreography different from orchestration?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?