Search Results per_vac_rki

Overview

The PL/SQL package body APPS.PER_VAC_RKI is a database-level Row-Kind Identifier (RKI) trigger package belonging to the Oracle E-Business Suite Human Resources (PER) product family. Its name follows the standard EBS trigger-package naming convention: the _RKI suffix designates a package that encapsulates the server-side logic executed by a row-level "Insert" trigger on a specific base table. In the EBS architecture, RKI packages such as this one are generated to implement the "WHO" column maintenance and row identity stamping required for every transactional table registered with the Applications DBA (AD) dictionary and the Oracle HRMS DateTrack framework.

Within the HRMS schema, tables that participate in DateTrack and multi-organization security require that each row carry a valid ROW_ID, creation-audit columns (CREATED_BY, CREATION_DATE), and last-update audit columns (LAST_UPDATED_BY, LAST_UPDATE_DATE), plus the object-version number used by Oracle Forms for optimistic locking. PER_VAC_RKI is the compiled PL/SQL unit that centralizes and enforces this logic for its associated vacancy table, ensuring consistent row identity and audit stamping regardless of whether the insert originates from a Forms session, a concurrent program, or a direct SQL call.

Key Procedures and Functions

The ETRM metadata documents a single public program unit within this package body:

• AFTER_INSERT — The core procedure invoked by the row-level insert trigger after the base table row has been inserted. It performs the post-insert RKI processing, including derivation or validation of the row identifier, population of audit and date-tracking columns, and synchronization of the WHO columns. Because it executes AFTER the insert, it can reference the newly created row's primary key and apply any dependent updates without violating referential constraints.

No other procedures or functions are documented as public API for this object, and no parameter lists are published in the ETRM metadata. Callers should therefore treat AFTER_INSERT as an internal trigger entry point rather than a directly callable API.

Tables Accessed

The documented dependency list identifies the following referenced objects:

• APPS.HR_UTILITY — A shared HRMS utility package that supplies common validation, WHO-column, and date-tracking helper routines used by the AFTER_INSERT logic.
• PER_VAC_RKI (self-reference) — Indicates internal recursion or overload resolution within the package body.
• SYS.STANDARD — The Oracle-provided STANDARD package, required by every compiled PL/SQL unit.

The metadata does not list a directly referenced application table under the "Tables referenced (via APPS synonyms)" section; the package operates in conjunction with the trigger on its parent vacancy table, from which the inserted row context is derived.

Usage Notes

APPS.PER_VAC_RKI is not referenced by any other database object and is not exposed as a callable API. It executes implicitly whenever an INSERT occurs against its associated HRMS base table, most commonly through Oracle Forms vacancy maintenance screens, HRMS APIs, or DataLoad-style batch inserts. The package is valid and compiled in both Oracle EBS 12.1.1 and 12.2.2. Because the ETRM notes that one other package references it, developers extending vacancy functionality should preserve the AFTER_INSERT contract and avoid disabling the underlying trigger, since its ROW_ID and WHO-column maintenance is a prerequisite for DateTrack and concurrency control. Direct invocation from custom code is not recommended; instead, use the supported HRMS public APIs, which will trigger this logic automatically.