Search Results per_ctc_rki




Overview
Explore in AI Chat

Overview

PER_CTC_RKI is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, documented as valid in both release 12.1.1 and 12.2.2. The package name follows Oracle's Human Resources naming conventions: the PER prefix denotes the Human Resources (PER) product family, while the RKI suffix identifies it as a row-level trigger interface package. Packages in the RKI family expose server-side routine handlers that are wired to database triggers defined on HR tables, allowing business logic to execute automatically in response to row-level DML events.

Consistent with this classification, APPS.PER_CTC_RKI is an internal implementation package for the Compensation and Total Compensation (CTC) area of Oracle HRMS. Its documented role is to service trigger-driven processing rather than to provide a public, callable API. ETRM classifies the object's API classification as OTHER, meaning it is intended for internal framework use and is not part of a supported customer-callable interface.

Key Procedures and Functions

ETRM documents exactly one procedure or function within this package body:

  • AFTER_INSERT — The row-level handler invoked for the AFTER INSERT event. Its purpose is to perform the follow-on processing required whenever a new row is created on the underlying compensation table, such as maintaining derived or denormalized data that must remain synchronized with the inserted record. Consistent with the RKI pattern, this routine is designed to be called by the database trigger created by the HR trigger-generation framework, not by application code directly. ETRM does not document a parameter list for this routine, and none should be assumed.

Because the package body is the only documented subobject, the specification is not exposed separately in the metadata. Package-level variables, private helpers, and exception handling are not itemized and are therefore considered implementation detail rather than documented interface.

Tables Accessed

The ETRM documentation for this package body does not enumerate base tables accessed through APPS synonyms. In the RKI model, table access is implicit: the trigger supplies the row context of the compensation record being inserted, and the handler operates on that context. Any direct DML performed by AFTER_INSERT would target PER compensation tables owned by the HR schema. Because the tables-accessed list is empty in the supplied metadata, specific table names should be confirmed by inspecting the package body source rather than inferred.

Usage Notes

The documented dependency list places PER_CTC_RKI within the HR API and HR Utility stack. It references APPS.HR_API and APPS.HR_UTILITY, the standard HRMS runtime libraries used for validation, date-effective (datetrack) handling, and error-message resolution, and it references APPS.PAY_DYT_CONTRACTS_PKG, linking the package to the payroll datetrack contracts mechanism. The package body also references itself, indicating internal recursion or private helper invocation. SYS.STANDARD is present as the expected PL/SQL built-in package.

The most significant usage fact in the metadata is that APPS.PER_CTC_RKI is not referenced by any database object, while it is itself referenced by one other package. This confirms its position as a top-level entry handler rather than a utility consumed by dependent objects. It is invoked at runtime by the generated database trigger on the associated compensation table, firing once per inserted row inside the inserting transaction. Customers and integrators should not call AFTER_INSERT directly; any customization should be applied through supported HRMS APIs or trigger framework extensions. Because trigger behavior is transaction-bound, failures raised within this package will roll back the originating DML.