Search Results batch_id_p

Overview

APPS.XTR_XTRCCYGL_XMLP_PKG is the package body that supports the Oracle E-Business Suite Treasury (ETRM) concurrent program "XTRCCYGL" — the Currency Gain/Loss report. The package follows the standard Oracle Reports XML Publisher (XMLP) integration pattern used throughout EBS 12.1.1 and 12.2.2, in which a report definition invokes a database package to validate parameters, resolve lookup and descriptive values, and expose formatted result columns to the report layout. Its primary business role is to report realized and unrealized foreign-exchange gain or loss positions on treasury deals, revaluation details, and rollover transactions, with amounts expressed in a user-selected reporting currency and unit scale.

The package is registered under the APPS schema and classified as an "OTHER" API. It is a report-support package rather than a public application programming interface; it is not referenced by any other package in the E-Business Suite.

Key Procedures and Functions

The user search term batch_id_p corresponds to the batch identifier parameter that drives selection of treasury batch data in the report. In this package, the batch context is resolved through the XTR_BATCHES and XTR_BATCH_EVENTS tables, and the parameter is consumed by the report's SQL query and by formatting formulas.

The package exposes vehicle functions (which Oracle Reports calls during execution) and formula functions (which return formatted strings for display). Documented entry points include:

• AFTERPFORM — Executes after the parameter form is submitted. It resolves the reporting unit factor from the XTR_FACTOR lookup, translates the realized flag and deal type from XTR_MISC, XTR_HEDGE_MISC, XTR_DEAL_TYPES, and XTR_MISC lookups, and populates user-friendly parameter values such as P_USER_FACTOR, P_USER_DEAL_TYPE, and P_USER_GROUPBY.
• BEFOREREPORT / AFTERREPORT — Standard report lifecycle triggers used for pre-query initialization and post-execution cleanup.
• C_DATEFORMATFORMULA, CO_SHT_NAMEFORMULA, C_REPORT_NAMEFORMULA — Layout formulas supplying date masks, company sheet names, and report titles.
• USER_DEAL_TYPEFORMULA, USER_DEAL_SUBTYPEFORMULA — Return the descriptive deal type and subtype from XTR_DEAL_TYPES and XTR_DEAL_SUBTYPES.
• FAIR_VALUEFORMULA, FAIR_VALUE_RNDFORMULA — Present fair-value amounts in the selected currency and factor.
• BEGIN_RATEFORMULA, END_RATEFORMULA — Display period-beginning and period-ending exchange rates on revaluation rows.
• GAIN_LOSS_RNDFORMULA, BASE_AMT_RNDFORMULA, SOB_CCYFORMULA, REPORT_PRDFORMULA — Round and format gain/loss amounts, base amounts, set-of-books currency, and period identifiers.

Tables Accessed

All tables are referenced through APPS synonyms. XTR_BATCHES and XTR_BATCH_EVENTS provide the batch header and event detail rows addressed by the batch_id_p parameter. XTR_DEALS, XTR_DEAL_TYPES, and XTR_DEAL_SUBTYPES supply deal-level attributes and descriptive names. XTR_PARTY_INFO resolves counterparty information. XTR_REVALUATION_DETAILS and XTR_ROLLOVER_TRANSACTIONS deliver the revaluation and rollover amounts, rates, and base-currency values that are the report's core figures. FND_LOOKUPS supplies lookup meanings for the XTR_FACTOR, XTR_MISC, and XTR_HEDGE_MISC lookup types. FND_CONCURRENT_REQUESTS and FND_NEW_MESSAGES support concurrent-program context and message retrieval.

Usage Notes

The package is invoked automatically when a user runs the Currency Gain/Loss concurrent program from the ETRM responsibility. Parameters such as batch_id_p are entered on the concurrent program's parameter form; AFTERPFORM executes after submission to translate codes into descriptive values, and the remaining formula functions are called by the Oracle Reports/XML Publisher layout at runtime. Direct invocation from custom PL/SQL is not supported, as this is a private report package. Because the metadata is limited, developers tracing parameter behavior should confirm exact signatures against the deployed package source in APPS.