Search Results bom_rtg_pvt




Overview
Explore in AI Chat

Overview

BOM_RTG_PVT is a private PL/SQL package in the APPS schema that supports Oracle E-Business Suite routing and bill of materials processing. The "PVT" suffix indicates that this is an internal implementation package, not a published API. Its logic is exposed to external callers only indirectly through the public package APPS.BOM_RTG_PUB, which is the documented, supported entry point for routing operations in Oracle Manufacturing.

The package forms part of the routing engine layer that underpins the Bills of Material and Routings module. It encapsulates the procedural logic required to create, validate, and process routing definitions — the ordered sequences of operations and resources that describe how a manufactured item is built. Because Oracle classifies BOM_RTG_PVT as a private package, its members exist to be called by BOM_RTG_PUB rather than by customer code, and they may change between releases without notice.

The metadata confirms a bidirectional dependency relationship: BOM_RTG_PVT references BOM_RTG_PUB and is itself referenced by BOM_RTG_PUB. This circular coupling is typical of layered PL/SQL design, where the public package authenticates, validates inputs, and logs results, while the private package performs the underlying data manipulation.

Key Procedures and Functions

The documented package metadata identifies a single exposed program unit:

  • PROCESS_RTG — The core routing processing routine. It carries out the substantive work behind a routing transaction, applying the operation and resource sequencing defined for an item's routing. In the layered design of the module, BOM_RTG_PUB delegates to PROCESS_RTG after performing caller-side validation and any required setup, and PROCESS_RTG then performs the persistence and internal consistency checks against the routing tables. Because this is a private package, PROCESS_RTG should not be invoked directly by custom code; the supported path is through BOM_RTG_PUB.

No other procedures or functions are documented for this package in the ETRM metadata. The absence of additional documented units does not imply the package body is limited to one program — private helpers may exist without separate documentation entries.

Tables Accessed

The package accesses two documented tables through APPS synonyms:

  • BOM_OPERATIONAL_ROUTINGS — The principal routing table, holding the routing header records for manufactured items, including routing type, status, and the association between an item and its routing definition. PROCESS_RTG reads and writes this table to establish or update the routing under which operations and resources are sequenced.
  • PLITBLM — A PL/SQL index-by table type definition referenced by the package. It is used as an in-memory structure to stage and pass collections of routing data during processing, rather than as a persistent business table.

Additional dependent objects may be touched indirectly through the public package, but the documented direct references are limited to these two.

Usage Notes

BOM_RTG_PVT is not a customer-facing API. It is invoked by APPS.BOM_RTG_PUB during routing creation, update, and validation transactions initiated from the Oracle Bills of Material and Routings forms, from concurrent programs that import or process routings, and from any Oracle application logic that calls the public routing API. The documented dependency shows exactly one referencing package, BOM_RTG_PUB, confirming that the private package is consumed exclusively by its public counterpart.

For Oracle EBS 12.1.1 and 12.2.2, customizations should always call BOM_RTG_PUB rather than BOM_RTG_PVT, since the private package has no compatibility guarantee across patches or upgrades. The presence of BOM_RTG_PVT in the dependency tree is useful during impact analysis and debugging, where it indicates that a routing transaction failure may originate below the public API layer in the operational routing table logic.