| submit concurrent request from oracle report 10g [message #468625] |
Sat, 31 July 2010 04:27  |
manisha_borade
Messages: 49
Registered: May 2010
|
Member |
|
|
hi...
i can i sumbit concurrent request in oracle report..
i wtitten a code i After report trigger...
Function AfterReport return boolean is
l_mail_reqid NUMBER;
begin
l_mail_reqid := FND_REQUEST.SUBMIT_REQUEST( 'FND',
'test_email_mt',
NULL, -- Description (Optional)
NULL, -- Start Time (Optional)
FALSE -- TRUE if this is to be child request
);
IF l_mail_reqid <> 0 THEN
COMMIT;
ELSE
srw.message('1005','Concurrent Request Submission for sending email failed!!!');
END IF;
SRW.USER_EXIT('FND SRWEXIT');
RETURN TRUE;
END;
and in before report ....
function BeforeReport return boolean is
v1 number;
begin
SRW.USER_EXIT('FND SRWINIT');
-- v1:=:P_CONC_REQUEST_ID;
return (TRUE);
end;
please help me...
its urgent
|
|
|
|
|
|
|
|
|
|
| Re: submit concurrent request from oracle report 10g [message #468831 is a reply to message #468751] |
Mon, 02 August 2010 05:05  |
manisha_borade
Messages: 49
Registered: May 2010
|
Member |
|
|
yes, ACtually i ask tht
1)can we sumbit concurrent request in oracle report.. ?
im not sure about this.... my code is not run i.e request was not be sumitted from backend
2) test_email_mt is the procedure. i create Executable and concurrent program with same name
3) is application short name is 'FND'
4)ok
5)no
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
