Interested to Buy Any Domain ? << Click Here >> for more details...
How can u call a standard interface program from sql or
pl/sql code?
- 3 Answers
- 16379 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sushil
FND_REQUEST.SUBMIT_REQUEST (?PO?,?EXECUTABLE
NAME?,,,,PARAMETERS)
| Is This Answer Correct ? | 7 Yes | 1 No |
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.
| Is This Answer Correct ? | 3 Yes | 0 No |
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.
| Is This Answer Correct ? | 2 Yes | 3 No |
What is the autonomous transaction?give me example?
what is the difference between %_all and %_f tables
How do u customize the Reports?
Is it possible to do purchase order without requisition?
How to create multi-layout reports ? If we have 5 layouts , then how to get into the 4th one ?
Tell me where we find the status of order information?
what is the difference between oracle 8i and 9i?
How can a process be deployed in soa?
which API to return the parameters & valuesets etc
What is procedure?
What multi org tables . example - difference between app table non all table . Po_header and po_headers_all
hi friends! i need sample codes for oracle apps 11i conversion and interfaces.If u have,plz send me
2 Answers Pathway Technologies,
Oracle Apps Technical 
