Search Results round_amount

Overview

The APPS.BOM_BOMRDODP_XMLP_PKG package is a generated Oracle Reports XML Publisher (XMLP) wrapper package that supports the Oracle E-Business Suite bill of materials resource and overhead cost report — internally identified by the report short name BOMRDODP. In the Oracle EBS 12.1.1 and 12.2.2 environments, packages bearing the _XMLP_PKG suffix are produced automatically when a report definition is converted to an XML Publisher template. They supply the PL/SQL logic and bind variables that the report template exercises at runtime.

Functionally, this package underpins reporting on departmental resource and overhead charges and their associated amounts, including currency handling and numeric rounding of monetary values. Its private state variables define the runtime parameters used by the concurrent program — organization, date range, resource class, concurrent request identifier, and various resource and overhead flags — alongside precision settings and the ROUND_AMOUNT variable that governs how monetary figures are rounded before display. The package is classified in the ETRM as an OTHER object owned by APPS, and it is not referenced by any other package, confirming its role as a report-scoped utility rather than a shared library.

Key Procedures and Functions

The package exposes four documented subprograms:

• BEFOREREPORT — The standard XML Publisher before-report trigger. It executes once as the report begins, initializing parameter values and session state so that subsequent queries and formulas run against a correctly configured context.
• AFTERREPORT — The standard after-report trigger. It returns control once report generation is complete and is typically used for cleanup or finalization of report-level processing.
• SUBTITLEFORMULA — A formula function that derives the report subtitle text from a supplied currency code. It presents the currency context of the reported amounts to the reader on the report layout.
• ROUND_AMOUNTFORMULA — The formatting function directly associated with the user's search term round_amount. It accepts a rate or amount value and returns that value rounded according to the report's configured precision rules, ensuring consistent presentation of financial figures across the output. The related package-level variable ROUND_AMOUNT holds the rounding state used by the template.

No parameter lists are documented for these subprograms beyond their return types; descriptions above reflect their names, the documented signatures for the formula functions, and standard XMLP trigger behavior.

Tables Accessed

Per the documented metadata, this package references a single table through its APPS synonym: FND_CURRENCIES. This access supports the currency-aware formatting logic — most evidently the SUBTITLEFORMULA, which requires a valid currency code to compose the report subtitle. Reading from FND_CURRENCIES lets the report resolve and validate currency information rather than hard-coding it, keeping output aligned with the application's currency setup.

Usage Notes

Because the _XMLP_PKG construct is generated alongside the underlying Oracle Report, this package is invoked implicitly by the concurrent program that runs the BOMRDODP report — either from the standard Submit Requests form in Oracle EBS 12.1.1 or from the Schedule Requests / Submit Request UI in 12.2.2. Users do not call it directly. Custom code should avoid invoking it programmatically, since the generated source (last modified per the header comment in 2007) is regenerated whenever the report definition is recompiled or its XML Publisher template is redesigned; modifications made directly to the package body would be overwritten.

The noship designation in the header indicates the package is internal, not part of the shipped public API surface. Where rounding behavior must be adjusted, the supported route is configuration of the report template and its parameters rather than alteration of ROUND_AMOUNTFORMULA or the ROUND_AMOUNT variable.