Search Results conc_req

Overview

FA_CUA_HR_RETIREMENTS_PKG is an Oracle E-Business Suite (EBS) PL/SQL package body owned by the APPS schema that supports the retirement of assets associated with Human Resources (HR) assignments. Its principal responsibility is to build and post HR retirement batches — groupings of asset retirement transactions — into the Oracle Assets (FA) transaction tables. The package is applicable to both EBS 12.1.1 and 12.2.2, and is classified under the general "OTHER" API category rather than a formal public API. Its source header indicates a last revision of 120.5 (2005), reflecting the long-standing stability of the HR retirement functionality within Oracle Assets.

A central design element is concurrency control. The package guards asset and book state by detecting whether an asset is already captured in a mass update or retirement batch that is pending or rejected. This prevents duplicate or conflicting transactions from being submitted concurrently, a critical safeguard because HR retirements may be initiated from multiple entry points — forms, triggers, hierarchy processing, and concurrent programs.

Key Procedures and Functions

The package exposes six documented procedures and functions:

• CHECK_PENDING_BATCH — The concurrency-checking function. It returns a Boolean indicating whether an asset belongs to any batch in the mass update or retirement batch tables with a pending or rejected status. Its x_calling_function parameter allows a single routine to serve several callers, including ADDITION (from mass additions), TRANSACTION (from the IFA_TRANSACTION_HEADERS_HR_BRI trigger), HIERARCHY (from hierarchy processes), DEPRECIATION (from the IFA_BOOK_CONTROLS_BRU trigger), and CONCURRENT (from a concurrent request). The comment block explicitly notes that the concurrent invocation passes x_conc_request_id, whereas form-based invocations pass it as null. Two derived status codes, CUA_PENDING_BATCH and CUA_PENDING_BOOK, are returned through the x_status out parameter, which uses NOCOPY for efficiency.
• GENERATE_RETIREMENT_BATCH — Creates the retirement batch that groups the HR retirement transactions prior to posting.
• INSERT_HR_RETIREMENT_HDRS — Inserts the HR retirement header records.
• INSERT_HR_RETIREMENT_DTLS — Inserts the corresponding HR retirement detail lines.
• CONC_REQUEST — The concurrent-program entry point that drives batch and transaction creation, corresponding to the "Create Batch Txns" concurrent request referenced in the source comments.
• POST_HR_RETIREMENTS — Posts the generated retirement transactions into Oracle Assets, completing the business flow.

Tables Accessed

The package reads and writes a set of FA tables via APPS synonyms. FA_RETIREMENTS, FA_TRANSACTION_HEADERS, FA_BOOKS, and FA_BOOK_CONTROLS form the core transaction and book context. FA_MASS_UPDATE_BATCH_HEADERS and FA_MASS_UPDATE_BATCH_DETAILS are inspected by CHECK_PENDING_BATCH to assess pending or rejected batch membership. FA_HR_RETIREMENT_HEADERS, FA_HR_RETIREMENT_HDRS_S, and FA_HR_RETIREMENT_DETAILS store the HR retirement header and detail data generated by the insert routines. FA_ADDITIONS, FA_ASSET_HIERARCHY, and FA_ASSET_HISTORY supply asset identity, hierarchy, and audit history. FA_CATEGORY_BOOK_DEFAULTS and FA_DISTRIBUTION_HISTORY provide category-level book defaults and distribution detail, while FND_CURRENCIES supplies currency validation data.

Usage Notes

The package is invoked from several layers of Oracle Assets. Form-based calls pass a null x_conc_request_id, while the CONC_REQUEST procedure is driven by the "Create Batch Txns" concurrent program, in which the request ID is supplied. Database triggers such as IFA_TRANSACTION_HEADERS_HR_BRI and IFA_BOOK_CONTROLS_BRU call it in TRANSACTION and DEPRECIATION modes respectively, and hierarchy processes invoke it in HIERARCHY mode. Because four other packages reference it, customizations should treat it as an internal but widely consumed dependency. Releases 12.1.1 and 12.2.2 share the same functional behavior, so no version-specific changes are required.