Results for “delete_routing_step”

30 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GMD_ROUTING_STEPS_PUB is the public PL/SQL API package for managing the individual steps that make up a process manufacturing routing and the dependencies between those steps in Oracle E-Business Suite Process Manufacturing. Within Oracle EBS 12.1.1 and 12.2.2, a routing defines the sequence of operations required to manufacture a product, and each routing step links an operation to a routing header at a specified sequence position. GMD_ROUTING_STEPS_PUB exposes the transactional interface through which routing steps and their inter-step dependencies are created, modified and removed. It is classified as a PUB (public) API, meaning it is intended to be called by external programs, forms and integration code rather than being restricted to internal use. The package enforces business rules, validation, message handling and multi-lingual (MLS) logic on behalf of its callers, wrapping the lower-level private implementation held in GMD_ROUTING_STEPS_PVT. Because the object is documented as VALID and owned by APPS, it is a supported and reachable component of the Process Manufacturing data model.

Key Procedures and Functions

The documented interface consists of six public procedures:

The separation of step maintenance from dependency maintenance reflects the two logical entities involved: the steps themselves and the directed relationships that sequence them. All procedures follow the standard EBS API conventions of returning a result status and populating the FND_MSG_PUB message stack rather than raising unhandled exceptions.

Tables Accessed

The package operates across the core Process Manufacturing routing tables, reached through APPS synonyms:

  • FM_ROUT_HDR — the routing header, providing the parent context for a step.
  • FM_ROUT_DTL — the routing detail holding the individual routing step records.
  • FM_ROUT_DEP — the dependency table storing predecessor/successor links between steps.
  • GMD_ROUTINGS and GMD_ROUTINGS_B — the routing ML view and base table, used to resolve and validate the routing identifier.
  • GMD_OPERATIONS and GMD_OPERATIONS_B — the operation ML view and base table, used to validate the operation referenced by a step.
  • PLITBLM — the standard EBS temporary table used for multi-lingual data access.

Supporting dependencies include FND_API for the API framework, FND_MSG_PUB and FND_MESSAGE for message handling, FND_LOG and GMD_DEBUG for logging, GMDRTVAL_PUB and GMD_COMMON_VAL for routing-specific validation, and GMD_OPERATIONS, GMD_ROUTINGS_PUB and GMD_API_GRP for related data retrieval.

Usage Notes

GMD_ROUTING_STEPS_PUB is typically invoked from the Process Manufacturing routing maintenance forms, from integration code loading routing structures into Oracle EBS, and from custom PL/SQL that needs to build or amend routings programmatically. Because it is a public, supported API, it should be called in preference to direct DML against the underlying FM_ROUT_* tables, ensuring validations, MLS handling and message propagation are applied consistently. The package is referenced by five other database objects, confirming its role as a shared dependency in the routing data model. Callers should invoke the procedures within an appropriate transaction, honor the returned status, and inspect the FND_MSG_PUB stack on failure. All documented procedures are listed as VALID in 12.2.2, so no compatibility workarounds are required between 12.1.1 and 12.2.2 for this interface.