Search Results tp_function1
Overview
AR_XML_VIEW_FUNCTIONS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Receivables (AR) module and is classified under the ETRM object registry as an OTHER-type API rather than a public concurrent or interface API. Its documented status is VALID, and it contains both a package specification and a package body.
The package exists to support the XML-based invoice presentation layer in Receivables. Specifically, it supplies the row-level function bodies consumed by the AR_XML_* database views that assemble e-invoice, print, and remittance XML payloads. Rather than querying tables directly, each view calls a function in this package to derive a single formatted or computed column value. In this sense AR_XML_VIEW_FUNCTIONS acts as the computational engine behind the XML invoice views, isolating the formatting logic from the view definitions and centralizing it for reuse and maintenance.
Key Procedures and Functions
The ETRM metadata documents 270 procedures and functions in this package. The listed entries follow a systematic naming pattern of HEADER_FUNCTION1 through HEADER_FUNCTION20 and beyond. These are the scalar value-returning functions referenced by the XML invoice views. Each HEADER_FUNCTIONn returns one discrete piece of header-level XML content for an invoice, such as the invoice number, invoice date, currency code, customer billing details, or remit-to information, formatted for direct inclusion in the generated XML document.
The full set of 270 subprograms continues this convention across additional view families, providing functions that supply line-level, tax, payment-terms, purchase-order, and sales-order values. The numbered naming sequence allows the AR_XML_INVOICE_V and companion views to map one column to one function without ambiguity. No parameter signatures are published in the ETRM documentation, and the object is not designated as a supported public API; the functions should be treated as internal implementation details of the XML view tier.
Tables Accessed
The ETRM metadata does not enumerate any base tables directly referenced by AR_XML_VIEW_FUNCTIONS. Its only documented dependency is the SYS.STANDARD package, which provides the PL/SQL language primitives available to every package body. Table access, where it occurs, is therefore executed indirectly, either through other APPS packages or through the calling views themselves.
The metadata records that AR_XML_VIEW_FUNCTIONS is referenced by nine other packages and by the following nine views: AR_XML_INVOICE_CHARGE_V, AR_XML_INVOICE_LINE_V, AR_XML_INVOICE_REMIT_TO_V, AR_XML_INVOICE_TAX_V, AR_XML_INVOICE_TP_V, AR_XML_INVOICE_V, AR_XML_PAYMENT_TERMS_V, AR_XML_PO_INFO_V, and AR_XML_SO_INFO_V. These views are the effective consumers of the underlying Receivables data; the package functions transform that data into XML-ready values.
Usage Notes
In normal operation AR_XML_VIEW_FUNCTIONS is invoked implicitly. When an XML invoice document is generated, whether through the Receivables e-invoice, billing, or print pipelines, the AR_XML_* views are queried and each function executes to populate a header, line, tax, or remittance element. Direct invocation from a concurrent program is not a documented use case.
Because the object is classified as OTHER rather than a public API and its parameter lists are not published, custom code should not call these functions directly. Extension or customization should instead be directed at the view tier or at the supported Receivables APIs. Any modification to this package risks breaking all nine dependent views and their consumers, so changes are best confined to Oracle-supplied patches. Developers diagnosing XML invoice content issues can use the dependency map above to trace an incorrect element back through the relevant AR_XML_* view to the responsible HEADER_FUNCTIONn.