Search Results pay_event_value_changes_s

Overview

PAY_EVC_INS is a PL/SQL package body owned by the APPS schema that supports the Oracle E-Business Suite Payroll module's "Event Value Changes" feature. Its name follows the Oracle HRMS API naming convention in which the _INS suffix denotes an insert-only (row-handling) API layer. In this capacity, PAY_EVC_INS is the physical insert routine for the PAY_EVENT_VALUE_CHANGES_S table, the database table that records changes to event values used during payroll and benefits processing for an employee assignment. When a value associated with a payroll event (for example, a date, rate, or hours amount) changes, a corresponding row is required in PAY_EVENT_VALUE_CHANGES_S, and this package performs that row insertion along with the associated validation of foreign keys and multi-tenant ownership data.

The package is classified as OTHER in the ETRM (Enterprise Technical Reference Manual) and is validated against both Oracle EBS 12.1.1 and 12.2.2. It depends on a relatively small but typical HRMS API stack: DT_API, FND_GLOBAL, FND_MESSAGE, FND_NUMBER, HR_API, HR_MULTI_MESSAGE, HR_STARTUP_DATA_API_SUPPORT, HR_UTILITY, PAY_EVC_BUS, PAY_EVC_RKI and PAY_EVC_SHD. The presence of PAY_EVC_RKI (row-key information) and PAY_EVC_SHD (shadow) indicates that PAY_EVC_INS participates in the standard Oracle HRMS API pattern involving row-integrity and shadow-row handling.

Key Procedures and Functions

The ETRM documents four callable units within PAY_EVC_INS. Only their names and purposes are described here; parameter lists are deliberately omitted.

• INS — The primary insert interface. It is the entry point that accepts a new row of event-value-change data and performs the insert against PAY_EVENT_VALUE_CHANGES_S, invoking the supporting validation and key-derivation units.
• INSERT_DML — The internal DML subroutine that actually emits the SQL INSERT into PAY_EVENT_VALUE_CHANGES_S. It is separated from the public INS routine so that the DML can be invoked from the row-handling layers while the business validations remain in the outer procedure.
• SET_BASE_KEY_VALUE — A helper that establishes the base key value for the new row, ensuring that identity or surrogate keys required by the table and its associated foreign keys are populated correctly before the insert executes.
• Fourth documented unit — The ETRM records a total of four documented procedures or functions for this package; the remaining routine operates in conjunction with INS, INSERT_DML and SET_BASE_KEY_VALUE to complete the row-handling contract.

Tables Accessed

Four tables are referenced via APPS synonyms: PAY_EVENT_VALUE_CHANGES_S is the primary target and receives the inserted rows. PAY_EVENT_VALUE_CHANGES_F is its "_F" (form/function) companion, used by the API to derive or validate values such as the event value identifier before the "_S" insert. HR_APPLICATION_OWNERSHIPS and HR_OWNER_DEFINITIONS are multi-tenant metadata tables that the package queries to enforce the ownership/security model, so that inserts are scoped to the correct business group and legal owner.

Usage Notes

PAY_EVC_INS is invoked indirectly rather than directly by end users. The documented package PAY_EVC_BUS (business layer) depends on it and acts as the normal caller; two other packages reference it in turn. Users of the event-value-changes feature therefore interact through Payroll and Benefits forms or through their own custom code that calls PAY_EVC_BUS, not PAY_EVC_INS. The package does not appear in any referenced-by list for direct database objects, confirming its role as an internal implementation layer. Customizations should call the business API layer, allowing PAY_EVC_INS to remain an implementation detail.