Search Results compute_irr

Overview

OKL_PRICING_UTILS_PVT is a private PL/SQL utility package in the Oracle E-Business Suite (EBS) Lease and Finance Management (Oracle Lease Management, OKL) application, owned by the APPS schema. Its API classification of PVT indicates that it is an internal helper package, not a public interface; it exposes no supported external API surface and is intended to be called only by other OKL packages within the pricing and quoting subsystem.

The package provides the common calculation and data-retrieval primitives that the pricing engine relies upon: interest rate computations, day-count and day-convention logic, cash-flow generation and retrieval, lease rate factor lookup, standard rate retrieval, and the pricing routines for quick quotes, standard quotes, and lease quotes. In effect, it centralizes the financial mathematics used across the OKL quoting and pricing modules so that yield, IRR, and cash-flow behavior remain consistent between all calling programs.

Key Procedures and Functions

The package contains 23 documented procedures and functions. They fall into several functional groupings.

• Quote and header retrieval: GET_SO_HDR, GET_QQ_FIN_ADJ_DETAILS, GET_QQ_ASSET_OEC, GET_QQ_SGT_DAY_CONVENTION produce header-level, financial-adjustment, asset-OEC (original equipment cost), and day-convention data for quick quotes.
• Cash flow handling: GET_QQ_CASH_FLOWS, GET_LQ_CASH_FLOWS, and GEN_SO_CF_STRMS retrieve or generate the cash-flow streams attached to quick quotes, lease quotes, and standard quote streams. GET_LEASE_RATE_FACTORS, GET_STANDARD_RATES, and PRICE_QUICK_QUOTE, PRICE_STANDARD_QUOTE_ASSET drive rate-factor and standard-rate evaluation and quote pricing.
• Day-count and convention: GET_DAY_COUNT, GET_DAY_CONVENTION, and GET_DAYS_PER_ANNUM return the day-count basis, day-convention rule, and days-per-annum value used in interest and yield calculations.
• Yield and return measures: COMPUTE_IRR, COMPUTE_IIR, COMPUTE_IIR_SFP, and COMPUTE_BK_YIELD calculate internal rates of return, implicit interest rates (including the SFP variant), and book yield.
• Supporting logic: IS_ASSET_OVERRIDING and DISTRIBUTE_FIN_AMOUNT_LQ test whether an asset overrides pricing and distribute financial amounts for lease quotes respectively.

Parameter lists are not documented in the metadata and should be obtained from the package specification in the target instance.

Tables Accessed

The package reads and writes pricing and quoting data through APPS synonyms. Rate and template definition data is supplied by OKL_FE_RATE_SET_VERSIONS_V, OKL_FE_STD_RT_TMP_V, OKL_FE_STD_RT_TMP_VERS, OKL_FE_STD_RT_TMP_ALL_B, OKL_FE_RATE_SET_LEVELS, OKL_LS_RT_FCTR_SETS_V, OKL_FE_EO_TERMS_ALL_B, and OKL_FE_EO_TERM_VERS. Cash-flow results are held in OKL_CASH_FLOWS, OKL_CASH_FLOW_LEVELS, and OKL_CASH_FLOW_OBJECTS. Asset and component information comes from OKL_ASSETS_B, OKL_ASSET_COMPONENTS_B, and OKL_AE_TMPT_SETS. Pricing adjustments and fees are drawn from OKL_COST_ADJUSTMENTS_B and OKL_FEES_B. FND_CURRENCIES supplies currency attributes, while FND_LOG_MESSAGES and the FND_API and OKL_API packages support the standard EBS API error-handling and message-logging model.

Usage Notes

Because the package is classified PVT, it is not intended to be invoked directly from forms, concurrent programs, or customer-written code. It is referenced by ten documented packages, including OKL_PRICING_PVT, OKL_LEASE_QUOTE_PRICING_PVT, OKL_QUICK_QUOTES_PVT, OKL_INTEREST_CALC_PVT, OKL_LEASE_APP_PVT, OKL_LA_STREAM_PVT, OKL_STREAM_GENERATOR_PVT, OKL_VARIABLE_INTEREST_PVT, OKL_GENERATE_PV_RENT_PVT, and OKL_SEEDED_FUNCTIONS_PVT, and it calls itself recursively for shared logic. It is therefore exercised whenever pricing, quoting, interest calculation, or stream generation is performed from the Oracle Lease Management user interface or concurrent processing. Customizations should target the public packages that wrap this utility rather than the utility itself, since its signature is subject to change between releases.