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
Which oracle apps version you are very confident in?
Can you explain the difference between architecture followed in 10g & 11g?
In oracle application how do you debug or trace errors?
Can you differentiate between mediator and osb?
List the various types of value set.
What do you understand by a set of books?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
can we get profile values in report without using user exists is it possible how?
Are you familiar with internet architecture of oracle apps 11i?
How do you register report in oracle apps?
Can we create tables in apps schema?
where to define interorganization transaction charges and what are the different options?
How many schemas we have? how many you have used?
can we use look up type instead of a pofile option?or valueset?is it possible how?
how do you describe O2C along with tables