Search Results a_comp

Overview

XTR_WRAPPER_API_P is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and validated in release 12.1.1 and 12.2.2. It resides within the Treasury (XTR) application, the module that manages foreign exchange, money market, and cash management instruments. The package name indicates its architectural role: it is a wrapper or façade layer that exposes a unified internal API surface for treasury operations that other treasury and cash management components call. Rather than embedding logic in each downstream program, the wrapper centralizes common routines for bank account verification, reconciliation, balance upload, settlement validation, zero-balance account (ZBA) handling, rate derivation, and the generation of intergroup (IG) and interaccount (IAC) transfers.

The package is tightly integrated with Oracle Cash Management (CE), as evidenced by the fact that CE_AUTO_BANK_CLEAR1, CE_AUTO_BANK_IMPORT, and CE_LEVELING_UTILS all reference it. It also serves as a shared dependency for XTR_IAC_TRANSFERS_PKG and XTR_IG_TRANSFERS_PKG, and it references itself, indicating internal recursive or layered calls among its own procedures.

Key Procedures and Functions

The ETRM metadata documents sixteen procedures and functions, classified generically as OTHER (not a public API set). Their purposes are evident from their names:

• XTR_WRAPPER_API — the primary entry point, dispatching wrapper-level treasury operations.
• BANK_ACCOUNT_VERIFICATION and ZBA_BANK_ACCOUNT_VERIFICATION — validate bank accounts, including zero-balance account constructs, against treasury configuration.
• RECONCILIATION — supports bank statement reconciliation processing.
• BANK_BALANCE_UPLOAD — loads bank balance data into treasury balance tables.
• SETTLEMENT_VALIDATION and SET_IAC_VALIDATE_SETTLE — enforce settlement rules for transfers.
• FIND_SPECIFIC_GLOBAL_RATE and DERIVE_LATEST_TRAN — locate exchange/interest rates and derive the most recent transaction data.
• CHK_ZBA_IG_DUPLICATE and CHK_ZBA_IAC_DUPLICATE — detect duplicate intergroup and interaccount transfer records for ZBA accounts.
• IG_ZBA_CL_DEFAULT — supplies default values for intergroup ZBA clearing.
• IG_GENERATION and IAC_GENERATION — create intergroup and interaccount transfer records.
• A_COMP — an internal comparison or computation helper.

No parameter signatures are published in the documentation; the descriptions above reflect documented naming only.

Tables Accessed

The package reads and writes treasury core tables through APPS synonyms. Bank account and balance data flows through XTR_BANK_ACCOUNTS and XTR_BANK_BALANCES, while cash concentration logic uses CE_CASHPOOLS and CE_CASHPOOL_SUB_ACCTS together with XTR_CASHPOOL_ATTRIBUTES. Transfer generation and validation touch XTR_INTERACCT_TRANSFERS and XTR_INTERGROUP_TRANSFERS, and batch processing uses XTR_BATCHES, XTR_BATCH_EVENTS, and XTR_DEALS_INTERFACE. Deal and date-based amounts are held in XTR_DEAL_DATE_AMOUNTS and its sequence view XTR_DEAL_DATE_AMOUNTS_S. Accrual and amortization data resides in XTR_ACCRLS_AMORT, while counterparty exposure is governed by XTR_COUNTERPARTY_LIMITS and XTR_LIMIT_TYPES.

Usage Notes

XTR_WRAPPER_API_P is an internal technical package rather than a customer-facing API. It is principally invoked by Cash Management concurrent programs (automatic bank import and clearing) and by the treasury transfer packages XTR_IAC_TRANSFERS_PKG and XTR_IG_TRANSFERS_PKG, which are themselves driven by concurrent programs and treasury forms. Customizations should avoid calling it directly because its signature set is undocumented and subject to change; instead, use supported CE or XTR public APIs. Diagnosing failures typically requires inspecting the dependency chain upward through CE_AUTO_BANK_CLEAR1, CE_AUTO_BANK_IMPORT, CE_LEVELING_UTILS, and the two transfer packages, since errors surfaced in those callers frequently originate in this wrapper's validation or generation routines.