Search Results create_working_copy

Overview

The OKL_CS_LEASE_RENEWAL_PUB package body is the public API layer of the Oracle EBS Lease Management renewal subsystem, delivered under the Oracle Enterprise Contracts (OKL/ETRM) module. In EBS 12.1.1 and 12.2.2 it exposes renewal-related operations that were otherwise implemented only inside the private okl_cs_lease_renewal_pvt package, providing a supported entry point for lease restructuring and renewal request processing. The header comment ($Header: OKLPKLRB.pls 115.4 … noship $) identifies the file as a shipped, core-named object maintained by Oracle development.

The package follows the standard Oracle EBS PL/SQL API pattern: each public routine wraps a corresponding private call, propagates the FND_API message stack (G_RET_STS_SUCCESS, G_RET_STS_ERROR, G_RET_STS_UNEXP_ERROR), and raises the standard G_EXCEPTION_ERROR / G_EXCEPTION_UNEXPECTED_ERROR exceptions. The classification as a PUB API confirms it is the intended integration surface for extensions and interfaces.

Key Procedures and Functions

• GET_CURRENT_LEASE_VALUES — A function returning the current lease details for a given lease/KHR identifier. It delegates to okl_cs_lease_renewal_pvt.get_current_lease_values and returns a lease_details_tbl_type collection, giving callers the baseline lease attributes used when building a renewal.
• CALCULATE — The primary calculation routine. It accepts a standard API version and initialization flag, returns the standard return-status/message-count/message-data OUT parameters, and processes a transaction-request table parameter of type okl_trx_requests_pub.trqv_tbl_type. Internally it calls the private CALCULATE and translates any error or unexpected-error status into the corresponding PL/SQL exception before exposing the result to the caller.
• CREATE_WORKING_COPY — The routine matched by the user's search term. It creates a working copy of the lease/renewal structure so that renewal terms can be modified without altering the original contract. This supports the Lease Management workflow in which a draft (working) version of the lease is prepared, edited, and subsequently submitted for approval.
• UPDATE_LRNW_REQUEST — Updates the lease renewal request record, allowing the renewal request attributes assembled through the working-copy process to be persisted. This is the write-back counterpart to the inquiry and calculation routines.

Consistent with the Oracle API convention, none of these routines commits work internally; transaction control remains with the caller.

Tables Accessed

The supplied ETRM metadata does not enumerate the base tables used by this package; the documented reference is limited to the PL/SQL source and the dependent OKL_TRX_REQUESTS_PUB transaction-request structure. In practice the package operates on the Lease Management renewal tables (the OKL lease/KHR header and renewal request entities) through APPS synonyms. The lease_details_tbl_type returned by GET_CURRENT_LEASE_VALUES is populated from the lease header data, while CREATE_WORKING_COPY and UPDATE_LRNW_REQUEST write the renewal request and working-copy records. Because the metadata records no confirmed table list, integrators should validate the actual table dependencies against a site-specific trace rather than assume a fixed set.

Usage Notes

OKL_CS_LEASE_RENEWAL_PUB is invoked when lease renewal processing is initiated from the Lease Management (Contracts) forms, from concurrent programs handling bulk renewal cycles, or from custom PL/SQL that must reproduce renewal behavior programmatically. It is referenced by two other packages, indicating it sits within a dependency chain rather than at the leaf of the call graph. Callers must initialize the FND message stack where required, check x_return_status after every call, and invoke FND_MSG_PUB to retrieve messages before issuing a COMMIT. Because the file is shipped and marked noship, no direct modification of the package body is supported; extensions should wrap the public routines.