Results for “pls_integer”

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

Overview

CZ_IMP_IM_MAIN is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite and is classified as an OTHER API in the ETRM repository. Its name indicates that it belongs to the Oracle Configurator / Configurator Model import family (the "CZ_IMP_IM" prefix), and its role is to drive the import and validation of item-related configuration data from staging tables into the production Configurator tables. The package is declared AUTHID CURRENT_USER, meaning that its database objects are resolved and privileges evaluated under the invoking schema's security context rather than the APPS schema. The header comment ($Header: cziimmns.pls 120.1.12020000.2) confirms the file was last shipped for the 12.1 / 12.2 release stream. The package exposes three logical groups of procedures — validation (CND_), import/maintenance (MAIN_), and reporting (RPT_) — that together form a complete staging-to-production pipeline for items, item types, properties, and item type properties used by Oracle Configurator.

Key Procedures and Functions

The 15 documented procedures fall into three families, all of which share a common signature pattern using PLS_INTEGER parameters, which is why the package surfaces in searches for pls_integer:

• Validation procedures (CND_): CND_ITEM_MASTER, CND_ITEM_PROPERTY_VALUE, CND_ITEM_TYPE, CND_ITEM_TYPE_PROPERTY, and CND_PROPERTY each validate a distinct staging entity. They accept an inRUN_ID, COMMIT_SIZE, and MAX_ERR, and return a FAILED counter (declared IN OUT NOCOPY PLS_INTEGER) indicating how many rows failed validation. These routines are used to pre-screen data before the main import runs.
• Import procedures (MAIN_): MAIN_ITEM_MASTER, MAIN_ITEM_PROPERTY_VALUE, MAIN_ITEM_TYPE, MAIN_ITEM_TYPE_PROPERTY, and MAIN_PROPERTY perform the actual insertion and update of validated rows. In addition to the run parameters, they return counters for INSERTS, UPDATES, FAILED, DUPS, NOCHANGE, and accept an inXFR_GROUP VARCHAR2 filter to scope the transfer to a specific transfer group.
• Reporting procedures (RPT_): RPT_ITEM_MASTER, RPT_ITEM_PROPERTY_VALUE, RPT_ITEM_TYPE, RPT_ITEM_TYPE_PROPERTY, and RPT_PROPERTY extract and present run results — typically error listings and success statistics — for each staging entity.

Tables Accessed

The package reads and writes the CZ_IMP_* staging synonyms — CZ_IMP_ITEM_MASTER, CZ_IMP_ITEM_PROPERTY_VALUE, CZ_IMP_ITEM_TYPE, CZ_IMP_ITEM_TYPE_PROPERTY, and CZ_IMP_PROPERTY — which hold the inbound extracted data. Production configuration data is stored in CZ_PROPERTIES and related base tables. Run-level metadata and outcome statistics are tracked in CZ_XFR_RUN_INFOS and CZ_XFR_RUN_RESULTS, keyed by inRUN_ID. The package additionally references DBMS_UTILITY and the PLITBLM PL/SQL table helper package for utility and collection handling.

Usage Notes

CZ_IMP_IM_MAIN is not invoked directly from EBS forms. It is normally called by the Configurator import concurrent programs, which pass the run ID, commit size, and error threshold and receive back the aggregate result counters. Because the procedures use NOCOPY OUT integer parameters, callers should pass properly initialised PLS_INTEGER variables. Two other packages in the ETRM repository reference CZ_IMP_IM_MAIN, indicating it sits mid-tier in the import architecture. Custom code should call it only against validated staging data and should respect the inXFR_GROUP scoping argument to avoid reprocessing rows. The AUTHID CURRENT_USER declaration means the invoking user must hold appropriate privileges on all CZ_IMP_* and CZ_* objects.