Search Results xtr_reset_bond_rate




Overview
Explore in AI Chat

Overview

The APPS.XTR_RESET_BOND_RATE package body is a server-side PL/SQL component within the Oracle E-Business Suite Treasury (ETRM) module, catalogued under the ETRM 12.2.2 metadata with an API classification of OTHER. Its principal business function is to support the rate-reset lifecycle of bond instruments managed in ETRM. Bonds and similar debt instruments frequently carry variable or floating coupons whose rate must be re-established at each reset date, based on a benchmark, index, or contractual spread. This package provides the programmatic logic required to recalculate and reapply coupon rates on outstanding bond deals, to propagate those changes into coupon schedule and allocation records, and to validate the underlying transaction state before any modification is committed.

The package is documented as VALID in the APPS schema and depends on standard EBS infrastructure utilities including FND_MESSAGE, FND_FILE, FND_GLOBAL, FND_DATE, and APP_EXCEPTION, indicating that it produces user-facing messages, handles date conversion, and supports concurrent-program style output and logging. It is not referenced by any other database object, which identifies it as an entry-point package rather than a shared library routine.

Key Procedures and Functions

Five documented procedures constitute the public surface of the package:

  • RESET_BOND_BENCHMARK_RATE — Re-establishes the benchmark or reference rate associated with a bond so that subsequent coupon calculations reflect the current market or contractual index value.
  • VALIDATE_TRANSACTION — Performs pre-processing validation of the bond transaction, confirming that the deal and instrument are in a state that permits a rate reset.
  • UPDATE_COUPON_DETAILS — Applies revised coupon attributes to the coupon schedule records generated for the bond.
  • UPDATE_COUPON_AMOUNT — Recomputes and updates the monetary coupon amount payable for the relevant period once the rate has been reset.
  • UPDATE_BOND_DETAILS — Propagates the reset outcome back to the primary bond issue record, keeping the instrument header consistent with the revised coupon terms.

Parameter lists are not published in the available metadata and should be confirmed against the package specification in the target instance.

Tables Accessed

The package reads and writes the following ETRM base tables through APPS synonyms:

It additionally references the view XTR_MASTER_CURRENCIES_V.

Usage Notes

XTR_RESET_BOND_RATE is typically invoked from the ETRM bond maintenance forms or from a concurrent program scheduled to process rate resets at defined reset dates. Because it is unreferenced by other packages, it should be treated as a top-level API: customizations should call it directly and stage inputs in the ETRM base tables rather than extending it. Its reliance on FND_MESSAGE and FND_FILE suggests results and errors are surfaced through the standard EBS message stack and concurrent log. Testing should be performed against a cloned instance, as the update procedures commit changes to live bond and coupon records.