Search Results okl_vp_extend_pub




Overview
Explore in AI Chat

Overview

OKL_VP_EXTEND_PVT is a private PL/SQL package in the APPS schema that supports contract extension processing within the Oracle Enterprise Asset Management / Lease and Loan Management (formerly Oracle Lease Management) module of Oracle E-Business Suite. The "PVT" classification indicates that this is a private implementation package, intended to be called only by its associated public wrapper package rather than directly by external code. It forms the backend logic layer for the OKL_VP_EXTEND_PUB public API, which exposes contract extension functionality to forms, concurrent programs, and other calling modules. The package encapsulates the business rules and database manipulation logic required to extend a contract's term or duration, working in conjunction with the OKC (Contracts Core) schema objects that underlie Oracle's contract management architecture. The package carries a VALID status in the ETRM documentation, confirming it has compiled successfully within the 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

The package exposes a single documented procedure:

  • EXTEND_CONTRACT — This procedure carries out the core logic for extending a contract. It is responsible for applying the extension to the target contract record, coordinating with contract header and process-related tables, and ensuring the extension is persisted consistently with the underlying OKC contract model. As a private procedure, EXTEND_CONTRACT is invoked internally by the public package OKL_VP_EXTEND_PUB, which handles any public-facing validations and parameter marshalling before delegating to this implementation. No parameter list is documented in the ETRM metadata, so callers should reference the public package specification for the supported interface.

Tables Accessed

According to the documented metadata, the package references the following tables through APPS synonyms:

  • OKC_K_HEADERS_B — The base table for contract headers. The procedure reads and updates header-level attributes to reflect the revised term or end date resulting from the extension.
  • OKC_K_PROCESSES — Stores process/action records associated with a contract. The extension logic likely creates or updates process entries to track the extension activity.
  • OKC_STATUSES_B — The base table for contract statuses. The procedure consults this table to validate and manage the contract's status throughout the extension.

Additionally, the dependency listing shows that the package references the OKC_K_HEADERS_V view as well as OKL_API and the SYS STANDARD package, which provide supporting utilities and view-based access to the contract header data.

Usage Notes

OKL_VP_EXTEND_PVT should not be called directly. It is referenced by the public packages OKL_VP_EXTEND_PUB and its wrapper OKL_VP_EXTEND_PUB_W, as well as by its own wrapper OKL_VP_EXTEND_PVT_W. This layered structure reflects Oracle's standard public/private API design pattern, in which the public package performs interface validation and the private package performs the actual data manipulation. Typical invocation scenarios include the contract extension form within the Lease/Loan Management application and any concurrent programs or custom extensions that extend contract terms. Developers seeking the required signature for EXTEND_CONTRACT should inspect the public OKL_VP_EXTEND_PUB specification, which was the subject of the user's search. Because this object is internal, customizations should always target the public wrapper to preserve upgrade safety across EBS 12.1.1 and 12.2.2.