Search Results is_valid_org

Overview

CN_OU_UTIL_PVT is a private PL/SQL utility package owned by the APPS schema in Oracle E-Business Suite. Its name follows the standard EBS naming convention: the "CN" prefix associates it with the Oracle Contracts (Core) module family, the "OU" segment indicates an Operating Unit context, and the "_PVT" suffix classifies it as a private API rather than a public, externally supported interface. As the header comment block states, the package exists to house internal helper logic rather than to expose a supported integration surface.

The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the calling schema rather than with the definer's rights of APPS. This is a deliberate design choice for a private utility: it allows the package to be invoked safely from multiple contexts, including public synonym-wrapped calls and Oracle Forms sessions, without granting broader privileges than the caller already holds. In EBS 12.1.1 and 12.2.2 the package resides in the APPS schema alongside the rest of the Contracts code base, and its source header (cnvouuts.pls, version 120.0) dates to 2005, indicating a long-stable component of the Contracts stack.

Key Procedures and Functions

The ETRM metadata documents a single public function, as follows.

• IS_VALID_ORG — A Boolean-returning function that validates whether a supplied organization identifier is a valid operating unit or organization within the Contracts context. Per the inline API comments, it accepts an organization ID and a raise-error flag, and returns a Boolean indicating validity. The metadata explicitly states the procedure "checks whether org_id is valid." It belongs to API version 1.0 and carries no pre-requisites.

No other procedures or functions are documented for this package. The documented call signature (one required organization ID parameter plus an optional raise-error indicator, returning BOOLEAN) is consistent with EBS validation utilities that either return a simple true/false result or raise a predefined application error when the caller requests it. Because the package is classified PVT, Oracle does not commit to backward compatibility for this interface, and customizations should not depend on it.

Tables Accessed

The ETRM record for CN_OU_UTIL_PVT lists no directly referenced tables via APPS synonyms. As a validation helper, the function logically must consult organization-related data — typically through views or other packages that resolve the set of valid operating units — but no base tables are documented against this package. Consumers requiring a definitive list of underlying dependencies should inspect the package body (cnvouutb.pls) in the deployed environment rather than rely on the metadata, since private packages frequently delegate their lookups to other private utilities.

Usage Notes

CN_OU_UTIL_PVT is invoked as an internal validation service. The ETRM metadata records that the package is referenced by one other package, confirming that its primary consumer is other Contracts PL/SQL code rather than external callers. Typical invocation patterns include:

• Internal Contracts logic — Other private or public Contracts packages call IS_VALID_ORG to confirm that an operating unit context is legitimate before processing contract data.
• Forms and concurrent programs — Contracts forms that prompt for an operating unit may use the same validation path indirectly, though direct calls from forms to a _PVT package are discouraged.
• Custom code — Customizations may call the function with APPS credentials, but because the package is private, any such dependency carries upgrade risk between 12.1.1 and 12.2.2 and should be treated as unsupported.

Callers should pass a valid organization ID and choose the raise-error parameter according to whether they prefer a Boolean result or an immediate application error. For new development, public Contracts APIs should be preferred over this private utility.