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 ?    7 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

What is SET-OF-BOOKS?

3 Answers  


how to set org context?

3 Answers  


what do you mean by value sets

8 Answers   Convergys,


in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me

4 Answers   CTS, iGate,


What is responsibility?

5 Answers  


in GL module specifing org_id or not?

1 Answers  


HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT

2 Answers  


differentiate between intra & inter UOM class conversion with examples.

1 Answers   Scan Steel,


What is request group

4 Answers   Accenture,


Are there any alternate tools other than sql* loader to load data into oracle apps tables from external systems

5 Answers   Deloitte, IBM,


sourcing in GL

1 Answers   Convergys,


The Task is that to register a Form into Oracle Apps on a particular responsiblity. - First i moved the FMX & FMB file into the custom_top through FTP - Using Application Developer i registered the Form through Form menu then Function then Menu..... as we do regularly.. - When i get into the particular responsiblity i can see the Form name getting listed. But when i click that to open..... i cant able to see the form. I need any one your help in advicing me...what would be the problem.

7 Answers   SGS,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • 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)