Search Results okl_am_integration_pub

Overview

OKL_AM_INTEGRATION_PUB is a public PL/SQL package in the APPS schema that forms part of the Oracle Lease and Finance Management (OKL) application module, within the broader Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 release streams. The suffix "_PUB" designates the package as a public API layer, meaning its procedures are intended to be called from outside the owning application — from forms, concurrent programs, or custom client code. The "AM" component of the name refers to the Asset Management area of the leasing module, which governs the lifecycle of leased assets, including their origination, mid-term modifications, and termination.

Functionally, OKL_AM_INTEGRATION_PUB provides an integration point between Oracle Lease Management and the Asset Management / Fixed Assets side of the E-Business Suite. Its role is to expose controlled, API-standard entry points that allow termination-related quote activity to be cancelled programmatically, ensuring that asset and lease records remain synchronized when a termination workflow is reversed or abandoned. By centralizing this logic in a public package, Oracle enforces data integrity and business rules rather than allowing direct table manipulation.

Key Procedures and Functions

The ETRM metadata documents a single procedure exposed by this package:

• CANCEL_TERMINATION_QUOTES — This procedure cancels one or more termination quotes associated with the asset management integration process. It is intended to remove or void termination quotes that were generated but not finalized, so that the associated lease and asset records are not incorrectly flagged as terminated. It handles the cleanup of quote data that would otherwise conflict with subsequent lease transactions or asset accounting. No parameter list is published in the documented metadata, so callers should obtain the exact signature from the package specification in the database.

The package body may contain additional private helper routines used internally, but only CANCEL_TERMINATION_QUOTES is enumerated as documented public surface.

Tables Accessed

The documented metadata does not enumerate specific base tables accessed through APPS synonyms. Based on the package's purpose within the Asset Management integration area, CANCEL_TERMINATION_QUOTES operates against the core Lease Management termination and quote tables — typically those holding termination quote headers and lines within the OKL schema. These records are updated or logically deleted to reflect cancellation. Because the metadata lists no explicit table references, callers and developers should not assume direct DML access; the package performs all persistence internally through its own logic and through calls to OKL_API.

Usage Notes

OKL_AM_INTEGRATION_PUB depends on FND_API and OKL_API, indicating that it observes Oracle Application Object Library API conventions — including standardized return statuses (for example, success, error, and unexpected error) and message-stack handling. This confirms it is designed to be called from PL/SQL as a formal API rather than invoked implicitly.

Typical invocation scenarios include:

• Oracle Forms within the Lease Management or Asset Management responsibility, when a user reverses or abandons a termination transaction and the associated quotes must be cleared.
• Concurrent programs that process lease termination batches and require rollback of quote records upon validation failure.
• Custom integration code or workflow business events that need to synchronize lease termination state with downstream asset accounting.

Because the package is classified as PUBLIC and is referenced by no other documented packages, it is primarily a top-level entry point. Developers should always call it through its public specification, honor the FND_API return conventions, and avoid direct DML against the underlying termination tables to preserve integrity. As with all ETRM objects, the authoritative parameter list should be confirmed against the 12.1.1 or 12.2.2 package specification in the target environment before use.