Search Results val_brokerage_code

Overview

XTR_FX_TRANSFERS_PKG is an Oracle E-Business Suite package owned by the APPS schema that supports the Treasury Management (ETRM) foreign exchange deal lifecycle. Its principal business role is the transfer of foreign exchange deals from the XTR_DEALS_INTERFACE staging table into the live XTR_DEALS and associated XTR_DEALS_S tables. The package bundles the validation, rate calculation, and mandatory-field checking logic that must be satisfied before an interface record can be promoted to a confirmed deal. The header comment indicates the source file is xtrimfxs.pls (version 120.4, dated 2005/06/29), and the package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer.

Key Procedures and Functions

The package exposes two overloaded forms of the main entry point, TRANSFER_FX_DEALS. Both accept a record of type XTR_DEALS_INTERFACE%ROWTYPE and return Boolean error flags for user, mandatory, validation, and limit failures; the second overload additionally returns the generated deal number. Supporting procedures include CHECK_MANDATORY_FIELDS, which enforces required interface columns, VALIDATE_DEALS, which applies business validation rules, CALC_RATES, which computes foreign exchange rates for the deal, and CHECK_VALIDITY, which tests overall record validity.

A set of Boolean validation functions mirrors the domain rules: VAL_DEAL_DATE and VAL_VALUE_DATE check date ordering and validity; VAL_CLIENT_CODE, VAL_CPARTY_CODE, and VAL_CPARTY_REF validate counterparty identifiers; VAL_PORTFOLIO_CODE, VAL_LIMIT_CODE, and VAL_COMP_ACCT_NO verify portfolio, limit, and company account references; VAL_CURRENCIES and VAL_BUY_SELL_CURR_COMB check currency codes and buy/sell currency pairings; and VAL_DEALER_CODE, VAL_BROKERAGE_CODE, VAL_DEAL_LINKING_CODE, and VAL_DEAL_SUBTYPE validate their respective code values. A CHECK_USER_AUTH procedure was previously declared but has been moved to xtrimddb.pls, as noted in the source comment block.

Tables Accessed

The package reads and writes XTR_DEALS_INTERFACE, the interface staging table, and XTR_DEALS and XTR_DEALS_S, the base and translated deal tables into which validated records are transferred. Configuration and lookup data are sourced from XTR_COMPANY_PARAMETERS, XTR_DEALER_CODES, XTR_DEAL_SUBTYPES, XTR_TAX_BROKERAGE_SETUP, XTR_PRICE_MODELS, and XTR_RM_MD_SETS (market data sets). XTR_DEAL_DATE_AMOUNTS and XTR_CONFIRMATION_DETAILS support date-related amounts and confirmation records, while XTR_INTERFACE_ERRORS stores validation failures surfaced during transfers. DUAL is referenced for trivial scalar queries.

Usage Notes

XTR_FX_TRANSFERS_PKG is typically invoked by concurrent programs and forms that process the FX deals interface in batch, and it is referenced by one other package in the ETRM module. In the context of the search term "p_user_deal_type," note that the parameter p_deal_type appears in the moved CHECK_USER_AUTH signature in the header comment, and user deal type distinctions are relevant to how foreign exchange deals are classified during transfer. Callers relying on user deal type should confirm whether that logic now resides in xtrimddb.pls. Because the package uses AUTHID CURRENT_USER, invoking custom code must ensure the session has appropriate EXECUTE privileges and synonym access to the referenced APPS tables.