Results for “ego_ipi_dataset_id_s”

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

Overview

APPS.EGO_ITEM_PEOPLE_IMPORT_PKG is a PL/SQL package body in the Oracle E-Business Suite application schema (APPS) that belongs to the EGO (Engineering/Product Information) module family. Its core business function is to support the import of item-to-people relationship data — that is, the association of people (employees, contacts, or parties) with items — into the Oracle EBS item master through the open interface tables. The package operates as part of the broader item people import mechanism, which allows organizations to bulk-load item-people assignments from external sources or staging tables rather than entering them manually.

The package is classified as an "OTHER" API type in the ETRM metadata, indicating it is primarily an internal implementation body rather than a public, versioned interface API such as those built on the FND_API framework conventions. Despite the presence of FND dependencies, it is not intended for direct third-party invocation. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents three procedures/functions within this package body:

• GET_CURR_DATASET_ID — Returns the current dataset identifier used to scope an import run. This function is closely tied to the EGO_IPI_DATASET_ID_S sequence, which the package references as a dependency. The dataset ID acts as a logical grouping key that isolates one batch of interface records from another during processing.
• LOAD_INTERFACE_LINES — Performs the primary load operation, moving or transforming staged item-people data into the interface structures that feed the item import process. It interacts with EGO_ITEM_PEOPLE_INTF, the interface table that holds inbound records prior to validation and import into the item master.
• PURGE_INTERFACE_LINES — Removes processed or obsolete interface records associated with a dataset, providing housekeeping and preventing the accumulation of stale rows in EGO_ITEM_PEOPLE_INTF and related staging tables.

Tables Accessed

The package reads and writes several documented tables via APPS synonyms. EGO_ITEM_PEOPLE_INTF is the central interface table where item-people assignment records are loaded, validated, and eventually consumed. EGO_IPI_DATASET_ID_S and EGO_IPI_TRANSACTION_ID_S are sequences that generate unique identifiers for each import dataset and transaction. EGO_LOGIN_ITEMS_TEMP serves as a temporary staging structure. HZ_PARTIES (and HZ_RELATIONSHIPS) supplies party and relationship data for resolving the people side of the assignment. MTL_INTERFACE_ERRORS records validation failures encountered during processing. Various FND tables — FND_FORM_FUNCTIONS, FND_GRANTS, FND_MENUS, FND_MENUS_TL, FND_MENU_ENTRIES, FND_NEW_MESSAGES, and FND_OBJECTS — support security, menu, and messaging lookups. UTL_FILE is referenced, indicating file-based input or output handling.

Usage Notes

EGO_ITEM_PEOPLE_IMPORT_PKG is typically invoked indirectly rather than called directly by end users. Its LOAD_INTERFACE_LINES and PURGE_INTERFACE_LINES procedures are most commonly driven by a concurrent program that accepts a dataset or batch identifier, processes the staged interface rows, and then purges them. Custom code that loads records into EGO_ITEM_PEOPLE_INTF often relies on GET_CURR_DATASET_ID to obtain the correct dataset key before inserting rows and invoking the loading logic. Because the package is referenced by one other package and is not itself referenced by any database object, it should be treated as an internal worker package; implementations should avoid depending on its signature and instead integrate through the documented interface tables and concurrent programs.