Search Results is_operator

Overview

GMD_EXPRESSION_UTIL is a utility package in the Oracle EBS Process Manufacturing (OPM/GMD) schema, owned by APPS and classified as a UTIL API. Its business function is to parse, store, and evaluate the mathematical and parameter-based expressions that drive OPM technical data calculations — for example, formula computations, quality specification limits, or product parameter derivations where a value is expressed as a combination of operators, numeric literals, and referenced technical parameters rather than a static number.

The package converts a user-entered expression string into structured rows held in GMD_PARSED_EXPRESSION, then evaluates those rows against the actual parameter values on a line to return a computed result. It separates the parsing stage (tokenizing operators, parameters, and numbers and writing the parsed representation) from the evaluation stage (resolving parameter values and applying the operators). This design allows expressions to be edited, re-parsed, and re-evaluated independently. Because it is an internal utility rather than a public business API, it is primarily called by other OPM packages and forms rather than by external integrations.

Key Procedures and Functions

• PARSE_EXPRESSION — Takes an organization, technical parameter, and expression string, tokenizes the expression, and populates the parsed-expression structure.
• INSERT_EXPRESSION_KEY — Inserts an expression key entry for the given organization and technical parameter.
• IS_OPERATOR — Boolean helper that determines whether a supplied token represents a recognized operator.
• IS_PARAMETER — Boolean helper that determines whether a supplied token is a valid parameter, returning the parameter ID and data type.
• IS_NUMBER — Boolean helper that determines whether a token is a numeric literal.
• ADD_EXPRESSION_ROW — Adds a single parsed row (type, data type, and parameter reference) for a technical parameter, supporting the parse process.
• EVALUATE_EXPRESSION_VALUE — Evaluates an expression line against an in-memory expression table and returns the computed value as a string.
• GET_VALUE — Retrieves the value of a named parameter for a given line, used during evaluation to resolve parameter references.
• EVALUATE_EXPRESSION — The principal entry point: given an entity, line, and technical parameter, evaluates the expression and returns the numeric result, the expression text, and a return status.

Tables Accessed

• GMD_PARSED_EXPRESSION — Stores the parsed token rows produced during parsing and read during evaluation.
• GMD_TECH_PARAMETERS_B — Source of technical parameter definitions, used to validate parameters and resolve their data types.
• GMD_MATERIAL_DETAILS_GTMP — Global temporary table providing material-level values used for parameter resolution.
• GMD_TECHNICAL_DATA_GTMP — Global temporary table supplying technical data values during evaluation.
• GMD_TECH_EXP_SEQ_ID_S — Sequence used to generate expression identifiers.
• PLITBLM — Standard OPM parse/token buffer table used for string tokenization.

Usage Notes

GMD_EXPRESSION_UTIL is invoked internally by OPM functionality that supports calculated technical parameters and specifications. It is referenced by one other package and is typically called during formula, recipe, or quality specification processing, including from Oracle Forms and from server-side packages that evaluate technical data lines. Custom code should treat the package as an internal utility: there is no documented public API surface or naming convention, and parameter signatures are subject to change between patch levels. Implementers integrating expression logic should call the higher-level OPM business APIs where available, and reserve direct calls to EVALUATE_EXPRESSION or PARSE_EXPRESSION for cases where no supported API exists.