Search Results gmp_process_parameters




Overview
Explore in AI Chat

Overview

GMD_MBR_UTIL_PKG is a PL/SQL utility package body owned by the APPS schema in Oracle E-Business Suite, classified as a Process Manufacturing (OPM) utility API. Its name reflects its role as a shared helper library for the MBR (Master Batch Record / recipe) subsystem within Oracle Process Manufacturing. Rather than exposing a single business transaction, the package consolidates reusable lookups and calculations that other recipe, resource, and process-parameter components invoke internally. Its status is documented as VALID, and the ETRM registry records it as not referenced by any database object in the dependency graph, meaning it sits at a leaf of the dependency tree and is called only from PL/SQL code rather than from triggers or views. In the context of EBS 12.1.1 and 12.2.2, this package is one of the supporting utilities that enable recipe organization overrides, resource activity factors, sampling-plan retrieval, and process-parameter resolution used throughout OPM manufacturing.

Key Procedures and Functions

The documented interface exposes five procedures and functions:

  • GET_ACTIVITY_FACTOR — Returns the activity factor applicable to a recipe resource, used to scale resource usage or consumption relative to a base activity quantity.
  • GET_RECIPE_RSRC_ORGN_OVERRIDES — Retrieves resource-level overrides defined for a specific recipe organization, allowing organization-specific resource values to supersede the master recipe definition.
  • GET_SAMPLING_PLAN — Resolves the sampling plan associated with a specification or quality context, supporting quality and testing requirements tied to process steps.
  • GET_ORGN_PROCESS_PARAMETERS — Returns the process parameters defined for a given organization, which is the routine most closely associated with the search term "gmp_process_parameters."
  • GET_STEP_QTY — Computes the quantity associated with a recipe or routing step, typically derived from batch scaling logic.

Parameter lists are not documented in the ETRM metadata and are therefore not reproduced here.

Tables Accessed

The package reads from seven documented base tables through APPS synonyms:

Usage Notes

GMD_MBR_UTIL_PKG is invoked programmatically by other OPM packages and forms rather than through a dedicated concurrent program. The ETRM metadata records that it is referenced by two other packages, confirming its role as a shared utility. Typical callers include recipe maintenance forms, process-parameter setup screens, and any custom code that must resolve organization-level overrides, activity factors, or sampling plans during batch execution or recipe definition. Because it performs no DML on the documented tables, it is generally safe to call from read-only contexts; however, custom extensions should treat it as an internal API subject to change between point releases.