Results for “cz_developer_utils_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.CZ_DEVELOPER_UTILS_PVT is a private PL/SQL utility package within the Oracle E-Business Suite configuration management framework, historically associated with the Oracle Configurator and its underlying Configurator Developer / rule engine runtime. The package is declared with AUTHID CURRENT_USER, meaning that its SQL statements execute under the privileges of the invoking user rather than the defining user, which is typical of internal helper packages that must operate within the caller's security context. Its primary business function is to provide low-level developer and administrative services that support the modeling, manipulation, copying, path resolution, and deletion of configuration model artifacts — including rules, rule folders, repositories, UI definitions, and model nodes. It underpins the operations that Oracle Configurator Developer performs when assembling and maintaining the structure of configuration models and their associated business rules.

Key Procedures and Functions

The package exposes a large internal API (68 documented program units). The documented procedures and functions cluster into several functional groups:

• Rule text manipulation: REPLACE_RULE_TEXT updates node names within rule text, and PARSE_TO_STATEMENT converts rule text into an executable statement form.
• Rule and folder copying: COPY_RULE, COPY_RULE_FOLDER, COPY_REPOSITORY_FOLDER, and COPY_PS_SUBTREE replicate rules, folders, repository structures, and product-structure subtrees during model administration.
• Path resolution: GET_ABSOLUTE_MODEL_PATH, GET_FULL_MODEL_PATH, GET_RELATIVE_MODEL_PATH, GET_ABSOLUTE_LABEL_PATH, GET_FULL_LABEL_PATH, GET_NODE_LABEL, GET_REPOSITORY_PATH, and GET_RULE_FOLDER_PATH resolve internal identifiers into human-readable or hierarchical path and label representations.
• Deletion utilities: DELETE_MODEL_NODE, DELETE_UI_DEF, and DELETE_RULE_FOLDER remove model, UI, and folder definitions.
• Reporting and validation: START_MODEL_REPORT and END_MODEL_REPORT bracket model report generation, while IS_VAL_NUMBER performs numeric validation.

Header constants such as COMPONENT_TYPE, REFERENCE_TYPE, FEATURE_TYPE, and the RULE_TYPE_* family define the classification codes used throughout the package to identify node and rule categories.

Tables Accessed

The package reads and writes configuration repository data through APPS synonyms. Documented tables include CZ_RULE_FOLDERS and CZ_EXPRESSION_NODES for the rule hierarchy; CZ_DES_CHART_CELLS and CZ_DES_CHART_FEATURES for design chart structures; CZ_ITEM_MASTERS, CZ_ITEM_TYPES, and CZ_ITEM_PROPERTY_VALUES for item and feature data; CZ_EFFECTIVITY_SETS and CZ_FILTER_SETS for effectivity and filtering; CZ_FCE_FILES, CZ_ARCHIVES, and CZ_ARCHIVE_REFS for stored files and archive references; CZ_DB_LOGS and CZ_DB_SETTINGS for logging and configuration settings; and CZ_DEVL_PROJECTS for developer project metadata.

Usage Notes

As a PVT (private) package, CZ_DEVELOPER_UTILS_PVT is not a public API and is not intended for direct invocation by end users or external applications. It is referenced by 19 other packages, confirming its role as an internal dependency of higher-level Configurator APIs and concurrent programs. It is typically invoked indirectly through Oracle Configurator Developer forms and batch processes during model maintenance, rule migration, and structure operations. The header reference to czdevus.pls 120.13 indicates a mature, patched codebase whose last recorded revision predates the 12.1.1 and 12.2.2 releases, so its behavior is consistent across both versions. Custom code should avoid calling this package directly, since its signature and internal logic may change without a public API guarantee.