Search Results cz_imp_all




Overview
Explore in AI Chat

Overview

APPS.CZ_IMP_ALL is a PL/SQL package in the Oracle E-Business Suite 12.1.1 / 12.2.2 environment, owned by the APPS schema and classified as an "OTHER" API object rather than a formal public API. It is a component of the Oracle Configurator / model import and transfer infrastructure, and its naming (CZ_IMP_*) reflects its role as the master import driver for model and price-list data moving between source and target environments. The package orchestrates the import lifecycle: it prepares staging tables, populates model records, links bills to an import run, executes the actual transfer, cleans up afterward, and maintains a per-run status and return code. Because the package is referenced by eleven sibling packages — including CZ_IMP_AC_MAIN, CZ_IMP_IM_MAIN, CZ_IMP_PR_MAIN, CZ_IMP_SINGLE, and CZ_MODELOPERATIONS_PUB — it acts as the central coordinator that those specialized import routines call into, rather than being invoked only at the top level itself.

Key Procedures and Functions

The ETRM metadata documents 20 procedures and functions in the package. The most significant are grouped as follows:

  • GO, GO_CP, GO_GENERIC, GO_GENERIC_CP — the top-level execution entry points. GO and GO_CP drive a full (multi-model) import, while the GENERIC variants provide the reusable driver logic. The _CP suffixes denote concurrent-program wrapper entry points.
  • IMPORT_BEFORE_START / IMPORT_AFTER_COMPLETE — lifecycle hooks invoked to prepare the environment before an import and to finalize state, release resources, or trigger post-processing once it completes.
  • POPULATE_TABLE and POPULATEMODELS_CP / POPULATESINGLEMODEL_CP — routines that load model data into staging or working tables, in both full and single-model modes.
  • GOSINGLEBILL / GOSINGLEBILL_CP and ADDBILLTOIMPORT / SETSINGLEBILLSTATE — single-bill import processing, including adding a bill to the current import run and managing its state.
  • REFRESHMODELS and REMOVEMODEL — model maintenance: refreshing existing models and removing models from the import set.
  • SETRUNID, SETRECSTATUS, SETRETURNCODE — bookkeeping routines that record the run identifier, per-record status, and the overall return code used by callers to detect success or failure.
  • CHECK_FOR_COMMON_BILL and REPORT — diagnostic helpers that test for shared bill definitions and produce reporting output for the run.

Tables Accessed

The package reads and writes the CZ_XFR_* transfer tables and related CZ configuration tables, all accessed through APPS synonyms:

  • CZ_XFR_PROJECT_BILLS / _S and CZ_XFR_PRICE_LISTS — the source records representing project bills and price lists being imported.
  • CZ_XFR_RUN_INFOS / _S — run-level control and status records keyed by the run id set via SETRUNID.
  • CZ_XFR_TABLES — the registry of tables participating in a transfer, used to determine what must be populated and cleaned up.
  • CZ_PRICE_GROUPS / _S — price group definitions associated with imported models.
  • CZ_SERVERS and CZ_DB_SETTINGS — environment and server configuration that govern where and how the import executes.
  • DBMS_APPLICATION_INFO, DBMS_SQL, DBMS_UTILITY, DUAL, PLITBLM — standard Oracle infrastructure packages used for session instrumentation, dynamic SQL, utility calls, and PL/SQL table handling.

Usage Notes

CZ_IMP_ALL is typically invoked through concurrent programs or orchestration routines rather than from a user-facing form, since the _CP entry points (GO_CP, POPULATEMODELS_CP, GOSINGLEBILL_CP) are designed as concurrent-program drivers. It is also called programmatically by the eleven dependent packages that manage asset, inventory, and pricing import variants, and custom code integrating with Configurator transfers may invoke it directly. Because it is classified as OTHER and not a supported public API, customizations should call it with caution and re-validate behavior across 12.1.1 to 12.2.2 upgrades, as internal procedure signatures are not guaranteed to be stable.