Search Results cz_config_items_s

Overview

APPS.CZ_CONFIG_API_PVT is the private implementation package body for the Oracle E-Business Suite Configure-to-Order (CTO) configuration API. It resides in the APPS schema with a PVT classification, indicating that it holds the internal business logic that is exposed to callers only through the public wrapper package CZ_API_PUB. The dependency listing confirms this relationship: CZ_CONFIG_API_PVT references CZ_API_PUB, while CZ_CONFIG_API_PVT itself is not referenced by any database object other than by its own internal calls, reinforcing its role as a private worker unit.

Its primary business function is to manage configuration data structures that describe configurable items within the CTO model, including configuration headers, configuration items, their attributes, extended attributes, input values, and the messages generated during configuration processing. In the context of Oracle EBS 12.1.1 and 12.2.2, this package supports the runtime validation and duplication of configured item definitions and instances. A user searching for the synonym cz_config_items_s is typically investigating the configuration item sequence object, which this package touches indirectly through the CZ_CONFIG_ITEMS and CZ_CONFIG_ITEMS_S tables during its processing logic.

Key Procedures and Functions

The ETRM documentation records three documented routines within this package body:

• COPY_CONFIGURATION — Creates a duplicate of an existing configuration definition or configuration instance. It reads source records and inserts corresponding rows into the configuration headers, items, attributes, and input tables, preserving the structural relationships required by the CTO model.
• COPY_CONFIGURATION_AUTO — Performs an automated, variant-driven copy of a configuration. It applies defaulting and automatic generation rules when reproducing a configuration, reducing manual input where the configuration model permits deterministic reproduction.
• VERIFY_CONFIGURATION — Validates a configuration by checking that the header, item, attribute, and input records are internally consistent and meet the constraints enforced by the Configurator. It is the routine that surfaces errors through the FND message stack, populating the CZ_CONFIG_MESSAGES tables as needed.

No parameter lists are documented, so callers should reference the public wrapper package CZ_API_PUB for the supported signatures.

Tables Accessed

The package reads from and writes to the core CTO configuration tables via APPS synonyms:

• CZ_CONFIG_HDRS, CZ_CONFIG_HDRS_S — configuration header records and their sequence/primary key source.
• CZ_CONFIG_ITEMS, CZ_CONFIG_ITEMS_S — configuration line items and the sequence object that generates cz_config_items_s identifiers.
• CZ_CONFIG_ATTRIBUTES, CZ_CONFIG_EXT_ATTRIBUTES, CZ_CONFIG_INPUTS — item-level attributes, extended attributes, and user-entered input values retained with a configuration.
• CZ_CONFIG_MESSAGES, CZ_CONFIG_MESSAGES_S — diagnostic and validation messages generated during verification and copy operations.
• CZ_DB_SETTINGS — configuration repository settings that govern behavior such as defaulting and numbering.
• ALL_TAB_COLUMNS, DUAL, PLITBLM — data dictionary and utility references used for dynamic column or construct handling.

Usage Notes

Because this is a private package body, it is never invoked directly by end users. It is called from the public API CZ_API_PUB, which is in turn invoked by the Oracle Configurator user interface, by CTO-enabled Oracle Forms, and by concurrent programs that process configuration copy or validation. Custom extensions should call CZ_API_PUB rather than CZ_CONFIG_API_PVT to remain upgrade-safe across 12.1.1 and 12.2.2. The package depends on FND_API, FND_MSG_PUB, FND_MESSAGE, CZ_UTILS, and CZ_IB_TRANSACTIONS, so its execution depends on a valid FND message stack and an initialized application context.