Search Results book_type

Overview

JL_ZZ_FA_LIBRARY_1_PKG is an Oracle EBS Applications (APPS) PL/SQL package body classified as an "OTHER" API under the Oracle Assets (FA) and Oracle Financials for localization (JL) schema. The "ZZ" token in the package name denotes a dummy/localization placeholder convention used by Oracle development, indicating that this library is intended as a template or seeded utility that may be cloned or extended by localization teams. Within the 12.1.1 and 12.2.2 code lines, the package functions as a read-only helper library that resolves period, book-control, and revaluation attributes required during asset mass revaluation and inflation-adjustment processing. It does not perform inserts, updates, or deletes; its sole responsibility is to retrieve precisely one row of control data based on a caller-supplied row ordinal and to return a SQL error code through an OUT parameter rather than raising an unhandled exception.

Key Procedures and Functions

The package exposes three documented procedures:

• GET_PERIOD_NAME — Returns the depreciation period name for a given book type and a caller-specified row number. It joins the mass revaluation, book control, and depreciation period tables, restricting to the open period (period close date is null) and to revaluations whose status is 'COMPLETED'. This procedure is central to the "book_type" lookup pattern, since the book type code is the primary filter used to resolve the active accounting period.
• GET_CHECK_INFLATION_ADJUSTMENT — Reads a single global attribute value from FA_BOOK_CONTROLS for a supplied book type and row number, returning an indicator that signals whether inflation adjustment processing is enabled for that book.
• GET_FA_BOOKS — For a given asset, asset category, and book type, returns a set of revaluation-related attributes: the current revaluation, the previous revaluation, the last approval number, the last approval date, and the last approval value. The values are extracted from global attribute columns with SUBSTR truncation applied to enforce expected field widths.

Tables Accessed

The package reads from four documented tables, all accessed through APPS synonyms:

• FA_BOOK_CONTROLS — Supplies book-level configuration and the global attribute columns (global_attribute1 through global_attribute6) that drive inflation checks and revaluation linkage.
• FA_DEPRN_PERIODS — Provides the period name and period close date used to identify the currently open depreciation period for a book type.
• FA_MASS_REVALUATIONS — Supplies completed mass revaluation records and links book controls to the revaluation identifier.
• FA_BOOKS — Source of per-asset revaluation and approval attribute values returned by GET_FA_BOOKS.

Usage Notes

Because the package is referenced by zero other packages per the documented dependency metadata, it is not part of the standard seeded call graph. It is typically invoked from localization customization code, from Oracle Forms-based asset revaluation screens, or from concurrent program logic that has been adapted for regional inflation accounting. Callers must supply a valid row_number, as each procedure relies on ROWNUM to isolate a single record, and must inspect the returned Errcd value rather than relying on exception propagation, since every procedure traps WHEN OTHERS and returns SQLCODE. The package header is dated 1999, so it is a legacy artifact; in 12.2.2 environments it remains valid but should be reviewed against current FA table structures before reuse.