Search Results assp_get_ese_key

Overview

IGS_AS_GEN_006 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Student System (IGS) product family for Assessment and Examination processing. The package name follows the institutional convention for generated or stage-specific assessment routines, and its documented status is VALID across EBS 12.1.1 and 12.2.2. Its principal business role is to support the creation, staging, and maintenance of assessment records — grades, assessor assignments, exam supervisor data, and temporary assessment staging rows — that feed examination instances and grade schema evaluation. In ETRM terms the package is classified as an OTHER API rather than a public or private API, indicating it is an internal repository component invoked by higher-level assessment packages rather than a supported integration entry point. The dependency footprint confirms this: IGS_AS_GEN_006 depends on the grade schema entity, item assessor entity, and unit version view, while it is itself referenced by five assessment packages, including IGS_AS_EXAM_INSTANCE_PKG, IGS_AS_EXMVNU_SESAVL_PKG, IGS_AS_EXM_INS_SPVSR_PKG, IGS_AS_EXM_SES_VN_SP_PKG, and IGS_AS_STD_EXM_INSTN_PKG.

Key Procedures and Functions

The ETRM metadata documents ten callable units within IGS_AS_GEN_006:

• ASSP_GET_ESE_KEY — Retrieves a key value for exam session or exam element context, used by callers to obtain identifying keys before inserting related assessment rows.
• ASSP_INS_ADMIN_GRDS — Inserts administrative grade records, typically for assessments driven by administrative rather than purely academic rules.
• ASSP_INS_AIA — Inserts assessment item assessor rows, establishing the link between an assessment item and its assigned assessor.
• ASSP_INS_AIA_DEFAULT — Inserts default assessor assignments where no explicit assessor has been specified, applying institutional defaults.
• ASSP_INS_AI_CVR_SHT — Inserts assessment item cover sheet data, the header used when distributing assessment material to assessors.
• ASSP_INS_ASR1020_TMP — Populates a temporary/staging structure used by the ASR1020 assessment process, supporting downstream report or batch generation.
• ASSP_INS_DFLT_EVSA_A — Inserts default event assessment records, seeding event-level assessment data when none exists.
• ASSP_INS_ESE_SPRVSR — Inserts exam supervisor records, capturing supervisory assignment against exam instances or sessions.
• ASSP_INS_GS_DUPREC — Handles graded schema duplicate record insertion, supporting reconciliation of grade records that appear more than once.
• ASSP_UPD_SUAO_TRANS — Updates student unit attempt outcome transactions, adjusting outcome or transaction data on the student unit attempt.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms: IGS_AS_GRD_SCHEMA, IGS_AS_GRD_SCH_GRADE, and IGS_AS_ITEM_ASSESSOR (grade schema and assessor linkage), IGS_AS_ITEM_ASSESSOR_SEQ_NUM_S (sequence for assessor numbering), IGS_AS_ASSESSMNT_TYP and IGS_AS_ASSESSOR_TYPE (assessment and assessor type reference data), IGS_AS_DUE_DT_SUMRY (due date summary information), IGS_AS_EXM_INS_SPVSR and IGS_AS_EXM_LOC_SPVSR (exam instance and location supervisor data), IGS_AS_SU_ATMPT_ITM and IGS_AS_SU_STMPTOUT_ALL (student unit attempt items and stamped outcome records), IGS_AS_UNIT_CLASS_ALL (unit class allocation), IGS_PS_UNIT_VER_ALL (unit version view for validation), and HZ_PARTIES and IGS_AD_LOCATION_REL (party and location relationship data for assessor and supervisor assignment). These accesses confirm the package operates across assessment setup, assessor assignment, exam supervision, and student outcome recording.

Usage Notes

IGS_AS_GEN_006 is not intended for direct custom invocation. It is called by the assessment packages listed above, which in turn are invoked through Oracle Forms-based assessment and examination entry screens, concurrent programs generating assessment and examination outputs (for example the ASR1020 staging process), and batch routines that seed default assessors, supervisors, and grades. Custom code should treat the package as an internal dependency: because its procedures have no documented public API classification and depend on application-internal sequences and staging tables, direct calls risk data inconsistency and are not supported across patching or upgrades. Developers extending assessment behaviour should call the documented public assessment APIs or the referencing packages rather than IGS_AS_GEN_006 directly, and should revalidate dependencies against ETRM after any 12.1.1 to 12.2.2 upgrade, since subobject and dependency lists may change.