Search Results po_session_gt_s




Overview
Explore in AI Chat

Overview

PO_PERIODS_SV is an Oracle Applications (APPS) PL/SQL server-side package body that provides period-related utility services for the Oracle Purchasing module. Its principal business function is to resolve accounting period information for purchasing documents and encumbrance processing. The package answers questions such as which accounting period is open, what the period name is for a given date, and what GL date should be derived for encumbrance accounting entries. In Oracle EBS 12.1.1 and 12.2.2, this logic is essential because purchasing transactions must be dated into valid, open General Ledger periods. Encumbrance accounting in particular requires that commitments and obligations be stamped with a GL date that aligns with the open period of the relevant set of books.

PO_PERIODS_SV is classified under ETRM as an "OTHER" API, meaning it is an internal utility rather than a formally published public interface. Its status is VALID, and it is referenced by ten other database objects, indicating it is a shared service consumed across purchasing-related code paths. The body also depends on the PO_SESSION_GT and PO_SESSION_GT_S global temporary tables, along with supporting collection types PO_TBL_DATE, PO_TBL_NUMBER, and PO_TBL_VARCHAR30.

Key Procedures and Functions

The ETRM metadata documents four procedures and functions within this package body:

  • GET_PERIOD_INFO — The primary routine that retrieves period information for a given context. It is the central entry point through which callers obtain the accounting period applicable to a purchasing transaction, drawing on GL period status data and financials system parameters.
  • GET_PERIOD_NAME — Returns the accounting period name associated with a supplied date or period identifier, typically derived from GL_PERIOD_STATUSES. This supports user-facing display of period labels.
  • BUILD_GL_ENCUMBERED_DATE — Constructs the appropriate GL date for encumbrance accounting. This routine ensures encumbrance entries are assigned a date falling within a valid open period.
  • GET_GL_DATE — Derives and returns the GL date to be stamped on purchasing transactions, based on the resolved period information and system parameters.

These four units work together: period resolution feeds GL date derivation, which in turn supports encumbrance date construction.

Tables Accessed

The package reads and references the following objects:

  • FINANCIALS_SYSTEM_PARAMETERS — Supplies system-level accounting configuration, such as the set of books and period-related defaults used to resolve valid periods.
  • GL_PERIOD_STATUSES — The authoritative source for period names, open/closed status, and period date ranges against which purchasing transactions are validated.
  • GL_SETS_OF_BOOKS — Provides set of books context needed to scope period and date logic correctly.
  • PO_SESSION_GT and PO_SESSION_GT_S — Global temporary tables used to stage session-scoped data during period and GL date processing.
  • DUAL and PLITBLM — Utility objects supporting PL/SQL expressions and collection handling.

Supporting collection types PO_TBL_DATE, PO_TBL_NUMBER, and PO_TBL_VARCHAR30 facilitate bulk processing of dates, numbers, and strings respectively.

Usage Notes

PO_PERIODS_SV is invoked internally by Oracle Purchasing forms, concurrent programs, and other purchasing packages that must determine a valid GL date or period name before committing transactions. Because it is referenced by ten database objects, it functions as a shared utility layer rather than a standalone entry point. In Oracle EBS 12.1.1 and 12.2.2, the package relies on PO_SESSION_GT and PO_SESSION_GT_S to hold transient session data during processing, and on the FND_API and PO_DEBUG utilities for error handling and diagnostics. Custom code should generally call the higher-level purchasing APIs rather than PO_PERIODS_SV directly, since the package is not a published public interface.