Search Results insert_hr_retirement_hdrs




Overview
Explore in AI Chat

Overview

APPS.FA_CUA_HR_RETIREMENTS_PKG is an Oracle E-Business Suite Oracle Assets (FA) package that supports the retirement of assets that are tracked against Human Resources (HR) assignment hierarchies. It provides a programmatic interface for creating, validating, and posting retirement transactions for assets assigned to employees, using the HR organization hierarchy as the grouping mechanism rather than the standard asset accounting distribution. The package is owned by the APPS schema and is classified as an "OTHER" API, indicating it is not part of Oracle's formally published public API set but is intended for controlled internal use by Oracle Assets forms, concurrent programs, and approved custom extensions.

The source header (FACHRMRMS.pls, version 120.4, last modified 2009/08/20) confirms the package has been stable across the 12.1.1 and 12.2.2 release lines. The AUTHID CURRENT_USER declaration means the package executes with the privileges of the invoking user, so callers must be granted the necessary privileges on the underlying FA tables and synonyms.

Key Procedures and Functions

  • GENERATE_RETIREMENT_BATCH — The primary entry point, and the object the user searched for. It accepts the retirement event code, book type, HR hierarchy node entity identifier, retirement method and type, proceeds of sale, cost of removal, retirement date, proration and retirement basis options, retirement amount or percentage flags, partial retirement and unit-retirement indicators, and the descriptive flexfield attribute columns for both the retirement header and its transaction history. It returns a batch identifier (x_batch_id) as an IN OUT NOCOPY parameter, which downstream procedures and callers use to track and post the generated batch.
  • INSERT_HR_RETIREMENT_HDRS — Creates the header rows for the HR retirement batch in the FA_HR_RETIREMENT_HDRS_S and FA_HR_RETIREMENT_HEADERS structures.
  • INSERT_HR_RETIREMENT_DTLS — Creates the corresponding detail rows in FA_HR_RETIREMENT_DETAILS for each asset selected for retirement under the requested hierarchy node.
  • CHECK_PENDING_BATCH — Validates whether an unposted or pending HR retirement batch already exists, preventing conflicting or duplicate batch generation.
  • CONC_REQUEST — Submits the concurrent request that performs post-processing or the actual retirement posting work asynchronously.
  • POST_HR_RETIREMENTS — Applies the validated batch against Oracle Assets, writing retirement transactions and updating asset balances.

Tables Accessed

The package reads asset definition and hierarchy data from FA_ADDITIONS, FA_ASSET_HIERARCHY, and FA_DISTRIBUTION_HISTORY; book and category defaults from FA_BOOKS, FA_BOOK_CONTROLS, and FA_CATEGORY_BOOK_DEFAULTS; and audit history from FA_ASSET_HISTORY. Transaction output is written to FA_HR_RETIREMENT_DETAILS, FA_HR_RETIREMENT_HDRS_S, FA_HR_RETIREMENT_HEADERS, FA_TRANSACTION_HEADERS, and FA_RETIREMENTS. Batch tracking records use FA_MASS_UPDATE_BATCH_HEADERS and FA_MASS_UPDATE_BATCH_DETAILS, while FND_CURRENCIES supplies currency validation. All accesses are performed through APPS synonyms.

Usage Notes

Because the package is classified as OTHER rather than a public API, Oracle does not guarantee interface stability across patches. It is typically invoked from Oracle Assets HR retirement functionality and related concurrent programs, with FUNCTION-level security and standard FA profile options applied by the caller. Custom code should call GENERATE_RETIREMENT_BATCH only after confirming no pending batch exists via CHECK_PENDING_BATCH, and should rely on the returned batch identifier to drive posting through POST_HR_RETIREMENTS or the associated concurrent request rather than manipulating the HR retirement tables directly.