Results for “t_genref”

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

Overview

GME_MOBILE_LOVS is a PL/SQL package owned by the APPS schema that supports the Java-based Oracle Process Manufacturing (OPM/GME) Mobile Application. Its stated purpose, per the package header, is to contain PL/SQL cursors used to fetch data for the mobile list of values (LOV) screens — the selection dialogs that let a mobile user pick a batch, resource, ingredient, lot, subinventory, or locator without typing codes by hand. In Oracle EBS 12.1.1 and 12.2.2 the package belongs to the Process Manufacturing suite and is classified under ETRM as an "OTHER" API rather than a formal public interface, meaning Oracle does not guarantee its signature across releases and it is intended for internal consumption by the OPM mobile front end.

The package header shows a strongly typed REF CURSOR, t_genref, which most procedures use as their OUT parameter so the Java layer can iterate a result set directly. The header also records a commented-out record type, allocation_rec, and associative array allocation_tab, remnants of earlier design work. The version string 120.15.12000000.3 and dated history entries (2005–2006) confirm that the package is mature and essentially frozen; the last functional changes were bug fixes for lot-controlled item filtering and expiration-date filtering.

Key Procedures and Functions

The 59 documented procedures are LOV data providers. They are grouped logically by the mobile flow they serve:

• Batch and step selection: BATCH_LOV, STEP_INGREDIENT_LOV, STEP_INGREDIENT_LINE_LOV, STEP_PROD_BYPROD_LOV, STEP_PEND_LOT_LOV, STEP_ALL_ITEMS_LOV, INGREDIENT_STEP_LOV.
• Ingredient and reservation selection: INGREDIENT_LOV, INGREDIENT_LINE_RSRV_LOV, INGREDIENT_RSRV_LOV, RSRV_LOV, ING_SUBINVENTORY_LOV_RSRV, ING_LOCATOR_LOV_RSRV, SUBINVENTORY_ONHAND_LOV, LOCATOR_ONHAND_LOV, DISPENSE_LOV.
• Lot and revision selection: PNDLOT_LOV, REVISION_TXN_LOV. History entries document the addition of Step_Material_Lot_Line_LoV, Material_Lot_LoV, Revision_LoV, Pending_Parent_Lot_LoV, and Lot_OnHand_Exp_LoV to constrain lots to lot-controlled items and to filter by expiration date.
• Activity, resource and resource instance selection: ACTIVITY_LOV, RESOURCE_LOV.

No parameter lists are reproduced here because the excerpt shows only the first procedure signature, Batch_LoV(x_batch_cursor OUT NOCOPY t_genref, p_org_id IN NUMBER ...). That signature illustrates the common pattern: an organization-scoped IN parameter plus a REF CURSOR OUT parameter.

Tables Accessed

The package reads through APPS synonyms of the OPM base tables. Batch and process context come from GME_BATCH_HEADER, GME_BATCH_STEPS, GME_BATCH_STEP_ACTIVITIES, GME_BATCH_STEP_ITEMS and GME_BATCH_STEP_RESOURCES. Ingredient and material data come from GME_MATERIAL_DETAILS and the global temporary table GME_MATERIAL_DISPENSING_GTMP. Pending lot information is drawn from GME_PENDING_PRODUCT_LOTS. Resource and activity data come from GME_RESOURCE_TXNS, GME_RESOURCE_TXNS_GTMP, GMP_RESOURCE_INSTANCES, GMD_OPERATIONS and CR_RSRC_DTL. Organization defaults and user context are supplied by GME_PARAMETERS and FND_USER. All access is read-only in character; the package exists to populate LOVs, not to post transactions.

Usage Notes

GME_MOBILE_LOVS is invoked by the OPM Mobile Java client, not by Oracle Forms or standard concurrent programs. It is referenced by zero other PL/SQL packages per the ETRM dependency data, confirming it sits at a leaf of the call graph. Customizations that call it directly inherit the same risk profile as any internal API: the REF CURSOR contract and procedure names may change without notice in a patch or upgrade. Implementations extending the mobile LOV behavior should prefer wrapping the packaged procedures in their own code rather than modifying the package body, and should re-validate behavior after applying Process Manufacturing patches since the object is not part of the supported public API set.