Results for “get_dispense_config”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GMO_MBR_UTIL is a utility package in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, owned by the APPS schema and classified as a UTIL-type API. It belongs to the Oracle Process Manufacturing (OPM) family of modules — specifically the Master Batch Record (MBR) and Electronic Records / Electronic Signatures (ERES) functionality. Its principal business role is to bridge the ERES business event framework to the generation of Master Batch Record content. When a business event occurs, the package resolves the configured ERES template, assembles the corresponding XML payload, and exposes supporting lookups such as organization, user display name, and dispensing configuration. In this way it enables Oracle EBS to render MBR information dynamically for a given event and event key, and to present that information through pages such as the View MBR Page.

Key Procedures and Functions

The package exposes eight documented procedures and functions:

• GET_TEMPLATE_CODE — retrieves the template code based on the ERES setup for a given event name and event key combination.
• GET_MBR_XML — returns the XML (as a CLOB) for the ERES event and event key combination, used to generate the Master Batch Record.
• GET_TEMPLATE_CODE_AND_XML — a wrapper on the two functions above, reducing JDBC calls from the View MBR Page. It returns the template code, a query ID for navigating to the Evidence Store Query Page, and the MBR XML.
• GET_TEMPLATE_CODE_AND_QUERYID — retrieves the template code together with a query identifier used for evidence-store navigation.
• GET_USER_DISPLAY_NAME — resolves the display name of a user, supporting identification within MBR output and pages.
• GET_ORGANIZATION — returns organization information, typically the organization name or identifier associated with the current context.
• GET_DISPENSE_CONFIG — retrieves dispensing configuration values relevant to the MBR dispensing process.
• SET_GLOBAL_ORGID — sets the package-level global variable G_ORGANIZATION_ID, establishing the organization context for subsequent calls.

Tables Accessed

The package reads from several APPS synonyms that support its lookups and event resolution:

• HR_ALL_ORGANIZATION_UNITS — supplies organization definitions, supporting GET_ORGANIZATION and the global organization identifier.
• MTL_PARAMETERS — provides organization-level inventory/parameter configuration, including default organization context.
• WF_EVENT_SUBSCRIPTIONS — the Workflow event subscription table, used to resolve which ERES setup applies to a given business event and event key.
• DUAL — used for simple single-row computations and default value resolution.
• PLITBLM — a standard EBS PL/SQL table type used for handling collections or list aggregates within the package logic.

Usage Notes

GMO_MBR_UTIL is typically invoked internally by OPM MBR and ERES components rather than directly by end users. The package is referenced by two other packages in the EBS codebase, confirming its role as a shared utility layer. It is called when viewing or generating Master Batch Record content — for example, from the View MBR Page, where the wrapper GET_TEMPLATE_CODE_AND_XML consolidates multiple lookups into a single database round trip. Custom code or extensions that need to resolve an ERES template, fetch MBR XML, obtain organization or user display data, or apply dispensing configuration may call these APIs directly. Because G_ORGANIZATION_ID is a session-level global variable, callers that depend on organization context should invoke SET_GLOBAL_ORGID before calling procedures that rely on it. The package is header-versioned (GMOMBRUS.pls 120.4), reflecting its long-standing role within the OPM schema.