Search Results per_apl_rki

Overview

The package body APPS.PER_APL_RKI is a database-level implementation object within the Oracle E-Business Suite Human Resources (HR) module. Its object type designation, a package body, indicates that it contains the executable PL/SQL code corresponding to a package specification of the same name. The RKI suffix follows the Oracle EBS naming convention for row-level key insertion/internal processing packages associated with a base object, and the base object here is the PER_APL family of database objects.

In Oracle EBS 12.1.1 and 12.2.2, packages of this class exist to support the mechanics of inserting or maintaining records on the underlying APL tables. In the standard Oracle HR schema, these objects are typically used for application-level or assignment-level processing rather than for end-user data entry directly. Because the ETRM record classifies this object as OTHER, it is not part of the public, supported API surface exposed to customers; it is an internal implementation artifact used by the Oracle application layer and by other internal packages.

The metadata confirms the package body is VALID in the APPS schema. Its only documented PL/SQL dependency outside of STANDARD is APPS.HR_UTILITY, a general HR utility package providing shared helper routines, and its own package specification PER_APL_RKI. The package body is not referenced by any database object, which is consistent with it being an internal row-key insertion routine that is invoked by the framework rather than by external callers.

Key Procedures and Functions

The ETRM documentation lists a single documented program unit within this package body:

• AFTER_INSERT — the sole documented procedure. Consistent with its name and with the row-key insertion convention, this procedure executes post-insert processing logic for a record that has just been inserted on the underlying APL table. Its role is to complete any dependent work required immediately after the row is created, ensuring the parent record and its associated key values are established in the correct state. The ETRM metadata does not expose a parameter list for this procedure, and no parameter signature should be assumed.

The package body contains no additionally documented functions. The limited documented program-unit count is typical of these internal support packages, which are scoped to a narrow, single-purpose task rather than a broad API.

Tables Accessed

The documented metadata for this package does not enumerate specific tables accessed via APPS synonyms. Based on the object's name and purpose, its operations are directed at the APL table family within the Oracle HR schema, and the AFTER_INSERT procedure operates on data already present in those tables following an insert. Because no table list is documented in the ETRM excerpt, the exact table names should be confirmed by inspecting the package body source in the target environment rather than assumed.

Usage Notes

PER_APL_RKI is an internal Oracle HR object. The ETRM documentation does not designate it as a public API, and the OTHER classification reinforces that it is not intended for direct invocation by customer code. Typical invocation occurs implicitly from the Oracle EBS application framework, from Oracle-delivered forms, or from other internal PL/SQL packages that manage the APL data set.

• Customers should not call AFTER_INSERT or other routines in this package directly; Oracle does not guarantee the stability of internal package signatures across releases.
• Because the object is not referenced by any other database object per the metadata, its callers are likely session-level or framework-level rather than stored dependencies.
• Customizations should target supported, documented HR APIs instead of this internal package, to preserve upgrade safety across 12.1.1 and 12.2.2.

The package depends on HR_UTILITY for shared functionality and is registered in the APPS schema, which is the standard location for Oracle EBS application database objects.