Search Results z1issued_buy_all




Overview
Explore in AI Chat

Overview

XTR_XTRDISRE_XMLP_PKG is the generated package body that supports the Oracle E-Business Suite (EBS) XML Publisher (BI Publisher) concurrent program report XTRDISRE, part of the Treasury (ETRM / XTR) module. The suffix "_XMLP_PKG" identifies it as the PL/SQL wrapper that Oracle Reports or the Oracle EBS report definition produces when a report is migrated to XML Publisher. The package is owned by APPS and classified as OTHER, meaning it is not a public API; it exists to satisfy report runtime requirements rather than to expose reusable business logic.

The report it backs is a Treasury disbursement register, as reflected in the header comment identifier "XTRDISREB.pls." Its core purpose is to build and format the data and session-level context required to render the Treasury disbursement report through the XML Publisher engine. The package handles report header values (such as the company name), report-level factors and amounts, language descriptions for report labels, and the "before report" logic that primes global variables used by the report layout or data model. It is invoked automatically by the concurrent manager when the XTRDISRE concurrent program is submitted, not by user code.

Key Procedures and Functions

  • CF_SET_PARAFORMULA — A format-trigger style function that retrieves the current database user (truncated to ten characters) from DUAL into the package variable CP_PARA and returns it. This supplies a parameter/default value to the report at runtime.
  • BEFOREREPORT — The main pre-report initialization function. It sets the company name session title using CEP_STANDARD.GET_WINDOW_SESSION_TITLE, handles lookup-based factor descriptions and amount multipliers from XTR_FACTOR lookups, populates a quantity of report label text from the XTR_SYS_LANGUAGES_VL view for the module 'XTRDISRE', and assigns language strings to report variables such as Z1ACCEPTOR, Z1AND, Z1COMPANY_CODE, Z1CPARTY_CODE, Z1ISSUED_BUY_ALL, and Z1MATURITIES_BETWEEN. It also raises an application error when the window session title lookup fails.
  • AFTERPFORM — Post-parameter-form processing logic that runs after the report parameter form is accepted, used to finalize parameter handling before report execution.
  • AFTERREPORT — Post-report cleanup/termination logic executed after report output is produced.
  • CP_PARA_P — A package-level procedure/variable used to manage the CP_PARA parameter value established by CF_SET_PARAFORMULA.

Tables Accessed

  • FND_CONCURRENT_REQUESTS — The standard concurrent request table, referenced for report submission context such as the request or parameter context.
  • FND_NEW_MESSAGES — Used to hold the message text type variable (L_MESSAGE) and to surface localized error messages via FND_MESSAGE when report initialization fails.
  • DUAL — Used to derive the current user value in CF_SET_PARAFORMULA.

Although the excerpt also references FND_LOOKUPS, XTR_SYS_LANGUAGES_VL, and CEP_STANDARD, those are used for lookup descriptions, language labels, and window title retrieval respectively rather than being counted among the primary documented tables for this object.

Usage Notes

This package is not intended for direct invocation. It is called by the Oracle EBS report/concurrent program framework when the XTRDISRE XML Publisher report is run from the Treasury responsibility (Requests window or a scheduled concurrent request). Customizations should not call its internal functions directly; instead, use supported Treasury APIs or the seeded report parameters. Because it is tagged OTHER and carries an old header revision (120.1, 2007), it is a stable, report-scoped artifact. Any modification risks breaking the associated concurrent program output. No other packages are documented as referencing it.