Search Results populate_revision

Overview

APPS.BOM_RTG_EXP is a PL/SQL package body belonging to the Oracle E-Business Suite Bills of Material (BOM) module. Its purpose is to export manufacturing routing definitions — including routing headers, revisions, operations, operation resources, sub-resources, and operation networks — from the EBS database into a structured, transferable format. The package is classified as an "OTHER" API in the ETRM repository for releases 12.1.1 and 12.2.2, meaning it is not part of the formally published, supported public API surface but is instead an internal extraction/export utility used by the routing export infrastructure.

The body declares several package-level global variables that mirror the public routing record types defined in BOM_RTG_PUB, including G_rtg_header_rec, G_rtg_revision_tbl, G_operation_tbl, G_op_resource_tbl, G_sub_resource_tbl, and G_op_network_tbl. These globals act as the in-memory staging area for the hierarchical routing data assembled during export. The header comment attributes initial creation to 06-OCT-02, with the source file identified as BOMREXPB.pls.

Key Procedures and Functions

The documented interface exposes a single procedure, EXPORT_RTG. This procedure drives the export of a complete routing definition for a given assembly and organization. Internally, the body contains at least one supporting procedure, Populate_Header, which populates the G_rtg_header_rec structure by querying the BOM_OPERATIONAL_ROUTINGS table and related views. Populate_Header accepts organization and item identifiers, an alternate routing designator, and returns the routing sequence identifier. It reads routing attributes such as routing type, common assembly item, routing comments, completion subinventory and locator, line code, configure-to-order flag, mixed model map flag, priority, total product cycle time, CTP flag, descriptive flexfield attributes (attribute1 through attribute15), and the original system reference. The user search term "populate_revision" corresponds to the revision-handling logic within this export flow: routing revisions are loaded into G_rtg_revision_tbl, the global aligned with the BOM_RTG_PUB.RTG_REVISION_TBL_TYPE structure, drawing on MTL_RTG_ITEM_REVISIONS.

No formal parameter list is documented here, and none should be assumed; the procedure signature is governed by the package specification, which is not part of the supplied excerpt.

Tables Accessed

The package reads from the following documented tables and synonyms:

• BOM_OPERATIONAL_ROUTINGS — routing headers (routing sequence, type, comments, flags, attributes).
• BOM_OPERATION_SEQUENCES — routing operations and their sequence assignments.
• BOM_OPERATION_RESOURCES — resources assigned at the operation level.
• BOM_SUB_OPERATION_RESOURCES — sub-resource detail beneath operations.
• BOM_RESOURCES — resource master definitions.
• BOM_SETUP_TYPES — setup type references used by operations/resources.
• CST_ACTIVITIES — cost activity references tied to routing operations.
• MTL_RTG_ITEM_REVISIONS — routing revisions per item, supporting the revision population logic.
• MTL_SYSTEM_ITEMS_KFV — item descriptive/concatenated flexfield view for item identification.
• WIP_LINES — work-in-process line codes referenced by the routing header.
• PLITBLM — the PL/SQL index-by table used for bulk collection handling.

Usage Notes

BOM_RTG_EXP is an internal helper rather than a supported public API. It is most plausibly invoked from concurrent programs or bulk export routines that extract routing data for migration, copy, or archival purposes, and it is not referenced by any other documented package (referenced by 0). Custom developers should avoid calling it directly; the supported entry points for routing creation and maintenance reside in BOM_RTG_PUB. The package remains compatible with both 12.1.1 and 12.2.2, as the underlying BOM tables are largely unchanged across those releases.