Search Results cz_intl_texts_s




Overview
Explore in AI Chat

Overview

CZ_IMP_IM_XFR is an Oracle Application Object Library package body owned by the APPS schema within the Oracle E-Business Suite. In EBS 12.1.1 and 12.2.2, it belongs to the Oracle Configurator / Oracle Advanced Product Catalog (CZ) family of objects that support item master and configuration model management. Its principal business function is to transfer or convert records held in the CZ interface (CZ_IMP_*) staging tables into the corresponding base CZ entities, notably item masters, item types, item type properties, item property values, and property definitions. The package therefore acts as a controlled movement layer between the import interface structures and the persistent Configurator repository, while also managing the associated localized and internationalized text records.

The package is documented as VALID and is classified under API classification OTHER, indicating that it is intended as an internal utility rather than a published public API. The grep term that surfaced this object, cz_intl_texts_s, corresponds to the CZ_INTL_TEXTS_S sequence referenced by the package, which supplies unique keys for internationalized text rows generated during the transfer of item master and property data.

Key Procedures and Functions

The package exposes five documented procedures, each mapping to a distinct interface-to-base transfer concern:

Each procedure follows the same architectural pattern: read the validated interface row, insert or update the corresponding base CZ row, resolve localized text via CZ_INTL_TEXTS_S and CZ_LOCALIZED_TEXTS, and preserve language context using FND_LANGUAGES.

Tables Accessed

The package references both interface and base tables, all through APPS synonyms:

  • Interface tables: CZ_IMP_ITEM_MASTER, CZ_IMP_ITEM_PROPERTY_VALUE, CZ_IMP_ITEM_TYPE, CZ_IMP_ITEM_TYPE_PROPERTY, and CZ_IMP_PROPERTY hold staged import data awaiting transfer.
  • Base CZ tables: CZ_ITEM_MASTERS, CZ_ITEM_PROPERTY_VALUES, CZ_ITEM_TYPES, CZ_ITEM_TYPE_PROPERTIES, CZ_PROPERTIES, CZ_PS_PROP_VALS, and CZ_RP_ENTRIES receive the transferred data.
  • Text and language tables: CZ_INTL_TEXTS_S (sequence), CZ_LOCALIZED_TEXTS, and FND_LANGUAGES support multilingual descriptions and localized properties.
  • Supporting objects: CZ_ADMIN, CZ_UTILS, and STANDARD provide administrative and utility routines; DUAL and PLITBLM are used for standard PL/SQL constructs.

Usage Notes

CZ_IMP_IM_XFR is not referenced by any database object, confirming it is a top-level driver rather than a called subprogram. It is typically invoked by the Oracle Configurator import/conversion processes, including concurrent programs that publish or convert item master and model data, and by custom extensions that need to move staged CZ interface records into the base repository. Because the package writes directly to core CZ tables, it should be executed within the standard import workflow, with committed interface data and valid FND_LANGUAGES configuration, to ensure localized text and property values are generated correctly.