Search Results bom_common_xmlp_pkg




Overview
Explore in AI Chat

Overview

BOM_COMMON_XMLP_PKG is a package body in the APPS schema that supports the Oracle Bill of Materials (BOM) module's XML Publisher (XMLP) reporting infrastructure. Its name follows the standard convention for concurrent program report packages that have been migrated to the Oracle XML Publisher framework, where the "_XMLP_PKG" suffix identifies the PL/SQL library that backs an XML Publisher-based concurrent report within the BOM product family.

The package operates as the report-logic layer rather than as a standalone business API. In EBS 12.1.1 and 12.2.2 the BOM reports (such as bill of material and component structure listings) rely on this shared package to supply common formatting, precision, and data-preparation routines consumed across the individual XMLP report programs. The ETRM metadata classifies its API type as OTHER, confirming that it is a report-support package rather than a public transactional API, and that it is not intended to be called directly by external integrations.

Key Procedures and Functions

ETRM documents a single callable routine in this package:

  • GET_PRECISION — a utility routine that returns the display precision used when rendering numeric values in the BOM XML Publisher reports. It exists so that quantity, usage rate, and related material figures are presented consistently across the BOM report suite, matching the UOM precision defined for the reported items rather than a hardcoded format mask.

No other procedures or functions are exposed in the documented metadata. The package's own body is listed in its dependency set, indicating the routine's logic is contained inside this body.

Tables Accessed

The ETRM dependency information for this object does not record any direct table references through APPS synonyms. This is consistent with its classification as a formatting/utility layer: the resource- and item-level querying performed by the BOM XML Publisher reports is handled by the calling report packages, which pass the relevant values into BOM_COMMON_XMLP_PKG for precision formatting. No direct INSERT, UPDATE, or DELETE activity is documented against base BOM tables from within this package body.

Usage Notes

BOM_COMMON_XMLP_PKG is invoked in the context of the XML Publisher concurrent programs in the Bills of Materials module. The BOM XMLP report drivers call into this package, and the ETRM metadata records that BOM_COMMON_XMLP_PKG is referenced by 14 other packages—confirming it functions as a shared common library rather than a one-off report unit.

Its documented dependencies are limited to the APPS schema itself and the SYS.STANDARD package, and the metadata explicitly notes that BOM_COMMON_XMLP_PKG is not referenced by any other database object. From a customization standpoint, this package should be treated as Oracle-owned and read-only. Site-specific extensions should be implemented through XML Publisher templates, data definitions, or their own concurrent program wrappers, leaving the packaged body intact so that Oracle maintenance and upgrades are not blocked.