Search Results chk_valid_event

Overview

APPS.PAY_EVC_BUS is the business-layer (BUS) PL/SQL package that encapsulates server-side logic for the Event Value Changes entity within Oracle Payroll. Its name derives from "Event Value Change" (EVC), and the package operates against the PAY_EVENT_VALUE_CHANGES_F table. In the Oracle EBS 12.1.1 and 12.2.2 architectures, the "BUS" suffix denotes a package that houses business rules and validation logic supporting the corresponding entity's API layer. The header comment confirms this is a generated runtime package built on the Oracle Designer/HR API generation conventions, identified by pyevcrhi.pkb, where the "rhi" segment indicates a Row Handler Implementation generated artifact.

The package provides the standard set of row-level validation routines and security helper functions required to maintain referential and legislative integrity of event value change records. It is not an end-user-facing API; rather, it is invoked internally by the entity's API layer and by other dependent packages.

Key Procedures and Functions

The ETRM documentation identifies five documented procedures and functions:

• SET_SECURITY_GROUP_ID — Populates the security group context for a given event value change record. As shown in the source excerpt, it accepts the event value change identifier and an optional associated column, queries PER_BUSINESS_GROUPS joined to PAY_EVENT_VALUE_CHANGES_F, and resolves the security group. It enforces the mandatory argument event_value_change_id via HR_API.MANDATORY_ARG_ERROR, and raises HR_7220_INVALID_PRIMARY when no matching record is found.
• RETURN_LEGISLATION_CODE — Returns the legislation code associated with a record. The package declares private globals g_legislation_code and g_event_value_change_id specifically for use by this function, indicating a cached lookup mechanism.
• INSERT_VALIDATE — Performs business-rule validation before an insert into the event value changes entity.
• UPDATE_VALIDATE — Performs business-rule validation before an update of an existing event value change record.
• DELETE_VALIDATE — Performs business-rule validation before deletion of a record, typically to confirm no dependent data blocks the removal.

Tables Accessed

The primary table referenced through an APPS synonym is PAY_EVENT_VALUE_CHANGES_F, which stores the event value change definitions and constitutes the subject of all insert, update, and delete validation logic. The SET_SECURITY_GROUP_ID routine additionally joins PER_BUSINESS_GROUPS to resolve the security group identifier from the record's business group. All access is read-oriented during validation, with the actual DML performed by the calling API layer.

Usage Notes

PAY_EVC_BUS is a supporting package, not a public API. ETRM records indicate it is referenced by three other packages within the Payroll schema. It is typically invoked indirectly: when a form or concurrent program manipulates event value changes, the corresponding API layer calls INSERT_VALIDATE, UPDATE_VALIDATE, or DELETE_VALIDATE to enforce business rules, and calls SET_SECURITY_GROUP_ID and RETURN_LEGISLATION_CODE to establish the correct legislative and security context. Customizations should not call these routines directly; developers extending event value change behavior should target the public API layer instead. The package was last modified in the 11i-era header revision but remains the active implementation in 12.1.1 and 12.2.2.