Search Results cz_logic_gen




Overview
Explore in AI Chat

Overview

APPS.CZ_LOGIC_GEN is a PL/SQL package owned by the APPS schema that forms part of the Oracle E-Business Suite Configure-to-Order (CTO) and Oracle Configurator infrastructure. Its documented status is VALID, and it is classified under the ETRM as an "OTHER" API rather than a public or private API surface. The package is responsible for generating the runtime logic that drives configuration models within the Configurator engine. In practice, CZ_LOGIC_GEN takes the declarative metadata defined by a modeler — expressions, expression nodes, design chart features and cells, and item type properties — and translates that metadata into executable logic that the Configurator runtime can evaluate when a user configures an item.

The package sits at the boundary between the modeling layer and the runtime evaluation layer. It depends on APPS.CZ_UTILS for shared configuration utilities and on FND_GLOBAL for session context such as the current user, responsibility, and application identifiers. Because it is referenced by other packages including CZ_MODELOPERATIONS_PUB and CZ_UPGRADE, it is invoked both during normal model operations and during upgrade or migration activity that requires regeneration of stored logic.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents three program units, all of which are variations of the same logical operation:

  • GENERATE_LOGIC — The primary entry point. It drives the generation of configuration logic for the associated model or model entity.
  • GENERATE_LOGIC_ — A single-underscore variant, typically an internal or overloaded form retained for backward compatibility or for alternative invocation contexts.
  • GENERATE_LOGIC__ — A double-underscore variant, conventionally the most private or internal form of the routine, used by the package itself and by tightly coupled callers.

The naming convention of trailing underscores indicates progressive encapsulation within the same logical operation rather than distinct business functions. Parameter lists are not documented in the ETRM metadata and should be confirmed against the package specification in the target instance before direct invocation.

Tables Accessed

Through APPS synonyms, the package reads and writes a substantial set of Configurator tables. CZ_EXPRESSIONS and CZ_EXPRESSION_NODES hold the modeled rule definitions that are converted into evaluable logic. CZ_DES_CHART_FEATURES and CZ_DES_CHART_CELLS store design chart structure and cell-level constraints. CZ_ITEM_MASTERS, CZ_ITEM_PROPERTY_VALUES, and CZ_ITEM_TYPE_PROPERTIES supply the item and property metadata that expressions reference. CZ_FUNC_COMP_SPECS and CZ_LCE_LOAD_SPECS relate to functional component specifications and load specification records, while CZ_LCE_HEADERS and CZ_LCE_HEADERS_S hold lead configuration entity header data, including the secure ( _S ) variant. CZ_EFFECTIVITY_SETS provides date-effective context, CZ_DEVL_PROJECTS links generated logic to development projects, and CZ_DB_SETTINGS and CZ_DB_LOGS supply runtime configuration parameters and diagnostic logging respectively.

Usage Notes

Direct invocation of CZ_LOGIC_GEN by end users is not supported; the package is an internal engine component. It is most commonly triggered indirectly through model publication and maintenance flows in Oracle Configurator Developer and through the CZ_MODELOPERATIONS_PUB API. It is also invoked by CZ_UPGRADE during EBS upgrade processing when stored logic must be regenerated to match the target release, and this is why behavior can differ between 12.1.1 and 12.2.2. Custom code that manipulates Configurator metadata directly should call the supported public APIs rather than this package. Because the package writes to CZ_DES_CHART_* and expression tables, any regeneration should be performed in a controlled window with adequate backups of the affected model definitions.