Search Results cz_network_api_pub




Overview
Explore in AI Chat

Overview

APPS.CZ_NETWORK_API_PUB is the public PL/SQL interface for network-related configuration operations in Oracle Configurator (product code CZ). It is owned by the APPS schema, classified as a public API, and declared AUTHID CURRENT_USER. The package exposes the entry points that Oracle Configurator and its dependent applications use to generate, modify, and interrogate configuration trees that describe how configurable models, options, and items relate to one another within a configuration session.

The package is registered in ETRM with the display name "Network API", an active lifecycle, and a scope of internal, with the business entity category CZ_CONFIG. Its documented purpose is to provide the public interface for operations on configurations in Oracle Configurator, spanning tree generation, container determination, model containment queries, item addition checks, RMA eligibility checks, and item deactivation. It is referenced by eleven other packages, which confirms its role as a shared service layer rather than an end-user-facing component.

Key Procedures and Functions

  • GENERATE_CONFIG_TREES — Generates configuration trees for a given set of configuration header identifiers and revision numbers. This is the primary documented entry point, accepting a configuration PL/SQL table, a tree copy mode, an application parameter record, and a validation context, and returning an output configuration table plus the standard API status trio (return status, message count, message data).
  • ADD_TO_CONFIG_TREE — Adds a node or item into an existing configuration tree structure.
  • GET_CONTAINED_MODELS — Retrieves the models contained within a given configuration context, supporting hierarchical navigation of the configuration.
  • IS_CONTAINER — Evaluates whether a specified configuration element functions as a container for other elements.
  • IS_CONFIGURABLE — Determines whether an item or model is eligible to participate in configuration.
  • IS_ITEM_ADDED — Reports whether a particular item has already been added to the configuration tree, used to prevent duplicate placement.
  • IS_RMA_ALLOWED — Indicates whether return material authorization is permitted for the configuration or item in question.
  • EXT_DEACTIVATE_ITEM — Provides an external entry point to deactivate a configuration item.
  • VALIDATE — Performs validation of configuration data prior to commit or further processing.

All procedures follow the Oracle EBS PL/SQL API standard of an inbound API version parameter and outbound return status, message count, and message data parameters, allowing callers to handle errors uniformly.

Tables Accessed

  • CZ_CONFIG_HDRS and CZ_CONFIG_HDRS_S — Configuration header and header translation tables; the source of configuration identity and revision information.
  • CZ_CONFIG_ITEMS — Configuration item records that populate generated trees.
  • CZ_CONFIG_MESSAGES — Stores validation and processing messages surfaced through the API status outputs.
  • CZ_PS_NODES — Persistent structure nodes representing the configuration hierarchy.
  • CZ_DB_SETTINGS and CZ_DB_LOGS — Runtime settings and diagnostic logging used during API execution.
  • CZ_DEVL_PROJECTS — Development project context associated with configurator models.
  • MTL_SYSTEM_ITEMS_B — Master item definitions referenced when validating configurable and RMA-eligible items.
  • DUAL, PLITBLM, UTL_HTTP, and UTL_RAW — Utility and PL/SQL table support objects used for scalar queries, table handling, and any network or encoding operations implied by the package name.

Usage Notes

CZ_NETWORK_API_PUB is invoked programmatically rather than from a user interface. Typical callers include Oracle Configurator runtime logic, concurrent programs that pre-generate configuration trees, order capture and order management flows that validate configurable items, and custom extensions that need to inspect or extend a configuration tree. Custom code should call only the documented public procedures, supply a valid API version, and inspect x_return_status before consuming output tables.

The package is declared AUTHID CURRENT_USER, so privileges are evaluated against the invoking schema; in EBS this normally resolves through APPS synonyms. Because it reads and writes core Configurator tables, it should be invoked within the caller's transaction so that rollback semantics remain consistent. The "Network API" display name and the use of UTL_HTTP and UTL_RAW indicate that portions of the package support network or remote configuration communication, but the documented public surface remains the tree and item operations listed above.