Search Results csi_systems_s

Overview

APPS.CSI_SYSTEMS_B_PKG is the base-table maintenance package for the Oracle E-Business Suite "Systems" entity within the Install Base (CSI) product family. It encapsulates the DML operations required to create, modify, lock, delete, and translate records in the CSI_SYSTEMS_B base table and its associated translation and security tables. The package is classified as an OTHER API in ETRM, meaning it functions as a low-level, internal implementation layer rather than a publicly supported business API. Its primary purpose is to provide a controlled, consistent mechanism for persisting system definition data — such as installed system registrations and their descriptive attributes — while centralizing validation, concurrency control, and multi-language handling logic.

The package's name follows the standard EBS convention in which the _B_PKG suffix identifies a base (non-translated) table maintenance package, typically paired with a _S_PKG security or sequence package. In the ETRM dependency listing, CSI_SYSTEMS_B_PKG references CSI_SYSTEMS_S and is itself referenced by another package, indicating it participates in a wider chain of Install Base object maintenance routines. It relies on standard EBS infrastructure components including APP_EXCEPTION, FND_API, FND_MESSAGE, and FND_LANGUAGES, which together supply error handling, API return-status conventions, message resolution, and language-installation awareness.

Key Procedures and Functions

The package exposes seven documented procedures, each targeting a specific DML or translation responsibility:

• INSERT_ROW — Creates a new row in the CSI_SYSTEMS_B base table, populating the standard WHO columns and assigning the primary key from the underlying sequence.
• UPDATE_ROW — Modifies an existing base-table record, applying the caller's changed attributes and refreshing the audit columns.
• UPDATE_ROW_FOR_MU — Performs an update variant intended for multi-org or multi-update scenarios, allowing the row to be maintained where standard update semantics are insufficient.
• LOCK_ROW — Obtains a row-level lock on the target system record, preserving concurrency control when a caller needs to validate or stage changes before committing.
• DELETE_ROW — Removes a system row from the base table, typically after dependent data has been cleared.
• ADD_LANGUAGE — Inserts a corresponding translated row into CSI_SYSTEMS_TL for a newly installed or newly supported language, using FND_LANGUAGES to determine the applicable language set.
• TRANSLATE_ROW — Updates the translated descriptive columns in CSI_SYSTEMS_TL for a specified row and language.

Parameter signatures are not documented in the ETRM excerpt and are deliberately omitted here.

Tables Accessed

• CSI_SYSTEMS_B — The base table holding non-translatable system attributes; the target of INSERT_ROW, UPDATE_ROW, UPDATE_ROW_FOR_MU, LOCK_ROW, and DELETE_ROW.
• CSI_SYSTEMS_TL — The translation table storing language-specific descriptive text; written by ADD_LANGUAGE and TRANSLATE_ROW.
• CSI_SYSTEMS_S — The sequence or security table supplying key values for new base rows.
• FND_LANGUAGES — Queried to resolve installed languages and the base language code used during translation processing.

All tables are referenced through APPS synonyms, so the package operates in the APPS schema without explicit schema qualification.

Usage Notes

CSI_SYSTEMS_B_PKG is not intended for direct invocation by end users or external integrations. It is ordinarily called by higher-level Install Base logic — including the package that references it and any Oracle Forms or concurrent programs that maintain system definitions — which handle validation and public API contracts before delegating persistence to this layer. Customizations should therefore avoid calling the procedures directly and instead use the supported CSI public APIs. Any extension that does invoke this package must preserve the WHO audit columns, respect the LOCK_ROW/UPDATE_ROW sequence for concurrency, and ensure that translation rows are inserted through ADD_LANGUAGE whenever a new language is enabled. Because the package is currently VALID and marked as logically referenced by one other package, changes to its behavior can cascade into dependent Install Base maintenance routines.