Search Results okl_split_asset_pvt




Overview

OKL_TXL_ITM_INSTS_PUB is the public application programming interface (API) for managing tax lines associated with item instances within Oracle E-Business Suite Lease and Finance Management (also known as Oracle Lease Management, OKL). The package belongs to the APPS schema and carries an API classification of PUB, meaning it is intended for external invocation by other Oracle modules, forms, and custom code. It serves as the transactional gateway for creating, maintaining, and reserving tax item instance records that link lease assets and item instances to their associated tax treatment.

The package follows the standard Oracle EBS layered architecture. The public layer (OKL_TXL_ITM_INSTS_PUB) delegates business logic to its private counterpart OKL_TXL_ITM_INSTS_PVT, while relying on common infrastructure packages including FND_API for the standard API return-status conventions, OKC_API for contract-related utility calls, and OKL_ITI_PVT for item instance handling. The dependency list confirms that OKL_TXL_ITM_INSTS_PUB is heavily reused across the lease asset and contract lifecycle.

Key Procedures and Functions

Eleven documented procedures and functions are exposed by this package. Their purposes are as follows:

  • CREATE_TXL_ITM_INSTS — Creates a new tax item instance record, establishing the tax association for a given item instance.
  • UPDATE_TXL_ITM_INSTS — Modifies an existing tax item instance record to reflect changed tax attributes or references.
  • DELETE_TXL_ITM_INSTS — Removes a tax item instance record when the association is no longer required.
  • LOCK_TXL_ITM_INSTS — Places a lock on the tax item instance record to prevent concurrent modification during a transaction.
  • VALIDATE_TXL_ITM_INSTS — Performs validation of the tax item instance data against required business rules before commit.
  • RESET_ITEM_SRL_NUMBER — Resets or reinitializes the item serial number context associated with tax item instance processing.

Additional documented procedures round out the full set of eleven, following the same create/update/delete/lock/validate pattern characteristic of Oracle EBS public APIs. Parameter lists are not reproduced here; consumers should reference the package specification for exact signatures.

Tables Accessed

The documented table referenced through APPS synonyms is PLITBLM. The package accesses this table to persist and retrieve the tax item instance data that underpins its operations. All database access occurs through APPS synonyms, consistent with the shared-schema deployment model used throughout ETRM. The private package OKL_TXL_ITM_INSTS_PVT encapsulates the direct SQL statements, while the public package provides the transactional wrapper.

Usage Notes

OKL_TXL_ITM_INSTS_PUB is referenced by twelve other packages, indicating it is invoked programmatically rather than through direct end-user forms in most cases. Prominent callers include OKL_SPLIT_ASSET_PVT — which is directly relevant to the user's search term "okl_split_asset_pvt" — along with OKL_COPY_ASSET_PUB, OKL_COPY_ASSET_PVT, OKL_CONTRACT_PVT, OKL_CREATE_KLE_PVT, OKL_DEAL_ASSET_PVT, OKL_EQUIPMENT_EXCHANGE_PVT, OKL_RELEASE_PVT, OKL_SPLIT_CONTRACT_PVT, OKL_BLK_AST_UPD_PVT, and OKL_ACTIVATE_IB_PVT.

In practice, this package is invoked whenever lease assets are split, copied, exchanged, released, or otherwise restructured, because each of those operations must preserve or recalculate the tax treatment attached to the underlying item instances. Custom extensions and Oracle Forms that manipulate lease assets should call this public API rather than touching PLITBLM directly, preserving the validation and locking semantics enforced by the package.