Results for “sort_options”

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

Overview

APPS.CZ_RUNTIME is a runtime support package within the Oracle E-Business Suite Configure-to-Order (CTO) and Oracle Configurator infrastructure. It belongs to the CZ schema family of packages that manage configurable models, runtime user interface definitions, model publications, and configuration hierarchies. The package operates with AUTHID CURRENT_USER, meaning that name resolution and privilege checking are performed against the invoking user rather than the package owner.

In the EBS 12.1.1 and 12.2.2 releases, CZ_RUNTIME serves as a helper library for the Oracle Configurator runtime engine. Its principal responsibilities include resolving annotated node paths through a model's UI definition hierarchy, determining the depth at which a target page reference occurs within that hierarchy, enumerating the UI pages reachable from a root UI definition, ordering configurator options according to a sort sequence, locating the root bill-of-material node of a model, and retrieving header-level configuration information. These operations are foundational to rendering the Configurator user interface and to persisting and validating user selections against the underlying model structure. The package also exposes utility functions for embedded publications tied to items, products, and saved configurations.

Key Procedures and Functions

The documented API surface comprises nine procedures and functions:

• ANNOTATED_NODE_PATH — Returns a VARCHAR2 representing the annotated path to a target node, calculated from root model, target page explanation, target UI definition, target page persistence, and root model explanation identifiers.
• GET_TARGET_PAGE_REF_DEPTH — Returns the numeric depth of a target page reference relative to a root model and its explanation.
• GET_TARGET_UI_PAGES — Populates a collection of target UI pages reachable from a given root UI definition and model node, honoring node collection and ordering parameters.
• SORT_OPTIONS — Reorders a caller-supplied sort table according to a UI definition, property, and sort order value.
• GET_ROOT_BOM_NODE — Retrieves the root BOM node identifier for a model, returning error flags for ambiguous or missing nodes.
• GET_CONFIG_INFO — Returns configuration header attributes such as component, top item, organization, quantity, usage, effective date, and creation date.
• EMBEDDED_PUBLICATION_FOR_ITEM, EMBEDDED_PUBID_FOR_PRODUCT, and EMBEDDED_PUB_FOR_SAVEDCONFIG — Resolve embedded publication identifiers for items, products, and saved configurations respectively.

Tables Accessed

CZ_RUNTIME reads and writes across the principal CZ configuration tables through APPS synonyms. Configuration headers and line items are represented by CZ_CONFIG_HDRS and CZ_CONFIG_ITEMS, with CZ_CONFIG_MESSAGES holding runtime messages. Item metadata is drawn from CZ_ITEM_MASTERS, CZ_ITEM_PROPERTY_VALUES, and CZ_ITEM_TYPE_PROPERTIES. Model structure and publication data reside in CZ_MODEL_PUBLICATIONS, CZ_MODEL_REF_EXPLS, and CZ_MODEL_USAGES, while properties are defined in CZ_PROPERTIES. Persisted runtime state is stored in CZ_PS_NODES and CZ_PS_PROP_VALS. User interface definitions and hierarchy are provided by CZ_UI_DEFS, CZ_UI_NODES, and CZ_UI_PAGES.

Usage Notes

CZ_RUNTIME is invoked internally by Oracle Configurator runtime forms and concurrent processes rather than being called directly by end users. It is referenced by one other package, confirming its role as a shared runtime dependency. Customizations that extend or wrap Configurator behavior may call these APIs, but because parameters are positional and tightly coupled to internal model structures, direct invocation should be limited to supported extension points. The package header carries a version stamp from 2005, indicating it has remained stable across the 12.1.1 and 12.2.2 releases.