Search Results calc_hce_amts

Overview

XTR_FPS1_P is a Financial Products Suite (FPS) calculation library within Oracle E-Business Treasury (ETRM), owned by the APPS schema. It is a non-API, internally consumed package body whose primary responsibility is to centralize the financial mathematics behind bond pricing, option valuation, tax and brokerage derivation, counterparty and static data validation, and advisory letter defaulting. In releases 12.1.1 and 12.2.2 the package is invoked from ETRM transaction entry forms and supporting concurrent processes whenever a deal requires pricing, tax computation, or reference-data validation. Because it encapsulates formula logic, it isolates calculation rules from the user interface and allows the same routines to be reused by neighboring packages — the metadata notes it is referenced by six other packages. The package contains fifteen documented procedures and functions spanning advice defaulting, bond and option pricing, tax/brokerage computation, and a suite of code validation routines.

Key Procedures and Functions

The documented routines group into four functional clusters:

• ADVICE_LETTERS — Defaults counterparty and client advice-letter indicators from product, party, and client-level setup. It resolves the effective advice flag by cascading from XTR_PRODUCT_TYPES defaults to party-specific overrides held in the party info view, returning N when no party or client is supplied.
• Pricing routines — CAL_BOND_PRICE computes clean (cum) and dirty (ex) bond prices from remaining coupons, annual yield, settlement-to-next-coupon days, and yield volatility; CALC_OPTION_PRICE derives the theoretical value of an option instrument.
• Tax and brokerage routines — CALC_TAX_BROKERAGE and CALC_TAX_AMOUNT compute the tax and brokerage charges applicable to a transaction; GET_TAX_SETTLE_METHOD returns the settlement method for a given tax; GET_TAX_ROUND_FACTOR supplies the rounding factor applied to tax amounts.
• Validation routines — CHK_CCY_CODE, CHK_CLIENT_CODE, CHK_COMPANY_CODE, CHK_CPARTY_ACCOUNT, CHK_CPARTY_CODE, CHK_CPARTY_LIMIT, CHK_DEALER_CODE, and CHK_DEAL_STATUS verify that currency, client, company, counterparty account, counterparty, counterparty limit, dealer, and deal status values are valid before a deal is saved or posted.

Tables Accessed

The package reads and writes setup and transaction data through APPS synonyms. Pricing and tax routines consume XTR_PRODUCT_TYPES, XTR_TAX_BROKERAGE_RATES, XTR_TAX_BROKERAGE_SETUP, XTR_TAX_DEDUCTION_CALCS, and XTR_DEDUCTION_CALCS, which hold the rate, setup, and calculated deduction values required to derive charges. XTR_CUM_DIST_CALCS supports accrued-interest and distribution calculations used by CAL_BOND_PRICE. Validation routines reference FND_CURRENCIES, XTR_MASTER_CURRENCIES, XTR_COMPANY_AUTHORITIES, XTR_COUNTERPARTY_LIMITS, XTR_CPARTY_ACCOUNT data, XTR_DEALER_CODES, and XTR_BANK_ACCOUNTS. XTR_PRODUCT_TYPES is also used by ADVICE_LETTERS to obtain product-level advice defaults, supplemented by the party info view for counterparty and client overrides.

Usage Notes

XTR_FPS1_P is an internal calculation utility rather than a published integration API. It is typically invoked by ETRM deal-entry forms and validation logic during transaction capture, and by concurrent programs that recompute pricing, tax, or brokerage positions in batch. The CHK_* routines are commonly called from form-level WHEN-VALIDATE-ITEM triggers and pre-save validations, while the pricing and tax routines are called before posting or accounting generation. Because six other packages reference it, changes to its behavior can propagate across the ETRM calculation chain; customizations should avoid modifying shipped logic and should instead route through supported extension points or wrap the package. The package is not classified as an open API, so direct calls from external systems are discouraged.