Search Results get_copy_structures_in

Overview

APPS.BOM_COPY_BILL is the Oracle Bills of Material package that implements the bill copy engine used by Oracle E-Business Suite Manufacturing. Its central purpose is to replicate a bill of material structure — components, component operations, reference designators, substitute components, and related routing associations — from a source organization and bill sequence to a target organization, item, alternate, or revision. The package header (BOMCPYBS.pls, version 120.14, last shipped 2011/06/16) defines the copy contract through parameters such as from_org_id, to_org_id, from_sequence_id, to_sequence_id, to_item_id, to_alternate, rev_date, and the direction flag. The direction parameter distinguishes four copy modes: BOM to BOM (1), BOM to Engineering (2), Engineering to Engineering (3), and Engineering to BOM (4). A display_option controls component scope, where 2 represents current components, 3 represents current plus future components, and 1 represents all (documented as not supported from the form). The package is declared AUTHID CURRENT_USER and carries the constant bom_application_id set to 702.

Key Procedures and Functions

The documented interface exposes 27 procedures and functions. COPY_BILL is the principal entry point, with an overloaded variant introduced 15-SEP-2003 to support copying specific components, reference designators, and substitute components. Supporting inquiry functions include GET_COMPONENT_PATH, GET_ITEM_EXISTS_IN, GET_STRUCTURE_EXISTS_IN, GET_COMMON_STRUCTURE_EXISTS_IN, GET_ASSIGN_ITEMS_IN, GET_COPY_STRUCTURES_IN, GET_COMMON_STRUCTURES_IN, and GET_ORG_LIST_FOR_HIERARCHY, which resolve organizational and structural questions prior to or during a copy. Revision handling is provided by REVISION_EXISTS, GET_MAX_MINORREV, GET_REVISION, and GET_MINOR_REV_CODE. Message retrieval is handled by GET_MESSAGE, GET_CNT_MESSAGE, and GET_COMP_TYPE_RULE_MESSAGE. Administrative functions include ASSIGN_ITEMS_TO_COPY_TO_ORG, PURGE_PROCESSED_COPY_REQUESTS, PURGE_PROCESSED_REQUEST_ERRORS, and UPDATE_CREATED_BY. Parameter lists are not reproduced here; the documented copy_bill signature includes organization, sequence, item, alternate, revision, ECO, effective date, unit number, and direction arguments.

Tables Accessed

The package operates against the core Bills of Material schema through APPS synonyms. BOM_STRUCTURES_B holds the bill header records for source and target. BOM_COMPONENTS_B stores component rows, while BOM_INVENTORY_COMPONENTS_S and BOM_REFERENCE_DESIGNATORS and BOM_SUBSTITUTE_COMPONENTS capture designator and substitute detail. BOM_COMPONENT_OPERATIONS, BOM_COMPONENT_OPERATIONS_S, BOM_OPERATION_SEQUENCES, and BOM_OPERATIONAL_ROUTINGS support operation and routing associations. BOM_DEPENDENT_DESC_ELEMENTS handles descriptive element dependencies. Copy request tracking and organizational scope are managed through BOM_COPY_STRUCTURE_REQUEST, BOM_COPY_STRUCTURE_ACTIONS, and BOM_COPY_ORGANIZATION_LIST. Engineering revision data is read from EGO_MINOR_REVISIONS and EGO_DATA_LEVEL_B.

Usage Notes

BOM_COPY_BILL is invoked primarily from the Bills of Material copy form and from concurrent programs that process pending copy requests, including purge routines that clear processed requests and errors. It is referenced by five other packages, indicating reuse by higher-level manufacturing APIs. Custom code should call the documented COPY_BILL entry point rather than manipulating the underlying tables directly, and should populate the direction, display_option, and error_code/err_msg out parameters to interpret results. The presence of distinct BOM and ENG directions means the package is equally applicable to production structures and engineering structures, making it relevant to ECO-driven copy scenarios as well as routine multi-organization bill replication.