Search Results additional_attr_validations

Overview

EGO_AG_BULKLOAD_PVT is a private (PVT-classified) PL/SQL package body in the APPS schema that implements the bulk-load processing engine for Oracle E-Business Suite Attribute Groups and Data Levels. Attribute Groups and Data Levels are the extensibility constructs used throughout Oracle Product Information Management and related modules to attach user-defined descriptive flexfield attributes to business entities such as items, catalogs, and organizations. When users or external systems need to load or maintain these attribute definitions in volume, the operations cannot realistically be performed one row at a time through the standard maintenance forms. This package supplies the set-based validation, identifier resolution, construction, and import logic that converts raw staging rows in the interface tables into validated, constructed Attribute Group and Data Level records.

The package operates in a two-stage model. The first stage handles interface-table rows: initialization of control columns, resolution of coded values into surrogate identifiers, and bulk validation against EGO's own configuration and Oracle Application Object Library reference data. The second stage consumes the validated interface rows and constructs the final Attribute Group, Data Level, and Attribute structures prior to import into the base tables.

Key Procedures and Functions

The 39 documented routines fall into four functional clusters.

• Initialization and interface setup: INITIALIZE populates control columns in the interface table, assigning a transaction identifier from the interface sequence, upper-casing TRANSACTION_TYPE, stamping audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN), recording the concurrent request context (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE), and setting the EGO application identifier. IMPORT_AG_INTF drives the import of validated Attribute Group interface rows into the base tables.
• Identifier resolution: VALUE_TO_ID_AG, VALUE_TO_ID_DL, and VALUE_TO_ID_ATTR resolve a user-visible value into the corresponding internal identifier for an Attribute Group, Data Level, or Attribute, respectively. The _TBL variants (VALUE_TO_ID_AG_TBL, VALUE_TO_ID_DL_TBL, VALUE_TO_ID_ATTR_TBL) support batch resolution for whole sets of interface rows.
• Validation: VALIDATE_TRANSACTION_TYPE checks the transaction type code. BULK_VALIDATE_ATTR_GROUPS and BULK_VALIDATE_ATTRIBUTE perform set-level validation of the staging rows. ADDITIONAL_AGDL_VALIDATIONS and ADDITIONAL_ATTR_VALIDATIONS extend the validation framework with Attribute Group/Data Level-specific and attribute-specific rules — this last procedure is the routine most frequently associated with the search term "additional_attr_validations." COMMON_AG_VALIDATIONS, COMMON_DL_VALIDATIONS, and COMMON_ATTR_VALIDATIONS hold the shared validation rules applied across the respective object types.
• Construction: CONSTRUCT_ATTR_GROUPS, CONSTRUCT_AG_DATA_LEVEL, and CONSTRUCT_ATTRIBUTE assemble the final Attribute Group, Data Level, and Attribute records from validated interface data; PROCESS_ATTR_GROUPS orchestrates the overall Attribute Group processing flow.

Tables Accessed

The package reads and writes the EGO interface tables EGO_ATTR_GROUPS_INTERFACE, EGO_ATTR_GROUPS_DL_INTERFACE, and EGO_ATTR_GROUP_COLS_INTF, which hold staging data for attribute groups, their data levels, and their columns. Base-table targets include EGO_ATTR_GROUP_DL, EGO_DATA_LEVEL_B, and EGO_OBJ_AG_ASSOCS_B, which store the persisted data level definitions, base data level rows, and object-to-attribute-group associations. Configuration and object-metadata reads come from EGO_FND_DF_COL_USGS_EXT, EGO_FND_DSC_FLX_CTX_EXT, FND_DESCRIPTIVE_FLEXS, FND_DESCR_FLEX_CONTEXTS_TL, FND_DESCR_FLEX_COLUMN_USAGES, FND_FLEX_VALUE_SETS, FND_COLUMNS, FND_FORM_FUNCTIONS, and FND_APPLICATION. The FND table access supplies flexfield definition and context information, value set validation, column metadata, and application identifiers required to map interface values to valid EGO constructs.

Usage Notes

Because the package is classified as PVT, it is not a supported public API and is invoked internally by the EGO Attribute Group bulk-load concurrent programs and by the EGO maintenance forms that stage data in the interface tables. The standard flow is: rows are inserted into the interface tables (by the forms, an upstream concurrent program, or external integration), INITIALIZE stamps and normalizes them, the value-to-ID and validation routines check them, and the construct and import routines move validated rows into the base tables. Custom code should not call this package directly; integrations should populate the documented interface tables and submit the seeded concurrent program, allowing the package to run under a controlled request context (REQUEST_ID, PROGRAM_ID, SET_PROCESS_ID) so that validation results and process_status values are tracked correctly. Developers extending validation should be aware that ADDITIONAL_ATTR_VALIDATIONS is one of the layered validation hooks, with COMMON_ATTR_VALIDATIONS providing the shared ruleset beneath it.