Search Results ego_ag_bulkload_pvt




Overview
Explore in AI Chat

Overview

The APPS.EGO_AG_BULKLOAD_PVT package body is a private (PVT) PL/SQL implementation owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It supports the bulk loading and validation of attribute groups and their associated data levels and attributes within the Oracle Product Information Management / Advanced Product Catalog (EGO) module. Attribute groups represent logical groupings of item or object attributes used in the attribute group framework, and the bulk load interface permits large volumes of attribute group definitions to be staged, validated, and imported through interface tables rather than entered manually.

The package operates primarily against the interface tables EGO_ATTR_GROUPS_INTERFACE, EGO_ATTR_GROUPS_DL_INTERFACE, and EGO_ATTR_GROUP_COLS_INTF. Its driving process status constant is G_PROCESS_RECORD, which identifies interface rows that the concurrent program has been instructed to process. The package encapsulates the entire bulk load lifecycle: initialization, normalization, value-to-ID resolution, validation, construction of base-table records, and import.

Key Procedures and Functions

The package exposes 39 documented procedures and functions. INITIALIZE seeds interface rows, assigns transaction IDs from MTL_SYSTEM_ITEMS_INTERFACE_S, upper-cases TRANSACTION_TYPE, resolves the EGO application ID, stamps WHO columns (CREATED_BY, LAST_UPDATED_BY, REQUEST_ID, PROGRAM_ID), and counts rows matching G_PROCESS_RECORD into G_AG_COUNT.

Validation logic is distributed across VALIDATE_TRANSACTION_TYPE, BULK_VALIDATE_ATTR_GROUPS, BULK_VALIDATE_ATTRIBUTE, ADDITIONAL_AGDL_VALIDATIONS, ADDITIONAL_ATTR_VALIDATIONS, COMMON_AG_VALIDATIONS, COMMON_DL_VALIDATIONS, and COMMON_ATTR_VALIDATIONS. These routines verify that staged attribute groups, data levels, and attributes conform to the expected metadata model before import.

Value resolution is handled by VALUE_TO_ID_AG, VALUE_TO_ID_DL, VALUE_TO_ID_ATTR and their bulk equivalents VALUE_TO_ID_AG_TBL, VALUE_TO_ID_DL_TBL, and VALUE_TO_ID_ATTR_TBL, which convert user-supplied flex value names into internal identifiers. Construction routines CONSTRUCT_ATTR_GROUPS, CONSTRUCT_AG_DATA_LEVEL, and CONSTRUCT_ATTRIBUTE build the parent records. IMPORT_AG_INTF and PROCESS_ATTR_GROUPS drive the final write into the base tables.

Tables Accessed

Interface-side tables include EGO_ATTR_GROUPS_INTERFACE, EGO_ATTR_GROUPS_DL_INTERFACE, and EGO_ATTR_GROUP_COLS_INTF, which hold the staged bulk load rows. Base definition tables written during import include EGO_ATTR_GROUP_DL, EGO_OBJ_AG_ASSOCS_B, and EGO_DATA_LEVEL_B.

Metadata lookups draw from FND_APPLICATION, FND_FORM_FUNCTIONS, FND_COLUMNS, FND_FLEX_VALUE_SETS, FND_DESCRIPTIVE_FLEXS, FND_DESCR_FLEX_COLUMN_USAGES, FND_DESCR_FLEX_CONTEXTS_TL, EGO_FND_DF_COL_USGS_EXT, and EGO_FND_DSC_FLX_CTX_EXT. These provide the descriptive flexfield context and column metadata required to validate attribute group and attribute definitions. FND_APPLICATION also supplies the EGO application ID used to stamp interface rows.

Usage Notes

EGO_AG_BULKLOAD_PVT is a private package and is not intended for direct invocation by custom code. It is called by the attribute group bulk load concurrent program and by the public wrapper that submits and monitors the load. Because it relies on session-level globals such as G_USER_ID, G_LOGIN_ID, G_REQUEST_ID, G_PROG_APPL_ID, G_PROGRAM_ID, G_SET_PROCESS_ID, and G_PROCESS_RECORD, it must be executed within the standard concurrent manager context where these values are populated. Rows are only processed when PROCESS_STATUS equals G_PROCESS_RECORD, and the optional G_SET_PROCESS_ID filter narrows the set when a specific batch is targeted.

Debug tracing is emitted through WRITE_DEBUG calls, which are useful when diagnosing why interface rows remain unprocessed. The package is referenced by one other package, which handles orchestration. In 12.2.2 the same interface table structures remain in use, so behavior is consistent across 12.1.1 and 12.2.2 within the EGO attribute group framework.