Search Results delete_split_asset_comp




Overview
Explore in AI Chat

Overview

OKL_SPLIT_ASSET_COMP_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, part of the Oracle Lease and Finance Management (OKL) module. It is classified as a PUB (public) API package, meaning its procedures are intended to be called from outside the owning application, including from the Lease Management forms, concurrent programs, and customer extensions. Its business purpose is to manage the split asset component data associated with lease contracts, allowing users to break a leased asset into multiple asset components and to create, maintain, delete, and process those component records.

The package is declared AUTHID CURRENT_USER, so it executes with the privileges of the calling user rather than the defining user. Its header defines global constants for the package name (OKL_SPLIT_ASSET_COMP_PUB), the application short name (OKL), SQL error tokens, and an unexpected-error message name (OKL_UNEXPECTED_ERROR), along with a global exception G_EXCEPTION_HALT_VALIDATION. These standard constructs confirm the package follows the Oracle EBS API error-handling convention, returning status through x_return_status and message details through x_msg_count and x_msg_data.

Key Procedures and Functions

  • CREATE_SPLIT_ASSET_COMP — Creates split asset component records from the incoming asset detail table structure. It accepts an API version and message-list initialization flag, and returns a return status, message count, and message data, together with the processed asset detail table.
  • UPDATE_SPLIT_ASSET_COMP — Modifies existing split asset component records held in the asset detail table, applying the same standard API signature and error-handling outputs as the create procedure.
  • DELETE_SPLIT_ASSET_COMP — Removes split asset component records identified in the incoming asset detail table, again returning standard status and message information.
  • PROCESS_SPLIT_ASSET_COMP — The procedure most directly associated with the user's search term. It drives the processing of split asset component data after create, update, or delete activity, and is the documented entry point for applying the split asset component logic end to end.

The package header also includes an add_language procedure used by the standard language-installation mechanism. The package additionally defines subtypes advv_rec_type and advv_tbl_type, which are aliases of the private package OKL_ASD_PVT record and table types (asdv_rec_type and asdv_tbl_type), used to pass asset detail records in and out of these APIs.

Tables Accessed

The ETRM metadata for this release does not enumerate the underlying physical tables accessed via APPS synonyms. Based on the package name and the OKL_ASD_PVT subtype dependency, the package operates on the OKL asset detail structures that support split asset accounting and component definition for lease contracts. The asset detail table type passed by the caller provides the component rows, and the package writes the resulting split component definitions into the lease asset tables owned by the OKL application.

Usage Notes

OKL_SPLIT_ASSET_COMP_PUB is invoked when split asset component information must be created, changed, removed, or processed in Oracle Lease and Finance Management. It is referenced by one other package, indicating it is layered beneath higher-level lease processing logic rather than being called directly by end users. Callers should follow the standard EBS API pattern: pass an API version, optionally initialize the message list, and inspect x_return_status and the message count and data outputs to detect success, warnings, or errors. Custom code that needs to manipulate split asset components should call these procedures rather than writing directly to the underlying OKL tables, to preserve validation and consistent processing behaviour across Oracle EBS 12.1.1 and 12.2.2.