Search Results cn_head_hierarchies




Overview
Explore in AI Chat

Overview

The APPS.CN_HEAD_HIERARCHIES_ALL_PKG package is a repository-level PL/SQL package within the Oracle EBS Channel Revenue Management (CN) module. It provides the data access and maintenance layer for header hierarchies — the hierarchical groupings used to organize and report on channel revenue, customer, and product dimension structures. In Oracle EBS 12.1.1 and 12.2.2, this package underpins the storage and retrieval of hierarchy header definitions, including their translated descriptions, by centralizing DML operations against the base, translation, and secure-view tables that make up the CN_HEAD_HIERARCHIES entity. The package carries an API classification of OTHER, indicating it is primarily an internal support package rather than a public, versioned business API. It is the foundational component consumed by higher-level hierarchy processing logic, most notably CN_DIM_HIERARCHIES_PVT.

Key Procedures and Functions

The package exposes seven documented procedures that together cover the full lifecycle of a header hierarchy record:

  • INSERT_ROW — Creates a new header hierarchy header record, establishing the primary key and base attributes in the underlying tables.
  • UPDATE_ROW — Modifies the attributes of an existing header hierarchy record.
  • DELETE_ROW — Removes a header hierarchy record and its associated translations.
  • ADD_LANGUAGE — Inserts a new language translation row for an existing hierarchy, supporting multi-language deployments.
  • LOAD_ROW — Loads a header hierarchy record, typically used during data migration, seeding, or bulk setup of hierarchy definitions.
  • TRANSLATE_ROW — Populates or refreshes the translated (TL) description columns for an existing hierarchy record in a specified language.
  • DEFAULT_HEADER — Establishes default attributes for a header hierarchy, likely invoked during creation to apply system defaults.

Each procedure operates on the DML layer only; parameter lists are not exposed in the metadata and should be confirmed against the deployed package specification in the target environment.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

  • CN_HEAD_HIERARCHIES_ALL_B — the base table holding language-independent header hierarchy attributes.
  • CN_HEAD_HIERARCHIES_ALL_TL — the translation table holding language-specific descriptions and names.
  • CN_HEAD_HIERARCHIES — the runtime header hierarchy table consumed by downstream hierarchy logic.
  • CN_HEAD_HIERARCHIES_S — the secure (organization/security-filtered) view or table used for access-controlled retrieval.
  • CN_DIM_HIERARCHIES — the dimension hierarchy definition table that ties headers to dimensional structures.
  • CN_HIERARCHY_EDGES and CN_HIERARCHY_NODES — the edge and node tables that define the actual hierarchical relationships beneath a header.
  • FND_LANGUAGES — the EBS language reference table used to validate and drive translation logic.
  • DUAL — used for single-row utility selection.

Usage Notes

CN_HEAD_HIERARCHIES_ALL_PKG is an internal package and is not intended for direct invocation from custom extensions. It is called by CN_DIM_HIERARCHIES_PVT, which is the public processing layer that forms, forms-based maintenance screens, and concurrent programs invoke for header hierarchy setup and maintenance. Administrators encounter its effects indirectly when defining or maintaining channel hierarchies in the EBS forms UI, and during multitenant or multi-org data migration where LOAD_ROW and TRANSLATE_ROW are used to seed hierarchy definitions. Because the package is documented as OTHER and depends on STANDARD together with the CN hierarchy tables, any customization should call the higher-level CN_DIM_HIERARCHIES_PVT rather than this package directly, and should respect the translation and secure-view tables to preserve multi-language and security semantics. Behavior is consistent across 12.1.1 and 12.2.2, though the 12.2.x online patching file system layout does not alter the package's logical role.