Search Results cancel_termination_quotes

Overview

OKL_AM_INTEGRATION_PUB is a public PL/SQL package belonging to the Oracle Lease and Finance Management (OKL) application family, part of the Oracle E-Business Suite. The package serves as the public-API façade for integrating the Oracle Assets (AM) domain with lease contract lifecycle events. Its documented purpose is to coordinate the automatic termination process that follows a rebook, ensuring that any termination quotes generated against a contract before the rebook are invalidated so they cannot be restated, applied, or processed against the revised contract. In EBS 12.1.1 and 12.2.2 the package is deployed in the APPS schema and classified as a PUB (public) API, meaning it is intended for supported external invocation by forms, concurrent programs, and custom code, while the package body delegates the majority of the logic to its private wrapper, OKL_AM_INTEGRATION_PVT.

Key Procedures and Functions

• cancel_termination_quotes — Invalidates all termination quotes associated with a contract. The procedure accepts an API version, an initialization flag for the message list, a KHR (contract header) identifier, a source transaction identifier, and an optional source descriptor added to address bug 4508497. It returns the standard Oracle error-handling out-parameters x_return_status, x_msg_count, and x_msg_data. The body creates a savepoint named after the procedure and immediately forwards all parameters to OKL_AM_INTEGRATION_PVT.cancel_termination_quotes, so the public package contains no business logic of its own. On success it sets x_return_status to G_RET_STS_SUCCESS; on an unexpected error it raises G_EXCEPTION_UNEXPECTED_ERROR, and on a normal API error it raises G_EXCEPTION_ERROR. Both exception branches perform a ROLLBACK TO the local savepoint, preserving transactional consistency for the caller.

Tables Accessed

The provided metadata documents no direct table references from this package body; because the body delegates entirely to OKL_AM_INTEGRATION_PVT, all DML against the underlying tables (termination quote headers and lines, contract header, and related integration tables) is performed by that private package. The public package is therefore effectively a thin, transaction-safe entry point rather than a data-access layer. Where a site needs to trace physical object access, DBMS_DEPENDENCY or the OKL private package should be inspected rather than this unit.

Usage Notes

The procedure is normally invoked by the lease rebook flow to clear stale termination quotes after a contract is rebooked, using the contract_id and the quote_id that triggered the rebook as input identifiers. Because it is a documented PUB API, it can be called from Oracle Forms, an OAF page, a concurrent program, or custom PL/SQL that wraps OKL_AM_INTEGRATION_PUB.cancel_termination_quotes inside the standard Oracle API invocation pattern. Callers should initialize the API and message list through the OKL_API utilities, pass a valid api_version, check x_return_status before continuing, and honor the message count and data for error reporting. Because the procedure relies on a savepoint and rollback, it must be called within a valid transaction and should not be nested across an autonomous transaction boundary. As the metadata shows no reverse dependencies, the procedure should be treated as a leaf utility that does not cascade callouts to other packages, which simplifies impact analysis during 12.1.1 to 12.2.2 upgrades.