Search Results extend_contract

Overview

The APPS.OKL_VP_EXTEND_PUB package body is a public API wrapper within the Oracle E-Business Suite Contracts (OKL/OKC) module — specifically the Enterprise Transaction and Reporting Management (ETRM) landscape for leasing and contract management. Its primary business function is to expose the contract extension process to external callers in a controlled, standardized manner. Contract extension is the mechanism by which an existing lease or service agreement's term is lengthened without terminating the original instrument, and this package provides the sanctioned public entry point for that operation.

The package is classified as PUB (public API) under the APPS schema, meaning it is intended to be called from outside the OKL module — by forms, concurrent programs, or custom code — rather than being an internal private helper. It acts strictly as a thin wrapper: the real processing logic resides in the private package OKL_VP_EXTEND_PVT, which this public layer delegates to after validating and staging the incoming header record.

Key Procedures and Functions

• extend_contract — The single documented public procedure. It accepts an API version, an initialization message list flag, a set of standard output parameters (x_return_status, x_msg_count, x_msg_data), and an extension_header_rec_type header record that carries the extension details. Internally it copies the header record into a local variable and invokes OKL_VP_EXTEND_PVT.extend_contract to perform the actual extension. It then interrogates the returned status: an error raises FND_API.G_EXC_ERROR, and an unexpected error raises FND_API.G_EXC_UNEXPECTED_ERROR. The exception handlers translate these into the corresponding return statuses and pull any accumulated messages off the message stack via FND_MSG_PUB.Count_and_get. No parameter list is invented here beyond what the source excerpt documents.

Tables Accessed

The ETRM metadata for this object does not enumerate any tables directly referenced through APPS synonyms. This is consistent with the package's design as a wrapper: all persistence activity is performed inside OKL_VP_EXTEND_PVT, which is where the contract header and related extension records are read and updated. Callers should consult the private package documentation for the specific OKL contract header and extension tables touched during processing.

Usage Notes

This package is typically invoked when a user or process needs to programmatically extend a contract's term. Common callers include the Oracle Contracts forms (such as the lease/contract extension windows), concurrent programs that batch-extend agreements, and custom PL/SQL integrations.

Because it follows the Open Interface / API Framework conventions, callers should always initialize the message list where appropriate and inspect x_return_status after every call, checking for FND_API.G_RET_STS_SUCCESS. Errors are returned both through the status code and the message stack, so x_msg_count and x_msg_data should be used to retrieve diagnostic detail.

The package was authored under source control (header revision 115.7, dated 2004) and remains documented under ETRM 12.2.2, confirming continued support across the 12.1.1 and 12.2.2 releases. The ETRM metadata further records that this package is referenced by one other package, indicating it participates in a broader extension-processing chain within the OKL module.