Search Results pqh_accommodations_api




Overview
Explore in AI Chat

Overview

PQH_ACCOMMODATIONS_API is a public PL/SQL API belonging to the Oracle E-Business Suite HR (PER) product family, packaged under the APPS schema. It exposes programmatic interfaces that allow external code to create, update, and delete accommodation records for France. Accommodations in this context represent employer-provided housing or lodging, and the API captures attributes such as whether the accommodation is suitable for disabled occupants, the owning department, rental value, and the number of persons accommodated. The package is licensed for use with Oracle Human Resources, and its operations are date-tracked, reflecting the effective-dated nature of HR datetracked entities. The API is identified in ETRM with an API classification and is documented as the supported integration point for maintaining accommodation data, ensuring that business validation logic is applied consistently rather than writing directly to the underlying tables.

Key Procedures and Functions

The package exposes three documented procedures, all of which operate against accommodation records. Note that parameter lists are not reproduced here; only the purpose of each routine is described, consistent with the documented metadata.

  • CREATE_ACCOMMODATION — Validates and creates a new accommodation record. The routine records details including suitability for disabled occupants, owning department, rental value, and the number of persons accommodated. It requires an existing business group as a prerequisite, and a p_validate parameter allows callers to perform validation only without committing changes. On success, a new accommodation is created for the specified business group; on failure, no record is written and an error is raised.
  • UPDATE_ACCOMMODATION — Modifies an existing accommodation record, applying the same validation and date-tracking semantics as the create routine. The effective date parameter determines when the datetrack change takes effect.
  • DELETE_ACCOMMODATION — Removes an accommodation record (subject to datetrack deletion semantics), preserving referential and historical integrity of the HR data model.

Across all routines, the p_effective_date parameter governs when the Date Track operation comes into force, and p_validate controls whether the database is actually modified.

Tables Accessed

The package operates on the base table PQH_ACCOMMODATIONS_F (referenced through its APPS synonym), which stores the accommodation records themselves. This is the primary object written during create, update, and delete operations. In addition, the create routine validates and stores a location reference via the p_location_id parameter, which is documented as a foreign key to HR_ALL_LOCATIONS. This linkage ties each accommodation to a valid HR location, which is frequently why users search for hr_all_locations when integrating with this API: accommodation records must reference an existing location, and the location must already be defined in HR before the accommodation can be created or updated. Callers should therefore ensure the target location exists in HR_ALL_LOCATIONS prior to invoking the API.

Usage Notes

PQH_ACCOMMODATIONS_API is the supported programmatic entry point for accommodation maintenance and is referenced by one other package within the EBS codebase. It is typically invoked from custom PL/SQL, integration scripts, or batch processes that need to load or maintain French accommodation data without using the standard HR forms. Because it is a public API with built-in validation and date-tracking, direct DML against PQH_ACCOMMODATIONS_F should be avoided. When calling the API, supply a valid business group and an existing HR location (via HR_ALL_LOCATIONS); use p_validate => TRUE during testing or pre-checks to confirm validation passes before committing, and set the correct p_effective_date to control how the change is recorded on the datetrack timeline.