Results for “assp_upd_suao_trans”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_AS_GEN_006 is a generated-style PL/SQL package body in the APPS schema belonging to the Oracle E-Business Suite Student System (the IGS product family), specifically the Assessment (AS) module. Its object name follows the convention used for utility and processing routines that support assessment administration and examination scheduling. The package encapsulates bulk data-processing and data-fix logic for exam supervisors, assessment coverage sheets, and assessor assignments, exposed through a small set of focused program units. As an OTHER-classified API it is not registered as a public interface; it is an internal processing utility invoked by other components of the assessment subsystem.

The package is relevant in both Oracle EBS 12.1.1 and 12.2.2. Its dependency list confirms it is tightly coupled to the assessment, enrolment, and location data models, and it is referenced by five other packages, indicating it sits in the mid-layer of the assessment call stack rather than at its apex.

Key Procedures and Functions

• ASSP_GET_ESE_KEY — Retrieves the surrogate key for an exam session or exam-session-related entity, providing calling routines with the identifier needed for subsequent inserts and updates.
• ASSP_INS_ADMIN_GRDS — Inserts administrative grade records, creating grade rows that support assessment result administration.
• ASSP_INS_AIA — Populates the item assessor assignment table, establishing the link between assessment items and their assigned assessors.
• ASSP_INS_AIA_DEFAULT — Creates default item assessor assignments, applying standard assignment rules where explicit assessor definition is absent.
• ASSP_INS_AI_CVR_SHT — Inserts assessment item coverage sheet data, the summary structure used to track assessment coverage for a student or unit attempt.
• ASSP_INS_ASR1020_TMP — Loads staging or temporary records associated with the ASR1020 reporting/processing context.
• ASSP_INS_DFLT_EVSA_A — Inserts default exam venue session availability records, ensuring venues have baseline availability defined.
• ASSP_INS_ESE_SPRVSR — Inserts exam session supervisor assignments, binding supervisors to exam instances or sessions.
• ASSP_INS_GS_DUPREC — Inserts grade scheme duplicate records, used in duplicate detection or reconciliation processing within grading.
• ASSP_UPD_SUAO_TRANS — Updates student unit attempt outcome transition data, advancing or correcting the outcome state of a unit attempt.

Tables Accessed

The package reads and writes assessment core tables including IGS_AS_ITEM_ASSESSOR, IGS_AS_ITEM_ASSESSOR_SEQ_NUM_S, IGS_AS_ASSESSMNT_TYP, IGS_AS_ASSESSOR_TYPE, IGS_AS_GRD_SCHEMA, IGS_AS_GRD_SCH_GRADE, IGS_AS_DUE_DT_SUMRY, IGS_AS_SU_ATMPT_ITM, IGS_AS_UNIT_CLASS_ALL, and IGS_AS_SU_STMPTOUT_ALL. Supervisor and venue data are handled through IGS_AS_EXM_INS_SPVSR and IGS_AS_EXM_LOC_SPVSR. Party and location context is derived from HZ_PARTIES and IGS_AD_LOCATION_REL, while unit version information comes from IGS_PS_UNIT_VER_ALL.

The presence of IGS_AS_ITEM_ASSESSOR_SEQ_NUM_S — the sequence named in the originating search term — confirms the package draws next assessor sequence numbers when inserting item assessor rows, ensuring uniqueness across assessments.

Usage Notes

IGS_AS_GEN_006 is invoked by sibling assessment packages and by concurrent programs that batch-assign assessors, generate coverage sheets, define default exam venue availability, and reconcile grade scheme duplicates. It writes informational and error output through FND_FILE and FND_LOG and raises messages via FND_MESSAGE and APP_EXCEPTION, so it is well suited to concurrent-manager execution where log files capture processing detail.

Because it is a non-registered internal API, customizations should not call it directly where a supported public API exists; instead it should be reached through the documented assessment processes. Session context via FND_GLOBAL is used to attribute records to the correct user and responsibility.