Search Results per_abv_rki

Overview

PER_ABV_RKI is an Oracle E-Business Suite database package owned by the APPS schema. It forms part of the Person "ABV" family of program units in the Oracle Human Resources (PER) module. The suffix convention "RKI" identifies this package as a row-level trigger implementation package, designed to supply the PL/SQL logic executed by a database trigger of the same or related name. In EBS release 12.1.1 and 12.2.2, the ABV series supports row-level processing of the PER_ALL_PEOPLE_F or related person/assignment structures through a standardized trigger mechanism. The ETRM repository classifies this object generically as "OTHER" within the API taxonomy. Its validity status confirms it is compiled and operational in the APPS schema.

Key Procedures and Functions

The documented interface exposes a single procedure:

• AFTER_INSERT — This procedure encapsulates the logic executed in the AFTER INSERT phase of the associated row-level trigger. It runs once per row inserted into the underlying table, after the row has been committed to the table buffer. It is the sole documented entry point for PER_ABV_RKI, and its purpose is to perform the ABV row-processing actions that must occur following a successful insert. As with other ABV trigger packages, the procedure typically updates derived or denormalized values and maintains auxiliary ABV bookkeeping consistent with the newly inserted row.

The package body also contains internal, non-documented program units supporting AFTER_INSERT; these are not part of the published interface.

Tables Accessed

The ETRM dependency extract for this package lists only the SYS.STANDARD package as a referenced object and does not enumerate any application tables accessed through APPS synonyms. This indicates that any table interaction performed by AFTER_INSERT occurs indirectly, either through calls to other ABV packages or through unqualified DML resolved at runtime rather than captured during dependency resolution. No base tables are directly documented as read or written by PER_ABV_RKI itself.

Dependency and Usage Notes

• Referenced by: PER_ABV_INS and PER_ABV_RKI. The presence of PER_ABV_INS as a dependent suggests the package is invoked from an insert-handling context, consistent with the AFTER_INSERT procedure.
• References: SYS.STANDARD, the PL/SQL standard package, confirming no unusual external dependencies.
• Invocation context: PER_ABV_RKI is not intended for direct invocation by forms, concurrent programs, or custom code. It is called by the database trigger on the corresponding ABV-enabled table when a row insert occurs, typically on a shadow or ABV-tracking structure.
• Customization guidance: Because this is a system-owned trigger implementation package, direct modification is unsupported. Any extension of insert-time ABV behavior should be implemented through supported APIs or trigger customization frameworks rather than by altering PER_ABV_RKI.
• Version applicability: The package metadata is documented for R12.2.2 and applies equally to R12.1.1 unless the ABV trigger architecture differs between releases.