Search Results xtr_xtrmilns_xmlp_pkg




Overview
Explore in AI Chat

Overview

XTR_XTRMILNS_XMLP_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle ETRM (Enterprise Treasury Risk Management) product family, identified by the XTR application prefix. The suffix _XMLP_PKG and the internal naming of its procedures indicate that this is an XML Publisher (BI Publisher) report template package, commonly generated or registered in support of a concurrent program report definition.

In the Oracle EBS architecture, report packages of this type serve as the runtime support layer for concurrent programs whose output is rendered through the XML Publisher engine. They handle pre-report initialization, parameter validation, formula resolution, and post-report cleanup, ensuring that concurrent request context, report parameters, and runtime values are correctly prepared before the report data model is executed. The package holds a VALID status in both 12.1.1 and 12.2.2 environments, and its API classification is recorded as OTHER, meaning it is not a published or supported public API for external consumption.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within this package:

  • BEFOREREPORT — Executed at the start of the report lifecycle. It performs initialization work required before the report query executes, such as setting up package-level state and preparing the report environment.
  • AFTERREPORT — Executed after the report output has been produced. It performs post-processing and cleanup activities to release resources or finalize report-level state.
  • AFTERPFORM — Invoked after the parameter form (or its equivalent parameter processing phase) has completed. It allows the package to react to parameter entry before execution proceeds.
  • CP_PARA_P — The naming convention (CP = concurrent program, PARA = parameter) indicates this procedure manages concurrent program parameter handling, likely validating or deriving report parameters.
  • CF_SET_PARAFORMULA — Handles setting a parameter formula, typically used to establish dynamic or derived default values for report parameters.

No parameter lists are documented, and no assumptions should be made about the exact signatures of these routines.

Tables Accessed

The package references three tables through APPS synonyms:

  • FND_CONCURRENT_REQUESTS — The core concurrent manager table. The package reads request context here to identify the active concurrent request and its associated execution state.
  • FND_NEW_MESSAGES — The Oracle Alert notification staging table, used for message handling associated with the report run.
  • DUAL — Used for single-row expression evaluation, a common pattern in parameter formula logic.

Usage Notes

This package is not intended for direct invocation from custom code. It is invoked automatically by the concurrent manager and the XML Publisher report runtime when its associated concurrent program executes. In 12.1.1 the report is registered as a standard concurrent program with an XML template; in 12.2.2 the same behavior persists, with 12.2's Online Patching editioning views affecting the base tables but not the calling convention.

Because the compiled package body is stored in the database, customizations should be avoided; any modification risks invalidating the package and disrupting the corresponding concurrent program. There are no dependencies on other packages and no packages depend on it, confirming its role as a leaf-level report support object rather than a shared API.