Search Results bom_default_rtg_revision




Overview
Explore in AI Chat

Overview

BOM_DEFAULT_RTG_REVISION is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It resides within the Oracle Bills of Material (BOM) application family and forms part of the routing revision defaulting infrastructure used by the Manufacturing modules. Its principal role is to supply defaulting logic for routing revision attributes and to populate mandatory columns during the creation and maintenance of routing records. The package is classified as OTHER under the documented API classification, indicating that it is an internal utility rather than a formal public API intended for external integration. It is a supporting component that underpins the larger routing publication and validation framework centered on BOM_RTG_PUB and BOM_RTG_PVT. The package status is recorded as VALID in the ETRM repository for both Oracle EBS 12.1.1 and 12.2.2, confirming that it is a shipped, compiled object in the APPS schema.

Key Procedures and Functions

The ETRM metadata documents three procedures within this package. Each is described below by name and purpose; no parameter signatures are asserted because the documented metadata does not expose them.

  • ATTRIBUTE_DEFAULTING — Applies default values to individual routing revision attributes. This routine is the primary entry point for attribute-level defaulting, supplying values such as effectivity dates, revision identifiers, and status flags when the caller has not provided them explicitly.
  • ENTITY_ATTRIBUTE_DEFAULTING — Performs defaulting at the entity level, coordinating the application of defaults across the full set of attributes that make up a routing revision entity. It complements ATTRIBUTE_DEFAULTING by ensuring consistency across related columns rather than treating each attribute in isolation.
  • POPULATE_NULL_COLUMNS — Scans a routing revision record for null columns and fills them with appropriate default values. This routine is typically invoked after the defaulting procedures to guarantee that no required column remains null before the record is written or validated.

Tables Accessed

The ETRM dependency record for BOM_DEFAULT_RTG_REVISION does not enumerate specific base tables accessed through APPS synonyms. Its documented references are to the package BOM_RTG_PUB, the ERROR_HANDLER utility package, and the SYS.STANDARD package. The absence of explicit table references in the dependency listing indicates that the package operates primarily through calls to BOM_RTG_PUB and related routing publication routines rather than by issuing direct DML against routing tables. Any table interaction is therefore mediated by those dependent packages, most notably the routing publication interface that ultimately reads and writes the routing revision entities within the BOM schema.

Usage Notes

BOM_DEFAULT_RTG_REVISION is referenced by BOM_DEFAULT_RTG_REVISION itself, indicating recursive or internal calls within the package or its body, and by BOM_RTG_PVT, the private implementation package for routing publication. This dependency pattern confirms that the package is invoked from the private routing publication layer rather than directly from Oracle Forms or concurrent programs. Custom code should generally avoid calling this package directly, because it is an internal defaulting utility whose behavior is tightly coupled to the routing publication workflow. When routing revisions are created or updated through the standard BOM interfaces, BOM_RTG_PVT calls this package to apply attribute defaults, entity-level defaults, and null-column population before validation and commit. Developers extending routing functionality should integrate through BOM_RTG_PUB, the public routing API, and allow the private layer to chain into BOM_DEFAULT_RTG_REVISION as designed.