Search Results insert_cash_flow_object




Overview
Explore in AI Chat

Overview

OKL_CASH_FLOW_OBJECTS_PUB is a public API package in the APPS schema that exposes the cash flow object maintenance functions of the Oracle Lease and Finance Management (OKL) module. In Oracle EBS 12.1.1 and 12.2.2, this package serves as the governed entry point for creating, modifying, validating, and removing cash flow object records that drive lease and loan payment schedules. Cash flow objects represent the individual payment stream components — principal, interest, fees, and other financial elements — that the OKL engine projects across the term of a contract. By publishing a stable, PL/SQL-encapsulated interface rather than exposing the underlying private logic, the package allows quoting, booking, and payoff processes to build and adjust cash flow schedules consistently while preserving the integrity of arithmetic and validation rules that the module enforces.

Key Procedures and Functions

The documented public interface comprises five procedures, each addressing a distinct operation on a cash flow object:

  • INSERT_CASH_FLOW_OBJECT — Creates a new cash flow object record, populating the schedule element for a contract or quote line.
  • UPDATE_CASH_FLOW_OBJECT — Modifies attributes of an existing cash flow object when schedule data changes, such as recalculated amounts or revised dates.
  • DELETE_CASH_FLOW_OBJECT — Removes a cash flow object that is no longer applicable, supporting schedule regeneration and re-quoting scenarios.
  • LOCK_CASH_FLOW_OBJECT — Acquires the concurrency lock required before updates or deletes, preventing conflicting concurrent modification of the same object.
  • VALIDATE_CASH_FLOW_OBJECT — Performs the business-rule validation checks that confirm an object is internally consistent and permissible before it is committed.

This collection follows the standard Oracle public API pattern: a validate-then-process convention, with explicit locking to enforce serialized access. The package delegates actual processing logic to the private package OKL_CFO_PVT, and relies on FND_API for its message and error-handling framework, OKC_API for core contracts functionality, and OKL_API for shared lease-management utilities.

Tables Accessed

The ETRM metadata for this package does not enumerate individual tables accessed by name; the referenced objects are the API and private packages listed above. Operationally, the package and its private counterpart interact with the OKL cash flow object tables through APPS synonyms, which is the standard EBS access pattern for a PUBLIC API package. The absence of documented direct table references reflects the deliberate layering of the design, where DML is confined to the private package body and callers are insulated from the physical data model.

Usage Notes

OKL_CASH_FLOW_OBJECTS_PUB is referenced by two other packages — OKL_AM_CALC_QUOTE_PYMNT_PVT, which calculates payment amounts during the quoting and amendment flow, and OKL_CS_PRINCIPAL_PAYDOWN_PVT, which supports principal paydown processing for customer service transactions. Both consume the public API rather than manipulating cash flow objects directly. Custom development and extensions should follow the same convention: invoke the public procedures, honor the lock-before-update sequence, and respect the validation results before committing schedule changes. In addition, the package is referenced by OKL_CASH_FLOW_OBJECTS_PUB itself, indicating internal recursion or self-referencing helper calls within the published interface. Because the public signature is documented as a PUBLIC API in 12.2.2, it is supported for customer and partner use; direct DML against the underlying cash flow tables is not.