Search Results po_xml_utils_grp




Overview
Explore in AI Chat

Overview

PO_XML_UTILS_GRP is a utility package body in the APPS schema that supports Oracle Purchasing's XML messaging and document delivery infrastructure. Its API classification of "GRP" indicates it is a group or helper package rather than a formal public API, and it is not referenced by any other database object, confirming its role as an internal support layer consumed by the Purchasing XML and workflow components. The package assembles, validates, and dispatches XML payloads for procurement documents, resolves attachment and terms-and-conditions content, and supplies tax and global agreement information required for outbound supplier communications. It reaches into PO_COMMUNICATION_PVT, WF_CORE, WF_EVENT, and ECX_ATTACHMENT, integrating document generation with Oracle Workflow event processing and the e-commerce attachment subsystem.

Key Procedures and Functions

The package exposes twelve documented procedures and functions, each addressing a discrete XML assembly or lookup concern:

  • GETATTACHMENT — retrieves attachment content associated with a purchasing document for inclusion in the XML message.
  • GETATTACHMENTFILE — resolves the physical file representation of an attachment.
  • GETATTACHMENTURL — returns the URL reference for an attachment so recipient systems can locate the source document.
  • SPLITFORIDS — parses a delimited identifier string into its component IDs, a common requirement for multi-document XML requests.
  • GETBLANKETPONUMBER — obtains the blanket purchase agreement number associated with a release or referenced document.
  • GETTANDC — returns terms and conditions text for standard document output.
  • GETTANDCFORXML — returns terms and conditions content formatted specifically for XML payload embedding.
  • REGENANDSEND — regenerates an XML document and re-transmits it, used for resend and recovery scenarios.
  • GETGLOBALAGREEMENTINFO — gathers global agreement attributes needed when communicating enterprise-wide procurement terms.
  • GETTAXDETAILS — retrieves line-level tax detail for XML generation.
  • GETTAXINFO — returns tax information at the document level from the tax code repository.
  • GETUSERENVLANG — resolves the user's environment language, driving correct localization of generated output.

Tables Accessed

The package reads purchasing document structures through APPS synonyms: PO_HEADERS_ALL and PO_LINES_ALL for current header and line data, PO_RELEASES_ALL for release information against blanket agreements, and the archive tables PO_LINES_ARCHIVE_ALL and PO_LINE_LOCATIONS_ARCHIVE_ALL for historical document versions. Tax content is sourced from AP_TAX_CODES_ALL. Attachment and text handling relies on FND_DOCUMENTS_VL, FND_DOCUMENTS_SHORT_TEXT, FND_DOCUMENTS_LONG_TEXT, and ECX_ATTACHMENT. WF_PARAMETER_LIST_T and PO_WF_ITEMKEY_S supply workflow parameter and item key values, while DBMS_LOB, UTL_FILE, DUAL, and PLITBLM provide LOB manipulation, file I/O, and PL/SQL utility support. Global values are obtained via FND_GLOBAL.

Usage Notes

PO_XML_UTILS_GRP is invoked internally by the Purchasing XML generation and delivery flow rather than called directly from Oracle Forms. Its procedures are typically reached from PO_COMMUNICATION_PVT operations, Oracle Workflow notification and event functions, the Purchasing document approval and dispatch process, and concurrent programs that generate or resend supplier-facing XML such as purchase orders, releases, and blankets. Custom extensions should treat the package as subordinate to PO_COMMUNICATION_PVT and PO_XML_* delivery logic, because REGENANDSEND and the attachment resolvers depend on workflow item keys and communication records established upstream. Because the package is not referenced by other database objects, direct custom invocation is possible but should be limited to diagnostic or recovery use, and any extension must preserve the expectations of the Workflow and e-commerce attachment layers it serves.