Search Results get_currency_info

Overview

APPS.POGOT_S is a server-side PL/SQL package body in the Oracle E-Business Suite Purchasing (PO) module. Its name reflects its role as a Purchasing "Get" utility package — a collection of small helper routines that retrieve commonly needed reference data for the Oracle Purchasing application. Rather than duplicating currency and set-of-books lookups across multiple forms, concurrent programs, and APIs, Oracle consolidated these accessors into POGOT_S so that callers can obtain validated currency information and purchasing document currency context through a single, stable interface.

The package is classified as OTHER in the ETRM metadata, meaning it is an internal utility rather than a formally published open API. It does not own business entities, nor does it perform transaction processing; instead, it centralizes read-only queries against Oracle Purchasing and Oracle General Ledger tables. The source header identifies the package as a long-lived component (last revised 2002), which is consistent with its role as foundational plumbing reused by higher-level Purchasing logic. The user search term "get_currency_info" corresponds directly to the first documented procedure, which is the most frequently referenced entry point in this body.

Key Procedures and Functions

The ETRM metadata for POGOT_S lists two documented program units: NAME and ECX_GET_TOTAL. The package body excerpt additionally exposes GET_CURRENCY_INFO, GET_PO_CURRENCY, and GET_REQ_CURRENCY, all of which are described below since the excerpt represents the authoritative package source.

• GET_CURRENCY_INFO — Retrieves currency precision and minimum accountable unit information for a supplied currency code. It delegates to the Oracle Application Object Library routine FND_CURRENCY.GET_INFO, which is the canonical source of currency formatting attributes. Errors are trapped via PO_MESSAGE_S.SQL_ERROR and re-raised.
• GET_PO_CURRENCY — Returns both the functional (base) currency of the ledger and the transaction currency of a specific purchasing document, identified by its object ID. This supports forms and reports that must display amounts in both currencies.
• GET_REQ_CURRENCY — Returns the base currency applicable to a requisition context, using an object ID as input.
• ECX_GET_TOTAL — A documented procedure associated with E-Commerce Exchange (ECX) integration scenarios, used to supply total values for exchange processing.
• NAME — A documented program unit within the package, recorded in the ETRM repository.

Tables Accessed

Through APPS synonyms, POGOT_S reads the following tables:

• FND_CURRENCIES — Currency definition master, accessed indirectly through FND_CURRENCY.GET_INFO.
• FINANCIALS_SYSTEM_PARAMETERS and GL_SETS_OF_BOOKS — Used to resolve the functional currency of the operating ledger.
• PO_HEADERS / PO_HEADERS_ALL — Source of the document currency for purchase orders and releases.
• PO_LINES / PO_LINES_ALL, PO_LINE_LOCATIONS / PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS / PO_DISTRIBUTIONS_ALL, PO_RELEASES / PO_RELEASES_ALL — Document hierarchy used to derive totals and line-level currency context.
• PO_REQUISITION_LINES / PO_REQUISITION_LINES_ALL — Requisition currency resolution.

Usage Notes

POGOT_S is invoked internally by at least five other packages within the Purchasing schema and by Oracle Forms and concurrent programs that need currency context. The GET_CURRENCY_INFO routine in particular is called whenever a form must format or validate a currency amount, while GET_PO_CURRENCY and GET_REQ_CURRENCY are used to populate currency fields on purchasing documents. Because these procedures are not formally published APIs, customizations should call them only after verifying signature stability across patch levels; direct querying of the underlying tables with the same join conditions is the recommended alternative for bespoke extensions.