XML Report TiPs

Metalink ID and Patch:
=======================
XML Publisher 4.5 - 3554613
XML Publisher 5.0 – 3822219
XML Publisher 5.0.1 - 4236958 (Core bug fixes)
Template Builder Plugin - 4239263 incl user guide, demos, etc
Conc Manager Integration – 3435480
Please check the associated About Documents for these patches prior to application
Check Printing Paper – Note:312353.1
Single Step Reporting Paper - Note:295409.1
Public Site

Tables:
=======
PER_GB_XDO_TEMPLATES
XDO_DS_DEFINITIONS_B
XDO_DS_DEFINITIONS_TL
XDO_DS_DEFINITIONS_VL
XDO_LOBS
XDO_TEMPLATES_B
XDO_TEMPLATES_TL
XDO_TEMPLATES_VL
XDO_TEMPLATE_FIELDS
XDO_TRANS_UNITS
XDO_TRANS_UNIT_PROPS
XDO_TRANS_UNIT_VALUES

Important: Since the latest release of XML Publisher, Applications Object Library (FND) patch 3435480 has been released to fully integrate XML Publisher with the Concurrent Manager. If you have taken this patch, you no longer have to run the XML Publisher Concurrent Request as a second step.

This Patch is in 5.5 version.

Develop xml code from plsql:
===========================
PROCEDURE do_it(errbuf OUT VARCHAR2, retcode OUT VARCHAR2) IS
CURSOR c_xml IS
SELECT SYS_XMLAGG(xmlelement( "e",
xmlforest(
e.ename as "EmployeeName",
e.sal as "Dept"
))).getCLobVal() FROM scott.emp e, scott.dept d
WHERE e.deptno = d.deptno;
l_xml CLOB;
proceed BOOLEAN;
l_curr PLS_INTEGER;
l_next PLS_INTEGER;
BEGIN
proceed := TRUE;
l_curr := 1;
l_next := 1;
OPEN c_xml();
FETCH c_xml INTO l_xml;
CLOSE c_xml;
IF proceed THEN
WHILE l_curr < dbms_lob.getlength(l_xml)
LOOP
l_next := INSTR(l_xml, ' l_next := INSTR(l_xml, '>', l_next);
Fnd_File.put_line(Fnd_File.OUTPUT, SUBSTR(l_xml, l_curr, l_next - l_curr + 1));
l_curr := l_next + 1;
END LOOP;
END IF;
Fnd_File.put_line(Fnd_File.LOG, 'XML succesfully created!');
END do_it;
/

Bold Character:
< ? if:ACCTD_AMT >1000 ? > < xsl:attribute xdofo:ctx="block" name="font-weight" > bold < / xsl:attribute >< ? end if ? >

Background Color:
< ? if:ACCTD_AMT >1000? > < xsl:attribute xdofo:ctx="block" name="background-color" >lime< / xsl:attribute >< ? end if ? >

ADD Page Total:
< ? add-page-total:pt;'ACCTD_AMT' ? >