Search Results cn_objects_s




Overview
Explore in AI Chat

Overview

CN_OBJ_TRIGGERS_V_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM repository as an "OTHER" API type. Its name follows the naming convention of the Oracle Advanced Product Catalog and Common Objects infrastructure (the CN product prefix), indicating that it belongs to the object metadata and catalog management subsystem rather than to a traditional transactional module such as Order Management or Payables. The "_V_PKG" suffix and its relationship to the CN_OBJ_TRIGGERS_V view identify it as a view-support package, a lightweight wrapper whose primary purpose is to expose controlled Data Manipulation Language operations against the CN_OBJ_TRIGGERS_V database view and its underlying base table, CN_OBJECTS_S. In EBS 12.1.1 and 12.2.2, this package provides the programmatic bridge between the catalog object definition layer and any form, concurrent program, or custom component that needs to insert or retrieve object trigger definitions without writing directly against the base tables.

Key Procedures and Functions

The ETRM metadata documents two procedures and functions within this package body:

  • INSERT_ROW — Handles the insertion of a new trigger definition row into the base object. Because the package sits on top of a view, INSERT_ROW performs the view-to-base-table mapping required to persist the incoming attribute values into the underlying storage.
  • SELECT_ROW — Retrieves a single trigger definition record, returning the attribute set associated with a specified object trigger entry. This is the read counterpart to INSERT_ROW and is typically the entry point used by forms when populating a block.

No parameter lists are published in the ETRM extract, and per standard practice the exact signatures should be confirmed against the live package specification in the target instance before invoking the procedures from custom code.

Tables Accessed

The dependency listing records two referenced objects through APPS synonyms:

  • CN_OBJECTS_S — the base sequence/storage table underlying the object catalog. INSERT_ROW writes to this table, and SELECT_ROW reads from it. CN_OBJECTS_S is the persistence layer for catalog object definitions, including the trigger metadata surfaced by CN_OBJ_TRIGGERS_V.
  • DUAL — used for single-row PL/SQL evaluations and control logic, consistent with a standard PL/SQL package body.

The package also depends on the CN_OBJ_TRIGGERS_V view and on CN_OBJ_TRIGGERS_V_PKG itself, reflecting internal self-references within the specification and body.

Usage Notes

Because CN_OBJ_TRIGGERS_V_PKG is a view-support package, it is normally invoked indirectly. Oracle Forms based on the CN_OBJ_TRIGGERS_V data block call INSERT_ROW and SELECT_ROW through the standard block-level triggers generated by the Oracle Forms runtime. The package is also available to custom PL/SQL that needs to create or read object trigger definitions atomically, which makes it a safer integration point than direct DML against CN_OBJECTS_S, since the view-based mapping and any validation in the package body are preserved. Developers searching for "cn_objects_s" are typically investigating where catalog object rows originate; CN_OBJ_TRIGGERS_V_PKG is one of the documented packages that touches that base table. The ETRM metadata states that this package is not referenced by any other database object, so its callers are external — forms, concurrent programs, or custom code — rather than other packaged APIs. As with all APPS-owned seeded packages, modification of the body is not supported, and the 12.1.1 and 12.2.2 releases should be treated as the authoritative source for its actual behavior.