Search Results writexmlvalues_rtf

Overview

APPS.PAY_NL_XDO_REPORT is a PL/SQL package that belongs to the Oracle Payroll (PAY) product family and specifically supports the Dutch (NL) localization. Its name reflects its role in the Oracle E-Business Suite XML Publisher (XDO) reporting architecture: it assembles, converts, and writes report output in the XML-family formats used for the Netherlands statutory and regulatory payroll reports. The package is classified as OTHER within ETRM and is owned by APPS. It functions primarily as a report-generation utility, transforming XML content into CLOB and BLOB representations so that generated documents can be stored in the database, retrieved as LOBs, or delivered as file output.

The user lookup for "fetch_pdf_blob" points to the LOB-handling concern that this package addresses: producing and managing binary large object output suitable for downstream rendering, including PDF and RTF processors, from an XML source.

Key Procedures and Functions

The package exposes six documented procedures and functions, each oriented around XML and LOB handling:

• WRITETOCLOB — Writes the contents of an XML file as a CLOB, returning the result as a BLOB output parameter. This is the core conversion routine for XML report content.
• WRITETOCLOB_RTF — A variant that builds XML content compatible with an RTF processor.
• CLOB_TO_BLOB — Converts an XML file currently held as a CLOB into a BLOB, enabling binary storage or transfer.
• WRITETOXML — Writes the XML to a file for debugging purposes, keyed by request ID and returning an output file name.
• WRITETOXML_RTF — The RTF-compatible counterpart to WRITETOXML, supporting XML generation for an RTF processor.
• WRITEXMLVALUES_RTF — Writes XML values in support of the RTF build path.

The package also declares a record type (XMLRec) holding a TagName and TagValue pair, and a collection type (tXMLTable) indexed by BINARY_INTEGER, used to hold XML tags and their values as content is assembled.

Tables Accessed

ETRM lists the following objects referenced through APPS synonyms: UTL_FILE, FND_LOBS, PER_GB_XDO_TEMPLATES, DBMS_LOB, PLITBLM, UTL_RAW, and V$PARAMETER. FND_LOBS is the standard EBS repository for XML Publisher and other LOB output, and is the natural destination for the BLOB content produced by WRITETOCLOB and CLOB_TO_BLOB. PER_GB_XDO_TEMPLATES holds the XML Publisher template definitions used to render the Dutch reports. DBMS_LOB and UTL_RAW supply LOB manipulation and raw conversion, while UTL_FILE supports the debugging file output of WRITETOXML. PLITBLM and V$PARAMETER provide supporting PL/SQL and instance-parameter access.

Usage Notes

The package is invoked in the context of Dutch payroll report generation, typically from concurrent programs and XML Publisher data templates that require Dutch statutory output. Report logic calls WRITETOCLOB or its RTF variant to build the XML payload, converts it to a BLOB where binary storage is needed, and relies on FND_LOBS for persistence so that the resulting document can be fetched and delivered to the user. The WRITETOXML routines are diagnostic aids and are used when debugging report generation, producing a file keyed to the concurrent request ID. ETRM records that the package is referenced by four other packages, indicating it is a shared utility within the Dutch localization rather than a standalone entry point. Customizations that extend Dutch payroll reporting should call these procedures rather than replicate LOB conversion logic, and any change to their signatures should be evaluated against the dependent packages.