Search Results csi_org_unit_vld_pvt




Overview
Explore in AI Chat

Overview

CSI_ORG_UNIT_VLD_PVT is a private PL/SQL validation package owned by APPS in Oracle E-Business Suite, shipped as part of the Enterprise Data Quality / Item Instance (CSI) module. Its stated purpose is to centralize the integrity checks that govern the relationship between item instances and the operating units to which they are assigned. The $Header line (csivouvs.pls 120.0 ... 2007/01/16) confirms it is an internal helper unit whose naming convention (_PVT) marks it as private, meaning it is intended for consumption by sibling CSI packages and public APIs rather than by external callers or direct customer code.

The package declares AUTHID CURRENT_USER, so all SQL inside executes with the privileges of the invoking session, a design choice typical of validation routines that must respect the caller's security context when reading the CSI tables.

Key Procedures and Functions

The ETRM metadata documents sixteen procedures and functions. Their names group into recognizable validation families:

No parameter lists are reproduced here; the excerpt shows that most functions accept an instance or operating-unit id and an optional p_stack_err_msg boolean that controls whether errors are stacked for downstream reporting.

Tables Accessed

The package reads and writes through APPS synonyms:

  • CSI_ITEM_INSTANCES — the master item instance record; used by the instance validators and by IS_UPDATABLE to determine whether the instance is in a state that permits further assignment changes.
  • CSI_I_ORG_ASSIGNMENTS — the base assignment table linking an instance to an operating unit; the target of the effective-date and operating-unit checks.
  • CSI_I_ORG_ASSIGNMENTS_H, _H_S, _S — the history and secondary/history-sequence tables that preserve prior assignments, referenced by GET_CIS_I_ORG_ASSIGN_H_ID and the alternate-key and expiry routines.
  • CSI_TRANSACTIONS — used to confirm that instance activity is consistent with the validity of an assignment.
  • DUAL — standard single-row queries for constant evaluation.

Usage Notes

The package is referenced by four other packages, consistent with its private classification. It is not exposed through a concurrent program or an Oracle Forms window directly; instead it is invoked from the public CSI item-instance APIs and from the assignment maintenance logic that manages the operating-unit relationship. A user searching on "VSS company" is typically looking for the operating-unit or company assignment path in the CSI hierarchy, and this package is the layer that validates the company/operating-unit id before the assignment row is inserted or updated. Custom code should not call it directly; the supported entry points are the public CSI APIs, which invoke these private validators internally. Because the functions return BOOLEAN, they cannot be called from SQL and must be used from PL/SQL. The p_stack_err_msg flag should be left at its default when calling from APIs that rely on the standard error stack for user-facing messages.