Search Results gml_rq_db_common




Overview
Explore in AI Chat

Overview

GML_RQ_DB_COMMON is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM API taxonomy as OTHER. Its header file, GMLRQXCS.pls (with the corresponding body conventionally named GMLRQXCB.pls per the inline comments), is a component of the Oracle Process Manufacturing (OPM/GML) Requisitions module. The package was authored to supply database-level procedures and functions consumed specifically by the Requisitions processing flow, hence the RQ segment in its name. Its stated design purpose is to encapsulate database logic required by REQUISITIONS functionality rather than to serve as a general-purpose inventory API.

The original source header carries the revision string $Header: GMLRQXCS.pls 115.1 2002/12/04 00:03:12 mchandak noship $, indicating a creation date in July 2002 (09-JUL-2002, PBamb) and a later version managed by mchandak. The package is declared with AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking session rather than as definer rights, an important consideration for synonym resolution in the APPS environment. The body is documented as terminating after a single declared callable, making this a small, focused utility package rather than a broad functional library.

Key Procedures and Functions

The ETRM documentation records exactly one callable in this package: GET_OPM_COST_PRICE. Per the inline comments, this procedure returns the process-manufacturing cost for an item within a specified process organization, applied to an internal order context. It is a procedure (not a function) and its cost value is returned through an OUT parameter rather than a function return.

The documented parameter intent is as follows: an item identifier input, an organization identifier input (the process organization), a document unit-of-measure input, and an in-out numeric parameter that carries the unit price. Because it is declared IN OUT NOCOPY, the unit price may be passed in with a starting value and overwritten with the retrieved OPM cost, and the NOCOPY hint avoids a copy-back for the parameter on return. No further procedures or functions are documented for this package.

Tables Accessed

The package reads OPM base tables exposed through APPS synonyms, as documented in the ETRM table reference:

  • IC_ITEM_MST — the OPM item master. This supplies item attributes needed to identify the item and its costing characteristics within the process organization.
  • IC_WHSE_MST — the OPM warehouse master. This supplies warehouse and organization context used to resolve the cost for the appropriate process organization.

Both are read-only reference sources for cost resolution; the documented metadata records no insert, update, or delete activity. No interface or temporary tables are documented.

Usage Notes

Because the package declares a single cost-retrieval callable and is documented as referenced by zero other packages, it is a leaf-level utility invoked directly by its consumers rather than shared through a call chain. Typical invocations are expected from the OPM Requisitions forms and from requisition-related concurrent or custom code that requires an item's process cost at the point of requisition line entry or validation, particularly where an internal order references an OPM item in a process organization.

Two practical cautions follow from the documented attributes. First, the AUTHID CURRENT_USER declaration means callers must have appropriate privileges on IC_ITEM_MST and IC_WHSE_MST, or must invoke the package from a context where those APPS synonyms resolve correctly. Second, no error-handling or exception behavior is documented in the available metadata; callers should therefore validate the returned unit price before using it in downstream requisition pricing logic. Both EBS 12.1.1 and 12.2.2 retain this package in the APPS schema with the same single-callable interface.