Search Results get_primary_structurename

Overview

APPS.BOM_IMPORT_PUB is the public PL/SQL API package responsible for importing bills of material structures and their related entities into Oracle E-Business Suite through the open interface or the Web ADI interface. The package supports the import of structure headers, components, substitute components, reference designators, and component operations, with each import batch identified by a batch identifier. As documented in the package header (BOMSIMPS.pls, version 120.19), the APIs support external items and structure import for Product Data Hub (PDH) purposes, including the creation of structures for existing PDH items. The package also enforces change control for objects that have change policies defined at either the object level or the batch level, in accordance with Oracle Change Management functionality.

The package operates on the EGO import framework, using object types such as BATCH_OPTIONS to store session-level batch options including source system, batch type, assignee, batch status, matching and import flags, structure type, structure name, and structure effectivity type. This design allows the import process to be configured per batch rather than per row.

Key Procedures and Functions

BOM_IMPORT_PUB exposes 32 documented procedures and functions. PROCESS_STRUCTURE_DATA is the procedure most commonly associated with the package; it drives the processing of structure data within an import batch. Related processing routines include IMPORT_STRUCTURE_DATA, PRE_PROCESS_IMPORT_ROWS, IMPORT_INTERFACE_ROWS, and DATA_UPLOAD_COMPLETE, which together manage the flow from staged interface rows to imported structure records. RESOLVE_XREFS_FOR_BATCH and UPDATE_MATCH_DATA support cross-reference resolution and matched data maintenance, while MATCHING_COMPLETE signals completion of the matching phase. UPDATE_BILL_INFO and UPDATE_BILL_VAL_ID maintain bill header information and validation identifiers. Attribute and designator handling is provided by BOM_GET_COMP_ATTR_DATA, GET_REF_DESGS, and UPDATE_USER_ATTR_DATA. Utility functions such as GET_G_MISS_NUM, GET_G_MISS_CHAR, and GET_G_MISS_DATE retrieve missing global values by data type, while GET_PRIMARY_STRUCTURENAME returns the primary structure name. CHECK_CHANGE_OPTIONS validates change control settings, PROPAGATE_CONFIRMATION_STATUS manages confirmation status propagation, and UPDATE_CONFIRMED_ITEMS updates confirmed item records. Parameter lists are not reproduced here; refer to the package specification for exact signatures.

Tables Accessed

The package reads and writes through APPS synonyms. Import batch and option metadata is held in EGO_IMPORT_BATCHES_B and EGO_IMPORT_OPTION_SETS. Inbound staged data resides in the interface tables BOM_BILL_OF_MTLS_INTERFACE, BOM_COMPONENT_OPS_INTERFACE, BOM_INVENTORY_COMPS_INTERFACE, BOM_OP_NETWORKS_INTERFACE, BOM_OP_RESOURCES_INTERFACE, BOM_OP_ROUTINGS_INTERFACE, BOM_OP_SEQUENCES_INTERFACE, BOM_CMP_USR_ATTR_INTERFACE, and BOM_REF_DESGS_INTERFACE. Validated structures and components are written to BOM_STRUCTURES_B, BOM_COMPONENTS_B, BOM_COMPONENTS_EXT_B, and BOM_REFERENCE_DESIGNATORS. Together these tables represent the open interface staging layer and the production BOM tables the package maintains.

Usage Notes

BOM_IMPORT_PUB is typically invoked indirectly through the Bill of Material open interface concurrent programs, Web ADI structure import flows, and Product Data Hub import processes, rather than being called directly from forms. It is referenced by four other packages, indicating its role as a shared service within the BOM import and PDH integration layers. Custom code should call only the PUBLIC procedures, initialize BATCH_OPTIONS appropriately, and ensure change control policies are configured when importing objects subject to change management. Because the interface rows are staged in the BOM interface tables, data must be loaded and validated before PROCESS_STRUCTURE_DATA and the associated import routines are executed.