Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Answers were Sorted based on User's Feedback



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

Answer / sushil

FND_REQUEST.SUBMIT_REQUEST (?PO?,?EXECUTABLE
NAME?,,,,PARAMETERS)

Is This Answer Correct ?    5 Yes 1 No

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

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

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

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

Post New Answer



More Oracle Apps Technical Interview Questions

Can u define exceptions twice in same block?

3 Answers  


what is multi org structure?

3 Answers   Covansys, TCS,


how to find the custom directory in front end.

1 Answers   IBM, Sierra Atlantica,


is it possible to run the interface without using oracle apps?

0 Answers  


What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?

2 Answers   TCS,






please send me forms, xml pulisher questions,answers

0 Answers   Zensar,


how i can create temporary table?

1 Answers   Zensar,


What are the Standard Reports and Forms in HRMS?

0 Answers  


What is multoorg and what is it's level or structure

4 Answers   IBM,


Do you know what is applysys in oracle application database schema, what is apps?

0 Answers  


where to define interorganization transaction charges and what are the different options?

0 Answers   Scan Steel,


Tell me where we find the status of order information?

0 Answers  






Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (791)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)