Search Results valid_deal_subtype

Overview

XTR_EXP_TRANSFERS_PKG is a PL/SQL package owned by the APPS schema within the Oracle E-Business Suite Treasury (ETRM) module. It is classified under the generic "OTHER" API category rather than as a formal public API. The package serves a dual role: it provides an extensive library of validation functions for treasury exposure and deal data, and it orchestrates the transfer of deal records from the XTR_DEALS_INTERFACE staging table into the permanent exposure transaction tables. The package is defined with AUTHID CURRENT_USER, meaning that name resolution for unqualified objects is performed in the calling schema's context, so callers must ensure that the necessary synonyms and privileges are in place.

The validation functions cover the core reference data dimensions of treasury exposures: company codes, status codes, exposure types, deal subtypes, portfolios, actions, currencies, company accounts, counterparty codes, counterparty references, dealer codes, and settlement actions. Collectively, they enforce the business rules that govern whether an incoming deal record is acceptable for processing. The package is referenced by three other packages in the ETRM schema, indicating that it acts as a shared validation and transfer utility within the module.

Key Procedures and Functions

The package exposes 23 documented procedures and functions. The validation functions return BOOLEAN and generally accept one or more identifier parameters against which reference data is checked: VALID_COMPANY_CODE, VALID_STATUS_CODE, VALID_EXPOSURE_TYPE, VALID_DEAL_SUBTYPE, VALID_PORTFOLIO, VALID_ACTION, VALID_CURRENCY, VALID_COMP_ACCT, VALID_SETTLE_ACTION, VALID_CPARTY_CODE, VALID_CPARTY_REF, and VALID_DEALER_CODE. Each validates a specific attribute or combination of attributes, such as counterparty code against a company, or a counterparty reference against an account, counterparty, and currency.

The processing routines include COPY_FROM_INTERFACE_TO_EXP, which transfers a row from the deals interface record type into the exposure transaction structures and returns an error flag; INS_DEAL_DATE_AMOUNTS, which inserts date and amount components of an exposure transaction; CHECK_MANDATORY_FIELDS, which validates that required interface fields are populated; and VALIDATE_DEALS, which drives validation of an interface record. LOG_ERRORS records error details to the interface error table. Supporting functions include GET_TRANSACTION_NUMBER, GET_CPARTY_ACCOUNT, and CREATE_EXP_DEAL. Parameter lists are intentionally omitted here; reference the package specification for exact signatures.

Tables Accessed

Through APPS synonyms the package interacts with several ETRM tables. XTR_DEALS_INTERFACE is the staging source read by the interface transfer, mandatory field, and validation routines. XTR_EXPOSURE_TRANSACTIONS and XTR_EXPOSURE_TRANS_S are the target exposure tables written during transfer and deal creation. Reference tables consulted during validation include XTR_DEALER_CODES, XTR_DEAL_SUBTYPES, XTR_DEAL_TYPES, and XTR_CONFIRMATION_DETAILS, along with DUAL for scalar lookups. Error conditions are persisted to XTR_INTERFACE_ERRORS. Counterparty account resolution relies on the related ETRM counterparty structures represented in the account lookups.

Usage Notes

This package is typically invoked during treasury deal import processing, where interface records are validated and promoted into exposure transactions. It is called from the ETRM exposure and transfer forms, from concurrent programs that batch-load deal interface data, and from custom extensions that require validation of treasury deal attributes. Because it is classified as OTHER rather than a public API, Oracle does not guarantee backward compatibility of its signatures across releases. Custom code should call it with caution, prefer documented reference-table lookups where possible, and be prepared for signature changes on upgrade. Callers should also confirm that the invoking schema holds execute privilege and synonym access to the underlying tables.