Search Results igs_en_atd_type_load_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_EN_ATD_TYPE_LOAD_PKG package body is a VALID database object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the APPS schema. It serves the Student System (formerly Student Records / OSS) product family under the IGS (Institution of Higher/Graduate Studies) module namespace. Its primary business function is to support the loading and maintenance of "ATD" (Attendance Type Load) reference data records stored in the underlying IGS_EN_ATD_TYPE_LOAD_ALL entity. It operates as the procedural layer that governs the Data Manipulation Language (DML) lifecycle for Attendance Type Load rows, providing row locking, insert, update, delete, and pre-DML validation logic. As an "OTHER" classified API, it is not part of the public documented open interfaces but functions as a supporting DML helper package used internally by forms, concurrent processes, or other packages within the Enrolment (EN) subsystem.

Key Procedures and Functions

The package body exposes a set of ten documented procedures and functions that implement a standard Oracle Forms-derived DML processing pattern:

  • INSERT_ROW — Inserts a new Attendance Type Load record into IGS_EN_ATD_TYPE_LOAD_ALL.
  • LOCK_ROW — Acquires a row-level lock to ensure concurrency control before modification.
  • UPDATE_ROW — Modifies the attributes of an existing Attendance Type Load row.
  • ADD_ROW — Provides the higher-level ADD entry point, typically performing validation and preparing defaults before delegating to the insert logic.
  • DELETE_ROW — Removes a specified Attendance Type Load record.
  • GET_PK_FOR_VALIDATION — Returns the primary key value used to validate a record, supporting foreign key checks.
  • GET_FK_IGS_EN_ATD_TYPE — Resolves the foreign key reference to the parent Attendance Type entity, verifying its existence.
  • GET_FK_IGS_CA_TYPE — Resolves the foreign key reference to the CA (Course Attempt / Award) Type entity for relational integrity.
  • CHECK_CONSTRAINTS — Enforces the business and database constraints applicable to the row before commit, using message-stack handling to surface errors.
  • BEFORE_DML — A pre-DML trigger-style routine invoked prior to any insert, update, or delete, coordinating validation and derived column population.

Tables Accessed

The only table documented as referenced through APPS synonyms is IGS_EN_ATD_TYPE_LOAD_ALL. This is the base (all-organisation) table storing Attendance Type Load definitions. The package reads from it to validate keys and constraints, and writes to it through the insert, update, and delete procedures. Foreign key validation procedures reference parent entities (Attendance Type and CA Type) logically through the key-resolution routines, though those parent tables are resolved indirectly via the API functions rather than direct SQL in the documented excerpt.

Usage Notes

The package is classified as an internal "OTHER" API and is not referenced by any other database object at the schema level, indicating it is invoked primarily from Oracle Forms or directly through the Enrolment attendance entry flows rather than by downstream PL/SQL. It may also be driven from concurrent programs or custom extensions that need to programmatically create or maintain Attendance Type Load records. Because it references supporting packages such as IGS_CA_TYPE_PKG, IGS_EN_ATD_TYPE_PKG, IGS_GE_MSG_STACK, IGS_GE_NUMBER, and IGS_AD_VAL_APCOO, callers should expect standard EBS error-stack semantics (FND_MESSAGE / APP_EXCEPTION) and the use of FND_GLOBAL for session context (user and responsibility). Custom code invoking this package should follow the documented DML sequence — typically BEFORE_DML, then LOCK_ROW for updates, then ADD_ROW or UPDATE_ROW or DELETE_ROW — to preserve constraint consistency and proper concurrency handling.