Search Results igs_ps_fac_wl_pkg




Overview
Explore in AI Chat

Overview

IGS_PS_FAC_WL_PKG is an Oracle EBS PL/SQL package owned by the APPS schema and classified under the "OTHER" API category in ETRM. In Oracle EBS 12.1.1 and 12.2.2, the IGS_PS prefix denotes the Student System (formerly Student Information System) product family, and the FAC_WL token indicates that this package manages "faculty workload" records. Functionally, IGS_PS_FAC_WL_PKG provides the core insert, update, delete, and locking operations for rows in the IGS_PS_FAC_WL table and its translated/intersection counterpart IGS_PS_FAC_WL_S, which together represent the assignment of teaching effort to faculty members within an academic period.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new faculty workload record into IGS_PS_FAC_WL.
  • UPDATE_ROW — Modifies an existing faculty workload row.
  • DELETE_ROW — Removes a faculty workload row.
  • LOCK_ROW — Obtains a row-level lock (typically SELECT ... FOR UPDATE) to serialize concurrent DML.
  • ADD_ROW — Higher-level entry point that performs insert and lock-related logic, validating preconditions before committing a new workload record.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key of the target workload row; used by callers to confirm existence before update or delete.
  • GET_UK_FOR_VALIDATION — Retrieves the unique key columns used to identify a workload business record.
  • GET_FK_IGS_CA_INST — Resolves the foreign key reference to the IGS_CA_INST calendar/instance entity to which the workload belongs.
  • BEFORE_DML — Pre-DML trigger package routine that standardizes auditing and derived column population (WHO columns, defaults) prior to insert or update.

Tables Accessed

  • IGS_PS_FAC_WL — Primary base table for faculty workload records; the target of INSERT_ROW, UPDATE_ROW, and DELETE_ROW.
  • IGS_PS_FAC_WL_S — Translated/shadow table holding locale-specific text values tied to the base workload row.
  • HZ_PARTIES — Party registry; used to validate the faculty/person identity associated with the workload.
  • DUAL — Oracle pseudo-table used in key-lookup and validation queries.

Usage Notes

This package is referenced by IGS_CA_INST_PKG, IGS_PS_FAC_ASG_TASK_PKG, IGS_PS_FAC_OVR_WL_PKG, and IGS_PS_RLOVR_FAC_TSK, confirming its role as a low-level utility layer invoked by higher-level faculty assignment, calendar/instance, and workload-override packages. Custom code should not call IGS_PS_FAC_WL_PKG directly, because the procedures exist to service these internal callers; releases in 12.1.1 and 12.2.2 support the same signature set, so no 12.1.x R12.1.1 / 12.2.x parity concerns apply. The package does not expose a formal concurrent-program entry point, so invocation typically occurs from Oracle Forms faculty assignment screens, from the dependent PL/SQL packages listed above, or from controlled custom integration code that must eventually run through the supported higher-level APIs. Standard APPS synonym grants provide schema access.