Search Results get_fk_igs_ps_fac_wl




Overview
Explore in AI Chat

Overview

IGS_PS_FAC_OVR_WL_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that provides the programmatic interface for the IGS_PS_FAC_OVR_WL entity, the faculty workload override table within the Oracle Student System (formerly OSS/HRMS-Student) product family. The package is declared AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking schema rather than the package owner. Its header carries the version string $Header: IGSPI3IS.pls 115.3 2002/11/29, indicating it originated in the earlier IGS product line and has been carried forward into the 12.1.1 and 12.2.2 releases without structural change.

The business purpose of the package is to maintain records that override a faculty member's expected workload for a defined period. Faculty workload records (IGS_PS_FAC_WL) establish the baseline expectation, and the override table allows institutions to substitute a different expected workload value — for example, for secondments, partial absences, or special assignments — together with a reason code and an effective date range. The package encapsulates all insert, update, delete, and validation logic for that entity.

Key Procedures and Functions

  • INSERT_ROW — Creates a new faculty workload override record, accepting the foreign key to the faculty workload row, start and end dates, the overridden expected workload value, and an override reason, with an operational mode parameter defaulting to 'R'.
  • LOCK_ROW — Obtains a pessimistic lock on an existing override row by rowid, used to serialize concurrent updates in a multi-user form session.
  • UPDATE_ROW — Modifies an existing override record's attributes based on rowid, applying the same mode convention as insert.
  • ADD_ROW — The combined insert-or-update entry point that accepts in/out rowid and primary key parameters, allowing the caller to add a row and receive the generated identifier in a single call.
  • DELETE_ROW — Removes an override record identified by rowid.
  • GET_PK_FOR_VALIDATION — Returns a Boolean indicating whether a supplied primary key value exists, supporting form-level validation of IGS_PS_FAC_OVR_WL_ID.
  • GET_FK_IGS_PS_WL_OVER_RESN — Validates that a supplied override reason value exists in the workload override reason reference table.
  • GET_FK_IGS_PS_FAC_WL — Validates the parent faculty workload foreign key. This is the routine associated with the search term get_fk_igs_ps_fac_wl, and it is the standard foreign key validation helper generated by Oracle Designer/Headstart style APIs.
  • BEFORE_DML — The internal row-level trigger handler that populates WHO columns (creation date, created by, last update date, last updated by, last update login) before insert or update, and enforces defaulting rules.

Tables Accessed

The package operates against three documented objects. IGS_PS_FAC_OVR_WL is the base table holding the override records and is the target of all DML. IGS_PS_FAC_OVR_WL_S is a shadow/audit table used for capturing prior row images. DUAL is referenced for single-row computations and sequence-style lookups within BEFORE_DML. All references are made through APPS synonyms, so the package is callable from any schema granted execute privilege.

Usage Notes

The package is typically invoked from the Oracle Forms-based maintenance screens for faculty workload overrides, which call ADD_ROW, UPDATE_ROW, and DELETE_ROW directly, and use LOCK_ROW when a record is queried for change. The two GET_FK_* procedures support the LOV-based validation of the override reason and parent workload keys in those forms. Two other packages reference this package, indicating it is a dependency in the faculty workload processing chain rather than a standalone utility. Custom code should call the procedures rather than performing direct DML on IGS_PS_FAC_OVR_WL, because the BEFORE_DML logic maintains the WHO audit columns and any defaulting behavior. For 12.2.2 environments the package resides in the same APPS schema and requires no editioning-specific handling beyond the standard EBS 12.2 online patching considerations.