Search Results igs_as_grd_schema_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_AS_GRD_SCHEMA_PKG package body is a core database-tier component of the Oracle E-Business Suite Student System (formerly Oracle Student System / IGS), hosted on the APPS schema. In Oracle EBS 12.1.1 and 12.2.2, the IGS product family supports the full academic lifecycle, including admissions, student records, assessment, and progression. The IGS_AS_* prefix denotes the Assessment module, and this package encapsulates the business rules and Data Manipulation Language (DML) logic associated with Grade Schema records — the configurable frameworks that define grade scales, grade point mappings, and result classifications used when recording and processing student assessment outcomes.

This package body (status VALID) is documented as belonging to the OTHER API classification, distinguishing it from a formally published public API. It operates as an internal, table-handling package responsible for inserts, updates, row locking, validation of foreign keys and check constraints, and pre-DML processing against the IGS_AS_GRD_SCHEMA table. Fifteen other database objects reference this package, evidencing its role as a shared utility within the Assessment and related modules.

Key Procedures and Functions

Eight documented procedures/functions constitute the package interface. Their purpose in the ETRM metadata is consistent with a generated or pattern-based table handler:

  • INSERT_ROW — Inserts a new grade schema record into IGS_AS_GRD_SCHEMA, populating the mandatory and derived columns defined by the table structure.
  • ADD_ROW — A higher-level wrapper that validates and adds a row, orchestrating validation and insertion logic.
  • UPDATE_ROW — Modifies one or more attributes of an existing grade schema record.
  • LOCK_ROW — Acquires a row-level lock (SELECT ... FOR UPDATE) to prevent concurrent modification of a grade schema record during a transaction.
  • BEFORE_DML — A pre-DML hook responsible for setting audit/derived values (such as WHO columns via FND_GLOBAL) and enforcing business rules prior to insert, update, or delete.
  • GET_FK_IGS_LOOKUPS_VIEW — Resolves a foreign key reference against the Oracle lookups view for value-set based columns (for example, grade type or schema status).
  • GET_PK_FOR_VALIDATION — Retrieves primary key information used to validate the existence and uniqueness of a grade schema row.
  • CHECK_CONSTRAINTS — Performs integrity checks to ensure the row satisfies required constraints before committing.

All procedures reference APP_EXCEPTION, FND_MESSAGE, and IGS_GE_MSG_STACK for standardized error handling and message token substitution.

Tables Accessed

The principal table accessed is IGS_AS_GRD_SCHEMA (via APPS synonym), which stores the definition of grade schemas. The package inserts, updates, and locks rows within this table. Validation procedures rely on foreign key lookups represented by the IGS_LOOKUPS_VIEW dependency. Additional inter-package calls — such as IGS_AS_GRD_SCH_GRADE_PKG, IGS_AS_UNITASS_ITEM_PKG, and IGS_PS_UNIT_GRD_SCHM_PKG — indicate that validation may cross-reference unit assessment items and program-level grade scheme configuration. The IGS_GE_NUMBER dependency suggests use of the system number-generation utility for sequencing.

Usage Notes

Because this is an internal OTHER-classified package body, it is not intended for direct invocation by external custom code. It is typically called by Assessment module forms, concurrent programs, and the other dependent packages listed in the ETRM dependency report — most notably within IGS_AS_GRD_SCHEMA_PKG itself (recursive/overload references), grade schema grade handlers, and student attempt/progression packages. Customizations should avoid modifying this package directly; instead, extensions should be built through supported public APIs or table handlers. The BEFORE_DML and LOCK_ROW routines enforce the transactional integrity required when grade schemas are created or amended, ensuring consistent assessment behaviour across Oracle EBS 12.1.1 and 12.2.2.