Search Results get_fk_igs_as_sassess_type




Overview
Explore in AI Chat

Overview

The APPS.IGS_AS_ASSESSMNT_TYP_PKG package is a PL/SQL API belonging to the Oracle Student System (IGS) product family, specifically the Assessment (IGS_AS) module. It encapsulates the data manipulation logic for the IGS_AS_ASSESSMNT_TYP entity, which defines the assessment types used throughout the institution's assessment and grading framework. Assessment types classify the nature of an assessment activity — for example, whether a given instrument is examinable, whether the type has been closed to further use, and whether anonymous grading applies. This package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the defining user, a common pattern in Oracle E-Business Suite table handler APIs generated from the Oracle Designer/Toolkit repository. The classification of this object is OTHER, indicating it functions as a supporting validation and DML utility rather than a top-level public API. It is referenced by five other packages, confirming its role as a foundational dependency for higher-level assessment processing logic.

Key Procedures and Functions

The package exposes nine documented procedures and functions, following the standard EBS table handler pattern:

  • INSERT_ROW — Inserts a new assessment type record, populating the row identifier and all descriptive and indicator columns.
  • LOCK_ROW — Obtains a row-level lock on an existing assessment type to support concurrency control during multi-user edits.
  • UPDATE_ROW — Modifies an existing assessment type record identified by its row identifier.
  • ADD_ROW — Provides an alternate entry point for row creation, typically used where the row identifier is generated by the caller.
  • DELETE_ROW — Removes an assessment type record by row identifier.
  • GET_PK_FOR_VALIDATION — A boolean function that validates whether a supplied primary key (assessment type) exists, used by the framework to enforce referential integrity during DML.
  • GET_FK_IGS_AS_SASSESS_TYPE — Validates the foreign key relationship against the IGS_AS_SASSESS_TYPE entity, ensuring the referenced assessment type value is consistent before allowing the operation. This is the procedure most commonly located by developers searching the validation entry point for this table.
  • CHECK_CONSTRAINTS — Evaluates database-level constraints for a given column and value, supporting pre-DML validation.
  • BEFORE_DML — A central pre-processing hook that enforces business rules and constraint checks prior to any insert, update, or delete.

Tables Accessed

The package operates against a single documented table via its APPS synonym: IGS_AS_ASSESSMNT_TYP. All insert, update, delete, lock, and validation operations target this table, which stores the master list of assessment type definitions along with their descriptive attributes and control indicators (examinable, closed, and anonymous grading flags). No additional tables are documented as directly accessed, though the foreign key validation routine implies a logical dependency on the IGS_AS_SASSESS_TYPE entity.

Usage Notes

This package is typically invoked from Oracle Forms-based setup windows where administrators maintain assessment type codes, or programmatically from the five dependent packages that reference it. Because it implements the standard toolkit-generated DML pattern, direct invocation in custom code should follow the conventional sequence: call GET_PK_FOR_VALIDATION or GET_FK_IGS_AS_SASSESS_TYPE for validation, then invoke INSERT_ROW, UPDATE_ROW, or DELETE_ROW as appropriate, relying on BEFORE_DML internally for constraint enforcement. The header references patch level 115.5, indicating this is a long-stable component of the IGS assessment schema across both 12.1.1 and 12.2.2 releases.