Search Results round_amountformula

Overview

The package body APPS.BOM_BOMRDODP_XMLP_PKG is the PL/SQL implementation unit behind the XML Publisher (BI Publisher) concurrent program associated with the Bill of Materials routing and department report, identified internally by the executable short name pattern BOMRDODP. In Oracle EBS 12.1.1 and 12.2.2, reports that were migrated to the XML Publisher reporting engine are generated through a companion PL/SQL package that supplies runtime data to the report template. The _XMLP_PKG naming convention is the standard Oracle E-Business Suite artifact used to wrap the SQL query, bind parameters, and formatting logic for such reports. The body is owned by the APPS schema and is documented with a VALID status, meaning the compiled code is present and usable in the database.

Functionally, this package drives the extraction and presentation of bill of materials and routing/department information, producing the result set consumed by the XML Publisher layout. It handles session initialization, report-level aggregations, and display formatting such as currency handling and numeric rounding before the data is rendered.

Key Procedures and Functions

The ETRM metadata documents four procedures and functions associated with this package, all of which are standard XML Publisher report-package entry points:

• BEFOREREPORT — Executed prior to the main report query. It is responsible for initializing report-level context, such as resolving session and organization settings and setting bind variables that the report query depends upon.
• AFTERREPORT — Executed after the main report query completes. It performs post-processing or cleanup tasks required once the result set has been produced.
• SUBTITLEFORMULA — A formatting formula that computes the report subtitle text, typically incorporating parameters such as organization or date context for the report header.
• ROUND_AMOUNTFORMULA — A formatting formula that rounds monetary or quantity amounts to the required precision before display in the report output.

Tables Accessed

The documented table reference for this package is FND_CURRENCIES, accessed through an APPS synonym. This is consistent with the presence of the ROUND_AMOUNTFORMULA procedure: currency precision information is retrieved from FND_CURRENCIES so that amounts can be rounded correctly according to the currency in use. The metadata also indicates the package references FND_GLOBAL (for session and user context), GL_SETS_OF_BOOKS (for ledger and currency configuration), and ORG_ORGANIZATION_DEFINITIONS (for operating unit and organization context). The package is not referenced by any other database object.

Usage Notes

This package is invoked indirectly rather than by direct application calls. It is executed by the XML Publisher concurrent program engine when the associated BOM routing/department report is submitted from the Submit Requests form or from the Oracle EBS application menus. Report parameters entered by the user are bound at runtime and passed into the query and formatting logic defined in this package body.

Because BOM_BOMRDODP_XMLP_PKG is not referenced by any other database object, it should be regarded as a report-specific implementation unit. Customizations should be limited to the associated XML Publisher data template and RTF layout rather than modifying the package body, since direct edits can be overwritten during patching or upgrade. When troubleshooting report output, this package is a relevant inspection point for initialization errors, currency rounding behavior, and subtitle formatting in releases 12.1.1 and 12.2.2.