Search Results csi_i_parties_pkg




Overview
Explore in AI Chat

Overview

CSI_I_PARTIES_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the CSI (Complex Sourcing and Installation / Enterprise Asset Management inventory) module family and provides the low-level Data Manipulation Language (DML) interface for the CSI_I_PARTIES entity. The package's classification is listed as OTHER, meaning it is not a public application programming interface in the same sense as a traditional open interface or public API; rather it functions as an internal, table-level DML handler generated for the entity and used by other packages within the same module.

In practice the package encapsulates the standard four operations required to maintain rows in the CSI_I_PARTIES base entity: insert, update, lock, and delete. These operations abstract the underlying table structure — including the associated _S (translation) table — from the calling code. The package is a dependent object on the SYS.STANDARD package and is referenced by CSI_PARTY_RELATIONSHIPS_PVT, indicating its role as a supporting building block within the CSI party relationships subsystem.

Key Procedures and Functions

Four documented procedures constitute the package interface:

  • INSERT_ROW — Inserts a new row into the CSI_I_PARTIES entity. It performs the base-table insert and synchronizes the corresponding translation row in CSI_I_PARTIES_S, including standard WHO (audit) columns and the language/translation columns required by the MLS-enabled table design.
  • UPDATE_ROW — Modifies an existing CSI_I_PARTIES row. It applies updated attribute values to the base table and, where translated columns are supplied, correspondingly updates the _S translation table for the relevant language rows.
  • LOCK_ROW — Acquires a row-level lock on the specified CSI_I_PARTIES record, typically used before an update or delete to enforce concurrency control and prevent conflicting concurrent modifications by other sessions.
  • DELETE_ROW — Removes a row from CSI_I_PARTIES, including the associated translation rows in CSI_I_PARTIES_S, completing the lifecycle of the entity record.

Parameter lists are not reproduced here; callers should inspect the package specification for exact signatures.

Tables Accessed

The package operates against two documented objects, accessed through APPS synonyms:

  • CSI_I_PARTIES — The base entity table. Insert, update, lock, and delete operations all target this table. It stores the primary party-related records for the CSI integration entity.
  • CSI_I_PARTIES_S — The multilingual (translation) table associated with CSI_I_PARTIES. Because the entity supports translated descriptive columns, INSERT_ROW and UPDATE_ROW maintain the corresponding _S rows, while DELETE_ROW removes them.

The base-plus-translation design is standard for EBS entities that store user-facing text in multiple installed languages.

Usage Notes

CSI_I_PARTIES_PKG is an internal handler rather than a publicly documented API. It is intended to be invoked by other packages in the CSI schema — most directly by CSI_PARTY_RELATIONSHIPS_PVT — and not by end users directly. Customizations that need to create, modify, or remove CSI_I_PARTIES records should route through the appropriate higher-level public API (such as the CSI party relationships private API) rather than calling this package's DML procedures directly, in order to preserve validation, defaulting, and business-rule enforcement. Direct invocation is generally limited to the owning subsystem and to tightly controlled custom code that fully replicates the surrounding business logic. As with all APPS-schema code, any extension must be carefully regression-tested across 12.1.1 and 12.2.2, since the package remains VALID in both releases.