Search Results update_serial_number

Overview

The OKL_EQUIPMENT_EXCHANGE_PUB package body is the public API layer for the Oracle E-Business Suite Lease and Finance Management (OKL) equipment exchange functionality. It exposes a published, supported interface through which callers can retrieve and manipulate data related to the exchange of leased equipment, such as when a customer returns or trades-in an item against a new agreement. The package follows the standard EBS public/private (PUB/PVT) design pattern: every function and procedure in this body is a thin wrapper that delegates its work to the corresponding routine in OKL_EQUIPMENT_EXCHANGE_PVT. In Oracle EBS 12.1.1 and 12.2.2 the PUB layer is the only layer guaranteed to remain backward compatible across upgrades, so external integrations, forms, and concurrent programs must invoke these routines rather than calling the private package directly.

Key Procedures and Functions

The package exposes nine documented routines:

• GET_TAS_HDR_REC – returns the transaction/agreement header record set for an equipment exchange, taking a table-type parameter and an OUT flag indicating no data was found.
• GET_STATUS – translates a status code into its descriptive display value.
• GET_TAL_REC – retrieves the transaction line record set, returning a line table type plus a no-data-found flag.
• GET_VENDOR_NAME – resolves a vendor identifier to a vendor name for display on exchange screens.
• GET_ITEM_REC – returns item (inventory) record information for the exchanged equipment, with a no-data-found indicator.
• GET_EXCHANGE_TYPE – given a transaction identifier, returns the exchange type classification.
• UPDATE_SERIAL_NUMBER – updates the serial number associated with an exchange instance; exposed as a standard API procedure with an API version and initialization message-list parameter.
• STORE_EXCHANGE_DETAILS – persists the captured exchange details for the transaction.
• EXCHANGE – performs the main equipment exchange operation, driving the core business logic for the transaction.

The header comment dates the source file to a 2004 revision, and the package is referenced by one other package, confirming it as a stable, low-level utility within the OKL module.

Tables Accessed

The documented metadata does not enumerate the underlying base tables because all access is performed through APPS synonyms resolved at runtime inside the private package. Functionally, the GET routines read the transaction header, transaction line, item, and vendor reference data that constitute an equipment exchange record, while UPDATE_SERIAL_NUMBER, STORE_EXCHANGE_DETAILS, and EXCHANGE write to the exchange transaction and detail tables. Because the public package only proxies to the private package, no direct DML on base tables is visible here.

Usage Notes

This package is intended for server-side invocation. It is typically called from the Lease Management Oracle Forms UI, from concurrent programs that process exchanges in batch, and from custom PL/SQL integrations that need to query exchange details or record a serial number change. Callers should use the API-versioned procedures and honor the standard initialization parameter conventions. Fault handling relies on the underlying private package and the OKL_API error stack, so callers should check the message list after write operations such as UPDATE_SERIAL_NUMBER and EXCHANGE.