Search Results okl_pricing_pvt




Overview
Explore in AI Chat

Overview

OKL_PRICING_PVT is a private (PVT-classified) PL/SQL package in the APPS schema belonging to the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. It encapsulates the core financial mathematics engine used to price, amortize, and schedule lease and loan contracts. The package converts contract terms — rates, payment amounts, streams, and party payment details — into amortization results and stream element values, serving as the computational back end for lease origination, subsidy processing, buyout/paydown handling, and loan schedule generation. Because its API classification is PVT, it is not intended as a public extension point; it is invoked internally by other OKL packages, principally OKL_STREAM_GENERATOR_PVT, OKL_LOAN_AMORT_SCHEDULE_PVT, OKL_SUBSIDY_PROCESS_PVT, and OKL_CS_PRINCIPAL_PAYDOWN_PVT, all of which depend on it for interest and payment calculations.

Key Procedures and Functions

The documented 12.2.2 metadata lists twelve callable units. Their purposes, consistent with their names and functional domain, are as follows:

  • GET_QUOTE_AMORTIZATION — Produces an amortization schedule for quotation purposes, allowing prospective terms to be evaluated before contract booking.
  • GET_LOAN_AMORTIZATION — Generates the amortization schedule for an existing loan contract, typically after booking.
  • COMPUTE_IIR — Derives the implicit interest rate (internal rate of return) implied by a set of cash flows and terms.
  • COMPUTE_IRR — Calculates the internal rate of return for the supplied cash flow stream.
  • GET_RATE — Retrieves or determines the applicable interest or pricing rate for the contract context.
  • TARGET_PAY_DOWN — Computes the paydown amount required to reach a targeted balance or payment objective.
  • COMPUTE_RATES — Derives the set of rates applicable to the contract, coordinating multiple rate calculations.
  • TARGET_PARAMETER — Determines a target parameter value (such as a target payment or balance) needed by other computations.
  • GET_PAYMENT_AFTER_PPD — Returns the payment amount applicable after a partial paydown (PPD), supporting principal paydown processing.
  • GENERATE_LOAN_SCHEDULES — Builds the full loan schedule set, including stream generation activities.
  • PRINT — Provides diagnostic or output-formatting support for pricing computations.

Tables Accessed

The package reaches the data model almost entirely through APPS synonyms. Contract, line, and header attributes are read from OKC_K_HEADERS_ALL_B, OKC_K_HEADERS_B, OKC_K_ITEMS, OKC_K_LINES_B, OKC_RULES_B, OKC_RULE_GROUPS_B, OKC_STATUSES_B, OKC_LINE_STYLES_B, OKL_K_HEADERS, and OKL_K_LINES. Payment information is read from OKL_PARTY_PAYMENT_DTLS and OKL_PARTY_PAYMENT_HDR, while amortization and pricing outputs are written to the stream structures OKL_STREAMS and OKL_STRM_ELEMENTS. FND_CURRENCIES supplies currency-specific attributes such as precision and currency code, ensuring numerical rounding and formatting conform to the contract currency. Together these tables supply the terms, rules, statuses, and payment data required for rate and schedule computation, and receive the resulting stream elements.

Usage Notes

OKL_PRICING_PVT is invoked indirectly rather than from a user-facing form or standalone concurrent program. Callers include OKL_STREAM_GENERATOR_PVT, OKL_LOAN_AMORT_SCHEDULE_PVT, OKL_SUBSIDY_PROCESS_PVT, OKL_CS_PRINCIPAL_PAYDOWN_PVT, and itself, reflecting a call pattern in which the stream generator and loan amortization processes drive pricing calculations. Typical triggering scenarios include lease quote generation, contract booking and funding, amortization schedule creation, subsidy processing, and customer-side principal paydown. The package further depends on the shared utilities FND_API, OKL_API, OKL_STREAMS_PUB, and OKL_STREAM_GENERATOR_PVT. Because it is a PVT package with no declared public interface, customization or direct calls from client code are discouraged; extensions should target the public OKL APIs instead, and any modification risks invalidating the four dependent packages listed in the dependency metadata.