Search Results xtr_ni_transfers_pkg




Overview
Explore in AI Chat

Overview

XTR_NI_TRANSFERS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and belonging to the Financials family of modules. It supports the Treasury/ETRM (Enterprise Treasury and Risk Management) product area, associated with the XTR application. Its principal business purpose is to transfer Non-Interest (NI) deal records from interface tables into the base XTR_DEALS structures, performing validation, mandatory field checking, currency and rate verification, and brokerage-related checks before the data is committed. The package falls under the API classification "OTHER," indicating that it is a specialized internal utility rather than a general-purpose public transactions API. Its status is VALID. It is heavily oriented toward data validation, conversion, and controlled movement of deal information into the ETRM deal repository.

Key Procedures and Functions

The package exposes a documented set of 42 procedures and functions. At the top level, TRANSFER_NI_DEALS orchestrates the transfer of non-interest deals from the interface area into the XTR_DEALS table. It is supported by CHECK_MANDATORY_FIELDS, which ensures required columns are populated, and VALIDATE_DEALS, which applies the broader rule set to an incoming deal. CALC_RATES computes applicable interest or exchange rates during the transfer process, while CHECK_VALIDITY acts as the general validity gatekeeper.

A large group of procedures perform field-specific validation: VAL_DEAL_DATE and VAL_MATURITY_DATE check date consistency and ordering, VAL_START_DATE validates the effective start date, VAL_CLIENT_CODE and VAL_CPARTY_CODE verify client and counterparty identifiers, VAL_PORTFOLIO_CODE confirms portfolio assignment, and VAL_CURRENCIES check currency pairs. Accounting and reference validations are handled by VAL_COMP_ACCT_NO (company account number), VAL_CPARTY_REF (counterparty reference), VAL_DEAL_LINKING_CODE, VAL_BROKERAGE_CODE, VAL_DEALER_CODE, VAL_DEAL_SUBTYPE, and VAL_PRODUCT_TYPE. VAL_PRICING_MODEL verifies the pricing model associated with the deal. Additional documented procedures include VAL_DEAL_DATE, VAL_PRICING_MODEL, and related checks. Each routine returns or raises errors through the package's error-handling framework.

Tables Accessed

The package reads and writes through APPS synonyms. Core deal tables include XTR_DEALS and its sequence-backed view XTR_DEALS_S, together with XTR_DEALS_INTERFACE and XTR_TRANSACTIONS_INTERFACE, which hold incoming interface data. Supporting structures include XTR_PARCEL_SPLITS, XTR_BATCHES and XTR_BATCH_EVENTS (batch orchestration), XTR_COMPANY_PARAMETERS (configuration defaults), XTR_CONFIRMATION_DETAILS, XTR_DEALER_CODES, XTR_DEAL_DATE_AMOUNTS, XTR_DEAL_SUBTYPES, XTR_EXPOSURE_TRANS_S, XTR_INTEREST_TOLERANCES, and XTR_INTERFACE_ERRORS for recording rejected rows. XTR_TAX_BROKERAGE_SETUP_V is also referenced. These tables collectively provide the deal header, validation reference data, and error logging required to transform interface records into valid treasury deals.

Usage Notes

This package is documented as referenced by XTR_IMPORT_DEAL_DATA, which indicates it is invoked as part of the deal import flow, typically behind a concurrent program or an ETRM forms action that submits non-interest deal data. It is also referenced by one other package. Developers integrating treasury deals should call the package only through supported entry points rather than invoking individual validation routines directly, because those routines assume a populated interface record and the surrounding context established by TRANSFER_NI_DEALS. When invoked as part of import, rejected or failing records are written to XTR_INTERFACE_ERRORS for later review.