Search Results upd_settlement_summary

Overview

XTR_SETTLEMENT_SUMMARY_P is the core PL/SQL package within the Oracle E-Business Suite Treasury (ETRM) module responsible for the persistence and lifecycle management of settlement summary records. Declared with AUTHID CURRENT_USER, the package executes under the privileges of the calling schema and is owned by APPS. Its stored procedures encapsulate the insert, update, delete, and group-inclusion operations that maintain the XTR_SETTLEMENT_SUMMARY entity, which represents individual settlement transactions and their association to netting or settlement groups. Settlement summaries are central to treasury processing because they aggregate deal-related cash movements by company, currency, counterparty, and settlement account, and they underpin netting, confirmation, and reconciliation workflows. The package header carries the identifier $Header: xtrsetls.pls 120.0.12010000.2 2008/08/06 10:44:38 srsampat ship $, and is internally described as containing "stored procedures/functions for settlements."

Key Procedures and Functions

The package exposes seven documented call specifications, with several overloaded variants that allow callers to identify a settlement record by different keys. The INS_SETTLEMENT_SUMMARY procedure creates a new settlement summary row, accepting settlement attributes such as settlement number, company, currency, amount, date, company and counterparty account numbers, net ID, status, audit columns, external source, and counterparty code, and returning the generated settlement identifier through an OUT NOCOPY parameter. The UPD_SETTLEMENT_SUMMARY procedure appears in three overloaded forms: one keyed by flag, netoff number, and settlement ID; a second that adds an amount parameter; and a third keyed by settlement number and amount. These variants support status transitions and amount corrections during netting and settlement processing.

The DEL_SETTLEMENT_SUMMARY procedure is likewise overloaded. One form deletes by settlement date, currency, account numbers, company code, and flag, returning a status indicator through an OUT NOCOPY parameter, while the second form deletes by settlement number and settlement amount. The INCLUDE_SETTLEMENT_GROUP procedure associates a settlement with a netting group, accepting settlement number, netoff number, company, currency, amount, date, account details, audit columns, and counterparty code. Notably, the header comments record that the counterparty code parameter was added under bug 3832387.

Tables Accessed

Through APPS synonyms, the package reads and writes XTR_SETTLEMENT_SUMMARY, the primary transactional table holding settlement records. It also references XTR_SETTLEMENT_SUMMARY_S, the corresponding sequence used to generate settlement identifiers returned by the insert procedure. The XTR_DEAL_DATE_AMOUNTS table is accessed to relate settlement amounts to underlying deal cash flows by date, supporting the aggregation logic used during settlement creation and group inclusion. DUAL is referenced for single-row selection of sequence values and simple scalar computations.

Usage Notes

XTR_SETTLEMENT_SUMMARY_P is invoked primarily from Treasury settlement and netting forms, from concurrent programs that generate or process settlements in batch, and from other ETRM packages; the ETRM metadata records that it is referenced by two other packages. Custom extensions that create or amend settlement summaries should call these documented procedures rather than performing direct DML, ensuring that sequence generation, audit columns, and group-association logic remain consistent. Because the package runs with AUTHID CURRENT_USER, callers must be granted appropriate object privileges on the underlying XTR tables. The overloaded signatures require care: callers must supply parameter combinations that match an existing specification exactly, since ambiguous argument lists can cause resolution errors at compile time.