Search Results get_gl_period_status

Overview

OKL_ACCOUNTING_UTIL is a utility package in the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite, owned by the APPS schema. It provides shared accounting helper routines used across the lease management subledger for currency conversion, account validation, period status checks, flexfield segment resolution, and lookup translation. The package is a foundational utility: it is referenced by 393 other packages, indicating that it underpins much of the accounting, contract, and asset processing logic in the OKL application.

The package specification declares several PL/SQL collection and record types that standardize how segment numbers, segment names, and segment descriptions are passed between OKL programs. Notably, seg_num_array_type, seg_array_type, and seg_desc_array_type support key flexfield segment handling, while error_message_type and seg_num_name_type support error propagation and segment metadata. The package also defines a large set of global constants governing error messaging and versioning, including G_UNEXPECTED_ERROR, G_VERSION_OVERLAPS, G_SQLERRM_TOKEN, G_SQLCODE_TOKEN, and the version increment constants G_INIT_VERSION, G_VERSION_MAJOR_INCREMENT, and G_VERSION_MINOR_INCREMENT. A fixed high-date constant, g_final_date, is computed from a Julian base to represent an effective end-of-time date without relying on locale-sensitive date formats.

Key Procedures and Functions

The 58 documented routines (of which the ETRM excerpt lists 20) cluster into functional groups:

• Flexfield and segment utilities: GET_SEGMENT_ARRAY, GET_ACCOUNTING_SEGMENT, and GET_CONCATE_DESC resolve key flexfield segment numbers, values, and concatenated descriptions for accounting code combinations.
• Validation routines: VALIDATE_LOOKUP_CODE, VALIDATE_CURRENCY_CODE, VALIDATE_GL_CCID, and VALIDATE_SOURCE_ID_TABLE verify that lookups, currencies, GL code combinations, and source identifiers are valid before accounting is generated. The user-searched term get_draft_actual_trx relates to draft versus actual transaction handling, a related accounting concern addressed by these validations.
• Period status checks: GET_OKL_PERIOD_STATUS and GET_GL_PERIOD_STATUS return the open/closed state of the OKL and General Ledger periods, used to prevent posting into closed periods.
• Set of Books utilities: GET_SET_OF_BOOKS, GET_SET_OF_BOOKS_ID, and GET_SET_OF_BOOKS_NAME retrieve the ledger (set of books) context for accounting entries.
• Currency and amount routines: GET_CURR_CON_RATE obtains the currency conversion rate, and ROUND_AMOUNT applies currency-aware rounding to monetary values.
• Lookup and translation helpers: GET_RULE_MEANING, GET_LOOKUP_MEANING, GET_LOOKUP_MEANING_LANG, and GET_FA_LOOKUP_MEANING return human-readable meanings for accounting rules, lookup codes, and fixed asset lookups, including language-specific variants.
• Error handling: GET_ERROR_MESSAGE and GET_ERROR_MSG format and return standardized error text for callers.

Tables Accessed

The package reads from several foundation and application tables via APPS synonyms:

• Flexfield tables: FND_ID_FLEX_SEGMENTS, FND_ID_FLEX_SEGMENTS_TL, FND_FLEX_VALUES, and FND_FLEX_VALUE_SETS supply segment definitions and valid values.
• Currency table: FND_CURRENCIES validates currency codes and conversion metadata.
• Application table: FND_APPLICATION resolves application identifiers for lookups and flexfields.
• Fixed asset tables: FA_BOOKS, FA_BOOK_CONTROLS, FA_DEPRN_PERIODS, and FA_LOOKUPS provide depreciation book and period information relevant to leased asset accounting.
• OKL/OKC tables: OKL_K_HEADERS and OKC_K_HEADERS_B provide contract header context, and AK_REGION_ITEMS, AK_REGION_ITEMS_TL, and AK_ATTRIBUTES_TL supply descriptive flexfield region and attribute metadata.

Usage Notes

OKL_ACCOUNTING_UTIL is invoked primarily from other PL/SQL packages within the OKL accounting and contract generation flow, as evidenced by its 393 dependent packages. It is not typically called directly from end-user forms; instead, forms, concurrent programs such as accounting generation and period-close processes, and custom extensions call it indirectly through those dependent packages. Consequently, any modification to this package carries broad impact, and it should be treated as a shared infrastructure object. Its error-message and versioning constants ensure consistent error reporting and version tracking across the OKL accounting stack in both EBS 12.1.1 and 12.2.2.