Search Results po_core_s2




Overview
Explore in AI Chat

Overview

APPS.PO_CORE_S2 is a valid PL/SQL package body in the Oracle E-Business Suite Purchasing (PO) module, classified as API type OTHER within the ETRM metadata for release 12.2.2. It functions as a low-level currency services utility within the Oracle Purchasing core layer, supplying the currency retrieval, validation, and monetary conversion logic that higher-level Purchasing APIs, forms, and concurrent programs rely upon. The package bridges standard Oracle Financials currency facilities — notably FND_CURRENCY and the General Ledger chart-of-accounts structures — with Purchasing-specific configuration held in PO_SYSTEM_PARAMETERS_ALL, ensuring that requisitions, purchase orders, and their downstream documents consistently resolve buying, operating, and base currency information.

Key Procedures and Functions

The documented package exposes eight procedures and functions, with seven named in the metadata and consolidated around currency resolution:

  • GET_REQ_CURRENCY — Returns the currency applicable to a requisition, taking into account requisition-level and system-level currency defaults.
  • GET_CURRENCY_INFO — Provides general currency attributes and descriptive information for a given currency code.
  • GET_CURRENCY_INFO_DETAILS — Supplies the expanded detail set for currency information, complementing GET_CURRENCY_INFO with additional descriptive attributes.
  • GET_PO_CURRENCY — Resolves the document currency for a purchase order, honoring the currency stored on the PO header.
  • GET_BASE_CURRENCY — Determines the ledger base currency from the financials system parameters and set of books definition.
  • GET_PO_CURRENCY_INFO — Returns the combined currency information associated with a purchase order, joining the PO-specific currency with its descriptive attributes.
  • ROUND_AND_CONVERT_CURRENCY — Performs monetary conversion between currencies and applies the appropriate rounding rules to the resulting amount.

Parameter lists are not exposed in the ETRM metadata and are deliberately not reproduced here; consumers should inspect the package specification in the target instance for exact signatures.

Tables Accessed

The package reads configuration and transactional currency data through the following referenced objects, all accessed via APPS synonyms:

  • PO_SYSTEM_PARAMETERS_ALL — Purchasing system-level defaults, including the default currency behavior for the operating unit.
  • FINANCIALS_SYSTEM_PARAMETERS and FINANCIALS_SYSTEM_PARAMS_ALL — Financials system options that govern ledger and currency defaults.
  • PO_HEADERS_ALL — Purchase order headers, the source of document currency values.
  • PO_SESSION_GT and PO_SESSION_GT_S — Session-level global temporary structures used to cache working values during a Purchasing session.
  • DUAL and PLITBLM — Utility objects used for scalar evaluation and PL/SQL table handling.

Currency reference data is obtained through dependencies on FND_CURRENCY and GL_SETS_OF_BOOKS, while error and diagnostic handling leverage FND_MSG_PUB, FND_API, and PO_DEBUG.

Usage Notes

PO_CORE_S2 is an internal core-layer package rather than a publicly published API. It is referenced by 25 other database objects, indicating that Purchasing forms, requisition and purchase order APIs, and currency-related validation routines call it indirectly. Custom code should not invoke it as a substitute for supported APIs, but developers diagnosing currency inconsistencies on requisitions or purchase orders may trace execution into this package. Among its documented dependents is PO_MESSAGE_S, reflecting its role in message-driven error reporting during currency processing. Because the body depends on session global temporary tables and system parameter tables, behavior can vary by operating unit and session context, so test conclusions should be validated in the target environment.