Search Results cz_lce_headers_s

Overview

APPS.CZ_LOGIC_GEN is a configuration engine package body within Oracle E-Business Suite's eTRM (Enterprise Territory and Resource Management, also delivered as the Configurator/TeleSales associated compiler framework). Its principal business function is to compile and generate executable logic — expressions, rules, and model behavior — from the metadata-driven structures stored in the CZ_ tables. Rather than embedding business rules as static PL/SQL, eTRM stores declarative definitions (expressions, rule folders, node graphs, chart cells, and property values) and relies on CZ_LOGIC_GEN to transform those definitions into generated logic at runtime or deployment time. The package is classified as OTHER in the ETRM 12.2.2 API documentation and carries VALID status in the APPS schema under both 12.1.1 and 12.2.2 release levels.

Key Procedures and Functions

The documented package exposes three program units:

• GENERATE_LOGIC__ — an internal helper, conventionally presumed to be a private implementation routine that performs the core generation work. The trailing underscore denotes a private (non-API) unit, likely a wrapper or recursive step.
• GENERATE_LOGIC_ — a further internal variant, typically an overload or refactored delegate exposing an alternate signature used by the primary entry point.
• GENERATE_LOGIC — the public entry point. It orchestrates the compilation of a logic definition, invoking the private helpers and coordinating the supporting utility calls.

Parameter lists are not documented in the available metadata; consumption should be verified against the actual package header. The three-unit naming pattern indicates that GENERATE_LOGIC is the only externally supported call.

Tables Accessed

CZ_LOGIC_GEN reads and writes a broad set of eTRM configuration tables (referenced through APPS synonyms):

• CZ_LCE_HEADERS and CZ_LCE_HEADERS_S — the logic compile/edit headers and their translated text segments. CZ_LCE_HEADERS_S is the subject of the originating search and holds locale-specific text for LCE definitions.
• CZ_EXPRESSIONS and CZ_EXPRESSION_NODES — the expression trees that are compiled into generated logic.
• CZ_RULES, CZ_RULE_FOLDERS, CZ_SIGNATURES, and CZ_SIGNATURE_ARGUMENTS — rules and their signature metadata.
• CZ_ITEM_MASTERS, CZ_ITEM_TYPE_PROPERTIES, CZ_ITEM_PROPERTY_VALUES, CZ_PROPERTIES — item and property metadata driving logic targets.
• CZ_PS_NODES, CZ_PS_PROP_VALS, CZ_EXPLMODEL_NODES_V, CZ_MODEL_REF_EXPLS — model/explosion node structures.
• CZ_DB_LOGS, CZ_DB_SETTINGS — diagnostics and configuration.
• CZ_LCE_LOAD_SPECS, CZ_EFFECTIVITY_SETS, CZ_FUNC_COMP_SPECS, CZ_DES_CHART_CELLS, CZ_DES_CHART_FEATURES, CZ_CONVERSION_RELS_V — supporting compile specifications and chart data.

It also depends on utility packages including CZ_UTILS, CZ_DEVELOPER_UTILS_PVT, CZ_FCE_COMPILE, CZ_SECURITY_PVT, FND_API, FND_GLOBAL, FND_MSG_PUB, FND_PROFILE, DBMS_SQL, and UTL_RAW.

Usage Notes

CZ_LOGIC_GEN is typically invoked indirectly rather than called from end-user forms. It is exercised during eTRM configuration deployment, when expressions or rules are compiled, and by concurrent programs that regenerate logic after metadata changes. It is referenced by two other packages and is not referenced by any table or view, indicating it is a leaf-level generator. Custom integrations should call the public GENERATE_LOGIC entry point only, relying on FND_MSG_PUB for error reporting and honoring the profile options read via FND_PROFILE.