Search Results hr_calendar_entry_swi




Overview
Explore in AI Chat

Overview

The APPS.HR_CALENDAR_ENTRY_SWI package is a PL/SQL construct within the Oracle E-Business Suite Human Resources (HR) module. Its classification in the ETRM repository is listed as OTHER, and its status is VALID, confirming that it is a compilable, active object within the APPS schema. The package name incorporates the "SWI" suffix, which in Oracle EBS nomenclature conventionally designates a Server-side Wrapper Interface. Such packages provide a thin, stable PL/SQL entry layer over an underlying business logic package, exposing calendar entry operations to callers such as forms, concurrent programs, or custom integrations without requiring those callers to invoke the base package directly. The corresponding base object, APPS.HR_CALENDAR_ENTRY_SWI is listed in the dependency metadata as both the package itself and a reference target, reinforcing the wrapper-to-base relationship. In the 12.1.1 and 12.2.2 code lines, this wrapper participates in the management of HR calendar entries, which underpin absence, availability, and schedule-related processing within the HRMS suite.

Key Procedures and Functions

The ETRM metadata documents three procedures within this package, each corresponding to a standard maintenance operation on calendar entries:

  • CREATE_CALENDAR_ENTRY — Handles the creation of a new calendar entry record. It encapsulates the validation and insertion logic required to establish a calendar entry in the HR schema.
  • UPDATE_CALENDAR_ENTRY — Applies modifications to an existing calendar entry. It manages the update path, ensuring that changes are applied consistently with the underlying business rules.
  • DELETE_CALENDAR_ENTRY — Performs the removal of a calendar entry, governing the deletion semantics for the record.

The metadata does not expose parameter lists, and specific argument signatures are therefore not enumerated here. The procedures are invoked by name and fulfill the create, update, and delete lifecycle for calendar entries.

Tables Accessed

The documented ETRM extract does not list specific tables referenced by HR_CALENDAR_ENTRY_SWI through APPS synonyms. The dependency information identifies only package-level references to APPS.HR_API and the SYS.STANDARD package, indicating that the wrapper delegates core business validation and processing to HR_API, Oracle's central HR API utility package. The actual DML against the calendar entry base tables is performed downstream of this wrapper. Because the metadata states that the package is referenced by zero other packages, the object stands as a terminal entry point rather than a shared dependency within the APPS schema.

Usage Notes

As a server-side wrapper interface, HR_CALENDAR_ENTRY_SWI is typically invoked indirectly. HRMS forms and concurrent programs that manage calendar data call into this package, which in turn routes processing to HR_API and the appropriate base tables. Custom extensions, interfaces, and data conversion routines may also call these procedures when they need to create, modify, or remove HR calendar entries programmatically. Because the wrapper depends on HR_API, callers inherit the validation, security, and business-rule enforcement provided by that central API layer without duplicating it. Developers integrating with this object should treat it as the supported programmatic entry point for calendar entry maintenance and should not bypass it to perform direct table manipulation.