Search Results igs_ps_uso_facility_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_PS_USO_FACILITY_PKG package body is a core database API within the Oracle E-Business Suite (EBS) Student System (also referred to as Oracle Student System / Higher Education). It provides the business logic for managing records in the IGS_PS_USO_FACILITY entity, which stores facility and resource allocation data associated with unit (course) offerings and their scheduled occurrences. In the terminology of the Student System, "IGS_PS" denotes the Product/Student records area, "USO" refers to Unit Offering, and "FACILITY" identifies the physical or logical facility resource. The package encapsulates the standard Oracle Forms transactional pattern — row locking, insert, update, and delete — together with referential validation routines and a BEFORE_DML trigger handler. Because it is a package body owned by APPS and reported with VALID status, it is a supported, compiled member of the EBS schema and is invoked from the corresponding maintenance form and from other student-system packages.

Key Procedures and Functions

ETRM documents ten callable units within the package:

  • INSERT_ROW — Creates a new facility record in the underlying table, populating standard WHO columns and defaults.
  • LOCK_ROW — Issues a SELECT ... FOR UPDATE to obtain a row-level lock, supporting optimistic concurrency from the form.
  • UPDATE_ROW — Applies modifications to an existing facility record and refreshes the audit columns.
  • ADD_ROW — Convenience wrapper that validates and then inserts a facility row.
  • DELETE_ROW — Removes a facility record, subject to the standard integrity checks.
  • GET_PK_FOR_VALIDATION — Confirms that the primary key supplied by the caller corresponds to an existing record; returns the validated key or raises a message.
  • GET_UK_FOR_VALIDATION — Validates uniqueness of the alternate (unique) key columns before DML proceeds.
  • GET_FK_IGS_PS_USEC_OCCURS — Validates the foreign key relationship to the unit offering occurrence.
  • GET_FK_IGS_PS_MEDIA_EQUIP — Validates the foreign key relationship to the media equipment entity.
  • BEFORE_DML — Central pre-insert/pre-update handler that enforces validation and audit rules.

Tables Accessed

  • IGS_PS_USO_FACILITY — The base table holding facility records.
  • IGS_PS_USO_FACILITY_S — The translated (language) table holding the user-entered descriptive text.
  • IGS_PS_USEC_OCCURS_ALL — The occurrence table referenced for foreign-key validation of the parent offering occurrence.
  • DUAL — Used for singleton lookups and sequence/default evaluation.

Additional dependencies executed through called packages include FND_GLOBAL, FND_MESSAGE, IGS_GE_MSG_STACK, APP_EXCEPTION, IGS_PS_MEDIA_EQUIP_PKG, IGS_PS_USEC_OCCURS_PKG, and IGS_PS_USEC_SCHEDULE.

Usage Notes

The package is principally invoked by the facility maintenance form in the Student System responsibility, which calls LOCK_ROW, INSERT_ROW, UPDATE_ROW, and DELETE_ROW during the standard Forms commit cycle. It is not referenced by any database object, but four other packages reference it, confirming its role as a subordinate API. Custom extensions should call the same public procedures rather than performing direct DML, ensuring that foreign-key validation, uniqueness checks, and audit stamping remain consistent with seeded behavior.