Search Results xtr_xtrtmavg_xmlp_pkg




Overview
Explore in AI Chat

Overview

XTR_XTRTMAVG_XMLP_PKG is a PL/SQL package in the APPS schema that serves as the report logic container for an Oracle E-Business Suite XML Publisher (BI Publisher) concurrent program within the Treasury (XTR) module. The package name follows the standard EBS naming convention for XML Publisher report packages: the "XMLP_PKG" suffix identifies it as the generated server-side package that supports a report registered against an XML Publisher data definition and template. The "XTRTMAVG" fragment indicates the report relates to time-averaged (average balance) computations used within Treasury deal and rate processing.

The package is documented in ETRM 12.2.2 with the owner set to APPS, an API classification of OTHER, and a status of VALID. Its structure — a package specification and body containing report-specific formula functions plus standard before/after report and parameter hooks — is characteristic of reports generated by the Oracle XML Publisher report definition utility, in which the tool lays down the data model logic and the developer supplies the SELECT statement and any supporting formula columns.

Key Procedures and Functions

ETRM documents twelve procedures and functions in this package. They fall into three functional groups.

  • Formula functions: WAVG_RATE1FORMULA and WAVG_RATEFORMULA compute weighted average rate values for display or grouping in the report output; AVG_AMOUNT1FORMULA and AVG_AMOUNTFORMULA compute average amount values. CF_SET_PARAFORMULA handles a report-level parameter formula (the "CF" prefix denotes a column/formula reference), and CP_PARA_P is the corresponding parameter procedure.
  • Report lifecycle triggers: BEFOREREPORT and AFTERREPORT execute at the start and end of report execution respectively; these are the standard XML Publisher package entry points used to initialize state and to perform clean-up or finalization.
  • Parameter form hooks: BEFOREPFORM and AFTERPFORM run before and after the concurrent program's parameter form is presented, allowing defaults and validation to be applied to report parameters.
  • Data-fetch procedures: WAVG_RATE_P and AVG_AMOUNT_P are the procedures that drive the underlying queries for the weighted average rate and average amount sections of the report.

No parameter signatures are published in the ETRM excerpt; consumers should treat these as internal report components rather than a public API.

Tables Accessed

The package references three tables through APPS synonyms:

  • FND_CONCURRENT_REQUESTS — the standard concurrent request table, used to obtain run-time context such as the request ID and the parameters supplied by the user when the report is submitted.
  • FND_NEW_MESSAGES — the application message repository, used for retrieving translatable message text displayed in the report output or raised as errors.
  • DUAL — used for scalar evaluations and simple date or parameter arithmetic within the report logic.

Usage Notes

This package is invoked by the Oracle XML Publisher framework when the associated Treasury weighted-average report concurrent program is run. It is not intended to be called directly from forms or custom code. The dependency listing shows that the package is referenced only by itself, confirming that no other EBS package depends on it.

Because the package is generated and owned by APPS, any customization should be applied through the XML Publisher data definition and template rather than by editing the package body, which may be regenerated by the report definition utility. Behavior is broadly consistent between EBS 12.1.1 and 12.2.2, though 12.2.x deployments should verify the Online Patching editioning setup for the APPS schema.