Search Results get_tas_hdr_rec




Overview
Explore in AI Chat

Overview

OKL_EQUIPMENT_EXCHANGE_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite Lease Management (OKL) module. It encapsulates the business logic required to process equipment exchanges on an existing lease or contract. In an exchange transaction, a customer returns leased equipment and receives replacement equipment, requiring the system to reconcile the original transaction assets, item instances, and transaction lines against the new equipment being delivered. This package provides the internal runtime APIs that read, validate, and persist those exchange details.

The package is declared with AUTHID CURRENT_USER, meaning executing procedures run with the privileges of the calling user rather than the defining user. Its source header (OKLREQXS.pls 115.2) and the use of subtypes inherited from sibling private packages such as okl_trx_assets_pvt, okl_txl_assets_pvt, and okl_txl_itm_insts_pvt confirm that it is an internal component designed to be consumed by other OKL packages rather than called directly by end users. ETRM documents nine procedures and functions in the package, and it is referenced by one other package.

Key Procedures and Functions

  • GET_TAS_HDR_REC — The function the user searched for. It accepts a transaction-asset header table (typed via the thpv_tbl_type subtype) and returns the populated header record set, signalling the absence of data through the p_no_data_found OUT parameter. It is the entry point for retrieving equipment-exchange header information.
  • GET_STATUS — Resolves a status code into its descriptive status text.
  • GET_TAL_REC — Retrieves transaction asset line records, again returning a typed table and setting a no_data_found flag.
  • GET_VENDOR_NAME — Returns the supplier name for a given vendor identifier.
  • GET_ITEM_REC — Fetches item instance records for the exchange.
  • GET_EXCHANGE_TYPE — Determines the exchange type associated with a given transaction asset identifier.
  • UPDATE_SERIAL_NUMBER — A standard OKL API procedure that updates the serial number and associated inventory item for an instance, using the OKL_API message-handling conventions (x_return_status, x_msg_count, x_msg_data).
  • STORE_EXCHANGE_DETAILS — Persists the complete exchange detail set, accepting old and new line and item-instance tables and returning the processed tables.
  • EXCHANGE — The top-level orchestration routine that drives the full exchange operation.

Tables Accessed

The package reads and writes lease and transaction data through APPS synonyms. Core lease structures include OKL_K_HEADERS (contract/lease headers), OKL_TRX_ASSETS (transaction assets under exchange), and OKL_TXL_ITM_INSTS (transaction line item instances). Supporting contract data comes from OKC_K_ITEMS, OKC_K_LINES_B, OKC_K_PARTY_ROLES_B, and OKC_LINE_STYLES_B. Supplier information is sourced from AP_SUPPLIERS, while physical item tracking uses CSI_ITEM_INSTANCES. Exchange type lookups reference CS_TRANSACTION_TYPES_B and CS_TRANSACTION_TYPES_TL. Sequence numbers for transactions are generated via OKL_TRN_SEQ, and DUAL and PL/SQL table utilities (PLITBLM) support internal logic.

Usage Notes

Because this is a classified private API, it should not be invoked directly from custom code unless no public alternative exists. It is normally called from Lease Management forms and concurrent programs that process equipment exchanges, and from the single referencing package noted in the ETRM metadata. Customizations requiring exchange behaviour should prefer public OKL APIs; where OKL_EQUIPMENT_EXCHANGE_PVT must be called, wrap the call in the standard OKL_API initialization and message-stack handling to interpret x_return_status and x_msg_data correctly. Callers of GET_TAS_HDR_REC must always inspect the p_no_data_found flag before consuming the returned table.