Search Results p_attr_group_col_list

Overview

PO_XML_FPDSNG_PKG (source file PODTFPDS.pls) is an Oracle E-Business Suite PL/SQL package owned by APPS and declared with AUTHID CURRENT_USER. It supports the generation of Federal Procurement Data System (FPDS) related XML payloads and supporting data extracts for purchasing documents. The package exposes utility functions for resolving location identifiers, producing XMLTYPE and CLOB structures for UDA (User Defined Attribute) header content, contacts, and addresses in both live and draft modes, and computing ordered amounts at the header, line, and option-excluded levels. In the context of Oracle EBS 12.1.1 and 12.2.2, it is typically invoked during XML document construction and FPDS/data reporting flows where purchasing header, draft, vendor, and descriptive flexfield information must be serialized into structured XML or CLOB output. The user search term "get_drafts_contactsxml" corresponds directly to one of the package's documented functions, indicating interest in draft-specific contact XML retrieval.

Key Procedures and Functions

The package exposes fourteen documented functions. They can be grouped by purpose:

• GET_LOCATION_ID and GET_LOCATION_NAME — resolve a location identifier and its display name from an operating unit or organization context.
• GET_UDA_HEADER_XML and GET_UDA_HEADER_DRAFTS_XML — return XMLTYPE representations of UDA header data, for live documents and for draft documents respectively.
• GET_CONTACTSXML and GET_DRAFTS_CONTACTSXML — return CLOB contact XML for a document and for a draft document (the function named in the user search).
• GET_ADDRESSXML and GET_DRAFTS_ADDRESSXML — return CLOB address XML for a document and for a draft document.
• GET_HEADER_AMOUNT_ORDERED, GET_LINE_AMOUNT_ORDERED, GET_WITHOUT_OPT_AMOUNT_ORDERED — compute ordered monetary amounts at header, line, and option-excluded aggregation levels.
• GET_VENDOR_ADDRESS_DETAILS and GET_VENDOR_CONTACT_DETAILS — return CLOB vendor address and vendor contact detail content tied to a UDA template and header/draft context.
• GET_ISSUING_OFF_LOC_CODE — returns the issuing office location code for a header or draft.

The package also declares several package-level variables and a private constant (P_ATTR_GROUP_COL_LIST) used to hold attribute group column definitions and session context values such as HEADERID, draft id, car id, and document modification flags.

Tables Accessed

The package reads from the following documented objects via APPS synonyms:

• PO_HEADERS_ALL and PO_HEADERS_ALL_EXT_B — purchasing document headers and their extension (UDA/draft) data, providing the primary document context.
• PO_UDA_AG_TEMPLATES and PO_UDA_AG_TEMPLATE_USAGES — UDA attribute group template definitions and their usages, used to shape the attribute XML.
• EGO_FND_DF_COL_USGS_EXT and EGO_FND_DSC_FLX_CTX_EXT — extended descriptive flexfield column usage and context metadata that drive attribute serialization.
• FND_DESCR_FLEX_COLUMN_USAGES — standard flexfield column usage definitions.
• XMLTYPE and DBMS_LOB — Oracle supplied types/packages used to construct and manipulate XML and CLOB data.
• DUAL — used for single-row utility selections.

Usage Notes

PO_XML_FPDSNG_PKG is normally called from FPDS/XML document generation logic rather than directly by end users. It is invoked during purchasing document XML construction (including draft documents) and reporting flows touching UDA header content, contacts, addresses, vendor details, and ordered amount totals. Custom code or concurrent programs that build FPDS-style payloads may call GET_DRAFTS_CONTACTSXML and related functions directly. The package operates under AUTHID CURRENT_USER, so the executing schema must hold appropriate privileges on the APPS synonyms referenced. Because procedures are not documented as returning ref cursors or DML operations, the package should be treated as a read-oriented XML/CLOB generation utility for purchasing header and draft data.