Search Results igs_en_atd_type_pkg




Overview
Explore in AI Chat

Overview

IGS_EN_ATD_TYPE_PKG is a PL/SQL package in the APPS schema that belongs to the Oracle Student System (formerly Oracle iLearning / Student Information) family of modules within Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its name derives from the entity it manages: Enrollment Attendance Type (IGS_EN_ATD_TYPE). The package provides the standard Oracle Forms–style "table handler" API used throughout EBS for maintaining rows in the IGS_EN_ATD_TYPE_ALL table, which stores the valid attendance-type codes used to classify how a student attends an offering — for example, full-time attendance, part-time attendance, or distance attendance.

The package is classified as an OTHER API rather than a public or private business API, meaning it is an internal infrastructure package primarily consumed by Oracle-delivered forms, concurrent programs, and other IGS packages rather than being intended as a customer-facing integration API. Its status is VALID and it depends only on SYS.STANDARD at the database level, confirming it is a self-contained DML helper with no external package dependencies of its own.

Key Procedures and Functions

ETRM documents nine procedures and functions in IGS_EN_ATD_TYPE_PKG. They follow the conventional Oracle Forms table-handler pattern:

  • INSERT_ROW — Performs the actual insert of a new attendance-type row into the base table.
  • LOCK_ROW — Issues a SELECT ... FOR UPDATE against the target row to serialize concurrent edits, typically called before an update or delete.
  • UPDATE_ROW — Applies the modified column values to the existing row.
  • ADD_ROW — The Forms-level entry point that orchestrates the add operation, including key generation and defaulting, before delegating to INSERT_ROW.
  • DELETE_ROW — Removes an attendance-type row from the base table.
  • GET_PK_FOR_VALIDATION — Retrieves the primary key value used by the Forms validation logic to confirm a row identity before committing.
  • GET_FK_IGS_PS_GOVT_ATD_TYPE — Resolves the foreign-key relationship to the government attendance-type entity, supporting referential validation between the institution's attendance types and the statutory government attendance types.
  • CHECK_CONSTRAINTS — Enforces mandatory and business-rule constraints prior to DML, returning validation errors to the calling form.
  • BEFORE_DML — The pre-DML hook that normalizes values, sets WHO columns, and invokes constraint checking before insert, update, or delete.

Tables Accessed

The package reads and writes a single documented table, IGS_EN_ATD_TYPE_ALL, accessed through an APPS synonym. This table holds the institution-defined attendance-type codes, their descriptions, and the associated government attendance-type reference used in statutory reporting. The package is referenced by twenty-three other packages, including IGS_EN_STDNT_PS_ATT_PKG (student attendance), IGF_AP_ATTEND_MAP_PKG, IGS_AD_PS_APPL_INST_PKG, IGS_FI_FEE_AS_RATE_PKG, and IGS_RE_CDT_ATT_HIST_PKG, indicating that attendance-type data is shared across enrollment, admissions, financial aid, and records subsystems.

Usage Notes

IGS_EN_ATD_TYPE_PKG is typically invoked indirectly. Oracle Forms such as the Attendance Type maintenance form call ADD_ROW, UPDATE_ROW, and DELETE_ROW through the generic Forms transaction triggers, which in turn invoke BEFORE_DML, CHECK_CONSTRAINTS, and the row-level DML procedures. The companion loader package IGS_EN_ATD_TYPE_LOAD_PKG calls it during bulk setup or conversion loads. Because it is an OTHER-classified internal API, custom code should not call it directly; implementers requiring attendance-type maintenance should use the delivered forms or, where automated loading is required, the documented loader package instead.