Results for “set_ledger_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BUDGET_INQUIRY_PKG is an APPS-owned PL/SQL package body in Oracle E-Business Suite, classified under the ETRM repository as a package of type OTHER. Its documented status is VALID, confirming that the compiled body is present and usable in the 12.1.1 and 12.2.2 environments. The package supports the Budget Inquiry functionality within the General Ledger / budgetary control domain, providing the programmatic layer that drives inquiry screens where users review budget balances, account ranges, and currency-related attributes. Rather than acting as a full accounting API, BUDGET_INQUIRY_PKG functions as a supporting inquiry utility: it maintains session-level criteria, resolves ledger and template context, retrieves currency and factor information, and validates detail account setup. The package is a foundational dependency rather than a widely consumed service — ETRM reports that it references other objects but is not itself referenced by any database object, while it is referenced by five other packages. This indicates an inward-facing role, supplying lookup and criteria-management routines to the inquiry forms and any custom extensions that build on the Budget Inquiry framework.

Key Procedures and Functions

The documented API surface comprises ten procedures and functions:

• SET_CRITERIA — establishes the inquiry criteria used to drive the budget inquiry query, capturing the user's selection parameters for subsequent retrieval.
• SET_LEDGER_ID — records the ledger context for the current inquiry session.
• GET_LEDGER_ID — returns the ledger identifier currently held in session state.
• GET_BVID — retrieves the budget version identifier associated with the inquiry.
• GET_CURRENCY — returns the currency applicable to the inquiry context.
• GET_TEMPLATE_ID — returns the template identifier used by the inquiry, supporting account hierarchy or report template selection.
• GET_FACTOR — returns the conversion or display factor applied to budget amounts.
• GET_FUNCT_CURR — returns the functional currency for the resolved ledger context.
• GET_CCID — returns the code combination identifier for the account in context.
• CHECK_DETAIL_ACCOUNTS — validates whether the accounts in the inquiry meet detail-account requirements, supporting Budget Inquiry display and validation logic.

Tables Accessed

ETRM documents one referenced table via APPS synonym: GL_ACCOUNT_HIERARCHIES. This table stores account hierarchy definitions used by General Ledger, and its presence indicates that BUDGET_INQUIRY_PKG resolves hierarchical account groupings when preparing budget inquiry output or validating detail account structure. The package also depends on FND_MESSAGE for message retrieval and APP_EXCEPTION for standardized error handling, plus STANDARD for common utility routines. These dependencies confirm that the package follows standard EBS error and messaging conventions rather than raising raw Oracle errors, which is expected for a forms-driven inquiry component.

Usage Notes

BUDGET_INQUIRY_PKG is typically invoked from the Budget Inquiry form or from custom code that extends the inquiry screens, where SET_CRITERIA and SET_LEDGER_ID are called first to populate session context, followed by the GET_* functions to populate display fields and the functional currency. CHECK_DETAIL_ACCOUNTS is called during validation. Because the package is not referenced by any database object, it is not part of a batch or concurrent processing chain; it serves interactive inquiry only. Developers extending or debugging the Budget Inquiry flow should treat the GET_* routines as the supported read interface.