Search Results get_current_pdh_revision

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:

• EGO_IMPORT_BATCHES_B — The batch header table that identifies the import batch under comparison.
• EGO_ITEM_MATCHES — Stores item matching results produced during the import comparison.
• EGO_ITM_USR_ATTR_INTRFC — The user-defined attribute interface table for imported item attribute values.
• EGO_OBJ_TYPE_LIFECYCLES and FND_OBJECTS, FND_FORM_FUNCTIONS — Provide object type and lifecycle metadata used to resolve the object being imported and its lifecycle context.
• MTL_SYSTEM_ITEMS_B and MTL_ITEM_REVISIONS — The production item master and revision tables against which imported items and revisions are compared.
• MTL_ITEM_CATALOG_GROUPS_B — The catalog group definition used to resolve catalog assignments during comparison.
• FND_NEW_MESSAGES — Used to surface messages associated with comparison outcomes.
• DBMS_SQL and PLITBLM — Dynamic SQL and PL/SQL table manipulation facilities supporting runtime construction of the comparison logic.

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.