Search Results report_table

Overview

JL_ZZ_FA_FUNCTIONS_PKG is a custom Oracle EBS PL/SQL package owned by the APPS schema and classified as an "OTHER" API within the ETRM repository for releases 12.1.1 and 12.2.2. The package body carries the header identifier jlzzfafb.pls 120.11 2006/09/20, indicating it is a customer-specific extension rather than a certified Oracle product module. Its business purpose is to assemble and populate the data set behind the JL_AR_FA_EXHIBIT_REPORT, a fixed asset reporting exhibit used primarily in the Japanese localization (JL) context.

Functionally, the package computes and returns asset-related figures for the exhibit: costs, descriptions, retirement and addition handling, and depreciation periods of use. It also performs the physical population of the exhibit data. A package-level collection type, temp_plsql_table, is declared as a table of JL_AR_FA_EXHIBIT_REPORT%ROWTYPE indexed by BINARY_INTEGER, and the variable report_table (the basis of the user's "report_table" search) holds the in-memory working set of exhibit rows before insertion. The body includes standard FND logging infrastructure (G_PKG_NAME, G_MODULE_NAME, and the FND_LOG runtime level constants) so that execution can be traced at unexpected, error, exception, event, procedure, and statement levels.

Key Procedures and Functions

• MIDDLE_MONTH — Determines the "middle month" used to adjust assets added or disposed of within the current fiscal year, effectively locating the midpoint of an asset's period of use. The logic originates from requirement #1561112 (08-Nov-00, S. Vaze). The parameter convention is documented: an addition month number of 0 signifies addition in the previous year, and a retirement month number of 13 signifies a specific retirement scenario.
• PERIODS_OF_USE — Calculates the number of periods an asset is considered in use, with options to include the DPIS month and the retirement month in that computation.
• ASSET_COST — Retrieves or derives the cost of an asset for exhibit purposes.
• ASSET_DESC — Retrieves or derives the asset description text used in the exhibit output.
• POPULATE_FA_EXHIBIT_DATA — Orchestrates the population of the JL_AR_FA_EXHIBIT_REPORT by collecting qualifying asset records and writing them, using the report_table collection.

Tables Accessed

The package reads the standard Oracle Assets base and transactional tables through APPS synonyms. Fixed asset master and descriptive data come from FA_ADDITIONS and FA_ASSET_HISTORY. Transactional data comes from FA_ADJUSTMENTS, FA_MASS_REVALUATIONS, FA_RETIREMENTS, and FA_TRANSACTION_HEADERS. Depreciation and book context are drawn from FA_DEPRN_SUMMARY, FA_DEPRN_PERIODS, FA_BOOKS, FA_BOOK_CONTROLS, FA_CATEGORY_BOOKS, and FA_CATEGORY_BOOK_DEFAULTS. Calendar reference comes from FA_CALENDAR_PERIODS, and revaluation index factors come from FA_PRICE_INDEXES and FA_PRICE_INDEX_VALUES. The exhibit output is written to JL_AR_FA_EXHIBIT_REPORT.

Usage Notes

The package is referenced by six other packages, confirming it is shared infrastructure for the fixed asset exhibit process rather than a standalone entry point. Typical invocation is through the concurrent program that generates the FA exhibit report, or from custom SQL/PLSQL. The presence of FND_LOG calls makes runtime diagnostics controllable through the standard FND logging profile option.