Search Results create_txl_itm_insts

Overview

OKL_TXL_ITM_INSTS_PVT is a private (PVT) PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that belongs to the Oracle Lease and Finance Management (OLFM/OKL) module within the ETRM (Enterprise Transaction and Reference Model) layer. It serves as the transaction-level API for managing the OKL_TXL_ITM_INSTS entity, which represents tax item instances associated with lease and finance contracts. The package declares AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the calling schema rather than the definer, which is consistent with EBS PL/SQL API conventions for controlled data access.

Its principal business function is to provide a programmatic interface for creating, locking, updating, validating, and deleting tax item instance records, as well as resetting item serial numbers. This supports the tax calculation and reporting requirements of lease contracts, where each taxable line item must be tracked as a discrete instance.

Key Procedures and Functions

The package exposes eleven documented procedures and functions. The most commonly referenced is DELETE_TXL_ITM_INSTS, the subject of the user's search, which removes tax item instance records from the underlying table. Supporting procedures include:

• CREATE_TXL_ITM_INSTS — inserts new tax item instances. It is overloaded; one version accepts a single iivv_rec_type record, and a second accepts a iivv_tbl_type table for bulk processing. Both follow the standard EBS API signature with p_api_version, p_init_msg_list, and the x_return_status, x_msg_count, and x_msg_data OUT parameters.
• LOCK_TXL_ITM_INSTS — acquires a lock on an existing tax item instance record to prevent concurrent modification.
• UPDATE_TXL_ITM_INSTS — modifies attributes of existing tax item instances.
• DELETE_TXL_ITM_INSTS — deletes tax item instance records, typically invoked when a contract line or asset association is removed or reprocessed.
• VALIDATE_TXL_ITM_INSTS — performs business-rule validation on the instance data prior to persistence.
• RESET_ITEM_SRL_NUMBER — resets the serial number assigned to an item instance.

The package also declares global exception G_EXCEPTION_HALT_VALIDATION and standard message tokens (G_SQLERRM_TOKEN, G_SQLCODE_TOKEN) used for error capture.

Tables Accessed

The package reads and writes several EBS tables via APPS synonyms. OKL_TXL_ITM_INSTS is the primary base table holding tax item instance rows. OKL_TXL_ASSETS_B links instances to lease assets. Contract context is supplied by OKC_K_HEADERS_B, OKC_K_ITEMS, OKC_K_LINES_B, OKC_LINE_STYLES_B, and OKC_STATUSES_B, which define the contract header, line, style, and status hierarchy. MTL_SYSTEM_ITEMS references inventory item definitions, and WF_PARAMETER_LIST_T is used for workflow parameter handling. Together these tables provide the referential and validation context required when creating or deleting a tax item instance.

Usage Notes

Because OKL_TXL_ITM_INSTS_PVT is classified as a private API, it is not intended for direct invocation by external customers or third-party integrations. It is referenced by four other packages within the OLFM transaction layer and is typically called internally by public tax or contract APIs, by Oracle Forms events during lease contract entry and amendment, and by concurrent programs that regenerate or reconcile tax data. Custom code should favor public OLFM APIs and avoid calling DELETE_TXL_ITM_INSTS directly, since doing so bypasses parent-level validation and may leave orphaned references. Regardless of entry point, callers must honor p_api_version, inspect x_return_status for OKC_API.G_RET_STS_ERROR or G_RET_STS_UNEXP_ERROR, and call OKC_API.GET_MSG to retrieve messages before committing.