Search Results igs_as_val_suaap




Overview
Explore in AI Chat

Overview

The APPS.IGS_AS_VAL_SUAAP package body is a validation library within the Oracle E-Business Suite Student Systems (Oracle Student System / Academic Records) module. Its name derives from the functional area it protects — "SUAAP" refers to Student Unit Attempt Assessment Pattern processing — and the package is responsible for enforcing institutional rules governing how assessment patterns are applied to a student's unit attempt records. It belongs to the IGS_AS_%_VAL_% family of validation packages, whose convention is to centralize business-rule checking so that the same validation logic is shared consistently across forms, concurrent programs, and PL/SQL APIs. In Oracle EBS 12.1.1 and 12.2.2 the package is documented with a status of VALID and an API classification of OTHER, meaning it is treated as an internal validation utility rather than a public, released API. The package body encapsulates the executable logic that realizes the validation contract and raises structured error messages through the Oracle application message stack when a rule is violated.

Key Procedures and Functions

Four documented program units constitute the package body:

  • ASSP_VAL_UAP_LOC_UC — Validates the association between a unit attempt pattern and its applicable location and unit-context attributes, ensuring a student's unit attempt is assessed only against patterns valid for that delivery context.
  • ASSP_VAL_SUAAP_INS — Performs the insert-time validation of the student unit attempt assessment pattern record, confirming required relationships and statuses are satisfied before the row is created.
  • ASSP_VAL_SUAAP_ACTV — Validates the activation of a student unit attempt assessment pattern, verifying that the pattern may legitimately become active given the student's enrolment and assessment position.
  • GENP_VAL_SDTT_SESS — A generic validation routine addressing session/date-track related checks used in support of the assessment pattern validations.

No parameter signatures are documented in the available metadata, so the actual argument lists must be confirmed against the deployed package specification in the target environment.

Tables Accessed

The documented table references, resolved through APPS synonyms, are:

  • IGS_AS_SU_ATMPT_PAT — the student unit attempt assessment pattern entity; the primary subject of the insert and activation validations, read to confirm the pattern's current state and written when a validated insert proceeds.
  • IGS_GE_S_DSB_TAB_TRG — a general-system trigger/control table consulted for system-level validation behaviour.
  • DUAL — used for scalar expression evaluation, for example invoking message or sequence functions within PL/SQL.

The dependency listing also indicates the package draws on IGS_EN_SU_ATTEMPT, IGS_PS_UNIT_OFR_OPT_ASS_PAT_V, APP_EXCEPTION, FND_MESSAGE and IGS_GE_MSG_STACK, using these to resolve the student's unit attempt context and to raise localized errors.

Usage Notes

As a validation package, IGS_AS_VAL_SUAAP is normally invoked indirectly rather than called directly by end users. Typical entry points are the Oracle Forms used to maintain student unit attempt assessment patterns, the Student System concurrent programs that process assessment pattern data in batch, and custom or seeded PL/SQL that must apply the same rules before committing. Because the metadata confirms the package is referenced by twenty-four other database objects while it references none back to them, it sits low in the dependency hierarchy and is safe to reuse. Its error handling routes messages through FND_MESSAGE and IGS_GE_MSG_STACK, so callers should surface the resulting message stack to the user. During upgrades from 12.1.1 to 12.2.2, the package's logic should be re-verified against the delivered specification, as validation packages are commonly patched to align with Online Patching and editioning requirements.