Search Results delete_itm_cat_rv_prcs

Overview

The APPS.OKL_ITM_CAT_RV_PRCS_PUB package is a public PL/SQL API within the Oracle E-Business Suite (EBS) Enterprise Contracts / Oracle Lease and Finance Management (OKL) module. It governs the processing of item category residual value rules and their associated processing records. The package is defined with AUTHID CURRENT_USER, meaning that its execution privileges are determined by the invoking schema rather than the owning schema, which is standard for ETRM public APIs intended to be called from diverse execution contexts.

The package follows the Oracle Application Object Library (AOL) API conventions, incorporating standard constants such as G_APP_NAME (derived from OKL_API.G_APP_NAME), G_API_VERSION, and the FND_API return status indicators (G_RET_STS_SUCCESS, G_RET_STS_ERROR, and G_RET_STS_UNEXP_ERROR). These conventions ensure consistent error handling, message stack management, and API versioning across EBS integration points. The header date shows this specification dates to release 12.0.0 (2005), and it remains a documented public interface in 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes a documented set of public program units that implement the standard CRUD-plus-validation pattern. The ten documented procedures and functions are:

• INSERT_ITM_CAT_RV_PRCS — Creates a new item category residual value processing record. This is the procedure targeted by the search term insert_itm_cat_rv_prcs. It accepts API versioning, initialization message list control, and standard output parameters for return status and message count.
• LOCK_ITM_CAT_RV_PRCS — Acquires a row-level lock on the specified processing record, typically used to enforce serialized access before a subsequent update or delete.
• UPDATE_ITM_CAT_RV_PRCS — Modifies an existing item category residual value processing record, supporting the standard API versioning and message-handling parameters.
• DELETE_ITM_CAT_RV_PRCS — Removes the specified processing record, subject to any business validation enforced by the package.
• VALIDATE_ITM_CAT_RV_PRCS — Performs business-rule validation on the record before it is inserted or updated, ensuring data integrity prior to persistence.

Supporting these public units is a private package (OKL_ICP_PVT) that defines the record type icpv_rec_type and the table type icpv_tbl_type, which are re-exposed through the public specification via subtypes. This structure promotes reuse of the internal data structures for both single and bulk processing.

Tables Accessed

The documented metadata does not enumerate the specific base tables referenced through APPS synonyms. The public API relies on private helper packages (notably OKL_ICP_PVT) that operate against the underlying lease and finance item category residual value processing tables. In practice, operations on OKL_ITM_CAT_RV_PRCS records read and write the item category residual value processing entity, which stores the association between item categories and their valuation processing rules. Because the API is defined against APPS synonyms, callers need only have execute privileges on the package and the corresponding object grants, rather than direct table access.

Usage Notes

This package is typically invoked from Oracle Forms user interface code, from concurrent programs, or from custom integration code that needs to create, modify, delete, or validate item category residual value processing records. The presence of the p_api_version and p_init_msg_list parameters means callers must pass the supported API version and may optionally request message stack initialization. The return status output parameter should always be checked for G_RET_STS_SUCCESS before proceeding, with the message count and message stack retrieved via standard FND_MSG_PUB calls on failure. The package is referenced by one other package, indicating it forms part of a layered API structure where higher-level business flows call this public interface rather than manipulating the underlying tables directly.