Search Results get_code_combination_id

Overview

GLR03300_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its declared purpose, per the package header, is "to contain database functions needed in Account Inquiry form." The Account Inquiry form (also known as the Account Inquiry / Account Monitor functionality within General Ledger) allows users to drill into balances and journal activity for a given account code combination across ledgers, periods, currencies, and budget or encumbrance dimensions. Rather than embedding this query and navigation logic directly in the form, Oracle encapsulates it in GLR03300_PKG, where it can be reused by the form and by other server-side components.

The package is declared AUTHID CURRENT_USER and carries a ship-date header comment of 2005, indicating it has been stable across the 11i and R12 code lines. It is documented with 22 procedures and functions and is referenced by 10 other packages, which confirms it functions as a shared utility layer rather than a standalone API. Its API classification is OTHER — it is an internal implementation package, not a formally published public API with an AOL registration or an externally supported interface.

A distinguishing characteristic of the package is its heavy use of package-level (global) state. Variables such as code_combination_id, budget_version_id, encumbrance_type_id, currency_type, translated_flag, ledger_id, period_name, and ledger_currency are declared publicly at the package level. The package therefore operates as a session-scoped context holder: criteria are written once, then read back repeatedly by the accessor functions. Two parallel sets of state exist — a primary set populated by set_criteria and a secondary set populated by set_sec_criteria — which supports the form's ability to compare or display a second set of balance criteria alongside the first.

Key Procedures and Functions

The documented routines fall into three functional groups: state setters, field populators, and getters. The setters establish the session context. SET_CRITERIA assigns all non-secondary package global variables, covering account, budget, encumbrance, template, factor, currency, balance type, currency type, actual flag, ledger, period, and ledger currency. SET_SEC_CRITERIA performs the equivalent assignment for the secondary criteria set. SET_LEDGER_ID sets the ledger context specifically, and SET_AR_CC sets the AR code combination reference (that is, the ar_code_combination_id global associated with the balancing or intercompany account).

POPULATE_FIELDS is the workhorse routine: it derives and fills the remaining package variables from the criteria already established, so that the getters return consistent values.

The accessors expose individual pieces of the populated context. GET_CODE_COMBINATION_ID, GET_BUDGET_VERSION_ID, GET_ENCUMBRANCE_TYPE_ID, GET_TEMPLATE_ID, GET_FACTOR, GET_LEDGER_ID, and GET_AR_CC return the corresponding identifier or numeric value. GET_ENTERED_CURRENCY_CODE returns the entered currency, while GET_CURRENCY_TYPE returns the currency type indicator — the value that determines whether balances are presented in entered, translated, or ledger currency. GET_TRANSLATED_FLAG, GET_BALANCE_TYPE, and GET_ACTUAL_FLAG return their respective display and filtering attributes. The secondary variants — GET_SEC_ACTUAL_FLAG, GET_SEC_BUDGET_VERSION_ID, and GET_SEC_ENCUMBRANCE_TYPE_ID — expose the secondary criteria set for side-by-side comparison.

Tables Accessed

The package reads reference and transaction metadata through APPS synonyms. GL_DAILY_CONVERSION_TYPES supports currency type and conversion-rate-type determination. GL_BUDGET_VERSIONS and GL_ENCUMBRANCE_TYPES validate and resolve the budget and encumbrance dimensions used in balance inquiry. GL_JE_BATCHES, GL_JE_CATEGORIES, GL_JE_HEADERS, and GL_JE_SOURCES supply journal batch, category, header, and source context used to interpret and drill into the underlying journal activity behind a displayed balance. The package is primarily a read-oriented utility; the documented table list suggests it resolves identifiers and descriptive context rather than performing transactional writes.

Usage Notes

GLR03300_PKG is invoked by the Account Inquiry form, which calls set_criteria or set_sec_criteria when the user submits query criteria, then calls populate_fields to derive dependent values, and subsequently calls the get_* functions to render currency, budget, encumbrance, and flag information. The same pattern is available to custom code, but because the package depends on package-level globals, callers must invoke the setters before any getter in the same database session, and must re-invoke them whenever the user changes criteria. The presence of GET_CURRENCY_TYPE among the documented functions is directly relevant to the search term "get_currency_type": it is the accessor that returns the currency type indicator previously established through SET_CRITERIA or POPULATE_FIELDS. Because the package is not a formally registered public API, customizations should treat it as subject to change between patch levels and should prefer supported GL APIs where an equivalent public interface exists.