Search Results pay_event_value_changes_api




Overview
Explore in AI Chat

Overview

PAY_EVENT_VALUE_CHANGES_API is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that exposes the application programming interface for maintaining event value change records within Oracle Payroll and related Oracle HRMS modules. An event value change represents an alteration to a value that participates in an event-driven business process, most notably payroll processing, where changes to element entries, assignment attributes, or other payroll-relevant data must be tracked so that downstream calculations, retroactive processing, and date-tracked events behave correctly.

The package is classified as an API in the ETRM repository, meaning it is intended as a supported programmatic entry point for inserting, modifying, and removing event value change data rather than as an internal implementation package. In Oracle EBS 12.1.1 and 12.2.2, it sits alongside the underlying entity table PAY_EVENT_VALUE_CHANGES_F and depends on the shared HR_API utility package for standard row-handling, validation, and error-management behavior. Because the interface is built on HR_API conventions, callers benefit from consistent handling of object version numbers, effective dates, and business group security that Oracle applies across the HRMS APIs.

Key Procedures and Functions

The ETRM metadata documents three public procedures within the package:

  • CREATE_EVENT_VALUE_CHANGE — Creates a new event value change record. It accepts the identifying and descriptive attributes of the change and writes a corresponding row to the underlying table, applying HR_API validation and generating the primary key through the standard HRMS key-flex mechanism.
  • UPDATE_EVENT_VALUE_CHANGE — Modifies an existing event value change record. The caller identifies the target row and supplies the revised attribute values; the procedure validates the change and persists it, respecting the object version number to detect concurrent updates.
  • DELETE_EVENT_VALUE_CHANGE — Removes an existing event value change record. As with the other entry points, the deletion is performed through the entity table and the associated HR_API processing, allowing the API to enforce any referential or business rules before the row is removed.

No parameter lists are exposed in the ETRM excerpt, and none should be assumed; the standard HRMS API pattern supplies the primary key, business group, and object version number as part of the formal signature.

Tables Accessed

The package operates on the table PAY_EVENT_VALUE_CHANGES_F, referenced through its APPS synonym. This is the core DateTrack-enabled entity table that stores the event value change records created, updated, or deleted by the three procedures. The suffix "_F" indicates that the table carries an object version number and is the subject of the API's row-level operations. All persistence activity performed by the package is directed at this table; the ETRM metadata does not document any additional application tables being read or written.

Usage Notes

The package is typically invoked from custom PL/SQL code, from forms or other user-interface components that need to maintain event value changes programmatically, or from concurrent programs that process payroll events in bulk. It is not referenced by other APPS packages according to the ETRM dependency listing, which confirms it is an edge API called directly by Oracle Payroll processing logic or by customer extensions rather than by peer APIs. Standard HRMS API calling conventions apply: callers should initialize the HR_API global savepoint, honor the business group and effective date parameters, check the returned error table, and commit or roll back explicitly. Because the interface is DateTrack-aware, updates and deletes are interpreted relative to the caller's effective date, and corrections should be made through UPDATE rather than by direct DML on PAY_EVENT_VALUE_CHANGES_F.