Search Results pay_evc_shd




Overview
Explore in AI Chat

Overview

APPS.PAY_EVC_SHD is a package body belonging to the Oracle Payroll module of Oracle E-Business Suite, present and valid in releases 12.1.1 and 12.2.2. The name resolves to "Pay Event Value Changes SHared," and the package is classified under the ETRM API scheme as OTHER rather than as a public or private API. It provides the supporting logic behind the PAY_EVENT_VALUE_CHANGES_F table, which stores changes made to the values of payroll event definitions. The package is therefore part of the infrastructure that tracks how payroll event value records evolve over time, particularly with respect to date-tracked (datetrack) maintenance of those records. It is a shared component: five other packages in the schema reference it, while it depends on DT_API, HR_API, HR_UTILITY, FND_MESSAGE, and the STANDARD package. It is not referenced by any database object outside the APPS schema.

Key Procedures and Functions

The ETRM metadata documents seven callable units within the package body:

  • CONSTRAINT_ERROR — Raises or handles the standard constraint exception, marshalling an appropriate error message through FND_MESSAGE when a data integrity rule is violated.
  • API_UPDATING — Indicates whether the current operation is an API-driven update, allowing the package to distinguish API manipulation of event value changes from direct maintenance.
  • FIND_DT_UPD_MODES — Determines the datetrack update modes that apply when an existing event value change record is modified, resolving the correct dating behaviour before the change is applied.
  • FIND_DT_DEL_MODES — The deletion counterpart to the above; establishes the datetrack delete modes to be used when an event value change record is removed.
  • UPD_EFFECTIVE_END_DATE — Sets or adjusts the effective end date on dated event value change rows, which is the core maintenance action for datetracked payroll event data.
  • LCK — A locking routine that secures the relevant rows or definition so that concurrent updates cannot corrupt date-tracked state.
  • CONVERT_ARGS — Normalises or converts arguments passed into the package into the internal formats expected by the datetrack and HR utility routines.

No parameter signatures are published in the ETRM record, and none are asserted here.

Tables Accessed

Two tables are documented as referenced through APPS synonyms:

  • PAY_EVENT_VALUE_CHANGES_F — The primary datetracked table of payroll event value changes. The package reads it to determine current effective dates and writes to it when effective end dates are modified or rows are deleted.
  • ALL_CONSTRAINTS — The data dictionary view used to verify constraint definitions, supporting the CONSTRAINT_ERROR routine in reporting or evaluating integrity violations.

All access is performed under the APPS schema using the standard synonym layer.

Usage Notes

PAY_EVC_SHD is an internal maintenance package rather than an integration entry point. It is normally invoked from the Oracle Payroll forms and concurrent processing that maintain payroll event definitions, and from other payroll packages — five of which reference it — that need to modify event value changes under datetrack rules. The presence of LCK, API_UPDATING, and the two FIND_DT_*_MODES routines indicates it is called within an active transaction that must be protected against concurrent modification and must respect the effective dating conventions of HR datetrack. Customers and implementers should not call this package directly; the supported route for manipulating event value changes is through the corresponding payroll APIs and forms, which in turn reach this shared body. Because the package is marked VALID and is not referenced outside APPS, it carries no external interface contract and may be subject to change between patches.