Search Results check_deprn_run

Overview

FA_UTIL_PVT is an internal (PVT-classified) PL/SQL utility package in the Oracle E-Business Suite Assets application, owned by the APPS schema. It provides the low-level data retrieval and validation services that support the public Fixed Assets APIs. Whereas the public FA_*_API packages expose transaction entry points to external callers, FA_UTIL_PVT supplies the shared helper logic those APIs depend upon: populating API record structures from the underlying asset tables, validating required key combinations, resolving book and period context, and converting scalar column values into the typed record attributes expected by FA_API_TYPES.

The package header declares AUTHID CURRENT_USER and is identified in the ETRM metadata for release 12.2.2 as containing seventeen documented units. Its header revision string (120.9, dated 2010/08/25) indicates a mature, long-lived component that spans the 12.1.1 and 12.2.2 code lines. In practice it functions as a private implementation layer: it is not intended for direct customer invocation, but understanding it is essential when diagnosing why a public asset API call failed, since most validation and defaulting errors surface from this package.

Key Procedures and Functions

The documented units fall into three broad categories. Record-population getters form the largest group and share a consistent signature pattern: they accept an asset header record, receive an IN OUT NOCOPY typed record that is filled in place, and return a BOOLEAN success indicator.

• GET_INV_REC — Constructs an inv_rec_type record, used to supply invoice-related context to asset API processing. It accepts an MRCS set of books type code, a set of books identifier, and an optional inv_trans_rec_type before populating the invoice record.
• GET_ASSET_FIN_REC — Populates the financial record for an asset, with optional transaction header and MRCS book type.
• GET_ASSET_DEPRN_REC — Retrieves depreciation information, optionally scoped to a specific period counter.
• GET_ASSET_CAT_REC and GET_ASSET_TYPE_REC — Return category and asset-type records effective as of a supplied date.
• GET_ASSET_DESC_REC — Retrieves descriptive asset information.
• GET_ASSET_RETIRE_REC and GET_ASSET_DEPRN_RESV — Supply retirement and depreciation reserve data respectively.
• GET_CORP_BOOK, GET_PERIOD_REC, GET_CURRENT_UNITS, and GET_LATEST_TRANS_DATE — Resolve book, period, unit, and transaction-date context required by callers.
• CHECK_ASSET_KEY_REQ and CHECK_DEPRN_RUN — Validation routines that verify asset key requirements and confirm depreciation run status before processing proceeds.
• LOAD_CHAR_VALUE, LOAD_DATE_VALUE, and LOAD_NUM_VALUE — Attribute-conversion helpers that load character, date, and numeric values into API record fields.

Tables Accessed

The package reads from or writes to a documented set of Fixed Assets tables through APPS synonyms. Core asset data is drawn from FA_ADDITIONS and FA_ADDITIONS_B (asset descriptive and balance information), with historical attributes obtained from FA_ASSET_HISTORY. Financial and book context come from FA_BOOKS, FA_MC_BOOKS, and FA_BOOK_CONTROLS, while the fiscal calendar is resolved via FA_FISCAL_YEAR.

Depreciation getters reference FA_DEPRN_SUMMARY and its multi-reporting-currency counterpart FA_MC_DEPRN_SUMMARY. Invoice-related routines access FA_ASSET_INVOICES, FA_INVOICE_TRANSACTIONS, and FA_MC_ASSET_INVOICES. Retirement processing uses FA_MC_RETIREMENTS. Additional data is sourced from FA_ADD_WARRANTIES and FA_LEASES. The MRCS tables are significant because several getters take an MRCS book type code parameter, allowing the same logic to serve both the primary and reporting currencies.

Usage Notes

FA_UTIL_PVT is invoked indirectly. The metadata records that it is referenced by sixty-seven other packages, placing it near the base of the Fixed Assets API dependency graph. Callers are therefore other PL/SQL packages—public asset APIs, business logic wrappers, and extension code—rather than end-user forms or concurrent programs directly. Forms and concurrent programs reach these routines only through the public API surface that wraps them.

Because the package is classified PVT, Oracle does not guarantee its signature across patches; customizations should call the public FA_*_API equivalents instead. When troubleshooting a failed asset transaction, the returned BOOLEAN from a getter indicates whether the record was populated successfully, and the p_log_level_rec parameter common to these functions controls diagnostic output. The optional MRCS book type and set of books parameters should be supplied whenever reporting-currency data is in scope. The 12.1.1 and 12.2.2 releases share the documented interface, so the same diagnostics and dependency analysis apply to both.