Search Results cn_obj_procedures_v_pkg




Overview
Explore in AI Chat

Overview

CN_OBJ_PROCEDURES_V_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. In the EBS object architecture, a package whose name carries the _V_PKG suffix typically acts as a thin procedural wrapper layered over a database view; the embedded _V indicates that the package exposes the row set produced by the underlying view CN_OBJ_PROCEDURES_V through callable PL/SQL entry points. The package therefore exists to present the content of that view as a programming interface, so that Oracle Forms, concurrent programs, and custom extensions can manipulate and retrieve the view's rows without embedding direct SQL against it. In ETRM 12.2.2 the package is documented as VALID and is classified under the generic OTHER API category, which reflects its role as an internal helper rather than a public, versioned business API.

Key Procedures and Functions

The ETRM metadata documents two procedures within the package:

  • INSERT_ROW — Inserts a row into the underlying view/entity. Because the package is view-backed, INSERT_ROW performs the insert against the base object behind CN_OBJ_PROCEDURES_V, providing a controlled, encapsulated path for creating records that the view then reflects.
  • SELECT_ROW — Retrieves a single row from the view, returning the attribute values for the requested record. This is used where an application needs a specific row's contents rather than a full query result set.

No parameter lists are documented, and the metadata does not enumerate any additional programs beyond these two, nor does it identify the primary key columns involved. Both procedures operate on the view's row type as a whole, consistent with the standard EBS pattern for view-based packages.

Tables Accessed

The documented tables referenced through APPS synonyms are:

  • CN_OBJECTS_S — The base table behind the view. Reads by SELECT_ROW and writes by INSERT_ROW ultimately resolve to this table. The name indicates it holds the object records exposed by CN_OBJ_PROCEDURES_V.
  • DUAL — The SYS-supplied single-row table, used for expression evaluation and to satisfy standard SELECT constructs within the package body.
  • CN_OBJ_PROCEDURES_V — The view on which the package depends. It provides the row type and column structure that both procedures operate against.

The package additionally depends on the SYS.STANDARD package, which is an implicit dependency of every PL/SQL unit.

Usage Notes

As a view-backed package with only INSERT_ROW and SELECT_ROW, CN_OBJ_PROCEDURES_V_PKG is normally invoked from Oracle Forms or from custom PL/SQL that needs to create and read individual records in the object-procedures view. The metadata records no other package referencing it, so it is not part of an inter-package call chain; it is called directly by client code. Because the package is classified as OTHER and is not a versioned public API, developers should treat it as subject to change between EBS releases (12.1.1 versus 12.2.2) and should validate behavior after patching. For multi-row processing, direct queries against CN_OBJ_PROCEDURES_V are preferable; the package is best reserved for the single-row insert and fetch operations it documents.