Results for “p_book”

50+ results




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

Overview

JL_CO_FA_TA_REVAL_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM object registry as an OTHER API. Its purpose is to perform revaluation of technical appraisals for fixed assets, as indicated by the procedure comment header which states that the revaluate procedure is used to revaluate technical appraisals. The package header reflects a historical lineage to Oracle Applications Release 11.0 and contains a version marker of 120.4.12010000.2, indicating it has been maintained through the 12.1.1 release cycle and remains available in 12.2.2. The package is instantiated with FND Logging infrastructure constants (G_PKG_NAME, G_CURRENT_RUNTIME_LEVEL, and severity levels from FND_LOG), which allows it to emit diagnostic messages at unexpected, error, exception, event, procedure, and statement levels during execution.

The business context is the localization of fixed asset accounting for Colombia (the JL_ prefix denotes Latin America / regional localization code), where technical appraisals represent statutory asset revaluations required for tax and reporting purposes. The package adjusts asset costs and depreciation bases in the Fixed Assets subledger and generates corresponding accounting entries through the SLA (Subledger Accounting) framework.

Key Procedures and Functions

ETRM documents a single public procedure for this package:

  • REVALUATE — The primary entry point. Based on the header comments, it accepts a book type code and an appraisal identifier and revalues the technical appraisal defined in JL_CO_FA_APPRAISALS for the specified asset book. Internally, the body includes supporting private procedures such as track_asset, insert_row, and find_who_columns. The track_asset procedure takes a book type code and appraisal ID; insert_row takes an adjustment type, debit/credit flag, code combination ID, book type code, asset ID, adjustment amount, period counter, distribution ID, journal entry category name, and reference. These private helpers construct the adjustment records and journal references needed to post the revaluation. find_who_columns resolves audit columns (last updated by, last update login, request ID, program application ID, program ID, and system date) from the concurrent request context.

Tables Accessed

The package reads and writes a broad set of Fixed Assets and Subledger Accounting tables via APPS synonyms:

Usage Notes

The package is classified as an OTHER API and is not referenced by any other documented package, meaning it is typically invoked directly rather than through a supporting library. In a standard Oracle EBS 12.1.1 or 12.2.2 environment it is most commonly called from the Colombian Fixed Assets technical appraisal revaluation concurrent program or from the corresponding localization form, where the user selects a book and appraisal and submits the revaluation. Because the package relies on FND_LOG for diagnostics and on the concurrent request context (request ID, program ID, application ID) for audit stamping, it should be run within the concurrent manager framework rather than from an ad hoc SQL*Plus session if proper audit trail values are required. Custom code that calls REVALUATE directly must supply a valid book type code and an existing appraisal ID, and must ensure the relevant depreciation period is open, since the package reads FA_DEPRN_PERIODS and FA_CALENDAR_PERIODS to derive the period counter used in the generated adjustments.