Search Results okl_ass_seq

Overview

OKL_ASS_PVT is the private implementation package body for the Oracle Lease and Finance Management (OLFM) asset API layer in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It belongs to the APPS schema and carries the PVT (private) classification, meaning it is intended to be called only by its companion public wrapper, OKL_ASS_PVT, rather than invoked directly by external code. The package is responsible for the persistence logic behind asset records in the OKL tables, handling language-specific rows, insert, update, and delete operations against the OKL_ASSETS base and translation tables. Assets in OLFM represent the leased or financed items that underpin contracts, so this package provides the transactional backbone that keeps asset definitions consistent across multilingual installations. Its validity status is VALID, and it sits within the OKL (Lease) product family of modules.

Key Procedures and Functions

• INSERT_ROW — Creates a new asset record. It establishes the base row in the asset table and the associated translatable attributes, applying standard EBS API conventions such as attribute validation and message publication through FND_MSG_PUB.
• UPDATE_ROW — Modifies an existing asset record, applying the supplied changes while respecting API-level validation and concurrency conventions.
• DELETE_ROW — Removes an asset record, logically or physically depending on the product's data-retention model, together with its dependent translated rows.
• ADD_LANGUAGE — Inserts translated rows for a new language. This supports multilingual deployments where asset descriptions must exist in each installed language defined in FND_LANGUAGES.

The package metadata documents seven procedures or functions in total; the four named above are the principal entry points. All follow the OLFM private API pattern, delegating standard validation and message handling to OKL_API and FND_API, and never being invoked directly by external callers.

Tables Accessed

• OKL_ASSETS_B — The base table holding language-independent asset columns. Written by INSERT_ROW, UPDATE_ROW, and DELETE_ROW.
• OKL_ASSETS_TL — The translation table holding language-dependent asset text. Populated by INSERT_ROW and ADD_LANGUAGE, and updated or deleted alongside base rows.
• OKL_ASS_SEQ — The sequence used to generate primary keys for new asset records, directly relevant to the searched term "okl_ass_seq". INSERT_ROW draws its next ID from this sequence.
• OKL_ASSETS_V — A view over the asset tables, referenced for validation or retrieval of asset data during API processing.

The package also references FND_LANGUAGES and FND_MSG_PUB for language validation and message publication, plus DUAL for lightweight queries and PLITBLM and STANDARD as standard PL/SQL dependencies.

Usage Notes

OKL_ASS_PVT should never be called directly by customer code. In standard OLFM processing, asset records are created and maintained through the OLFM asset user interface, through concurrent programs that import asset data, or through the public OKL_ASS API wrapper. The public wrapper performs caller validation before delegating to this private body, so custom integrations must target the public package. The metadata notes that OKL_ASS_PVT is not referenced by any database object, confirming its role as a terminal implementation layer, while the seven packages that reference it operate through the public interface. Because OKL_ASS_SEQ supplies the unique asset identifiers, any direct manipulation of asset tables that bypasses this package risks sequence and integrity conflicts; all asset persistence should be routed through the documented API.