Results for “cn_mod_obj_depends”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CN_MOD_OBJ_DEPENDS_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Channel Revenue Management (CN) product family and is classified in the ETRM repository under the generic API classification "OTHER." The package supports the storage and retrieval of dependency relationships between objects within the Channel Revenue Management object model, specifically against the CN_MOD_OBJ_DEPENDS table. Rather than exposing a formalized public API with validation and business-rule enforcement, the package functions as a low-level data access layer for the dependency entity, providing insert and single-row retrieval operations. In practice, it is an internal utility used by the CN object framework to resolve how one modeled object references another, information that downstream processing relies upon when sequencing modifications or deployments of Channel Revenue Management object definitions.

Key Procedures and Functions

The ETRM documentation records two documented program units in this package:

• INSERT_ROW — Persists a new dependency record into the CN_MOD_OBJ_DEPENDS table. It is the mechanism by which a modeled object's dependency on another object is registered in the repository.
• SELECT_ROW — Retrieves an existing dependency record from CN_MOD_OBJ_DEPENDS, returning the attributes of the dependency for a given object relationship. It supports targeted lookups rather than set-based queries.

Both units are documented by name and purpose only; the ETRM metadata does not publish parameter lists or signatures. No public validation, update, or delete routines are documented, which is consistent with the package's classification as a non-public utility rather than a supported integration API.

Tables Accessed

The package operates against the following objects, accessed through APPS synonyms:

• CN_MOD_OBJ_DEPENDS — The primary table holding modeled object dependency definitions. INSERT_ROW writes to it and SELECT_ROW reads from it.
• CN_OBJECTS_S — The sequence used to generate identifiers for CN objects, including dependency rows inserted by this package.
• DUAL — The standard Oracle single-row utility table, typically used for sequence value retrieval and similar scalar operations.

The ETRM dependency listing further confirms that CN_MOD_OBJ_DEPENDS_PKG references the CN_MOD_OBJ_DEPENDS object and the SYS.STANDARD package, and that the package body is self-referencing. No other APPS packages are documented as referencing CN_MOD_OBJ_DEPENDS_PKG, indicating a narrow dependency footprint.

Usage Notes

Because the package is not documented as being referenced by any other package, it is not a shared integration point within the EBS codebase. It is invoked internally by Channel Revenue Management framework components when object dependency metadata must be recorded or resolved — for example, during setup of modeled objects, when their interrelationships are established, or when the framework needs to confirm that a dependency exists before proceeding with object-related processing. There is no documented form, concurrent program, or public API entry point that exposes these routines to end users or external integrations. Customizations and extensions should treat CN_MOD_OBJ_DEPENDS_PKG as an unsupported internal object: direct invocation bypasses any framework-level validation that may exist in higher layers, and the package's lack of a documented signature means callers cannot rely on stable parameter contracts. Where custom code must inspect or create modeled object dependencies, the supported approach is to use the published Channel Revenue Management APIs that govern the object model rather than calling this package directly.