FND_REQUEST.SUBMIT_REQUEST('XDO','XDOREPPB'
I am making changes in the Audit Trail Report, our requirement is to generate this report in Excel. I have created the template in word attache the template with the report, changed the output type of the report to "XML".
I have written an sql package and calling it in the After Report trigger in the FNDATREP.rdf report ,
v_req_id := trk_xmlp_pkg.do_submit('SHAWFNDATREP',:P_conc_request_id);
Package is,
CREATE OR REPLACE package body APPS.TRK_XMLP_PKG ASfunction do_submit( p_code in varchar2, p_request_id in number) return number