Search Results gmd_recipe_fetch_pub




Overview
Explore in AI Chat

Overview

GMD_RECIPE_FETCH_PUB is a public PL/SQL package body owned by the APPS schema that serves as the primary retrieval API for Oracle Process Manufacturing (OPM) recipe, routing, and formula data within Oracle E-Business Suite 12.1.1 and 12.2.2. Its central business function is to expose validated, denormalized access to recipe structure — including routing steps, operation activities, operation resources, process parameters, step materials, and process loss — to calling applications without requiring those callers to navigate the underlying base tables directly. Because the package is classified as a PUB API and is referenced by fifteen other database objects, it functions as a stable integration contract for recipe data consumption across the OPM module boundary. The package status is VALID, indicating it is compiled and operational in the documented environment.

Key Procedures and Functions

The package exposes sixteen documented procedures and functions, each targeting a discrete slice of recipe metadata:

Tables Accessed

The package reads from a broad set of OPM recipe and routing base tables through APPS synonyms:

The package also depends on FND_API, FND_MESSAGE, FND_MSG_PUB, GMDRTVAL_PUB, GMD_AUTO_STEP_CALC, and GMD_COMMON_VAL, indicating that it uses the Oracle Application Object Library error-handling and message stack, delegates validation to GMD rules, and may invoke automatic step calculation logic during retrieval.

Usage Notes

GMD_RECIPE_FETCH_PUB is typically invoked from OPM recipe and routing forms, concurrent programs that explode or report recipe structures, and custom PL/SQL extensions requiring read-only access to validated recipe data. Because it is a PUB API and is referenced by fifteen other packages, it should be treated as a supported entry point rather than a candidate for direct table access by downstream integrations. Callers benefit from centralized validation and consistent message handling through FND_MSG_PUB. Custom code should reference the documented procedures only and rely on the APPS synonyms for any supplementary queries.