Search Results igs_as_assessmnt_typ_pkg




Overview
Explore in AI Chat

Overview

The IGS_AS_ASSESSMNT_TYP_PKG package body, owned by the APPS schema, is a core data-access and validation component within the Oracle E-Business Suite Advanced Student Systems (formerly Student Systems / IGS) assessment-type infrastructure. Its purpose is to encapsulate DML and validation logic for assessment type definitions held in the IGS_AS_ASSESSMNT_TYP table. In the terminology of the product, an assessment type classifies the nature of an assessment (for example, exam, assignment, or continuous assessment) and governs how assessment items are grouped, weighted, and reported against a student's enrolment.

The package follows the standard Oracle EBS "table-handler" pattern: it exposes discrete procedures for row insertion, update, deletion, and locking, each wrapping the underlying SQL with server-side validation, foreign-key integrity checks, and error-message propagation through the FND message stack. Because the object is classified as an "OTHER" API rather than a public, supported interface, it is intended primarily for internal use by the related assessment packages and by the generated forms that maintain assessment setup data.

Key Procedures and Functions

The documented package exposes nine procedures and functions, consistent with the Oracle EBS table-handler convention:

  • INSERT_ROW — inserts a new assessment-type row, applying the mandatory column defaults and validations required before the record is committed.
  • LOCK_ROW — acquires a row-level lock on an existing assessment type, typically issued prior to an update or delete to guarantee concurrency control.
  • UPDATE_ROW — modifies an existing assessment-type record, re-validating changed attributes and foreign-key relationships.
  • ADD_ROW — a higher-level entry point that delegates to INSERT_ROW after performing additional pre-insert processing.
  • DELETE_ROW — removes an assessment type, subject to the referential-integrity rules enforced by the assessment item package.
  • GET_PK_FOR_VALIDATION — returns the primary-key value used by the validation layer to confirm the uniqueness and existence of an assessment type.
  • GET_FK_IGS_AS_SASSESS_TYPE — resolves the foreign key relating an assessment type to its associated assess-type record, supporting lookups used during validation.
  • CHECK_CONSTRAINTS — validates the business and database constraints applicable to the assessment-type row before the DML is permitted.
  • BEFORE_DML — a pre-DML hook invoked by the other routines to centralise cross-cutting checks, such as mandatory-field and date-range validation.

Tables Accessed

The package operates against IGS_AS_ASSESSMNT_TYP, accessed through the APPS synonym layer. This table stores the assessment-type definition rows and is the sole documented base table referenced. All inserts, updates, deletes, and locks performed by the package target this table. The package depends on IGS_AS_ASSESSMNT_ITM_PKG and IGS_AS_VAL_ATYP for related validation logic, on IGS_AS_SASSESS_TYPE_PKG for the parent assess-type relationship, and on APP_EXCEPTION, FND_MESSAGE, FND_GLOBAL, and IGS_GE_MSG_STACK for error handling and message-stack management.

Usage Notes

IGS_AS_ASSESSMNT_TYP_PKG is not intended for direct end-user invocation. It is typically called from the assessment-type maintenance form, from related assessment setup packages, and potentially from concurrent programs that load or migrate assessment configuration data. The ETRM metadata records that the body is referenced by five other database objects, confirming its role as a shared dependency. Customisations should avoid calling this package directly; instead, the supported public APIs of the assessment subsystem or the maintainable form should be used. Any change to this package body must account for the five dependent callers and the foreign-key relationship to the assess-type parent, and should be regression-tested against the assessment item validation routine to ensure referential integrity is preserved.