Search Results igs_ad_room_pkg




Overview
Explore in AI Chat

Overview

IGS_AD_ROOM_PKG is the Oracle E-Business Suite PL/SQL package that encapsulates the business logic for maintaining room records within the Student Systems / Academic and Admissions (IGS) schema. In the EBS 12.1.1 and 12.2.2 releases, this package serves as the primary programmatic interface for the IGS_AD_ROOM entity, which stores physical room inventory (such as classrooms, laboratories, and lecture halls) associated with buildings. The package is declared with AUTHID CURRENT_USER, meaning that its unqualified object references resolve against the privileges of the calling schema rather than the package owner, which is the standard pattern for Oracle Forms–generated APIs in EBS.

The package exposes the conventional seven-part API structure used throughout the IGS product family: INSERT_ROW, LOCK_ROW, UPDATE_ROW, ADD_ROW, DELETE_ROW, validation functions, and constraint enforcement routines. This design supports declarative form-based maintenance as well as programmatic integration from concurrent programs and custom interfaces.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new room record into the base table, accepting the organization, room identifier, building, room code, description, primary-use code, capacity, and closed indicator, and returning the ROWID.
  • LOCK_ROW — Obtains a row-level lock on an existing room record for the duration of a form transaction, keyed by ROWID and the business columns.
  • UPDATE_ROW — Updates an existing room record identified by ROWID with new attribute values.
  • ADD_ROW — Combines insert and update semantics into a single entry point, generating or reusing the primary key as required.
  • DELETE_ROW — Removes a room record identified by ROWID.
  • GET_PK_FOR_VALIDATION — Validates that a supplied room identifier (with an optional closed indicator) corresponds to a valid primary key.
  • GET_UK_FOR_VERIFICATION (documented as GET_UK_FOR_VALIDATION) — Confirms uniqueness of the building plus room code combination.
  • GET_FK_IGS_AD_BUILDING — The routine associated with the user’s search term; it verifies that a supplied building identifier exists and satisfies the foreign-key relationship between rooms and buildings.
  • CHECK_CONSTRAINTS — Applies declarative constraint validation on a named column and value passed by the caller.
  • BEFORE_DML — Central pre-DML handler that performs standard housekeeping (WHO columns, org defaults) prior to insert, update, or delete operations.

Tables Accessed

The package operates on two documented tables through APPS synonyms. IGS_AD_ROOM_ALL is the multi-organization base table holding room definitions, and IGS_AD_ROOM_S is the corresponding security/sequence wrapper used by the IGS security model. GET_FK_IGS_AD_BUILDING logically resolves against the building parent table referenced by the IGS_AD_BUILDING foreign key on the room entity.

Usage Notes

The package is invoked principally from the Oracle Forms-based room maintenance screens shipped with the IGS application, where the insert, update, lock, and delete procedures back the block-level triggers. It is also called by eight documented dependent packages, and may be reused by custom concurrent programs, interface tables, or conversions that must respect the same validation and constraint logic applied by the standard forms. Because the routines enforce primary, unique, and foreign key validation, custom code should call GET_PK_FOR_VALIDATION, GET_UK_FOR_VALIDATION, and GET_FK_IGS_AD_BUILDING rather than writing directly to the underlying tables.