Search Results update_iac_cashpool

Overview

XTR_CASHPOOL_UTLS is an Oracle E-Business Suite (EBS) PL/SQL utility package owned by the APPS schema and delivered as part of the Treasury / ETRM (Enterprise Treasury and Risk Management) module. Its declared header includes the AUTHID CURRENT_USER clause, meaning the package executes with the privileges of the invoker rather than the definer, which is consistent with an internal utility layer that is called from within an already-privileged ETRM session. The package encapsulates the create, update, and delete logic for cash pool records held in the XTR_CASHPOOL_ATTRIBUTES entity, together with the persistence and defaulting of the Instrument Group (IG) and Investment Administration Company (IAC) attributes that describe each pool. It also provides the defaulting routine used to derive portfolio, product type, rounding, and day-count values from company-level configuration. In the context of the search term p_portfolio, this package is the primary internal mechanism by which a portfolio identifier is written to a cash pool record and, conversely, resolved as a default when one is not explicitly supplied.

Key Procedures and Functions

The package exposes seven documented procedures, each addressed by a cash pool identifier and, in most cases, a party code.

• INSERT_IAC_CASHPOOL — Inserts a cash pool record carrying the Investment Administration Company perspective, capturing the IAC portfolio and IAC product type for the pool.
• INSERT_IG_CASHPOOL — Inserts a cash pool record carrying the Instrument Group perspective. This is the richest overloaded insert and includes the portfolio (the p_portfolio parameter visible in the search), product type, rounding type, day-count type, pricing model, fund limit, and invest limit, together with the corresponding party-level portfolio, product type, pricing model, and limit values.
• UPDATE_IAC_CASHPOOL — Updates an existing pool's IAC portfolio and IAC product type attributes.
• UPDATE_IG_CASHPOOL — Updates the full set of Instrument Group attributes for a pool, mirroring the column set written by INSERT_IG_CASHPOOL, including the portfolio value.
• UPDATE_IG_ROW_CASHPOOL — A narrower update that refreshes only the fund limit, invest limit, and the associated party-level portfolio, product type, pricing model, and limit values without disturbing the other IG attributes.
• DELETE_XTR_CASHPOOL — Removes a cash pool record for the supplied cash pool identifier and party code.
• DEFAULT_IAC_IG_ATTRIBUTES — Returns defaulted values for the IAC portfolio, IAC product type, portfolio, product type, rounding type, and day-count type based on a company code. This routine is the source of the portfolio default that populates p_portfolio when the user has not overridden it.

Tables Accessed

The package operates against three base objects accessed through APPS synonyms: XTR_CASHPOOL_ATTRIBUTES, which holds the active cash pool attribute rows written and updated by the insert and update procedures; XTR_CASHPOOL_ATTRIBUTES_S, the corresponding EBS sequence used to generate or validate cash pool identifiers; and XTR_PORTFOLIOS, the portfolio definition table consulted by DEFAULT_IAC_IG_ATTRIBUTES to resolve valid portfolio codes and their accounting configuration. The portfolio value passed as p_portfolio is therefore validated against XTR_PORTFOLIOS and then persisted to XTR_CASHPOOL_ATTRIBUTES.

Usage Notes

XTR_CASHPOOL_UTLS is an internal utility package rather than a public API. It is not referenced by any other documented ETRM package, which indicates it is invoked directly from the ETRM Cash Pool setup forms (the cash pool maintenance and portfolio assignment screens) and, less commonly, from custom extensions or concurrent programs that automate bulk cash pool maintenance. Invocation from custom code requires the APPS credentials or an equivalent grant, since the package is owned by APPS and executes with invoker rights. Because the insert and update entry points bypass the form-level validation layer, custom callers should perform their own validation of the portfolio code against XTR_PORTFOLIOS before passing p_portfolio, and should supply consistent IAC and IG attribute values to avoid the pools being reported differently in the Investment Administration Company and Instrument Group views.