Search Results create_accommodation

Overview

The APPS.PQH_ACCOMMODATIONS_API package body is a public PL/SQL API within the Oracle E-Business Suite HRMS family of packages, designed to manage accommodation records held by the enterprise. Accommodations in this context represent physical dwellings or housing units that are tracked against a business group and, typically, a specific location. The package encapsulates the full lifecycle of an accommodation record by providing discrete procedures for creating, updating, and deleting accommodation data, thereby insulating callers from the underlying table structures and validation logic. Because it is classified as an API in the ETRM metadata for both 12.1.1 and 12.2.2, it is intended to be the supported programmatic interface rather than requiring direct DML against the base tables. The package header declares g_package as a constant identifying string used for error and message prefixing, which is a common convention in Oracle HRMS APIs to attribute raised errors to the originating package. The body is identified by the header pqaccapi.pkb 115.1, indicating a relatively stable, low-maintenance unit of code.

Key Procedures and Functions

• CREATE_ACCOMMODATION — Inserts a new accommodation record. The procedure accepts a validation flag, an effective date, a mandatory accommodation name and business group identifier, and a location identifier, followed by a wide set of optional descriptive and attribute parameters covering address details, contact telephone numbers, physical characteristics such as floor number, floor area and measurement unit, main rooms and family size, suitability for disabled occupants, rental value and its currency, owner, comments, and a set of descriptive flexfield information columns. It is the primary entry point for establishing a new accommodation.
• UPDATE_ACCOMMODATION — Modifies an existing accommodation record, allowing the same attribute set to be maintained over time as the accommodation details change.
• DELETE_ACCOMMODATION — Removes an accommodation record from the system, providing the supported means of retiring an accommodation that is no longer required.

All three procedures follow the standard HRMS API pattern of supporting a validation-only mode through the p_validate parameter, enabling callers to test a transaction without committing it.

Tables Accessed

The package operates against the PQH_ACCOMMODATIONS_F table, accessed through the APPS synonym layer. This is the base (or "_F" dated) table that stores accommodation records, and the API procedures perform the corresponding insert, update, and delete operations directly against it. Additional validation and lookup assistance is drawn from the standard HRMS date-track and business group infrastructure that these APIs rely upon, though the primary data store documented is PQH_ACCOMMODATIONS_F.

Usage Notes

The package is typically invoked from the Oracle EBS Forms-based Accommodations maintenance screens, from concurrent programs that load or migrate accommodation data, and from custom PL/SQL code requiring a supported interface to accommodation records. One other package references this API, indicating it also participates in a wider dependency chain within the HRMS schema. Callers should always supply a valid p_effective_date consistent with the date-tracking model and should consider invoking the procedures first in validation mode before committing, to surface validation errors cleanly. Direct DML against PQH_ACCOMMODATIONS_F should be avoided in favour of these documented API procedures, as the API enforces the required business rules and maintains the integrity of the accommodation record set.