Search Results igs_en_su_attempt_pkg




Overview
Explore in AI Chat

Overview

IGS_EN_SU_ATTEMPT_PKG is a core table-handler package in the Oracle EBS Student Systems (IGS) product family, owned by the APPS schema and reported as VALID in the ETRM object registry for release 12.1.1 and 12.2.2. Its business function is to manage rows in the student unit attempt entity — the record of a student's attempt at a specific unit version offering within a teaching period — together with its associated header, history, and reference-code structures. The package therefore underpins the enrolment, assessment, and progression flows by providing the standard insert, update, delete, locking, and constraint-validation primitives that higher-level enrolment and assessment APIs rely upon, rather than exposing a single business transaction of its own.

Key Procedures and Functions

The documented interface exposes twenty-two program units, following Oracle's generated table-handler pattern:

No parameter lists are reproduced here, as the ETRM metadata does not document them.

Tables Accessed

The package operates against the following APPS synonyms:

Usage Notes

This package is not intended for direct end-user invocation. It is referenced by thirty-seven other packages, including the enrolment APIs IGS_EN_ADD_UNITS_API and IGS_EN_DROP_UNITS_API, the student unit attempt API IGS_EN_SUA_API, assessment packages such as IGS_AS_SUA_AI_GROUP_PKG and IGS_AS_MSHT_SU_ATMPT_PKG, and generated forms packages (IGS_EN_GEN_001, IGS_EN_GEN_004, IGS_EN_GEN_010, IGS_EN_GEN_012, IGS_EN_FUTURE_DT_TRANS). It is therefore invoked indirectly whenever students are enrolled, withdrawn, or assessed through the corresponding forms and concurrent processes. Only SYS.STANDARD appears as a dependency, indicating pure PL/SQL with no external service calls. Custom code should use the supported APIs listed above rather than calling the table handlers directly.