Search Results get_fk_igs_ps_govt_dscp




Overview
Explore in AI Chat

Overview

The APPS.IGS_FI_GV_DSP_HEC_CN_PKG package is a generated table-handler API within the Oracle E-Business Suite Student System (formerly Oracle Student System, now part of the Higher Education / Student Information product family). It encapsulates DML and validation logic for the base table IGS_FI_GV_DSP_HEC_CN, which stores Government HECS (Higher Education Contribution Scheme) contribution band definitions segmented by government discipline group. The table associates a discipline group code with a contribution band, bounded by an effective start date and end date, allowing the institution to maintain date-effective contribution rates for Australian government reporting.

The package is declared AUTHID CURRENT_USER and is classified as an "OTHER" API, meaning it is not a public, business-level API but a low-level, table-maintenance PL/SQL unit typically invoked by the Oracle Forms layer or by other internal packages. The source header identifies it as IGSSI53S.pls. It is referenced by two other packages, indicating it participates in a dependency chain of internal validation and maintenance routines.

Key Procedures and Functions

The package exposes eleven documented subprograms:

  • INSERT_ROW — inserts a new discipline-group / contribution-band record, returning the row identifier. Accepts an operating mode parameter defaulting to 'R'.
  • ADD_ROW — performs an insert with a row identifier passed in and out, supporting the Forms-based "add" workflow.
  • UPDATE_ROW — updates an existing record identified by row identifier.
  • DELETE_ROW — removes a record identified by row identifier.
  • LOCK_ROW — issues a locking read against a specific row to support Forms optimistic locking.
  • GET_PK_FOR_VALIDATION — returns a Boolean indicating whether the primary key (discipline group code, contribution band, start date) exists, used for FK/PK validation.
  • GET_UK1_FOR_Validation — validates the unique key (discipline group code and start date).
  • CHECK_CONSTRAINTS — validates supplied column name/value pairs against table constraints.
  • BEFORE_DML — central pre-DML hook that sets WHO columns and performs constraint checks before any insert, update, or delete.
  • GET_FK_IGS_PS_GOVT_DSCP — the foreign key validation routine that the user searched for; it verifies that the referenced government discipline group exists in the parent table before allowing the child row to be persisted.
  • GET_FK_IGS_FI_GOVT_HEC_CNTB — validates the foreign key relationship to the government HECS contribution band parent table.

Tables Accessed

The package operates on IGS_FI_GV_DSP_HEC_CN, accessed via the APPS synonym. This is the sole base table documented. It holds the discipline group code, HECS contribution band, start date, end date, and standard WHO audit columns. The two foreign-key validation functions reference parent entities (government discipline groups and HECS contribution bands) to enforce referential integrity at the application layer, since Oracle Forms-based EBS modules traditionally perform FK checks in PL/SQL rather than relying solely on database constraints.

Usage Notes

This package is not intended to be called directly by end users or custom integrations. It is invoked internally by the Oracle Forms UI for the Government HECS Contribution Band setup screen, where INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW back the block-level DML triggers. The BEFORE_DML procedure and the GET_FK_* validators run automatically during Forms validation. The package is also called by two other packages, confirming its role as a shared internal dependency. Customisations should avoid modifying or directly invoking these routines; instead, institutions should use the supported setup forms or, where necessary, call the public business APIs. When diagnosing the "get_fk_igs_ps_govt_dscp" search term, note that this function simply confirms the existence of the referenced government discipline group record and raises an error when the parent value is missing or invalid.