Results for “p_adj_mode”

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

Overview

JE_JEHUFDAN_XMLP_PKG is an Oracle Application Object Library (AOL) generated PL/SQL package of type XML Publisher (XMLP) report package. It belongs to the Oracle Assets (FA) product family, owned by the APPS schema. The package supports the concurrent report "JEHUFDAN" (Journal Entry – Asset Depreciation Adjustment Report), a fixed assets report that produces period-based depreciation and adjustment data for a selected asset book. The package holds global variables, exposes formatted prompts used by the report parameter form and report layout, and contains the procedural logic invoked before and after report execution. The user search term "p_adj_mode" corresponds to the package global variable P_ADJ_MODE declared as VARCHAR2(32767), which captures the adjustment mode parameter passed into the concurrent program and drives how adjustment amounts are evaluated. The package classifies as OTHER and is referenced by no other packages, confirming that it is a report-bound self-contained package rather than a reusable API.

Key Procedures and Functions

The package exposes 46 documented procedures and functions. The trigger-style functions include BEFOREREPORT and AFTERREPORT, which execute pre- and post-report logic, and B_PERIOD_OPENFORMATTRIGGER, which validates period openness for the selected book and period. Formatting helpers include REPORT_NAMEFORMULA, CF_CURRENT_DATEFORMULA, and CF_UNPLANNEDFORMULA, which produce derived display values for report layout fields.

Report computation logic is distributed among several families of functions:

• PERIOD1_PCFORMULA and PERIOD2_PCFORMULA derive the period counters for the two reporting periods.
• DO_INSERTFORMULA and INSERT_INFO control insertion of report data into staging or result structures.
• ADJUSTFORMULA, ENDFORMULA, and LIFEFORMULA calculate adjustment amounts, ending balances, and asset life figures based on tax, flat, unplanned, expense, and production inputs.

Data retrieval procedures include GET_ADJUSTMENTS, GET_ADJUSTMENTS_METHOD, GET_ADJ_STR_UNPLANNED, GET_ADJ_NON_STR_UNPLANNED, GET_DEPRN_EFFECTS, GET_DEPRN_EFFECTS_FIRST, and GET_DEPRN_EFFECTS_METHOD. These populate depreciation effect and adjustment detail used by the report output, with separate variants handling straight-line, non-straight-line, and method-specific calculations.

Tables Accessed

The package references the Oracle Assets base tables through APPS synonyms:

• FA_BOOKS, FA_BOOK_CONTROLS, FA_CATEGORY_BOOKS – book definition, period control, and category-to-book rules.
• FA_ADDITIONS – asset master information used to build the report population.
• FA_ADJUSTMENTS – adjustment transactions processed via GET_ADJUSTMENTS and related procedures.
• FA_ASSET_HISTORY and FA_TRANSACTION_HEADERS – transactional history supporting the report detail lines.
• FA_DEPRN_DETAIL and FA_DEPRN_PERIODS – depreciation amounts and period status used for effect calculations.
• FA_DISTRIBUTION_HISTORY – distribution context for reported entries.
• FA_METHODS – depreciation method attributes referenced by method-driven calculations.
• FA_LOOKUPS, FA_LOOKUPS_B, FA_LOOKUPS_TL – lookup values for translated display of report fields.
• FND_CONCURRENT_REQUESTS – concurrent request context, including the parameter P_CONC_REQUEST_ID.

Usage Notes

JE_JEHUFDAN_XMLP_PKG is not called by other packages and is intended solely to support the JEHUFDAN XML Publisher concurrent report. It is invoked by the AOL concurrent manager at report run time. The report parameter form supplies values later stored in globals such as P_BOOK, P_PERIOD1, P_PERIOD2, P_REPORT_TYPE, and P_ADJ_MODE. The P_ADJ_MODE variable influences which adjustment behavior is applied during execution, so any customization or troubleshooting should verify its accepted values against the concurrent program parameter definition. Because the package is report-bound and regenerated from the report definition file (JEHUFDANS.pls), direct modification is discouraged; changes should be made through the report definition and redeployed.