Search Results get_itemcatalogtable

Overview

APPS.CZ_IMP_SINGLE is a Configuration-to-Order (C2O) and Oracle Configurator-related PL/SQL package belonging to the "CZ" (Configurator / ETRM, Enterprise Trade and Risk Management heritage scheme) namespace. In Oracle EBS 12.1.1 and 12.2.2, its principal business responsibility is the extraction and import of a single configured bill of material from an external configuration model into the Oracle Bills of Material and item structures. The package references the ETRM single-model import flow, where model nodes, exploded option classes, and associated item properties are read from staging tables and written into the production BOM. It supports the propagation of parent (root) and child configuration models, resolution of localized text and item master attributes, and produces run-level audit records for the import operation. The header comment ("$Header: czisngs.pls 120.4") indicates this is a versioned package file shipped under the standard Oracle EBS patch mechanism, with the constant declarations near the top indicating the numeric offsets used when translating Oracle item types (Product, Component, Feature, Option, Model) into the Merlin-style type codes stored in the CZ_IMP_* staging schema.

Key Procedures and Functions

The documented API surface comprises five procedures and functions:

• EXTRACTPSNODE — A function that extracts a single product-structure node from the configured model, returning a numeric identifier. It takes the run identifier, organization, top model, explosion type, server, exploder mode, revision date, date format, refresh/copy model flags, and a statistics-generation flag, consistent with the configuration exploder parameters used by the C2O engine.
• IMPORTSINGLEBILL — The core procedure that performs the import of a single configured bill into the target organization. It receives the organization, top model, child-model copy flag, refresh model identifier, root-model copy flag, explosion type, and revision date, and returns the run identifier to the caller for downstream tracing.
• ISAPPSVERSION11I — A boolean function that detects whether the current application instance is on an 11i release, allowing the package to branch its behaviour for the older EBS release line.
• IMPORTCHILDMODEL — A boolean function that imports a subordinate/child configuration model referenced by the root model, returning an indicator of success. It supports hierarchical configurations where a parent model pulls in nested child models.
• GET_ITEMCATALOGTABLE — Returns the name of the item catalog staging table (CZ_IMP_TMP_ITEMCAT) used to hold transient catalog data during the import, referenced from the package's table list.

Tables Accessed

The package reads and writes the following documented tables (accessed through APPS synonyms):

• CZ_IMP_PS_NODES, CZ_IMP_TMP_ITEMCAT — Staging tables holding product-structure nodes and the temporary item catalog produced during extraction.
• CZ_IMP_ITEM_MASTER, CZ_IMP_ITEM_TYPE, CZ_IMP_ITEM_TYPE_PROPERTY, CZ_IMP_ITEM_PROPERTY_VALUE, CZ_IMP_PROPERTY — Item master, item type, and property definition/value tables used to materialise the imported items and their configurable attributes.
• CZ_IMP_INTL_TEXT, CZ_IMP_LOCALIZED_TEXTS — Localized and international text tables providing multilingual item and option descriptions.
• CZ_IMP_DEVL_PROJECT, CZ_DEVL_PROJECTS — Development/configuration project tables linking imported models to their project context.
• CZ_MODEL_REF_EXPLS — Model reference explosion records used when resolving child models for importChildModel.
• BOM_EXPLOSIONS — The Oracle Bills of Material explosion view, read to establish existing parent-child structures and validate the imported single bill.
• CZ_DB_LOGS, CZ_DB_SETTINGS — Log and runtime settings tables that record the outcome of each import run and provide control parameters.

Usage Notes

CZ_IMP_SINGLE is an internal configuration import API rather than a public-interface package. It is invoked indirectly by the C2O "Import Configuration" concurrent program and by the configurator entity form flows that trigger an import of a previous configuration into a new order or a new model. Because it is classified under "OTHER" and is not a documented public API, callers should not rely on direct invocation; it is referenced by exactly one other package in the ETRM dependency graph, confirming its role as a subordinate utility. Implementers extending or troubleshooting single-bill imports should treat the run identifier (returned by EXTRACTPSNODE and IMPORTSINGLEBILL) as the key to correlate CZ_DB_LOGS entries with generated BOM rows, and should respect the copy-child-model and refresh-model flags, as these determine whether the import overlays or preserves existing item/BOM structures. The isAppsVersion11i branch reflects the package's original 11i-era design, with behaviour preserved for compatibility in 12.1.1 and 12.2.2.