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
- 16349 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 |
HOW CAN YOU KNOW UPDATE STMT IS WORKED OR NOT IN PL/SQL?
What do you understand by soa and what are the benefits of using this architecture?
what is the error you will get if field is referenced in wrong repeating frame?
How does accounting occured in Expense Reporting?
How will u register concurrent request ?
IN WHICH MODULE THE LEGAL ENTITY COMES?
What is Value Set?
in reports token is casesensitive or not?
what are the different calculation columns available in reports?
what is MRC? Why it is needed?
hi friends! i need sample codes for oracle apps 11i conversion and interfaces.If u have,plz send me
2 Answers Pathway Technologies,
Where we can write a PL/SQL code in report triggers?
Oracle Apps Technical 
