Search Results get_formula_details

Overview

APPS.GMD_PROCESS_INSTR_UTILS is a technical utility package body within the Oracle EBS Process Manufacturing (OPM) product family, specifically the Enterprise Technical Reference Model (ETRM) area governing process instructions. In both 12.1.1 and 12.2.2, the package serves as a supporting engine for assembling, copying, and transmitting process instruction data associated with recipes, routings, operations, and formula material details. Rather than exposing a formal public API classification—it is catalogued as OTHER—the package provides internal PL/SQL building blocks consumed by other OPM components. The header ($Header: GMDPIUTB.pls 120.9) confirms it is a maintained core library file.

Key Procedures and Functions

The documented interface exposes ten procedures and functions. Their naming indicates two principal concerns: process-instruction manipulation and acknowledgement messaging.

• BUILD_ARRAY — Builds an array structure passed to the GMO subsystem. The header notes it was introduced under bug B5305793 to resolve a reported issue, indicating it is a workaround/enhancement utility.
• COPY_PROCESS_INSTRUCTIONS / COPY_PROCESS_INSTR / COPY_PROCESS_INSTR_ROW — A family of routines that copy process instruction records, operating at whole-instruction, single-instruction, and single-row granularity respectively.
• SEND_PI_ACKN and DESG_SEND_PI_ACKN — Transmit process instruction acknowledgements, with the DESG variant tied to designated invocation context.
• DESG_SEND_VER_PI_ACKN — Sends version-specific process instruction acknowledgements.
• GET_DESG_INVOKE_PI_ID and SET_DESG_INVOKE_PI_ID — Accessor and mutator pair for a designated invoke process instruction identifier.

No parameter lists are documented; usage must be confirmed against the installed source.

Tables Accessed

The package references eleven tables via APPS synonyms, all standard OPM and inventory objects:

• GMD_RECIPES / GMD_RECIPES_B and FM_FORM_MST / FM_MATL_DTL — Recipe and formula headers and their material detail lines.
• FM_ROUT_DTL / FM_ROUT_HDR — Routing steps and headers.
• GMD_OPERATIONS_B, GMD_OPERATION_ACTIVITIES, GMD_OPERATION_RESOURCES — Operation definitions, their activities, and associated resources.
• MTL_SYSTEM_ITEMS_KFV — Inventory item descriptive flexfield view, used to resolve concatenated item segments.
• PLITBLM — The generic PL/SQL index-by table storage used for array passing.

The inline cursors confirm these reads: Get_recipe_details, Get_formula_details (the object matching the user's search term), Get_activity_details, Get_routing_details, and Get_resource_details.

Usage Notes

Get_formula_details is the cursor that resolves formula material lines for a given formula_id, joining FM_MATL_DTL to MTL_SYSTEM_ITEMS_KFV on inventory_item_id and organization_id, ordered by line_type and line_no. This cursor underpins the process instruction assembly performed by BUILD_ARRAY and the copy routines. Because the package is referenced by five other packages and lacks a formal API classification, it is invoked programmatically rather than through a dedicated concurrent program or form. Customizations should call it only where the OPM manufacturing flow expects process instruction assembly, and 12.1.1/12.2.2 compatibility should be verified against the installed 120.9 source line.