Search Results get_period_info

Overview

PO_PERIODS_SV is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It is declared with AUTHID CURRENT_USER, meaning that its SQL statements execute under the privileges of the calling session rather than the definer, so authorization depends on the grants held by the invoking user. The package encapsulates the accounting period resolution logic used by Oracle Purchasing when dates supplied by a caller must be translated into meaningful General Ledger period attributes. Its central purpose is to accept one or more transaction or encumbrance dates, apply a caller-supplied rolling rule, and return the corresponding period name, period year, period number, quarter number, and an indicator of whether any supplied date falls outside a valid open or defined period. This is the mechanism that allows Purchasing documents — requisitions, purchase orders, receipts, and encumbrances — to be reported and accrued against the correct GL calendar period for a given set of books.

Key Procedures and Functions

• GET_PERIOD_INFO — The primary public entry point and the object most commonly located through searches such as "get_period_info". It accepts a rolling logic parameter, a set of books identifier, and a table of dates, and returns parallel collections containing period names, period years, period numbers, and quarter numbers, together with an invalid period flag. It is the procedure that performs the bulk period derivation used by Purchasing reporting and period-close logic.
• GET_PERIOD_NAME — A single-value convenience routine that accepts a set of books identifier and a GL date and returns the corresponding GL period name. It is typically used when a caller needs the period for exactly one date rather than an array.
• BUILD_GL_ENCUMBERED_DATE — Documented in the ETRM 12.2.2 metadata for this package. It supports the derivation of the GL encumbered date associated with Purchasing encumbrance accounting, consistent with the package's role in period and encumbrance date processing.
• GET_GL_DATE — Documented in the ETRM 12.2.2 metadata for this package. It provides the inverse or complementary resolution, returning a GL date given the period-oriented inputs supplied by the caller.

Tables Accessed

• GL_PERIOD_STATUSES — The authoritative source of accounting period definitions, open/closed status, and the period-to-date mapping for the specified set of books. GET_PERIOD_INFO reads this table to resolve dates to period names, years, numbers, and quarters.
• FINANCIALS_SYSTEM_PARAMETERS — Provides the set-of-books and financials configuration context used to interpret the rolling rule and calendar assignments.
• PO_SESSION_GT and PO_SESSION_GT_S — Global temporary tables used by the Purchasing session framework to stage working data during period and date processing.
• DUAL and PLITBLM — Utility objects used for expression evaluation and PL/SQL table iteration within the package logic.

All access is performed through APPS synonyms, and the package is referenced by ten other packages, indicating it is a shared utility rather than a self-contained transaction API.

Usage Notes

PO_PERIODS_SV is not exposed as a user-facing form or concurrent program entry point in its own right. It is invoked from within other Purchasing PL/SQL packages, from period-close and encumbrance processing routines, and from custom extensions that need to translate dates into GL period attributes for a specified set of books. Because it is declared AUTHID CURRENT_USER, custom callers must hold the necessary privileges on the underlying GL and financials tables, or the call must be made in a context where APPS-equivalent grants are available. The po_tbl_date and po_tbl_varchar30 collection types used by GET_PERIOD_INFO allow batch resolution of many dates in a single call, which is the preferred pattern for reporting logic that would otherwise issue one lookup per row. When a date cannot be resolved to a valid period, callers should inspect the invalid period flag returned by GET_PERIOD_INFO before using the returned period attributes.