Search Results mtl_item_revs_interface

Overview

BOMPASGB is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema that supports the Bill of Materials (BOM) open interface import process. Its business function is to populate foreign key columns and derived attribute values in the BOM interface tables before the importing concurrent program transfers that data into the production BOM tables. The package header identifies its parameters as org_id, all_org, prog_appid, prog_id, req_id, user_id, and login_id, confirming that it executes in the context of a concurrent request and can operate either against a single organization or across all organizations.

The package addresses a common requirement in the BOM import cycle: interface rows are loaded by external systems or by extract programs that supply organization codes, item names, and revision labels rather than internal numeric identifiers. BOMPASGB resolves those business keys into the surrogate keys required by the destination tables.

Key Procedures and Functions

The documented API surface contains thirteen functions, most of which follow a consistent "assign" naming convention that reflects the package description: functions used to assign bill data in the interface tables.

• BMABLORG_ASSIGN_BILL_ORGID — Assigns ORGANIZATION_ID to the BOM bill and child interface tables based on the organization code supplied on each row.
• BMASREV_ASSIGN_REVISION — Resolves revision values against item revision data, operating in conjunction with the MTL_ITEM_REVISIONS_INTERFACE table.
• BMASBILH_ASSIGN_BILL_HEADER — Assigns bill header identifier data to the bill of materials interface rows.
• BMASCOMP_ASSIGN_COMP — Assigns component-level data to the inventory components interface rows.
• BMGBLSQ_GET_BILL_SEQUENCE — Retrieves the next bill sequence value used when constructing bill identifiers.
• BMGCPSQ_GET_COMP_SEQUENCE — Retrieves the next component sequence value for component records.
• BMGBLIN_GET_BILL_INFO — Returns bill information used to validate or complete interface rows.
• BMASBITM_ASSIGN_BOM_ITEM_ID — Assigns the BOM item identifier to interface records.
• BMASBOMID_ASSIGN_BOM_SEQ_ID — Assigns the BOM sequence identifier.
• BMASCMPID_ASSIGN_CMP_SEQ_ID — Assigns the component sequence identifier.
• BMGCPQY_GET_COMP_QUANTITY — Derives component quantity values for interface rows.
• BMASREFD_ASSIGN_REF_DESG_DATA — Assigns reference designator data to the reference designator interface table.
• BMASSUBD_ASSIGN_SUB_COMP_DATA — Assigns sub-component data to the sub-components interface table.

Tables Accessed

The package reads and writes the core BOM interface tables: BOM_BILL_OF_MTLS_INTERFACE, BOM_INVENTORY_COMPS_INTERFACE, BOM_REF_DESGS_INTERFACE, and BOM_SUB_COMPS_INTERFACE. It also references MTL_ITEM_REVISIONS_INTERFACE, which is directly relevant to searches involving mtl_item_revs_interface, and BOM_INVENTORY_COMPONENTS_S. Master and parameter data are drawn from MTL_PARAMETERS, MTL_SYSTEM_ITEMS, and MTL_SYSTEM_ITEMS_INTERFACE_S, with DUAL used for single-row lookups. MTL_INTERFACE_ERRORS is modified so that resolution failures are recorded against the originating interface row.

Usage Notes

BOMPASGB is invoked indirectly through the BOM open interface concurrent programs rather than called by end users. The presence of prog_appid, prog_id, req_id, user_id, and login_id in its parameter list confirms this concurrent-program execution model. The all_org parameter allows the same logic to run for a single inventory organization or across all organizations. It is referenced by one other package, indicating that the assignment routines are also reused by additional interface processing code. Customizations should not call BOMPASGB directly; the supported entry point is the standard BOM import program, which invokes these functions in the required sequence.