Search Results valid_deal_linking_code
Overview
XTR_IG_TRANSFERS_PKG is an APPS-owned PL/SQL package within the Oracle E-Business Suite Treasury (ETRM) module. Its principal business function is to manage intergroup transfers — the movement of financial exposure, cash positions, or deals between distinct legal entities or groups within a corporate treasury structure. In Oracle Treasury, intergroup transfers allow a parent or central treasury entity to record and settle cross-entity obligations while preserving the applicable accounting and currency relationships.
The package supports the ingestion of intergroup transfer data from an open interface, validation of that data against treasury master and reference data, calculation of monetary and home-currency-equivalent (HCE) amounts, and the propagation of validated records into the base intergroup transfer tables. In Oracle EBS 12.1.1 and 12.2.2 it is a VALID database object and is classified as an API of type OTHER, meaning it is not a formally published public API but is invoked internally by ETRM programs and, in some implementations, by custom extensions.
Key Procedures and Functions
The package exposes 34 documented procedures and functions, which fall into three broad categories.
- Validation routines: VALID_CPARTY_CODE, VALID_TRANSFER_DATE, VALID_CURRENCY, VALID_COMP_ACCT, VALID_PARTY_ACCT, VALID_ACTION, VALID_PRODUCT, VALID_PORTFOLIO, VALID_LIMIT_CODE, VALID_PRINCIPAL_ADJUST, VALID_DEAL_LINKING_CODE, VALID_DEALER_CODE, VALID_COMP_REPORTING_CCY, and VALID_IG_ACCT each verify a specific attribute of an intergroup transfer against the corresponding treasury reference data — counterparties, currencies, accounts, products, portfolios, limit codes, dealer codes, and reporting currencies. They enforce referential and business-rule integrity before data is committed.
- Processing and calculation routines: COPY_FROM_INTERFACE_TO_IG moves staged records from the interface into the intergroup transfer tables. CALC_DETAILS, CALC_HCE_AMTS, and CALCULATE_VALUES compute transfer amounts, including home-currency-equivalent values using the master currency view. CHECK_MANDATORY_FIELDS confirms that all required attributes are populated. LOG_IG_ERRORS records validation or processing failures to the interface error table.
- Supporting logic: the remaining functions perform ancillary rule evaluation used by the validation and calculation paths.
Tables Accessed
The package operates against a defined set of APPS synonyms, notably: XTR_INTERGROUP_TRANSFERS and XTR_DEALS_INTERFACE (the primary interface and destination tables for transfer records); XTR_DEALS_S and XTR_DEAL_DATE_AMOUNTS (deal header and dated amount data); XTR_ACCRLS_AMORT (accruals and amortization); XTR_AMOUNT_ACTIONS, XTR_DEALER_CODES, XTR_PARTY_INFO, XTR_BANK_ACCOUNTS, XTR_PRICE_MODELS, and XTR_MASTER_CURRENCIES_V (reference and master data used for validation and currency conversion); XTR_IG_JOURNAL_STRUCTURES and XTR_IG_JOURNAL_STRUCTURES_S (accounting journal generation for intergroup transfers); XTR_BATCHES and XTR_BATCH_EVENTS (batch processing control); and XTR_INTERFACE_ERRORS (error logging). It is additionally referenced by XTR_IMPORT_DEAL_DATA and XTR_WRAPPER_API_P.
Usage Notes
XTR_IG_TRANSFERS_PKG is typically invoked indirectly. The primary entry point is the deal import or intergroup transfer import flow, where a concurrent program or the wrapper API XTR_WRAPPER_API_P calls the package to validate and load staged interface records. Validation routines may also be called from Treasury forms during manual entry to provide immediate field-level checks. Custom code should invoke the package only with full awareness that it is an OTHER-classified API without documented parameter contracts; Oracle does not guarantee signature stability across patches. Customers upgrading between 12.1.1 and 12.2.2 should re-validate any custom dependencies, since underlying reference tables and journal structures may change.