Search Results copy_comp_uda_overrides




Overview
Explore in AI Chat

Overview

APPS.BOM_UDA_OVERRIDES_PVT is a private (PVT) PL/SQL package within the Oracle E-Business Suite Bills of Materials application. Its purpose is to manage User Defined Attribute (UDA) override data associated with bill of material components. In Oracle EBS, UDAs allow organizations to capture custom attributes against components without modifying the underlying data model. Because those attributes may be defined at a higher level (for example, at the item or component level), individual BOM components can override the inherited values. This package encapsulates the logic required to keep those overrides consistent when components are copied or removed from a bill of materials.

The package is declared with AUTHID CURRENT_USER and carries the header identifier BOMVATOS.pls. Its private classification indicates it is not intended as a public integration API; it is an internal building block invoked by other BOM processing logic rather than by external callers directly.

Key Procedures and Functions

The documented package exposes two procedures. Both operate on component sequence identifiers, which are the internal keys that uniquely identify a component line within a bill of materials.

  • COPY_COMP_UDA_OVERRIrides (Copy_Comp_UDA_Overrides) — Duplicates the UDA override records from an existing component to a new component. It receives the source component sequence and the target component sequence, and is used when a component is copied so that the copied line inherits the same UDA override state as its origin.
  • DELETE_COMP_UDA_OVERRIDES (Delete_Comp_UDA_Overrides) — Removes the UDA override records associated with a specified component. It accepts the component sequence to delete and returns a status value through an OUT parameter, allowing the calling program to detect success or failure. This is the procedure most relevant to the search term "delete_comp_uda_overrides."

The OUT parameter on the delete procedure follows the standard EBS convention of returning a return status string (typically validated against the FND_API.G_RET_STS_SUCCESS / ERROR constants), enabling callers to branch on the outcome.

Tables Accessed

The package reads and writes the following objects, accessed through APPS synonyms:

  • BOM_COMPONENTS_EXT_B and BOM_COMPONENTS_EXT_TL — the base and translated extension tables that hold component-level extended attribute data, including UDA overrides.
  • BOM_COMP_ATTR_CTX_ASSOCS_B and BOM_COMP_ATTR_CTX_ASSOCS_B_S — the attribute context association tables that link components to their attribute definitions and contexts; the copy and delete operations must reconcile records here.
  • EGO_DATA_LEVEL_B and EGO_EXTFWK_S — EGO (Oracle Product Information Management) extensibility framework tables that define the data levels and attribute framework backing the UDA model.
  • DUAL — used for single-row lookups or PL/SQL evaluations.
  • PLITBLM — an internal BOM-related table used in the package's processing logic.

Usage Notes

BOM_UDA_OVERRIDES_PVT is not a public API and is normally invoked from within other BOM packages; the metadata records it as referenced by one other package. Typical triggers include component copy operations and component deletion flows in the Bills of Materials forms and related concurrent or batch programs, where calls to Delete_Comp_UDA_Overrides clean up orphaned override rows before or after the parent component is removed.

Custom extensions should not call this private package directly. Where override cleanup is required, the recommended approach is to allow the standard BOM component deletion or copy processes to invoke the package, ensuring that the related attribute context association and EGO extensibility records remain synchronized.