Search Results cz_refs




Overview
Explore in AI Chat

Overview

APPS.CZ_REFS is a VALID PL/SQL package body in the Oracle E-Business Suite APPS schema, belonging to the Oracle Configurator (CZ) product family. It functions as a structural reference management engine for Configurator models, governing the relationships, nodes, and reference explanations that define how configurable items are assembled and validated within a model hierarchy. In EBS 12.1.1 and 12.2.2, the package supports both the runtime and design-time behavior of Configurator by maintaining the reference ("ref") structures that connect model nodes, features, UI definitions, and rule expressions. Its API classification is OTHER, indicating it is an internal implementation package rather than a public published interface. The ETRM documentation records 18 procedures and functions, and the package is referenced by four other packages, confirming it is a foundational utility within the Configurator codebase.

Key Procedures and Functions

The documented routines address node lifecycle, reference validation, and structural maintenance:

  • ISNONVIRTUAL – Determines whether a node represents a non-virtual (concrete) element, distinguishing real model components from virtual placeholders.
  • CHECK_NODE – Validates a node's integrity within the model structure.
  • DELETE_NODE – Removes a node and its associated references from the model.
  • MOVE_NODE – Repositions a node within the hierarchy, supporting model restructuring.
  • CHECK_REF_REQUEST – Evaluates a reference request for validity before processing.
  • GET_NODE_UP / GET_NODE_DOWN – Traverse the model tree upward and downward to locate parent or child nodes.
  • ADD_REFERENCE – Inserts a new reference relationship between model elements.
  • CHANGE_STRUCTURE – Applies structural modifications to the reference tree.
  • SOLUTIONBASEDMODELCHECK – Verifies solution-based model constraints.
  • SET_TRACKABLE_CHILDREN_FLAG – Manages the flag controlling whether child nodes are tracked.
  • UPDATE_CHILD_NODES – Propagates updates to dependent child nodes.
  • UPDATE_NODE_DEPTH – Recalculates and persists node depth values.
  • RESET_MODEL_ARRAY – Clears in-memory model array state.
  • POPULATE_COMPONENT_ID – Assigns or retrieves component identifiers for nodes.
  • VALIDATE_INST_FLAG – Validates the instantiation flag on a node.
  • CHECK_INST_RULE – Enforces instantiation rules during validation.
  • POPULATE_PARENT_EXPL_TREE – Builds the parent explanation tree used for reference explanations.

Tables Accessed

CZ_REFS reads and writes across the Configurator data model. Core reference and explanation data resides in CZ_MODEL_REF_EXPLS and CZ_MODEL_REF_EXPLS_S, which store model reference explanations and their translated/alternate records. Structural hierarchy is held in CZ_PS_NODES, CZ_EXPRESSION_NODES, and CZ_FUNC_COMP_SPECS. UI-related definitions are touched through CZ_UI_DEFS, CZ_UI_PAGES, CZ_UI_PAGE_ELEMENTS, CZ_UI_PAGE_REFS, CZ_UI_PAGE_SETS, and CZ_UI_ACTIONS. Feature combination and rule logic draws on CZ_COMBO_FEATURES, CZ_DES_CHART_CELLS, CZ_DES_CHART_COLUMNS, CZ_DES_CHART_FEATURES, CZ_RULES, and CZ_RP_ENTRIES. Project and run context come from CZ_DEVL_PROJECTS and CZ_XFR_RUN_INFOS_S. Utility and diagnostic calls rely on CZ_UTILS, FND_LOG, and FND_MSG_PUB, with DUAL, STANDARD, and PLITBLM providing standard PL/SQL support.

Usage Notes

CZ_REFS is invoked internally by Configurator forms, concurrent programs, and dependent packages during model definition, validation, and runtime configuration. Because it is referenced by four other packages and does not itself reference any, it occupies a mid-level position in the dependency chain. Developers extending or debugging Configurator model behavior should treat CZ_REFS as an internal API; direct custom calls should be avoided in favor of supported Configurator interfaces, and any dependency changes must be reviewed against the calling packages to prevent validation failures.