Results for “gmca_get_perbal”

8 results




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

Overview

APPS.PMI_COST_ANALZ_PACK is a valid PL/SQL package body residing in the APPS schema and is classified as an "OTHER" API within the Oracle EBS 12.1.1 / 12.2.2 environment. It belongs to the Process Manufacturing (OPM) cost analysis functional area, as indicated by the PMI prefix, and provides the server-side logic used to compute, retrieve, and analyze item costs and period balances. Its procedures support cost variance reporting, inventory valuation, on-hand quantity retrieval, unit-of-measure conversion, and currency/warehouse resolution — all core requirements of process manufacturing costing and month-end close activities. The package relies on APPS synonyms to reference base product tables across the GME, IC, CM, FM, and SY product families, and it is not referenced by any other database object, meaning it is a top-level consumer of data rather than a shared building block. It is, however, itself dependent on a large set of sibling and product tables, reflecting its role as a central costing query engine.

Key Procedures and Functions

The documented interface exposes eleven procedures and functions. Each is described below by purpose only.

  • GMCA_GET_COST — Retrieves the cost of an item for the relevant organization and cost context, forming the basis for valuation and variance calculations.
  • GMCA_GET_PERBAL — Returns period balance information, typically the inventory balance held for an item, location, or period as stored in period balance records.
  • GMCA_GET_LINE_TYPE — Derives or classifies the line type associated with a cost or material transaction, used to categorize cost elements during analysis.
  • GMCA_INV_PEREND — Handles inventory activity at period end, supporting the closing and roll-forward of period balances.
  • GMCA_VARIANCE — Computes cost variance between actual and expected or standard values, the primary analytical output of the package.
  • GMCA_GET_ONHANDQTY — Returns the on-hand quantity for an item and location, drawn from inventory location and period balance data.
  • GMCA_GET_MEANING — Resolves a lookup code to its descriptive meaning, using the lookup repository for cost and line-type decodes.
  • GMCA_IUOMCV — Performs inventory unit-of-measure conversion, translating quantities between the inventory UOM and the item's primary UOM.
  • GMCA_UOMCV — Provides a general unit-of-measure conversion utility used across costing and quantity routines.
  • GMCA_COST_WHSE — Determines the warehouse (cost warehouse) applicable to a costing request, resolving which warehouse's cost should be used.
  • GMCA_WHSE_CURRENCY — Returns the currency associated with a warehouse, required for currency-denominated cost and variance reporting.

Tables Accessed

The package reads and writes through APPS synonyms covering several functional areas.

Usage Notes

PMI_COST_ANALZ_PACK is typically invoked from OPM cost analysis forms, cost variance and inventory valuation concurrent programs, and custom reporting or extension code that requires standardized cost, balance, UOM, and warehouse-currency resolution. Because it is referenced by twelve other packages but references none of them in return at the top level, it behaves as a low-level costing service. Developers should treat it as a read-oriented utility layer, invoke it in the context of an initialized OPM organization and period, and avoid assuming side effects beyond those implied by the period-end and balance routines. When extending OPM costing, calling these documented procedures is preferable to re-deriving cost logic against the underlying tables.