Search Results gl_get_period_info

Overview

GMF_GL_GET_PERIOD_INFO is an APPS-owned PL/SQL package body in Oracle EBS Financials/Process Manufacturing that resolves General Ledger accounting period information for a given calendar and date. Its purpose is to translate a set of book, an accounting calendar (period set), a period type, and a point-in-time date into the corresponding GL period attributes: period name, period status (closing status and status code), period year and number, quarter number, description, start date, and end date. The package is functionally rooted in the SQLGL application schema, as evidenced by the internal lookup of the application identifier using the short name 'SQLGL' from FND_APPLICATION.

The package encapsulates period-set and period-status logic so that other Process Manufacturing and Financials components do not need to query GL tables directly. It is classified as OTHER, meaning it is a supporting/internal utility rather than a full public API, and it is referenced by one other package in the documented instance.

Key Procedures and Functions

• GL_GET_PERIOD_INFO — The single documented program unit. It accepts a calendar name (period set), a period type, a date within the period, a set of books name, and an application abbreviation, and returns period detail including the period name, closing status, period year, period number, quarter number, period description, a numeric status code, a row-to-fetch indicator, and the period start and end dates. Internally it first derives the application identifier for SQLGL from FND_APPLICATION and then delegates set-of-books resolution to GMF_GL_GET_SOB_ID.PROC_GL_GET_SOB_ID. Its parameter list is not reproduced here; the documented signature shows both IN and OUT (and IN OUT) NOCOPY parameters, confirming it is designed for programmatic invocation.

Tables Accessed

The package reads four tables via APPS synonyms:

• FND_APPLICATION — Used to translate the application short name 'SQLGL' into the numeric application_id passed to subsequent queries.
• GL_PERIOD_SETS — Provides the period set (calendar) definition used to validate the incoming calendar name via a case-insensitive comparison of period_set_name.
• GL_PERIODS — Supplies the period name, period year, period number, quarter number, and the start and end dates that bracket the supplied date; filtering uses nvl on the input date so that year and period number can also be supplied directly.
• GL_PERIOD_STATUSES — Supplies the closing status for the matching period, constrained by set_of_books_id and application_id.

A driving cursor, cur_get_period_info, joins these tables and orders results by period year and period number.

Usage Notes

GMF_GL_GET_PERIOD_INFO is typically invoked by Process Manufacturing application logic and by custom code that must convert a transaction or inventory date into its owning GL period and closing status. Because it accepts both date-driven and year/period-number-driven inputs (through nvl-based predicates), it can be used for point-in-time period resolution as well as for lookups by explicit period year and number.

Callers must supply a valid calendar name and set of books; set-of-books resolution is externalized to GMF_GL_GET_SOB_ID, which the package calls with the SOB name. The integration with GL_PERIOD_STATUSES means the results reflect period open/close state, making the package useful for controls that must confirm whether an accounting period is open before posting. In EBS 12.1.1 and 12.2.2 environments the package remains part of the APPS schema and should be treated as an internal dependency; customizations should prefer supported APIs where available, but this package is a reliable utility for period attribute retrieval.