Search Results batch_process_parameter

Overview

GMD_PROC_PARAMS_MIGR is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Process Manufacturing (GMD/GME) product family. Its name and structure indicate that it exists to migrate and interrogate process parameter data across the various process manufacturing entities: operations, recipes, and batches. The package is declared with AUTHID CURRENT_USER, meaning its contained SQL executes with the privileges of the invoking schema rather than the definer, which is consistent with a utility or migration routine that must resolve unqualified objects against the caller's synonym context.

The header comment ($Header: GMDPROCS.pls 115.1 2002/09/13) places the source file in the early 11i lineage of Process Manufacturing, and the package has been carried forward into EBS 12.1.1 and 12.2.2 without a change in its public interface. It is a low-level data-maintenance package rather than a business API exposed to end users.

Key Procedures and Functions

The package exposes six documented procedures, all without published parameter lists in the metadata:

• CHECK_PROCESS_PARAMETER — Validates process parameter records, presumably detecting inconsistencies or missing rows across the parameter tables before migration proceeds.
• OPRN_PROCESS_PARAMETER — Handles process parameter data at the operation level, migrating or reconciling records held in the operation-level parameter tables.
• RECIPE_PROCESS_PARAMETER — Performs the equivalent function for recipe-level parameters, moving or reconciling data associated with recipe and recipe organization resource definitions.
• BATCH_PROCESS_PARAMETER — Addresses batch-level process parameters, covering the batch step resource and batch process parameter tables.
• GET_OVERRIDE — The procedure the user searched for. In process manufacturing, a recipe or operation parameter may be overridden at a lower level (for example, a batch value overriding a recipe default). GET_OVERRIDE is the accessor that resolves and returns the effective override value for a given parameter context, allowing the migration logic to determine which value takes precedence.
• RUN — The driver procedure that orchestrates the remaining routines, typically invoked once to execute the full migration or validation pass.

Tables Accessed

The package references eleven documented tables through APPS synonyms, spanning setup and transactional process data:

• Setup/master data: GMP_PROCESS_PARAMETERS_B (the base process parameter definition), GMP_RESOURCE_PARAMETERS, CR_RSRC_MST_B (resource master), and GMD_OPERATION_RESOURCES.
• Recipe level: GMD_RECIPE_PROCESS_PARAMETERS and GMD_RECIPE_ORGN_RESOURCES.
• Operation level: GMD_OPRN_PROCESS_PARAMETERS.
• Batch level: GME_PROCESS_PARAMETERS, GME_BATCH_STEP_RESOURCES, and the sequence GME_PROCESS_PARAMETERS_ID_S used to generate surrogate keys.
• DUAL is referenced, confirming the presence of simple PL/SQL expression or existence checks.

Usage Notes

GMD_PROC_PARAMS_MIGR is not referenced by any other documented package, which confirms its role as a terminal utility rather than a shared service. It is most likely invoked from a concurrent program or a one-time upgrade script during an 11i-to-12.x migration, or manually from SQL*Plus by an application DBA. Because GET_OVERRIDE is not a published API and carries no documented signature, custom code should not call it directly; integrators seeking override resolution should use the supported Process Manufacturing APIs where available. Any direct invocation should be performed in a controlled maintenance window, as the procedures write to process parameter and batch resource tables.