Search Results pay_evc_del




Overview
Explore in AI Chat

Overview

The APPS.PAY_EVC_SHD package is a shared utility package within the Oracle Payroll schema that supports the Event Value Changes (EVC) framework. The suffix "SHD" denotes "shared," indicating that this package exposes common low-level routines consumed by the higher-level EVC data manipulation packages rather than acting as a standalone business API. Its principal responsibility is to provide reusable logic for detecting, describing, and reconciling mode and date-based conflicts that arise when event value change records are inserted, updated, deleted, or otherwise maintained.

Within Oracle EBS 12.1.1 and 12.2.2, the EVC framework captures changes to payroll event values so downstream processes can react to them. Because several sibling packages (PAY_EVC_INS, PAY_EVC_UPD, PAY_EVC_DEL, PAY_EVC_BUS) each perform variations of the same validation work, PAY_EVC_SHD centralizes that shared logic. The ETRM record classifies its API type as OTHER, consistent with its role as an internal helper library rather than a published public API.

Key Procedures and Functions

Seven procedures and functions are documented for this package:

  • CONSTRAINT_ERROR — Raises or reports a constraint violation encountered while maintaining event value change data, giving callers a consistent error signal.
  • API_UPDATING — Determines whether the current operation is being driven through the API update path, allowing shared logic to branch appropriately.
  • FIND_DT_UPD_MODES — Identifies the update modes applicable to a given date, supporting effective-dated conflict resolution.
  • FIND_DT_DEL_MODES — Identifies the delete modes applicable to a given date, used when removing or ending event value change records.
  • UPD_EFFECTIVE_END_DATE — Adjusts or applies the effective end date on an event value change record as part of date-range maintenance.
  • LCK — Acquires a lock on the affected record or resource to serialize concurrent modifications.
  • CONVERT_ARGS — Converts or normalizes argument values passed between the calling packages and the shared routines.

Parameter lists are not documented in the ETRM extract and are therefore not reproduced here.

Tables Accessed

Two database objects are documented as referenced through APPS synonyms:

  • PAY_EVENT_VALUE_CHANGES_F — The core event value changes table. The shared routines read and update this table to locate existing rows, apply effective end dates, and enforce locking before modifications.
  • ALL_CONSTRAINTS — Queried for constraint metadata to support the CONSTRAINT_ERROR handling path and to validate the integrity rules governing the event value changes records.

Usage Notes

PAY_EVC_SHD is not intended for direct invocation by forms, concurrent programs, or customer extensions. The ETRM dependency listing shows it is referenced by five packages: PAY_EVC_BUS, PAY_EVC_DEL, PAY_EVC_INS, PAY_EVC_UPD, and PAY_EVENT_VALUE_CHANGES_API. The public entry point for developers is PAY_EVENT_VALUE_CHANGES_API; that API and the internal maintenance packages delegate shared validation, locking, mode detection, and argument conversion to PAY_EVC_SHD.

Custom code should always call the published API rather than this package. Invoking PAY_EVC_SHD directly risks bypassing established locking or effective-dating conventions and can produce inconsistent event value change data. The package depends only on STANDARD and ALL_CONSTRAINTS, confirming its narrow, utility-oriented design.