Results for “gmd_item_substitution_hdr_s”

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

Overview

GMD_SUBSTITUTION_PVT is the private implementation package body for Oracle Process Manufacturing (OPM) substitution functionality within the Oracle E-Business Suite. In the ETRM documentation for release 12.2.2 it is registered under the APPS schema with the API classification "PVT," designating it as an internal, non-public layer that supports the published substitution API, GMD_SUBSTITUTION_PUB. The package governs the creation, maintenance, and removal of substitution records for both formula ingredients and items, allowing planners and process engineers to define alternate materials that may be used in place of a primary component during manufacturing.

The business value of the package lies in its role as the transactional engine beneath the substitution user interface. Application forms and concurrent processes do not normally call the private body directly; instead they invoke the public wrapper, which delegates validation and DML work to this package. Working in tandem with related packages such as GMD_SUBSTITUTION_PUB, GMD_FORMULA_SUBSTITUTION_PKG, GMD_ITEM_SUBSTITUTION_HDR_PKG, GMD_ITEM_SUBSTITUTION_DTL_PKG, GMD_COMMON_VAL, and FND_API, the private body enforces standard Oracle Applications error-handling conventions and returns messages through FND_MSG_PUB and FND_MESSAGE.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions within this package body:

• CREATE_SUBSTITUTION_HEADER — Creates a new substitution header record, establishing the top-level substitution definition in GMD_ITEM_SUBSTITUTION_HDR.
• CREATE_SUBSTITUTION_DETAIL — Adds detail lines beneath an existing header, defining the specific substituted components in GMD_ITEM_SUBSTITUTION_DTL.
• CREATE_FORMULA_ASSOCIATION — Establishes the link between a substitution definition and a formula, inserting records into GMD_FORMULA_SUBSTITUTION.
• UPDATE_SUBSTITUTION_HEADER — Modifies attributes of an existing substitution header record.
• UPDATE_SUBSTITUTION_DETAIL — Modifies attributes of existing substitution detail records.
• DELETE_FORMULA_ASSOCIATION — Removes the association between a formula and its substitution definition.
• COPY_SUBSTITUTION — Duplicates an existing substitution definition, creating a new header and associated detail rows.

Each routine operates within the standard OPM transaction model and relies on FND_API for savepoint and message handling. Parameter lists are not published in the ETRM extract and should be obtained from the live package specification.

Tables Accessed

The package body reads and writes several base tables and their corresponding sequence and view objects. Substitution masters are stored in GMD_ITEM_SUBSTITUTION_HDR, with header base and sequence objects GMD_ITEM_SUBSTITUTION_HDR_B and GMD_ITEM_SUBSTITUTION_HDR_S supplying storage support and primary-key generation. Detail lines are held in GMD_ITEM_SUBSTITUTION_DTL, supported by GMD_ITEM_SUBSTITUTION_DTL_S. Formula linkage records are written to GMD_FORMULA_SUBSTITUTION and GMD_FORMULA_SUBSTITUTION_S. Formula material detail is validated against FM_MATL_DTL. Item validation queries MTL_SYSTEM_ITEMS_B, while configuration lookups and utilities draw on GMD_COMMON_VAL, DUAL, and PLITBLM. Validation and utility logic is also delegated to GMD_SUBSTITUTION_PUB, GMD_FORMULA_SUBSTITUTION_PKG, GMD_ITEM_SUBSTITUTION_HDR_PKG, and GMD_ITEM_SUBSTITUTION_DTL_PKG.

Usage Notes

As a private package, GMD_SUBSTITUTION_PVT is not intended for direct invocation by customer code. It is called through GMD_SUBSTITUTION_PUB by OPM substitution maintenance forms and by internal concurrent programs that process substitution changes. Because it performs direct inserts, updates, and deletes on the underlying substitution tables, bypassing the public API risks violating validation rules enforced in this layer, such as item validity checks against MTL_SYSTEM_ITEMS_B and formula material cross-checks against FM_MATL_DTL. Developers extending substitution behavior should call the public API and use this package only for reference. The package is recorded as VALID in both 12.1.1 and 12.2.2 environments, and its dependency list confirms it is referenced by one other package but does not itself depend on custom objects.