Search Results okl_cfo_pvt




Overview
Explore in AI Chat

Overview

OKL_CFO_PVT is an Oracle E-Business Suite Private API package owned by the APPS schema and classified under the PVT (private) API layer of Oracle Lease and Finance Management (OKL), part of Oracle's Enterprise Trading and Risk Management (ETRM) solution set. Its name reflects its core subject area: Cash Flow Objects (CFO). The package encapsulates the internal business logic that creates, maintains, validates, and versions cash flow object records — the structured financial data that represent the timing, amount, and type of money movements associated with lease and finance contracts, quotes, and payment schedules. As a private API, OKL_CFO_PVT is not intended for direct invocation by external or customer code; it is called by the public API layer (notably OKL_CASH_FLOW_OBJECTS_PUB) and by other internal private packages that need to manipulate cash flow objects as part of a larger processing flow.

Key Procedures and Functions

The ETRM metadata documents nineteen procedures and functions within OKL_CFO_PVT, including the following named entities:

  • QC — A quality-control or consistency-check routine used to validate the state or integrity of cash flow object data before or after processing.
  • CHANGE_VERSION — Handles versioning of cash flow object records, supporting the multi-version model used to track changes to lease quote or contract cash flows over their lifecycle.
  • API_COPY — Copies cash flow object data, typically during quote duplication, version creation, or contract origination scenarios.
  • INSERT_ROW — Inserts a single cash flow object row into the underlying table, applying defaulting and validation logic.
  • INSERT_ROW_BULK — Provides a bulk-insert path for processing multiple cash flow object rows in a single call, optimizing performance for high-volume generation.
  • LOCK_ROW — Acquires a row-level lock on a cash flow object record, ensuring serialized access during update or delete operations.
  • UPDATE_ROW — Updates an existing cash flow object row, applying the package's internal validation and defaulting rules.
  • DELETE_ROW — Removes a cash flow object row, subject to the package's referential and business validation checks.
  • VALIDATE_ROW — Performs field-level and cross-field validation on a cash flow object record prior to persistence.

These routines follow the standard Oracle private API pattern: lock, validate, insert/update/delete, plus specialized helpers for bulk operations, copying, and versioning.

Tables Accessed

The package reads from and writes to OKL_CASH_FLOW_OBJECTS, the primary transactional table storing cash flow object records, and its view OKL_CASH_FLOW_OBJECTS_V. It references FND_LOOKUP_VALUES to resolve Oracle Application Object Library lookup codes used during defaulting and validation. It also references PLITBLM, a standard Oracle Applications internal temporary/PL-SQL table structure frequently used for bulk row handling and nested table processing.

Usage Notes

OKL_CFO_PVT is invoked indirectly through the public API OKL_CASH_FLOW_OBJECTS_PUB and by numerous internal packages, including OKL_AM_CALC_QUOTE_PYMNT_PVT, OKL_CS_PRINCIPAL_PAYDOWN_PVT, OKL_LEASE_QUOTE_ASSET_PVT, OKL_LEASE_QUOTE_CASHFLOW_PVT, and OKL_LEASE_QUOTE_FEE_PVT. The metadata confirms it is referenced by six other packages. Because it is a private API, it should never be called directly from custom code; developers requiring cash flow object manipulation must use the corresponding public API instead, preserving upward compatibility across EBS 12.1.1 and 12.2.2. Typical invocation contexts include lease quote generation, payment schedule calculation, principal paydown processing, and cash flow versioning during contract origination.