Search Results get_uda_header_xml

Overview

APPS.PO_POXPRCLM_PKG is a PL/SQL package in Oracle E-Business Suite that supports the Descriptive Flexfield (DFF) and User-Defined Attribute (UDA) infrastructure for Oracle Purchasing requisitions. The package name (POXPRCLM) suggests its role in processing requisition-related flexfield context logic. Its primary business function is to generate XML representations of UDA/DFF header and line data associated with purchase requisitions, enabling those attributes to be rendered, transferred, or consumed by downstream processes such as requisition import, approval workflows, or integration interfaces. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the defining owner, which is relevant when it is called from within form or concurrent processing sessions. The header comment references script POXPRCLMS.pls, consistent with a Purchasing-family source module.

Key Procedures and Functions

The documented interface exposes three callable units:

• GET_UDA_HEADER_XML — Accepts a requisition header identifier and returns an XMLTYPE document. It assembles the UDA/descriptive flexfield attribute values defined at the requisition header level into a structured XML payload. This function is the direct answer to the search term "get_uda_header_xml" and is the header-level counterpart to the line-level routine below.
• GET_UDA_LINES_XML — Accepts a requisition line identifier and returns an XMLTYPE document containing the UDA/DFF attribute values associated with that specific requisition line. It provides the line-granular view of the same attribute framework.
• AfterPForm — A standard Oracle Forms post-form trigger helper returning a BOOLEAN. It performs package-level initialization or context setup after the form block is populated, supporting the surrounding form that consumes the XML functions.

The package also declares public package-level variables p_req_num_from, p_req_num_to, and SEGMENT_WHERE, used to hold query-range and segment filtering criteria that the XML generation logic references internally.

Tables Accessed

The package reads from requisition and flexfield metadata tables, referenced via APPS synonyms:

• PO_REQUISITION_HEADERS_ALL and PO_REQUISITION_LINES_ALL — the base requisition header and line records that anchor the UDA context.
• PO_REQ_HEADERS_EXT_B and PO_REQ_LINES_EXT_B — the extension tables storing DFF/UDA attribute values at header and line level.
• PO_UDA_AG_TEMPLATES and PO_UDA_AG_TEMPLATE_USAGES — UDA attribute-group templates and their usages, defining which attributes apply.
• EGO_FND_DF_COL_USGS_EXT, EGO_FND_DSC_FLX_CTX_EXT, and FND_DESCR_FLEX_COLUMN_USAGES — flexfield context and column-usage metadata used to resolve segment definitions and labels.
• XMLTYPE — the return data type used to construct the XML output.

Usage Notes

PO_POXPRCLM_PKG is classified as an OTHER API and is referenced by zero other packages, indicating it is an internal, form-oriented utility rather than a shared public API. It is most likely invoked from the Oracle Purchasing requisition entry form (or a related requisition form) to build the XML needed for UDA display and processing, with AfterPForm supporting the form's post-query initialization. Custom code should call the XML functions cautiously, as they follow the CURRENT_USER privilege model and are not documented as supported extension points. The functions accept a single requisition header or line identifier and return an XMLTYPE, making them straightforward to invoke from PL/SQL wrappers or concurrent programs that need to extract requisition UDA data in XML form.