Search Results csi_i_assets_s

Overview

APPS.CSI_I_ASSETS_PKG is the installation-layer PL/SQL package associated with the CSI_I_ASSETS entity in Oracle E-Business Suite Release 12.1.1 and 12.2.2. The _I_ prefix identifies it as part of the interface (open-interface / staging) family of CS (CSI) APIs, distinct from the base (non-interface) entity packages. Its purpose is to provide the transactional entry points required to populate, maintain, and remove rows in the interface table CSI_I_ASSETS, which serves as the inbound staging area for asset records that are subsequently validated and processed into the enterprise asset repository. Because it is an interface table package, its scope is deliberately narrow: it performs single-row DML against the staging table with minimal business logic, leaving validation, derivation, and promotion to the consuming processor. The documented API classification is "OTHER," indicating that it is not a full public business API (such as the standard OEO/TCA interfaces) but rather an internal, package-under-the-entity implementation.

Key Procedures and Functions

The package exposes four documented routines, each aligned to a standard single-row DML verb:

• INSERT_ROW — Creates a new record in the CSI_I_ASSETS interface table. This is the primary entry point used by external or upstream processes to stage an asset that is to be validated and processed.
• UPDATE_ROW — Modifies an existing staged interface record, typically used to correct or complete data before the interface processor consumes the row.
• LOCK_ROW — Acquires a row-level lock on a specified interface record, providing concurrency control so that a record being processed or edited cannot be simultaneously modified by another session.
• DELETE_ROW — Removes a staged interface record, generally after successful processing or when a record is rejected as invalid.

The metadata lists no documented parameters for these routines, and none are asserted here.

Tables Accessed

The package references two object dependencies through APPS synonyms:

• CSI_I_ASSETS — the interface (staging) table in which inbound asset records are held pending processing. INSERT_ROW, UPDATE_ROW, LOCK_ROW, and DELETE_ROW all operate against this table.
• CSI_I_ASSETS_S — the companion sequence (or translated reference) object used by the package to obtain the unique identifier assigned to interface rows on insert. This mirrors the standard EBS convention in which the _S suffix denotes the sequence that supplies the primary key for the corresponding _I_ table.

Additional standard dependencies include APP_EXCEPTION, FND_API, FND_MESSAGE, DUAL, and STANDARD, indicating that the package uses the common EBS error-handling and messaging facilities (FND_MESSAGE / APP_EXCEPTION) and the FND_API layer for consistent return-status semantics.

Usage Notes

CSI_I_ASSETS_PKG is normally invoked programmatically rather than interactively. Typical callers are concurrent programs, feeder programs, or custom data-conversion routines that load asset interface data prior to running the asset interface processor. In custom code, the routines are called within a transaction that first locks the target row, applies the insert, update, or delete, and then commits, with errors surfaced through the FND_MESSAGE/APP_EXCEPTION stack. The package is documented as not being referenced by any other database object, and it references one other package (itself, per the dependency listing) while being referenced by one package overall — confirming its role as a leaf-level DML helper. Because it is an interface-layer package, it should be used only against CSI_I_ASSETS staging data and not against the production asset tables directly.