Search Results set_ar_cc

Overview

APPS.GLR03300_PKG is a General Ledger utility package body in Oracle E-Business Suite (12.1.1 and 12.2.2) whose primary role is to seed, hold, and retrieve the runtime criteria used by the GLR03300 inquiry and reporting logic. The package implements a session-level context holder: callers invoke the SET_* procedures to populate a set of package-level global variables (code_combination_id, budget_version_id, encumbrance_type_id, template_id, factor, currency_code, translated_flag, balance_type, currency_type, actual_flag, ledger_id, period_name, and ledger_currency), and then invoke the GET_* functions to read those values back during the query execution. The header comment ($Header: gl03300b.pls 120.8 2005/05/05) indicates the package predates Release 12 and has been maintained across the EBS 11i/R12 lineage. ETRM classifies the package as API classification OTHER, reflecting that it is an internal, non-public interface rather than a certified open API.

Key Procedures and Functions

The 22 documented subprograms fall into three groups. The criteria-setter group establishes the query context: SET_CRITERIA accepts the full primary criterion list; SET_SEC_CRITERIA accepts the same core criteria plus the secondary (secondary actual flag, secondary budget version, and secondary encumbrance type) values used for comparative columns; SET_LEDGER_ID sets the ledger context; and SET_AR_CC sets the AR (accounting/reconciliation) code combination context associated with the request. The accessor group returns the held values for use by downstream SQL and PL/SQL: GET_CODE_COMBINATION_ID, GET_BUDGET_VERSION_ID, GET_ENCUMBRANCE_TYPE_ID, GET_TEMPLATE_ID, GET_ENTERED_CURRENCY_CODE, GET_TRANSLATED_FLAG, GET_BALANCE_TYPE, GET_FACTOR, GET_CURRENCY_TYPE, GET_ACTUAL_FLAG, GET_SEC_ACTUAL_FLAG, GET_SEC_BUDGET_VERSION_ID, GET_SEC_ENCUMBRANCE_TYPE_ID, GET_LEDGER_ID, and GET_AR_CC. The remaining documented procedure, POPULATE_FIELDS, performs the derived/calculated population of member fields required to render the report or inquiry output. Because SET_AR_CC and GET_AR_CC are the pair most frequently referenced in searches, they merit emphasis: SET_AR_CC records the account code combination used for the AR-side amount, and GET_AR_CC exposes that value so the reporting layer applies identical account filtering to the AR figures as to the GL figures.

Tables Accessed

The package references seven GL tables through APPS synonyms. GL_BUDGET_VERSIONS and GL_ENCUMBRANCE_TYPES support validation and description lookup of the budget version and encumbrance type criteria. GL_DAILY_CONVERSION_TYPES is used to validate or resolve the conversion rate type implied by the currency criteria. GL_JE_HEADERS, GL_JE_BATCHES, GL_JE_CATEGORIES, and GL_JE_SOURCES supply the journal-level data on which the inquiry and the factor-based aggregation operate. The presence of these tables confirms that GLR03300_PKG drives journal-driven balances and encumbrance inquiries rather than ledger balance table (GL_BALANCES) access alone.

Usage Notes

GLR03300_PKG is an internally scoped package and is referenced by 10 other packages, all of which are expected to call the SET_* procedures to establish context before calling the GET_* accessors or POPULATE_FIELDS. Typical invocation originates from the Oracle General Ledger inquiry forms and the related GLR03300 report program, where the user's entered criteria are passed to SET_CRITERIA / SET_SEC_CRITERIA and the report's SQL subsequently calls the GET_* functions. Custom extensions should avoid calling the package across concurrent-request boundaries without first re-invoking the SET_* procedures, since the package variables are session-scoped and not re-entrant. Because the class is OTHER, Oracle does not guarantee backward compatibility of the subprogram signatures across patches, so any custom code that references SET_AR_CC, GET_AR_CC, or the other members should be regression-tested during EBS patching and upgrades.