Search Results bom_component_operations_s




Overview
Explore in AI Chat

Overview

BOM_COMP_OPERATION_UTIL is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is classified as a utility (UTIL) package within the Oracle Bills of Material (BOM) module. Its business function is to support maintenance and retrieval operations for component-to-operation assignments — that is, the association of a bill of material component to a specific routing operation on a manufacturing routing. These assignments determine the operation at which a given component is consumed on the shop floor, and they are essential for work-in-process material transactions, backflush logic, and cost rollups.

The package encapsulates low-level data access logic that higher-level public APIs (notably BOM_BO_PUB) rely upon, shielding callers from direct manipulation of the underlying component-operation tables. It also uses the EBS standard APIs FND_API, FND_GLOBAL, FND_MSG_PUB, and ERROR_HANDLER, indicating conformance to the Oracle Application Object Library API patterns, including message-stack handling and session context management.

Key Procedures and Functions

The ETRM documentation for Release 12.2.2 lists three procedures or functions in this package:

  • QUERY_ROW — Retrieves a single component-operation record for a given key. This routine supports read access to the component-operation assignment so callers can validate or display existing data before performing updates.
  • COMMON_COMPSEQIDCO — Handles the common logic associated with the component sequence identifier for component-operation rows. The name suggests it centralizes the derivation or resolution of the component sequence ID (COMP_SEQUENCE_ID) used to join a component to its operation assignment, ensuring consistency across callers.
  • PERFORM_WRITES — Performs the insert, update, or delete operations against the component-operation tables. This is the write-path procedure used when component-operation assignments are created, changed, or removed through higher-level BOM APIs.

Parameter lists are not documented in the ETRM metadata and should not be assumed; callers must reference the actual package specification for exact signatures.

Tables Accessed

The package references the following tables through APPS synonyms:

  • BOM_COMPONENTS_B — The base table storing bill of material component definitions. It is read to obtain and validate component context for operation assignments.
  • BOM_COMPONENT_OPERATIONS — The primary table holding the association of a component to a routing operation. PERFORM_WRITES and QUERY_ROW operate against this table.
  • BOM_COMPONENT_OPERATIONS_S — The sequence (surrogate key) table for BOM_COMPONENT_OPERATIONS. It supplies unique identifiers for new rows, consistent with the sequence-ID logic implied by COMMON_COMPSEQIDCO. This object is frequently the target of the user's search term, "bom_component_operations_s".

Usage Notes

BOM_COMP_OPERATION_UTIL is an internal utility rather than a public interface. It is invoked indirectly by BOM_BO_PUB, the public Bills of Material business object API, and by BOMPCMBM. Oracle Forms and concurrent programs in the BOM module call BOM_BO_PUB, which in turn delegates component-operation persistence to this package. It is not referenced by any database object, confirming its role as a leaf-level implementation helper.

Customizations should generally call BOM_BO_PUB rather than this package directly, since the public API enforces validation, message handling, and transactional integrity. Direct invocation risks bypassing those safeguards, though direct calls to QUERY_ROW for read-only validation are comparatively low risk.