Search Results get_fk_igs_ps_fld_of_study




Overview
Explore in AI Chat

Overview

IGS_PS_US_FLD_STUDY_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Student System (IGS) product family. It provides the programmatic interface for maintaining records in the IGS_PS_US_FLD_STUDY entity, which captures the association between a unit set version and a field of study within the academic program structures used by institutions running Oracle Student System. The package is declared with AUTHID CURRENT_USER, so its SQL statements execute with the privileges of the invoking schema rather than the definer, a convention typical of Oracle EBS table-handling APIs generated from the Oracle Designer/Forms repository. The header comment indicates the source file IGSPI98S.pls at version 115.1, dated 2003, which places the package within the older generation of IGS APIs that predate many of the later public API standards. The package exposes seven documented procedures and functions covering row insertion, locking, deletion, primary key validation, foreign key validation, and a shared pre-DML processing routine.

Key Procedures and Functions

  • INSERT_ROW — Inserts a new row into the IGS_PS_US_FLD_STUDY table, accepting values for the unit set code, version number, and field of study, along with an OUT NOCOPY ROWID parameter and an operating mode flag that defaults to 'R'.
  • LOCK_ROW — Acquires a row-level lock on the target record identified by ROWID and the composite key values, used to serialize concurrent updates and deletes.
  • DELETE_ROW — Removes the row identified by ROWID.
  • GET_PK_FOR_VALIDATION — A Boolean function that verifies the existence of the primary key composed of unit set code, version number, and field of study. It returns TRUE when a matching row is found and is typically called before an insert or update to detect duplicate keys.
  • GET_FK_IGS_EN_UNIT_SET — Validates the foreign key relationship to the IGS_EN_UNIT_SET entity using the unit set code and version number pair.
  • GET_FK_IGS_PS_FLD_OF_STUDY — Validates the foreign key relationship to the field of study entity using the field of study code. This is the routine most commonly associated with the search term get_fk_igs_ps_fld_of_study, since it is the documented entry point for checking that a referenced field of study exists.
  • BEFORE_DML — A shared pre-processing routine invoked by the other DML operations. It manages the WHO columns (creation date, created by, last update date, last updated by, last update login) and enforces the standard Oracle EBS auditing conventions.

Tables Accessed

The package operates on a single documented base table, IGS_PS_US_FLD_STUDY, accessed through an APPS synonym. This table stores the mapping between unit set versions and fields of study. INSERT_ROW, DELETE_ROW, and LOCK_ROW perform the corresponding DML and locking operations directly against it. GET_PK_FOR_validation queries the table to confirm the composite primary key, while the two foreign key validation routines reference it indirectly to confirm that incoming unit set and field of study values are consistent with the stored relationships. No other tables are documented as accessed by this package.

Usage Notes

This package functions as a low-level table handler rather than a business-level public API. It is generally invoked from Oracle Forms-based maintenance screens within the Student System responsibility, where the form triggers map user actions to INSERT_ROW, LOCK_ROW, and DELETE_ROW calls, and from concurrent programs or custom PL/SQL that must maintain the unit set to field of study relationship. The GET_FK_IGS_PS_FLD_OF_STUDY routine is typically called before insert or update to validate that a supplied field of study code is legitimate. Because the package uses AUTHID CURRENT_USER and predates the modern IGS API standards, customizations should prefer any higher-level public APIs where available and reserve direct calls to this package for scenarios in which no alternative exists. The package is referenced by one other package, indicating a limited dependency footprint within the IGS schema.