Search Results ego_import_batch_compare_pvt




Overview
Explore in AI Chat

Overview

The APPS.EGO_IMPORT_BATCH_COMPARE_PVT package is a private (PVT) PL/SQL package in the Oracle E-Business Suite application schema. It supports the Oracle Product Information Management (PIM) and Item Catalog import framework, specifically the process by which batch import records are validated against existing production master data before they are committed to the base tables. During an import cycle, records staged in the interface tables are compared against the current definition of items, revisions, catalog groups, and object lifecycle states. The package supplies the comparison logic that determines whether an incoming import record represents a new object, a change to an existing object, or a revision that already exists in the production master. Its classification as PVT indicates it is an internal implementation package called by the public-facing import batch API rather than a documented integration entry point for customer code. In 12.1.1 and 12.2.2 the package status is VALID, and its declared dependencies are limited to the schema elements required to resolve dynamic SQL and construct the comparison view used during batch processing.

Key Procedures and Functions

The package exposes three documented procedures and functions that encapsulate the batch comparison workflow:

  • GET_COMPARED_DATA — Retrieves the dataset produced by comparing the imported batch records against the corresponding production master records. This routine is the primary data access point of the package and returns the composite result that downstream import logic evaluates to decide the disposition of each staged record.
  • GET_CURRENT_PDH_REVISION — Obtains the current production revision associated with the product data hub record being evaluated. This allows the import comparison to determine the current baseline revision against which the incoming batch row must be reconciled.
  • REV_EXISTS_IN_PDH — Determines whether a specified revision already exists in the product data hub. The result is used to prevent duplicate revision creation and to classify the incoming record appropriately during the comparison pass.

Tables Accessed

The package operates against a defined set of interface, master, and reference tables accessed through APPS synonyms:

Usage Notes

This package is invoked internally during the item and catalog batch import flow, typically through the public import batch API and its associated concurrent programs. It is not intended for direct invocation from forms or customer-written code, and because it is classified as a private package, its signatures should be treated as subject to change across patch levels and releases. Customizations that require batch comparison behavior should call the supported public API rather than this PVT package. The package is documented as referenced by zero other packages, confirming that its callers reside in the import batch execution layer rather than in reusable API code.