Search Results pay_bct_rku

Overview

PAY_BCT_RKU is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It is a Row-Kick-Up (RKU) style helper object associated with the Payroll (PAY) product family, as indicated by the PAY_ prefix. In Oracle EBS, packages suffixed with _RKU are typically generated or seeded utilities used to propagate or cascade changes to dependent or denormalized columns when a base record is modified. The package is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2, and its API classification in the ETRM metadata is recorded as OTHER, reflecting its role as an internal supporting routine rather than a public, business-facing API.

The body depends on APPS.HR_UTILITY and STANDARD (the SYS standard package), which are common prerequisites for HR and Payroll related PL/SQL objects. HR_UTILITY supplies shared HR utility functions, such as date or conversion helpers, while STANDARD provides the standard PL/SQL types and functions. The package is not referenced by any other database object in the documented dependency listing, although the package metadata notes that it is referenced by one other package. This discrepancy is typical of ETRM records where the parent object reference is maintained separately from the inverse dependency tree.

Key Procedures and Functions

The documented interface for PAY_BCT_RKU contains a single procedure or function:

• AFTER_UPDATE — An after-update handler. Its name indicates it is designed to run following an UPDATE operation against a base table or record, so that associated or dependent data can be synchronized. Typical behavior for an RKU after-update routine is to recalculate, cascade, or refresh derived values that depend on the updated row. The specific parameter list is not provided in the ETRM metadata and should not be assumed; consult the actual package source for exact signatures.

Because the package exposes only this one documented routine, it functions as a focused utility rather than a general-purpose API. No other procedures or functions are recorded in the ETRM metadata for this body.

Tables Accessed

The ETRM documentation excerpt does not enumerate specific base tables referenced directly by PAY_BCT_RKU through APPS synonyms. The dependency information lists APPS.HR_UTILITY and SYS.STANDARD as package-level dependencies, and the package is noted as being referenced by one other package. In practice, an after-update helper within the Payroll schema will operate on Payroll and HR tables, and any such references would be resolved through APPS synonyms. Readers requiring an authoritative table inventory should review the package source or the ETRM object's "SQL Statements" tab, which is referenced in the documentation but not populated in the excerpt provided.

Usage Notes

PAY_BCT_RKU is an internal package and is not intended to be called directly by end users or custom code. Its AFTER_UPDATE routine is normally invoked implicitly as part of a larger transaction flow, typically from within a parent package or database trigger that performs the base update and then calls the after-update handler to synchronize dependent data. Because it is referenced by one other package, it should be treated as a supporting component of that parent's logic.

Customizations that bypass the parent transaction and call PAY_BCT_RKU.AFTER_UPDATE directly risk leaving dependent data inconsistent, since the routine assumes the base update has already completed. In upgrade or migration projects between 12.1.1 and 12.2.2, the package is compiled as part of the standard APPS schema build; no user-facing setup or concurrent program is associated with it. Developers troubleshooting payroll data discrepancies may trace invocations of this package through the parent object identified in the dependency tree.