Search Results igs_ps_unit_facility_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_PS_UNIT_FACILITY_PKG package is a PL/SQL database package in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, owned by the APPS schema with the object status VALID. It forms part of the Student System (IGS) product family, which manages academic structures, program and unit definitions, and the physical resources associated with their delivery. This package serves as a data-access and constraint-enforcement layer for unit facility records — that is, the association between an academic unit version and the facilities (media equipment, rooms, and related physical resources) required or used during delivery of that unit.

Consistent with Oracle's Table-Handler (TAPI) design pattern, the package implements standardized DML operations, row locking, primary/unique/foreign key validation lookups, and constraint checking. Its API classification is recorded as OTHER, reflecting that it exposes a mixed procedural interface rather than a pure public API. This design enables Oracle forms, concurrent programs, and custom extensions to perform controlled inserts, updates, and deletes against the unit facility entity while preserving relational integrity across the IGS schema.

Key Procedures and Functions

ETRM documents eleven procedures and functions within the package:

  • INSERT_ROW — Inserts a new unit facility record into the base table, including surrogate key generation.
  • UPDATE_ROW — Applies changes to an existing unit facility record.
  • ADD_ROW — Performs an integrated insert/update operation, typically used for form-level DML that must reconcile new and existing rows.
  • DELETE_ROW — Removes a unit facility record.
  • LOCK_ROW — Obtains a row-level lock to prevent concurrent modification during transactional processing.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key value for validation purposes.
  • GET_UK_FOR_VALIDATION — Resolves a unique key value to support uniqueness validation.
  • GET_FK_IGS_PS_MEDIA_EQUIP — Validates and returns the foreign key reference to media equipment.
  • GET_FK_IGS_PS_UNIT_VER — Validates and returns the foreign key reference to the unit version.
  • CHECK_CONSTRAINTS — Enforces business and relational constraints prior to DML execution.
  • BEFORE_DML — Provides pre-DML processing, such as attribute defaulting and WHO-column stamping.

Tables Accessed

The package operates on the following tables through APPS synonyms:

  • IGS_PS_UNIT_FACILITY — The primary base table storing unit facility associations, read and written by the insert, update, delete, and lock operations.
  • IGS_PS_UNIT_FACILITY_S — The corresponding DFF/translation-style secondary table (the "_S" suffix), accessed for descriptive and language-dependent attributes.
  • DUAL — Used for singleton scalar evaluations during key generation and validation logic.

These tables underpin the relationship between unit versions and the facilities or equipment mapped to them, supporting scheduling, resource planning, and facility utilization reporting.

Usage Notes

The package is referenced by three other database objects: IGS_PS_GEN_008 (a generated object), IGS_PS_MEDIA_EQUIP_PKG, and IGS_PS_UNIT_VER_PKG (with self-reference from its own body). This dependency chain indicates that facility validation is invoked during unit-version and media-equipment processing. Typical invocation occurs indirectly through Oracle Forms and OAF pages that maintain unit facility data, and through the enclosing IGS business packages rather than through direct ad hoc calls. Custom code should call the documented procedures instead of issuing direct DML, ensuring that constraint validation, key resolution, and row locking remain consistent. Because the object is VALID in the APPS schema, no compilation or revalidation is required.