Search Results cz_rules_s

Overview

APPS.CZ_CX_UTIL_PVT is a private PL/SQL utility package body in the Oracle E-Business Suite Configurator (also known as Oracle Configurator or CZ) schema. It is classified as a PVT (private) API, meaning it is intended for internal use by other Configurator packages rather than being called directly by external code or end users. The package contains shared helper logic used across the Configurator runtime and setup infrastructure to resolve and evaluate configuration rules, convert values, and interact with the underlying rule, model, and user-interface metadata tables.

The object is marked VALID and resides in the APPS schema, which is standard for EBS 12.1.1 and 12.2.2 installations. As a utility package, it does not expose formal public APIs but instead centralizes reusable functions referenced by sibling packages such as CZ_UTILS and the Configurator processing engines. The search term "cz_rules_s" that surfaced this object points to a documented dependency: CZ_CX_UTIL_PVT references the CZ_RULES_S synonym, indicating it participates in rule-definition and rule-evaluation processing.

Key Procedures and Functions

ETRM documentation records one documented program unit in this package body:

• CONVERT_FC_BY_MODEL — Converts a functional/currency (FC) value using model-specific reference information. The name and dependency footprint (CZ_MODEL_REF_EXPLS, CZ_RULES) suggest it applies model reference expressions or conversion logic during configuration evaluation, likely to translate a user-selected value into the model's representation or currency basis. No parameter list is documented and should not be assumed.

Additional helper routines may exist in the compiled body beyond the documented set; only CONVERT_FC_BY_MODEL is captured in the ETRM metadata. The private classification means these routines are called internally by other Configurator packages, not by customer extensions.

Tables Accessed

The package body references the following tables via APPS synonyms, reflecting its role in rules, model, and UI resolution:

• CZ_RULES and CZ_RULES_S — Rule definitions and their runtime surrogate, used when evaluating or converting values in the context of a rule.
• CZ_RULE_FOLDERS — Organizational grouping of rules, supporting rule lookup by folder hierarchy.
• CZ_MODEL_REF_EXPLS — Model reference expressions, central to CONVERT_FC_BY_MODEL's conversion logic.
• CZ_FUNC_COMP_SPECS — Functional component specifications, used to identify the component context of a conversion.
• CZ_RP_ENTRIES — Runtime/parameter entries tied to configuration processing.
• CZ_UI_DEFS, CZ_UI_NODES, CZ_UI_NODE_PROPS — User-interface definition, node, and node-property metadata, supporting UI-aware resolution.
• CZ_DB_SETTINGS — Configurator database-level settings and profile-like configuration.
• DUAL and PLITBLM — Standard Oracle single-row and PL/SQL index-by table helper constructs.

Usage Notes

Because CZ_CX_UTIL_PVT is a PVT package, it is invoked indirectly — typically from Configurator runtime packages, the Configurator UI (Oracle Forms / OAF pages), or Configurator concurrent programs that evaluate model rules and convert values. In EBS 12.1.1 and 12.2.2 the package body compiles against the CZ schema synonyms and depends on CZ_UTILS and CZ_CX_UTIL_PVT itself. ETRM records that it is not referenced by any other database object, confirming its role as a leaf-level utility consumed within the Configurator engine rather than by external customizations. Developers troubleshooting rule or model conversion behavior should inspect this body through the "show dependent code" path in ETRM, but should avoid direct calls since private packages are unsupported for extension.