Search Results update_entry_value

Overview

APPS.HR_CAL_ENTRY_VALUE_SWI is a self-service wrapper package (the "SWI" suffix denotes "Self-Service Web Interface") within the Oracle E-Business Suite HRMS schema. Its purpose is to expose restricted HR Calendar Entry Value API operations for consumption by self-service web applications, rather than by external integrations or batch programs. The package acts as a thin façade over the underlying business API hr_cal_entry_value_api, deriving and validating the "IN" parameters before delegating the substantive work to that API. In an EBS 12.1.1 or 12.2.2 environment, this arrangement enforces a controlled entry point through which middle-tier self-service pages can create, update, and delete calendar entry values (the formatted values displayed against calendar entries in an HR calendar).

Key Procedures and Functions

Three procedures are documented in the package specification, mirroring the core maintenance verbs of the underlying API:

• CREATE_ENTRY_VALUE — The self-service wrapper for hr_cal_entry_value_api.create_entry_value. It accepts the effective date, calendar entry, hierarchy node, value, organizational context, override metadata, and parent/child relationships, and returns the new entry value identifier along with an object version number and a return status indicating success or failure.
• DELETE_ENTRY_VALUE — The wrapper for the corresponding API delete operation. It removes an existing calendar entry value, subject to validation and effective-dating rules, and returns a standard return status so callers can confirm the outcome.
• UPDATE_ENTRY_VALUE — The wrapper that applies modifications to an existing calendar entry value. Like its siblings, it validates inputs, invokes the underlying API, and communicates success or failure through p_return_status.

All three follow the same pattern: the wrapper provides a standardized interface and parameter derivation, while the actual business logic, validation, and database maintenance reside in hr_cal_entry_value_api. Each declares AUTHID CURRENT_USER, so privileges are evaluated against the invoking schema.

Tables Accessed

The ETRM metadata for this object does not enumerate underlying tables directly; the package specification indicates that all DML is performed by the delegated hr_cal_entry_value_api package. The relevant tables are therefore those maintained by that API — principally the HR calendar entry value entity and its associated hierarchy/calendar entry structures, together with the standard HR date-tracked tables that support effective dating, object versioning, and "Who" columns. Because the wrapper performs no direct SQL, any table-level analysis should be conducted against the underlying API.

Usage Notes

This package is annotated "Internal Development use only" and is not intended for direct invocation by customers, integrators, or third-party products. It is typically called by Oracle self-service web applications (for example, public-sector or absence-management pages that render and maintain HR calendars). Only three entry points exist, and the package is referenced by zero other packages according to the metadata, confirming its role as a leaf-level entry point invoked from the application tier rather than from server-side PL/SQL hierarchies. Because the wrapper relies on the underlying API for validation and DML, and because it depends on session context established by the self-service framework, direct invocation from custom SQL or concurrent programs is generally unsupported and may produce unexpected return statuses. Developers requiring calendar entry value maintenance outside a self-service context should call hr_cal_entry_value_api directly, using the wrapper only as a reference for expected behavior and error semantics.