Search Results gmd_search_replace_vers




Overview
Explore in AI Chat

Overview

APPS.GMD_SEARCH_REPLACE_VERS is a PL/SQL package belonging to the Oracle Process Manufacturing (OPM) product family within Oracle E-Business Suite. It supports the "search and replace" functional requirement for versioned process manufacturing master data, allowing users to propagate substitutions across dependent recipe, formula, routing, and operation definitions instead of editing each object manually. The package is classified as OTHER in the ETRM repository, indicating that it is an internal utility package rather than a public, documented API with a controlled interface contract. Its validation status is VALID in the APPS schema under both 12.1.1 and 12.2.2.

Because it operates directly on OPM master data tables rather than on interface tables, it is intended for server-side use within the application's own business flows. The package exposes four documented entry points that share a common purpose: creating the new versioned copies of manufacturing objects after a replacement operation has determined what must change.

Key Procedures and Functions

The package documents four procedures or functions:

  • CREATE_NEW_FORMULA — creates the new formula (formula header and associated material detail) resulting from a search-and-replace operation.
  • CREATE_NEW_RECIPE — creates the new recipe version that carries the replaced specification or material reference.
  • CREATE_NEW_ROUTING — creates the new routing header and routing step records for the substituted process.
  • CREATE_NEW_OPERATION — creates the new operation definition, including its activity and resource associations, that reflects the replacement.

Each routine is oriented toward versioning: rather than mutating existing master data in place, the package generates new version records. ETRM does not document parameter signatures for these routines, so callers should obtain exact argument lists from the package specification in the target environment before invoking them directly.

Tables Accessed

The package reads and writes the core OPM formula, recipe, and routing tables through APPS synonyms:

The dependency on FND_PROFILE reflects the package's use of profile option values to determine application context, such as the current organization or installation settings.

Usage Notes

GMD_SEARCH_REPLACE_VERS is referenced by GMD_CONC_REPLACE_PKG, the concurrent-program-facing package that drives the search-and-replace process. This indicates the standard invocation path: a user submits the OPM search-and-replace concurrent request, the driving package identifies the affected objects, and GMD_SEARCH_REPLACE_VERS performs the versioned creation of formulas, recipes, routings, and operations. The package also references itself, consistent with internal recursive or shared helper logic.

Because it is an internal package rather than a documented public API, direct calls from custom code are not recommended for supported implementations. Where a business requirement demands programmatic replacement, the supported approach is to invoke the concurrent program or its driving package and let GMD_SEARCH_REPLACE_VERS handle object creation within the application's own transaction and validation logic. Direct invocation bypasses expected validations and can leave formula, routing, and operation records inconsistent with the ID sequences and attachment records that the package manages jointly.