Results for “get_item_rec”
33 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The OKL_EQUIPMENT_EXCHANGE_PVT package body is a private (PVT) API within the Oracle E-Business Suite Lease Management (OKL) module. It encapsulates the business logic required to process equipment exchanges on lease contracts. In the leasing lifecycle, an equipment exchange occurs when an existing asset on a contract line is replaced by a new item, whether through a vendor buyout, a trade-in, or a mid-term substitution. The private package sits behind the public API surface and performs the validation, data retrieval, and persistence operations that support the exchange workflow.
The package is classified as _PVT, meaning it is not intended for direct external invocation. Its global constants and exception declarations—such as G_EXCEPTION_HALT_VALIDATION, G_EXCEPTION_STOP_VALIDATION, and G_API_VERSION—follow the standard Oracle EBS API framework conventions. The body also declares subtypes borrowed from CSI_DATASTRUCTURES_PUB (instance_rec, extend_attrib_values_tbl, party_tbl, account_tbl), which indicates tight integration with the Oracle Installed Base (CSI) data model for item instance and party information.
Key Procedures and Functions
The documented API exposes nine procedures and functions, each handling a discrete portion of the exchange flow:
- GET_TAS_HDR_REC — Retrieves the transaction asset header record, establishing the context for the exchange.
- GET_STATUS — Determines the current status of the exchange or associated transaction, used to gate subsequent processing.
- GET_TAL_REC — Fetches the transaction asset line record, linking the exchange to specific contract line detail.
- GET_VENDOR_NAME — Resolves the supplier name associated with the exchange, drawing on supplier master data.
- GET_ITEM_REC — Returns item information for the equipment involved in the exchange.
- GET_EXCHANGE_TYPE — Identifies the classification of the exchange (for example, trade-in versus substitution), which drives downstream logic.
- UPDATE_SERIAL_NUMBER — Updates serial number attributes on the affected item instance.
- STORE_EXCHANGE_DETAILS — Persists the assembled exchange information to the transaction tables.
- EXCHANGE — The principal driver procedure that orchestrates the full equipment exchange operation by invoking the supporting routines above.
Tables Accessed
The package reads and writes several core EBS tables via APPS synonyms. Contract and line data are sourced from OKC_K_ITEMS, OKC_K_LINES_B, OKC_K_PARTY_ROLES_B, and OKC_LINE_STYLES_B, while OKL_K_HEADERS provides lease header context. Transaction asset information is maintained in OKL_TRX_ASSETS, supported by OKL_TXL_ITM_INSTS for item instance detail (the table often searched as okl_txl_assets in related queries). Supplier data comes from AP_SUPPLIERS. Installed Base integration uses CSI_ITEM_INSTANCES. Transaction type lookups draw on CS_TRANSACTION_TYPES_B and CS_TRANSACTION_TYPES_TL. Sequence values are obtained from OKL_TRN_SEQ, and DUAL and PLITBLM support utility and bulk operations.
Usage Notes
Because OKL_EQUIPMENT_EXCHANGE_PVT is a private package, it is invoked indirectly through the corresponding public API (OKL_EQUIPMENT_EXCHANGE_PUB) rather than called directly by forms, concurrent programs, or custom code. The metadata notes that it is referenced by one other package, consistent with this public/private delegation pattern. Developers extending equipment exchange functionality should call the public wrapper, which in turn delegates to the procedures documented here. Direct calls to the private package are discouraged, as internal signatures may change across patch levels in 12.1.1 and 12.2.2.