Search Results igs_as_msht_su_atmpt_pkg




Overview
Explore in AI Chat

Overview

IGS_AS_MSHT_SU_ATMPT_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Student System (IGS) product family, specifically the Assessment (IGS_AS) module, and manages the persistence layer for the IGS_AS_MSHT_SU_ATMPT entity — the association between an assessment mark sheet and a student unit attempt. In institutional terms, this table records which student unit attempt is captured on a given mark sheet, forming the linkage that allows assessment results to be recorded against the correct enrolment. The package is classified as an OTHER API in the ETRM repository, meaning it is an internal generated-style data access package rather than a published public API. It supplies the standard row-level DML, locking, foreign key resolution, and constraint validation operations required to maintain rows in this intersection table. The package depends on the SYS.STANDARD package only, and it is referenced by four other packages, indicating it is a low-level component consumed by higher-level assessment processing logic.

Key Procedures and Functions

The package exposes ten documented procedures and functions, organized around the typical table handler pattern:

  • INSERT_ROW — Inserts a new mark sheet / student unit attempt association row into the underlying table.
  • UPDATE_ROW — Updates an existing row identified by its primary key.
  • DELETE_ROW — Removes an existing association row from the table.
  • ADD_ROW — Performs an insert with supplemental logic, typically used when a row must be created together with derived or defaulted column values.
  • LOCK_ROW — Issues a SELECT ... FOR UPDATE against the target row to serialize concurrent modification before an update or delete.
  • GET_PK_FOR_VALIDATION — Returns the primary key value(s) required for validation checks, allowing callers to confirm a row exists before acting on it.
  • GET_FK_IGS_AS_MARK_SHEET — Resolves and returns the foreign key reference to the mark sheet entity for a given association.
  • GET_FK_IGS_EN_SU_ATTEMPT — Resolves and returns the foreign key reference to the student unit attempt entity for a given association.
  • CHECK_CONSTRAINTS — Validates that supplied values satisfy the business and referential constraints defined for the table.
  • BEFORE_DML — Centralizes pre-DML housekeeping such as WHO column population and key derivation, invoked internally before row operations.

Only name and purpose are described here; ETRM does not publish parameter signatures for this object.

Tables Accessed

All table access is performed through APPS synonyms. The single documented table is IGS_AS_MSHT_SU_ATMPT. This package reads from it to resolve primary and foreign key values and to lock rows, and writes to it through the insert, add, update, and delete operations. No other table is documented as being touched directly by this package; related validation logic depends on the caller or on higher-level packages.

Usage Notes

As an OTHER-classified table handler, this package is not intended for direct invocation by customers or integrators. It is called by the four packages documented as referencing it — IGS_AS_GEN_004, IGS_AS_MARK_SHEET_PKG, IGS_EN_FUTURE_DT_TRANS, and IGS_EN_SU_ATTEMPT_PKG — and it also appears in its own dependency list. In practice it is driven from Oracle Forms and PL/SQL business logic in the Mark Sheet and Student Unit Attempt areas of the Student System, whenever a student unit attempt must be attached to or detached from a mark sheet. Because the API is internal and unpublished, customizations should call the higher-level assessment packages rather than IGS_AS_MSHT_SU_ATMPT_PKG directly. In both EBS 12.1.1 and 12.2.2 the object is VALID and its interface is unchanged across those releases.