Search Results pay_evc_bus




Overview
Explore in AI Chat

Overview

PAY_EVC_BUS is a business-layer PL/SQL package in the APPS schema of Oracle E-Business Suite, operating within the Oracle Payroll (PAY) module. Its name reflects its role as the business logic container for event value changes — records that capture modifications to payroll event values during processing. In the Oracle EBS architecture, the _BUS suffix denotes a business-rules package: a private, support-level layer that sits beneath the public Table Handler APIs (_INS, _UPD, _DEL) and applies validation and derivation logic on their behalf. Rather than being called directly by external or customer code, PAY_EVC_BUS exists to centralize the rules that govern whether insert, update, or delete operations against the event value changes entity are permissible, and to supply contextual values such as the security group and legislation context.

Key Procedures and Functions

  • SET_SECURITY_GROUP_ID — Establishes the security group context for the business operations processed by this package. Security groups in Oracle HRMS/Payroll partition data access; this routine sets the identifier used by subsequent validation logic.
  • RETURN_LEGISLATION_CODE — Returns the legislation code applicable to the current business context. Payroll validation rules frequently differ by localization (e.g., US, UK), so this function supplies the regulatory context used by downstream checks.
  • INSERT_VALIDATE — Performs business-level validation when a new event value change record is created, invoked by PAY_EVC_INS before the row is committed.
  • UPDATE_VALIDATE — Performs business-level validation when an existing event value change record is modified, invoked by PAY_EVC_UPD.
  • DELETE_VALIDATE — Performs business-level validation when an event value change record is removed, invoked by PAY_EVC_DEL.

Tables Accessed

The package operates on PAY_EVENT_VALUE_CHANGES_F, the transactional table storing event value change records for payroll processing. Access occurs through the APPS synonym layer, so the package references the table under its APPS-qualified name. The three *_VALIDATE routines read this entity to confirm the legality of the requested change, while the context routines supply the security group and legislation values that qualify the operation.

Usage Notes

PAY_EVC_BUS maintains explicit dependency relationships confirming its position in the call stack. It references PAY_EVC_SHD (the shadow/row-handler package) and the SYS.STANDARD package, and it is referenced in turn by PAY_EVC_INS, PAY_EVC_UPD, and PAY_EVC_DEL — the Table Handler APIs generated for the PAY_EVENT_VALUE_CHANGES_F entity. Additionally, the package references itself, indicating internal recursive or shared-helper calls. Because only these table handler packages invoke it, PAY_EVC_BUS is not intended as a public API surface: custom code and Oracle Forms should call the _INS, _UPD, and _DEL handlers, which delegate validation to this package. The package is classified as OTHER under ETRM (Oracle E-Business Suite Table and API Reference Manual) rather than as a public API. It holds a VALID status in the APPS schema across 12.1.1 and 12.2.2, with no documented signature changes between those releases. Support engineers investigating failures in payroll event value change processing should inspect this package's validation routines, as they form the final gatekeeper for transactional integrity on that entity.