Search Results get_ufk_igs_as_untas_pattern




Overview
Explore in AI Chat

Overview

IGS_AS_SU_ATMPT_PAT_PKG is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite, part of the Student Systems (IGS) product family associated with the Oracle Student System and its assessment (AS) modules. The package serves as the table handler and API layer for the IGS_AS_SU_ATMPT_PAT entity, which stores the association between a student's assessment attempt and a specific assessment pattern. In functional terms, the record links a person, course, unit, calendar instance, and assessment pattern identifier, and records attributes such as a default indicator, creation date, logical delete date, UOO (unit offering option) identifier, and an assessment pattern identifier. The package encapsulates the standard Oracle EBS table-handler programming pattern: insert, update, delete, lock, validation, and constraint-checking routines that enforce referential integrity and business rules against the underlying table. It is classified in ETRM as an "OTHER" API, meaning it is an internal, form-driven table handler rather than a published, externally supported integration interface.

Key Procedures and Functions

The package exposes ten documented procedures and functions. The DML procedures are INSERT_ROW, ADD_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW.

  • INSERT_ROW — Inserts a new assessment-pattern-attempt association, populated from the person, course, unit, calendar, pattern, and UOO attributes, with a row mode cursor parameter defaulting to 'R' for runtime.
  • ADD_ROW — Performs the same insert role as INSERT_ROW, providing the alternate entry point used by the form's block-level add logic.
  • UPDATE_ROW — Modifies an existing association row, including its default indicator and logical delete date.
  • DELETE_ROW — Removes the row identified by its ROWID.
  • LOCK_ROW — Acquires a row-level lock for the identified record, supporting form-level concurrency control.
  • GET_PK_FOR_VALIDATION — A function returning BOOLEAN that verifies the existence and uniqueness of the primary key combination (course code, person ID, assessment pattern ID, creation date, and UOO ID) before insert or update.
  • GET_FK_IGS_EN_SU_ATTEMPT — Validates the foreign-key relationship from this table to the student attempt entity, confirming that the referenced person, course, and UOO combination is valid.
  • GET_UFK_IGS_AS_UNTAS_PATTERN — Validates the user-foreign-key relationship to the assessment pattern entity (IGS_AS_UNTAS_PATTERN), ensuring the supplied pattern reference exists; this is the routine corresponding to the "get_ufk_igs_as_untas_pattern" search term.
  • CHECK_CONSTRAINTS — Performs general constraint validation for the row before DML.
  • BEFORE_DML — A trigger-style routine invoked prior to insert, update, or delete to enforce package-level business rules.

Tables Accessed

The package operates on the table IGS_AS_SU_ATMPT_PAT, accessed through the APPS synonym. All DML operations, lock calls, and validation queries in the package read from and write to this single base table. The table records the attempt-to-pattern assignment for a student's assessment, and is functionally dependent on the student attempt data (IGS_EN_SU_ATTEMPT) and the assessment pattern definition (IGS_AS_UNTAS_PATTERN), which are referenced only for foreign-key validation by the GET_FK and GET_UFK functions rather than being directly modified.

Usage Notes

IGS_AS_SU_ATMPT_PAT_PKG is typically invoked by Oracle Forms within the Student System assessment setup or result entry flows, where the form block triggers INSERT_ROW, ADD_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW during user interaction. The BEFORE_DML and CHECK_CONSTRAINTS routines are called automatically by the table handler to enforce integrity before committing changes. Because the package is classified as OTHER rather than a supported public API, custom code should treat it as internal and avoid direct invocation unless no supported alternative exists. The package is referenced by one other package in the IGS modules, which depends on its validation functions. Developers resolving the "get_ufk_igs_as_untas_pattern" search should recognize GET_UFK_IGS_AS_UNTAS_PATTERN as the user-foreign-key validation routine for the assessment pattern reference, used during DML to guarantee that only valid pattern IDs are stored.