Search Results cz_expression_nodes_s

Overview

APPS.CZ_MODEL_CONVERT is a VALID package body within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 schema, belonging to the Oracle Configurator (CZ) product family and the broader ETRM (Enterprise Trade and Resource Management) modules. Its name and dependency footprint indicate that it serves as a model-conversion and transformation utility, responsible for translating, migrating, or normalizing configuration model definitions between representations used by the Configurator runtime and its supporting metadata tables. Oracle Configurator stores the structural, textual, and rulebased elements of a configuration model across a normalized set of tables (models, nodes, features, expressions, rules, UI definitions, and texts). CZ_MODEL_CONVERT coordinates movement of that metadata—converting models, generating and resolving UI navigation paths, and resolving UI element identifiers—while logging its activity through the CZ_DB_LOGS mechanism and the FND_LOG framework.

The package is classified as OTHER in the ETRM API registry, meaning it is an internal implementation utility rather than a public, supported integration API. The metadata states that APPS.CZ_MODEL_CONVERT is not referenced by any other database object, so its invocation surface is external: it is called by forms, concurrent programs, or administrative scripts rather than by other PL/SQL packages.

Key Procedures and Functions

The documented interface exposes four procedures and functions:

• CONVERTMODELS — The principal entry point for the package. It performs the model-level conversion activity, iterating the configuration models identified for conversion and orchestrating the transformation of their dependent metadata. It is the routine most likely registered behind a concurrent program or menu action.
• MODEL_CONVERT_CP — The concurrent-program driver procedure (CP conventionally denotes concurrent program). It is designed to be launched from the standard concurrent manager, invoking the conversion logic and reporting status through FND_FILE and FND_CONC_GLOBAL.
• GET_UI_PATH — A resolution function that returns the UI navigation path for a given Configurator UI object, traversing the UI definition, UI node, and page-element metadata to build the path string used by the runtime and administration screens.
• GET_UI_ELEMENT_ID — A resolution function returning the identifier of a specific UI element, used to map logical UI components to their stored definitions during conversion and rendering.

The registered metadata does not document parameter signatures; consumers should inspect the package specification in the target instance before calling these routines directly.

Tables Accessed

Through APPS synonyms, the package touches a broad slice of Configurator metadata. Model and structure tables include CZ_PS_NODES, CZ_MODEL_PUBLICATIONS, CZ_MODEL_REF_EXPLS, CZ_DES_CHART_FEATURES, and CZ_DEVL_PROJECTS. Expression and rule metadata is handled via CZ_EXPRESSION_NODES and CZ_EXPRESSION_NODES_S (the _S suffix denoting the seeded/standard variant), together with CZ_RULES, CZ_RULES_S, and CZ_RULE_FOLDERS and CZ_RULE_FOLDERS_S. Localization and text content is read and written through CZ_INTL_TEXTS, CZ_INTL_TEXTS_S, and CZ_LOCALIZED_TEXTS. The UI layer is addressed by CZ_UI_DEFS, CZ_UI_NODES, CZ_UI_PAGE_ELEMENTS, CZ_UI_TEMPLATES, CZ_UI_TEMPLATE_ELEMENTS, and CZ_UI_CONT_TYPE_TEMPLS. Audit and diagnostic output is captured in CZ_DB_LOGS, while supporting infrastructure dependencies include CZ_PB_MGR, CZ_PB_MODEL_EXPORTS, CZ_SIGNATURES, CZ_RULE_TEXT_GEN, CZ_UTILS, CZ_DEVELOPER_UTILS_PVT, and CZ_TYPES, alongside FND_CONCURRENT, FND_FILE, FND_GLOBAL, FND_LOG, FND_MESSAGE, FND_MSG_PUB, FND_PROFILE, and FND_REQUEST.

The user query cz_expression_nodes_s is directly relevant: CZ_EXPRESSION_NODES_S is one of the seeded expression tables this package references when converting rule expressions.

Usage Notes

Because the object is not referenced by any other database object, it is invoked externally. Typical scenarios include running the model-conversion concurrent program (via MODEL_CONVERT_CP) after applying a patch, upgrade, or localization change to the Configurator repository, or executing CONVERTMODELS manually during model migration. GET_UI_PATH and GET_UI_ELEMENT_ID are helper routines intended to be called from Configurator administration forms or custom PL/SQL that must resolve UI navigation and element identity. As the package is classified OTHER and is proprietary Oracle code, direct custom invocation should be restricted to implementation or support scenarios, with changes logged to CZ_DB_LOGS for traceability.