Search Results set_find_window_state

Overview

GLXJEENT_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified in the ETRM repository as an OTHER-type API. Its name follows the standard GLXJE prefix convention used by the General Ledger journal entry form family (GLXJEENT), indicating that the package supports the Journal Entry form rather than acting as a public, callable business API. The package is documented as VALID in both 12.1.1 and 12.2.2 and carries a dependency on SYS.STANDARD, the implicit PL/SQL base package.

The central business role of GLXJEENT_PKG is date-to-period resolution and period-state validation for journal entry processing. General Ledger journal lines are stored with accounting dates, while period balances, period status, and open/closed controls are maintained at the accounting period level. This package provides the deterministic mapping logic between those two concepts, together with caching and form-state helpers that reduce repeated lookups while a user is entering a journal.

Key Procedures and Functions

• CACHE_DATA — Populates and maintains the package-level cache used by the remaining routines, avoiding redundant database round trips for period and ledger information during a form session.
• GET_PERIOD — Returns the accounting period corresponding to a given date and ledger context, resolving the date through the period mapping structures.
• IS_PRIOR_PERIOD — Evaluates whether the resolved period precedes the current or entered period, supporting validation of back-dated journal entries.
• DEFAULT_STILL_GOOD — Determines whether a previously defaulted value (typically a period or date) remains valid for the current ledger and context before it is reused.
• DEFAULT_ACTUAL_PERIOD — Computes the actual accounting period to be defaulted into the journal entry when no period has been explicitly supplied.
• SET_FIND_WINDOW_STATE — Manages the state of the Journal Entry find/lookup window, controlling which records and period context the query window presents.

Tables Accessed

• GL_DATE_PERIOD_MAP — Provides the date-to-period mapping used by GET_PERIOD and DEFAULT_ACTUAL_PERIOD.
• GL_PERIODS — Supplies period definitions, including start and end dates, for the ledger's accounting calendar.
• GL_PERIOD_STATUSES — Supplies the open, closed, or future-enterable state of a period, which drives prior-period and default validation.
• GL_LEDGERS — Identifies the ledger and its associated calendar so that the correct period set is applied.
• GL_JE_HEADERS — Read for journal header context when validating or defaulting period values against an existing batch or entry.
• DUAL — Used for single-row computation and constant evaluation within the package logic.

Usage Notes

GLXJEENT_PKG is an internal form-support package. It is invoked by the Journal Entry form (GLXJEENT) during date entry, period defaulting, and find-window processing, and it is not intended as a public API for customer extensions. The ETRM metadata records no other packages referencing it, so callers are components within the same form/module family rather than downstream PL/SQL APIs.

Custom code should not call this package directly; the supported integration points for journal data remain the Journal Import and Journal Entry open interfaces. The presence of CACHE_DATA and DEFAULT_STILL_GOOD indicates that the package is stateful across a form session, so any direct invocation would require careful session-scoped initialization. The package is validated and available in both 12.1.1 and 12.2.2, with functionality unchanged between those releases according to the documented metadata.