Search Results balance_type_rec

Overview

The APPS.FV_SF133_ONEYEAR package body is a United States federal financial reporting utility within Oracle E-Business Suite, responsible for producing the Treasury Financial Manual Standard Form 133 (SF-133), "Report on Budget Execution and Budgetary Resources," for a one-year reporting period. SF-133 is a statutorily mandated budget execution report submitted to the U.S. Treasury, reconciling budgetary resources against the status of those resources. This package implements the report generation logic, extracting balances from the General Ledger and mapping them against report line and column definitions maintained in the FV SF133 setup tables.

The body declares extensive global and package-level state, including stored input parameters (parm_application_id, parm_set_of_books_id, parm_gl_period_year, parm_gl_period_num, parm_treasury_symbol_id, and parm_run_mode), pre-built query variables, and stored globals such as g_chart_of_accounts_id, g_fund_segment_name, and g_treasury_symbol_id. Balance accumulators — c_total_balance, c_ending_balance, and c_begin_balance — alongside period delimiters c_begin_period and c_end_period, drive the computation of reporting-period figures. The user search term "balance_type_rec" corresponds to this balance-oriented processing domain, where beginning, ending, and total balances are accumulated per line.

Key Procedures and Functions

ETRM documents a single public program unit within this package body: MAIN. The MAIN procedure serves as the primary entry point and orchestrates the full SF-133 one-year report cycle. It initializes the stored parameters and global variables derived from the caller's context, resolves the treasury symbol, chart of accounts, and fund segment, then iterates the report line and column definitions to compute and populate the balance figures. MAIN coordinates the dynamic SQL generation required to extract General Ledger balances and controls the insert activity tracked by g_insert_count, as well as error capture through g_error_code and g_error_message.

Tables Accessed

The package reads and writes across the federal reporting and General Ledger schema through APPS synonyms:

• FV_SF133_DEFINITIONS_ACCTS, FV_SF133_DEFINITIONS_LINES, FV_SF133_DEFINITIONS_COLS_TEMP — report line, column, and account mapping definitions driving report layout and computation.
• FV_SF133_REP_LINE_CALC — calculation rules applied per report line.
• FV_TREASURY_SYMBOLS — treasury symbol and resource type resolution.
• FV_CFS_REP_LINES — related federal report line reference.
• GL_CODE_COMBINATIONS, GL_PERIOD_STATUSES — account validation and period status determination.
• FND_FLEX_VALUE_HIERARCHIES, FND_FLEX_VALUE_SETS, FND_ID_FLEX_SEGMENTS, FND_SEGMENT_ATTRIBUTE_VALUES — key flexfield structure, hierarchy, and segment attribute resolution.
• DBMS_SQL — dynamic SQL execution for balance extraction.

Usage Notes

FV_SF133_ONEYEAR is typically invoked through the SF-133 report submission flow, most commonly via a concurrent program that supplies the application, set of books, period year, period number, and treasury symbol parameters. It is referenced by one additional package, indicating reuse within the federal reporting module. Because MAIN relies on stored global state, each invocation must fully initialize parameters; the FV_DEBUG_FLAG profile option controls debug output. The package is documented only for the report execution path and should not be called directly from unrelated custom code without ensuring all parameters and treasury symbol context are valid.