Search Results igs_ps_govt_atd_mode_pkg

Overview

IGS_PS_GOVT_ATD_MODE_PKG is an Oracle EBS Applications (APPS) schema PL/SQL package that belongs to the Student Systems product family, specifically the IGS (Student Information / Student Records) module. Within the ETRM 12.1.1 and 12.2.2 documentation, the object carries an API classification of OTHER, indicating that it is not a formally published public API but rather an internal supporting package used to manage a specific entity and its persistence logic.

The package governs the Government Attendance Mode entity, represented by the base table IGS_PS_GOVT_ATD_MODE. Government attendance modes describe the regulatory classification of how a student attends or participates in a program — for example, full-time, part-time, or other government-reported attendance categories. These values are used for statutory reporting and alignment between institutional attendance data and government-defined codes. The package provides the standard row-level Data Manipulation Language (DML) operations required for maintaining records in this entity, and exposes both package-level routines and a package body that implements them.

Key Procedures and Functions

The documented package exposes eight procedures/functions. Descriptions below are limited to documented purpose; parameter lists are not published in the available metadata.

• INSERT_ROW — Performs a direct insertion of a new row into the underlying entity table.
• UPDATE_ROW — Applies modifications to an existing row identified by its primary key or surrogate identifier.
• DELETE_ROW — Removes an existing row from the entity table.
• ADD_ROW — Higher-level routine that encapsulates validation and insertion logic, typically used as an entry point rather than the primitive INSERT_ROW.
• LOCK_ROW — Acquires a row-level lock on the target record, ensuring concurrency control during updates or deletes.
• GET_PK_FOR_VALIDATION — Retrieves the primary key value used to validate that a referenced row exists before performing dependent DML.
• CHECK_CONSTRAINTS — Validates that the operational constraints associated with the entity are satisfied before committing changes.
• BEFORE_DML — A hook invoked prior to DML execution, typically handling defaulting, auditing stamps, or last-minute derived field population.

Tables Accessed

The package references one documented base table via an APPS synonym:

• IGS_PS_GOVT_ATD_MODE — The core storage table for government attendance mode definitions. All inserts, updates, deletes, and locks performed by the package target this table, and CHECK_CONSTRAINTS and GET_PK_FOR_VALIDATION operate against its key structure.

No other tables are documented as referenced by this package, which is consistent with its role as a single-entity maintenance package.

Usage Notes

IGS_PS_GOVT_ATD_MODE_PKG is typically invoked indirectly. The root dependency chain shows that it is referenced by APPS.IGS_EN_ATD_MODE_PKG, meaning the enrollment-side attendance mode package calls into this package to resolve, validate, or persist government attendance mode data. It also references itself, which is common when package routines call sibling routines within the same package or when a body reuses its own validation logic.

Because the classification is OTHER and not a published API, the package should be treated as an internal implementation detail. Custom code should prefer operating through higher-level APIs such as IGS_EN_ATD_MODE_PKG, or through the standard Oracle Forms and setup windows provided for Student System configuration. Direct calls from custom concurrent programs or reports are possible using the documented procedures, but doing so bypasses any business rules enforced by callers higher in the stack. Version 12.1.1 and 12.2.2 share the same documented metadata, so the package can be treated as behaviorally stable across both releases. Validate against the target instance before relying on it in an integration, since internal packages are not guaranteed compatibility across patches.