Search Results bom_rtg_applet_pkg

Overview

BOM_RTG_APPLET_PKG is an Oracle EBS package body owned by the APPS schema that supports the routing and operation network functionality within Oracle Bills of Material and Manufacturing. It is classified in the ETRM metadata as "OTHER," indicating it is not a formally published public API but rather an internal utility package whose main purpose is to service a Java applet embedded in the EBS routing maintenance forms. Its name and procedure set strongly suggest that it backs the Routing Network / Operations applet (associated with the Routing window and the operation network editor used to define predecessor-successor relationships between operations). Activities such as adding, validating, moving, and relinking nodes in an operation network diagram are executed through this package against the underlying routing tables.

Key Procedures and Functions

The ETRM metadata documents four procedures or functions in this package: ASSOCIATE_EVENT, ALTER_LINK, VALIDATE_LINK, and MOVE_NODE. The following descriptions summarize the intended purpose of each based on the documented name and their role in an applet-driven operation network editor:

• ASSOCIATE_EVENT — Associates an event or action with a node or link in the routing network, effectively tying an applet action to the underlying operation network record so that the change persists.
• ALTER_LINK — Modifies an existing link between two operations in the network, such as changing the predecessor or successor relationship, without necessarily deleting and recreating the link.
• VALIDATE_LINK — Checks the validity of a proposed or existing link in the operation network before it is committed, ensuring the relationship is logically permissible given the routing and operation sequence definitions.
• MOVE_NODE — Repositions a node within the network diagram, typically updating positioning or sequencing information associated with the operation network entry.

Exact parameter lists are not available in the documented metadata and should be obtained from the deployed package specification or the ETRM source view before direct invocation.

Tables Accessed

The package body references two APPS tables through synonyms:

• BOM_OPERATION_NETWORKS — Stores the network connections (links) between operations in a routing. It is the primary target of ALTER_LINK and VALIDATE_LINK operations and the record-keeping table for network relationships drawn in the applet.
• BOM_OPERATION_SEQUENCES — Stores the operation sequences that define the individual operations within a routing. Nodes moved or associated via the applet ultimately correspond to rows in this table.

The package also depends on FND_MESSAGE (via the APPS synonym) for application message lookups, which is consistent with an applet-backed component that returns error and validation messages to the user interface.

Usage Notes

BOM_RTG_APPLET_PKG is intended for internal, applet-facing use rather than direct customer invocation. It is exercised implicitly when users interact with the routing operation network editor in the Bills of Material / Manufacturing forms; the Java applet calls into these procedures to persist node moves, link changes, and validations. Because the ETRM metadata documents that BOM_RTG_APPLET_PKG is not referenced by any other database object, it is not part of a formal dependency chain and should not be treated as a public API. Custom code should not call these procedures directly, as their signatures and behavior are subject to change across patch levels (12.1.1 versus 12.2.2) and are governed by the corresponding form/applet, not by a documented interface contract. For extension or diagnostic purposes, reference the package specification and source via ETRM, and prefer supported BOM routing APIs where available.