Results for “update_serial_number”
42 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKL_EQUIPMENT_EXCHANGE_PUB is a public PL/SQL API package in the APPS schema within the Oracle E-Business Suite Lease Management (OKL) module, part of the Enterprise Territory and Revenue Management (ETRM) family. The package supports the equipment exchange business process, in which an existing leased asset is returned or traded and replaced with a new asset while preserving the contractual, transactional, and accounting relationships of the original lease. The "PUB" classification indicates it is a published, externally callable API intended for integration, forms, or workflow invocation rather than internal-only use. Its declared status is VALID in the ETRM 12.2.2 metadata, and it is documented against both 12.1.1 and 12.2.2 environments.
Key Procedures and Functions
The package exposes nine documented program units:
- EXCHANGE — The principal driver procedure. It orchestrates the equipment exchange, coordinating the transactional, asset, and item-instance updates required to substitute one leased asset with another.
- STORE_EXCHANGE_DETAILS — Persists the exchange-specific attribute set captured during the exchange, making the detail available to downstream processing.
- GET_EXCHANGE_TYPE — Returns the classification of exchange being performed, allowing callers to branch logic based on the exchange category.
- GET_STATUS — Retrieves the current processing status of the exchange transaction.
- GET_TAS_HDR_REC — Fetches the Transaction Asset header record associated with the exchange.
- GET_TAL_REC — Retrieves the Transaction Asset Line record, providing line-level asset information.
- GET_ITEM_REC — Returns item-instance details for the equipment involved in the exchange.
- GET_VENDOR_NAME — Resolves and returns the vendor name linked to the exchange transaction.
- UPDATE_SERIAL_NUMBER — Updates the serial number attribute on the affected asset or item instance.
Tables Accessed
The documented metadata does not enumerate base tables directly; the package operates against tables owned in the OKL schema and exposed through APPS synonyms. Based on its dependencies, the relevant data sets include transaction asset header and line tables (surfaced via OKL_TAS_PVT and OKL_TAL_PVT), transaction asset and item-instance tables (OKL_TRX_ASSETS_PVT and OKL_TXL_ITM_INSTS_PVT), lease item-instance data (OKL_ITI_PVT), and asset-line data (OKL_TXL_ASSETS_PVT). Vendor and item lookups draw on OKC_API, while common error and message handling uses FND_API, OKL_API, and the SYS.STANDARD package.
Usage Notes
OKL_EQUIPMENT_EXCHANGE_PUB is invoked from the Lease Management application and from Oracle Workflow; the metadata records that it is referenced by OKL_CS_WF and recursively by itself, indicating internal re-entrant calls. Typical invocation paths include the equipment exchange form flow, workflow-driven notifications and approvals, and custom extensions that must exchange a leased asset programmatically. The package depends on OKL_OKC_MIGRATION_PVT, suggesting it participates in migration or conversion scenarios where exchange data is reconciled. Because it is a PUB API, callers should use the documented procedures rather than modifying underlying tables directly. Error conditions are propagated through the standard FND_API message stack, and all dependencies reside in APPS, keeping the interface consistent across 12.1.1 and 12.2.2 releases.
-
PACKAGE: APPS.OKL_SSC_WF 12.1.1
-
PACKAGE: APPS.OKL_SSC_WF 12.2.2
-
PACKAGE: APPS.OKL_SSC_WF 12.2.2
-
PACKAGE: APPS.OKL_SSC_WF 12.1.1