Delete Script for XML Reports

Delete Script for XML Publisher

begin
delete from XDO_TEMPLATES_B       where template_code    = 'ERPC_TEST' ;
delete from XDO_TEMPLATES_TL      where template_code    = 'ERPC_TEST' ;
delete from XDO_LOBS              where lob_code         = 'ERPC_TEST' ;
delete from XDO_DS_DEFINITIONS_TL where data_source_code = 'ERPC_TEST' ;
delete from XDO_DS_DEFINITIONS_b  where data_source_code = 'ERPC_TEST' ;
end;

LDT File for XML Publisher

FNDLOAD apps/$CLIENT_APPS_PWD O Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XX_CUSTOM_DD.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME="XXCUST" DATA_SOURCE_CODE="XX_SOURCE_CODE" TMPL_APP_SHORT_NAME="XXCUST" TEMPLATE_CODE="XX_SOURCE_CODE"