Search Results bmassubd_assign_sub_comp_data

Overview

BOMPASGB is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, declared with AUTHID CURRENT_USER. Its header identifies it as a set of functions used to assign bill (bill of material) data within the BOM interface tables. The package operates in the BOM (Bills of Material) module and supports the processing of bill-of-material import records, translating staged interface rows into validated, sequenced bill structure data before they are loaded into the base BOM tables.

The header parameters documented for the package include org_id (organization identifier), all_org (a flag selecting processing scope, where 1 processes all organizations and 2 restricts processing to the current organization), along with prog_appid, prog_id, req_id, and user_id/login_id, which are standard concurrent-program and session context identifiers. This indicates the package is designed to run from concurrent request processing while attributing activity to the submitting user and request.

Key Procedures and Functions

The 13 documented functions fall into several logical groups:

• Assignment functions — BMABLORG_ASSIGN_BILL_ORGID assigns the organization identifier to bill records. BMASREV_ASSIGN_REVISION assigns revision data. BMASBILH_ASSIGN_BILL_HEADER assigns bill header information. BMASCOMP_ASSIGN_COMP assigns component records. BMASBITM_ASSIGN_BOM_ITEM_ID assigns BOM item identifiers, while BMASBOMID_ASSIGN_BOM_SEQ_ID and BMASCMPID_ASSIGN_CMP_SEQ_ID assign bill-sequence and component-sequence identifiers respectively. BMASREFD_ASSIGN_REF_DESG_DATA and BMASSUBD_ASSIGN_SUB_COMP_DATA assign reference-designator and substitute-component data.
• Getter functions — BMGBLSQ_GET_BILL_SEQUENCE retrieves a bill sequence identifier (the object referenced by the user search term bill_seq_id) based on organization, item, and alternate designator. BMGCPSQ_GET_COMP_SEQUENCE retrieves a component sequence value. BMGBLIN_GET_BILL_INFO returns bill information, and BMGCPQY_GET_COMP_QUANTITY returns a component quantity.

Most assignment functions share the pattern of accepting organization scope and concurrent-program context, then returning an integer status with an err_text OUT parameter conveying error messages.

Tables Accessed

The package reads and writes through APPS synonyms, including BOM_BILL_OF_MTLS_INTERFACE, BOM_INVENTORY_COMPS_INTERFACE, BOM_REF_DESGS_INTERFACE, and BOM_SUB_COMPS_INTERFACE — the staging structures that hold imported bill, component, reference designator, and substitute-component data. It also references BOM_INVENTORY_COMPONENTS_S, the base component table, and MTL_SYSTEM_ITEMS_INTERFACE_S alongside MTL_SYSTEM_ITEMS for item validation and lookup. MTL_ITEM_REVISIONS_INTERFACE supports revision assignment, and MTL_PARAMETERS supplies organization-level defaults. DUAL is used for scalar evaluations and sequence retrieval.

Usage Notes

BOMPASGB is typically invoked by the BOM interface import concurrent programs that validate and transfer interface table rows into production BOM structures. The getter functions, particularly BMGBLSQ_GET_BILL_SEQUENCE, are commonly consumed by custom extensions needing to resolve or validate a bill_seq_id during bill import. Because the package uses AUTHID CURRENT_USER, execution requires appropriate grants for the invoking user. In EBS 12.1.1 and 12.2.2, the package should be treated as an internal, unsupported API; direct calls are best confined to concurrent-program logic or carefully controlled custom code, and the documented all_org convention (1 for all organizations, 2 for the current organization only) must be observed to avoid cross-organization processing errors.