Search Results xtr_settlement_summary_p




Overview
Explore in AI Chat

Overview

The APPS.XTR_SETTLEMENT_SUMMARY_P package body forms part of the Oracle E-Business Suite Treasury (ETRM) module, which manages cash management, deal management, and settlement processing for financial instruments such as foreign exchange contracts, money market deals, and loans. The package encapsulates the business logic used to create, maintain, and remove settlement summary records that aggregate the settlement obligations arising from Treasury deals. Settlement summaries provide a consolidated view of amounts due or receivable on a given value date, enabling treasury users to manage liquidity, netting, and payment instructions efficiently.

The package body is documented as VALID in the APPS schema and is classified as an "OTHER" API, indicating it is not a formal public open-interface API but is intended for internal consumption by ETRM forms and concurrent programs. Its procedures operate against the XTR_SETTLEMENT_SUMMARY entity and its supporting date-amount table, ensuring that settlement aggregates remain synchronized with the underlying deal records.

Key Procedures and Functions

The package body exposes four documented procedures and functions that together implement the settlement summary lifecycle:

  • INS_SETTLEMENT_SUMMARY — Inserts a new settlement summary record, typically invoked when a Treasury deal is confirmed or when a new settlement date aggregation is required. It populates the summary table with the relevant deal, counterparty, date, and amount attributes.
  • UPD_SETTLEMENT_SUMMARY — Updates existing settlement summary records, recalculating or modifying amounts when underlying deal data changes, such as amendments to value dates or settlement amounts.
  • DEL_SETTLEMENT_SUMMARY — Deletes settlement summary records, supporting cleanup when deals are cancelled, reversed, or when summaries are regenerated.
  • INCLUDE_SETTLEMENT_GROUP — Associates a deal or deal component with a settlement group, enabling grouping of multiple settlements for netting or consolidated payment processing.

These procedures collectively support the procedural maintenance of settlement data and are designed to be called in sequence to preserve data integrity of the summary entity.

Tables Accessed

The package body references several ETRM tables and objects via APPS synonyms:

  • XTR_SETTLEMENT_SUMMARY — The primary table holding settlement summary records, providing the target for insert, update, and delete operations.
  • XTR_SETTLEMENT_SUMMARY_S — The sequence used to generate unique primary keys for new settlement summary records.
  • XTR_DEAL_DATE_AMOUNTS — A supporting table containing date-based amount details for deals, used as a source for computing or validating settlement amounts.
  • DUAL — The standard Oracle single-row dummy table, used for simple computations or sequence retrievals.
  • STANDARD — The PL/SQL standard package supplying built-in functions and exceptions.

Usage Notes

The package is typically invoked from ETRM settlement and deal-entry forms, and from concurrent programs that process and regenerate settlement summaries in batch. It is referenced by two other packages, indicating its role as a shared internal utility within the Treasury module. Because it is classified as an "OTHER" API and is not referenced by any external database object in the documented dependency listing, customizations should call it cautiously, relying on the same invocation patterns used by standard ETRM forms and programs. Direct modification of the underlying settlement summary tables is discouraged; instead, the procedures in this package should be used to preserve the integrity of settlement aggregates.