Search Results per_events_pkg




Overview
Explore in AI Chat

Overview

The APPS.PER_EVENTS_PKG package body encapsulates the core business logic for managing Oracle HRMS events within Oracle E-Business Suite 12.1.1 and 12.2.2. An "event" in the Oracle Human Resources model represents a scheduled occurrence such as an interview, meeting, or other workforce activity associated with people and assignments. This package provides the server-side logic that validates, inserts, updates, locks, and deletes event records, and it also governs the interaction between events and related downstream entities, including bookings, letters, and assignment changes.

The package is classified as OTHER within the Oracle API taxonomy, signifying that it is an internal support package rather than a formal public interface intended for unrestricted customer extension. It is a VALID object owned by the APPS schema and depends on shared library components such as FND_MESSAGE, FND_PROFILE, HR_UTILITY, and APP_EXCEPTION, indicating that it participates in the standard Oracle HRMS error-handling and profile-based configuration framework. It is referenced by one other database package but does not itself reference any external object that is not part of the Oracle HRMS or Application Object Library suite.

Key Procedures and Functions

The documented interface comprises ten procedures and functions:

  • CHECK_VALIDITY — Performs the fundamental validity checks on an event record prior to persistence, ensuring that required attributes and business constraints are satisfied.
  • INTERVIEWERS_ARE_BOOKED — Determines whether the interviewers associated with an event already have bookings, supporting conflict detection during scheduling.
  • CHECK_CURRENT_INTERVIEWERS — Validates the set of interviewers currently attached to an event, typically against eligibility or availability rules.
  • REQUEST_LETTER — Initiates a letter request, linking the event to the letter generation framework used for correspondence such as interview invitations.
  • EVENT_CAUSES_ASSIGNMENT_CHANGE — Evaluates whether the occurrence of the event implies a change to the assignment record, a key consideration for date-tracked HRMS data.
  • INTERVIEW_DOUBLE_BOOKED — Detects the condition in which an interviewer would be double-booked, preventing scheduling collisions.
  • INSERT_ROW — Inserts a new event row, applying validation and populating key identifiers.
  • LOCK_ROW — Acquires a row-level lock on the event record to support concurrency control during updates.
  • UPDATE_ROW — Modifies an existing event record.
  • DELETE_ROW — Removes an event record, typically after dependency checks against bookings and letter requests.

The presence of LOCK_ROW alongside INSERT_ROW, UPDATE_ROW, and DELETE_ROW reflects a conventional database utility pattern in Oracle HRMS, in which each Data Manipulation Language (DML) operation is paired with explicit locking so that concurrent form sessions cannot corrupt event data.

Tables Accessed

The package reads and writes through APPS synonyms for the following tables:

Usage Notes

Because PER_EVENTS_PKG is an internal package, it is normally invoked indirectly by Oracle HRMS forms and concurrent programs rather than called directly by end users. The Event and Interview forms in the Oracle HRMS product family rely on these procedures to enforce schedule integrity, prevent interviewer double-booking, and manage letter requests. Custom code that manipulates events, bookings, or associated letter requests should observe the same validation order used here — validity checks, booking conflict checks, then DML — and should acquire row locks before updating events in multi-user environments. Direct calls to the DML procedures should be treated with caution, since bypassing the validation routines may violate HRMS date-tracked integrity rules.