Search Results cn_objects_pkg




Overview
Explore in AI Chat

Overview

CN_OBJECTS_PKG is an Oracle EBS Application Object Library (APPS) PL/SQL package that manages the CN_OBJECTS entity, part of the Channel Revenue Management / Trade Management schema. The package serves as the primary programmatic interface for creating, retrieving, and maintaining records in the CN_OBJECTS and CN_OBJECTS_ALL tables, which store object definitions used by the Channel Management module. Operations against these tables are performed through this package rather than through direct DML so that row-level integrity and consistent population of mandatory columns are guaranteed. The package body is valid in both 12.1.1 and 12.2.2, and is installed under the APPS schema with synonyms exposed to the runtime environment. The documented API classification is OTHER, indicating that it is a general-purpose data access package rather than a true Oracle public API, although it is referenced by five other database objects within the application.

Key Procedures and Functions

  • INSERT_ROW — Inserts a single new object record into the CN_OBJECTS tables, applying the mandatory column values and audit defaults required by the entity.
  • SELECT_ROW — Retrieves an existing object record, returning its attributes to the calling program for display or validation.
  • LOAD_ROW — Loads a row from a seed or staging context, typically used when migrating or seeding object data across environments.
  • LOAD_SEED_ROW — Loads seed data rows, used during setup and installation to populate the base CN_OBJECTS content supplied by Oracle.

Parameter lists are intentionally omitted here because the ETRM metadata documents only the procedure names and their purpose. Callers should confirm exact signatures against the deployed package specification before use.

Tables Accessed

  • CN_OBJECTS — The base object definition table, accessed for insert and select operations by INSERT_ROW and SELECT_ROW.
  • CN_OBJECTS_ALL — The installation-independent (ALL) variant of the object table, referenced for multi-org aware operations and during seed loading via LOAD_ROW and LOAD_SEED_ROW.

Both tables are referenced through APPS synonyms. The package also depends on the SYS STANDARD package, as expected for any PL/SQL unit, and on the CN_OBJECTS_PKG specification itself.

Usage Notes

CN_OBJECTS_PKG is positioned as an internal data access layer for the Channel Management objects entity. It is referenced by five other packaged objects, indicating that higher-level business logic in the Channel Revenue Management modules calls into this package rather than manipulating CN_OBJECTS or CN_OBJECTS_ALL directly. Typical invocation paths include setup forms and concurrent programs that seed or maintain object definitions, as well as migration utilities that use LOAD_ROW and LOAD_SEED_ROW when transferring object data between environments. Because the package is documented as not referenced by any database object outside these five dependents, customizations should prefer express registration or a supported Channel Management API where one exists. Direct calls from custom code are possible but are not covered by Oracle support, and developers should treat INSERT_ROW, SELECT_ROW, LOAD_ROW, and LOAD_SEED_ROW as subject to change between point releases. When integrating, the safest approach is to call the package only from within the same application schema context, honoring the APPS synonym resolution and the multi-org access rules that govern CN_OBJECTS_ALL.