Search Results get_sua_yop

Overview

IGS_AS_ADI_UPLD_AIO_PKG is an Oracle EBS Student Systems (Higher Education) package owned by APPS. It belongs to the Assessment (AS) product family and supports the Application Data Import (ADI) upload path for Assessment Item Outcome records. Its central role is to move data from the interface tables (IGS_AS_AIO_INTERFACE, IGS_AS_UG_INTERFACE) into the base assessment tables after validating that each staging record resolves to a legitimate person, unit attempt, assessment, grading schema, and version. In addition, the package exposes a grading process routine that creates or updates grade records for assessment items, and it delegates the actual grade persistence to the standard Grade Unit and Grade Assessment Item APIs through a wrapper procedure.

The package is classified as an OTHER API in the ETRM metadata for 12.1.1. It is referenced by four other packages, confirming its position as a shared utility used by ADI import routines and related assessment processing flows rather than as a stand-alone user-facing program.

Key Procedures and Functions

The following public procedures and functions are documented for this package:

• GET_SUA_YOP — Returns the year of program for a student unit set attempt. This is the object referenced by the search term "get_sua_yop". It derives the program year from the attempt context so downstream assessment logic can associate an outcome with the correct program year.
• ASSESSMENT_ITEM_GRADE_PROCESS — Validates staged records and, on success, inserts into the base tables by calling the appropriate table handlers. It drives the primary assessment item grading upload.
• ASSMNT_ITEM_GRADE_UNIT_PROCESS — A wrapper API around the Grade Unit and Grade Assessment Item APIs. It applies the same validate-then-insert pattern used by the item grade process but covers unit-level grading.
• IGS_AS_AIO_VAL_UPLD — Validates a single Assessment Item Outcome record held in the interface table before upload. It resolves identifiers such as person number, course code, unit code, calendar type and sequence number, returning resolved person, assessment, and grading schema identifiers. This validation is invoked both from the interface table import routine and from ADI pre-validation.
• ISVALIDUSER — A supporting check confirming the user submitting the upload is valid, typically resolved against FND_USER, before the process proceeds.

Tables Accessed

The package reads and writes across the following documented tables:

• Staging: IGS_AS_AIO_INTERFACE and IGS_AS_UG_INTERFACE hold the incoming assessment item outcome and unit grade rows that the validation and process routines consume.
• Person/Party: FND_USER is checked for submitter validity, while HZ_PARTIES supplies party resolution for person identification.
• Attempts and Enrolment: IGS_EN_SU_ATTEMPT_ALL, IGS_AS_SU_SETATMPT, IGS_AS_SU_ATMPT_ITM, and IGS_EN_STDNT_PS_ATT_ALL provide the student unit attempt, attempt item, and program attempt context, including the data used by GET_SUA_YOP.
• Assessment and Grading: IGS_AS_ENTRY_CONF, IGS_AS_GRD_SCHEMA, IGS_AS_GRD_SCH_GRADE, and IGS_EN_UNIT_SET_CAT supply assessment entry configuration, grading schema, schema grade, and unit set category definitions.
• Calendar: IGS_CA_TYPE, IGS_CA_INST_ALL, and IGS_CA_STAT validate calendar type, calendar instance, and calendar status for the teaching period referenced on the staged record.

Usage Notes

IGS_AS_ADI_UPLD_AIO_PKG is normally invoked indirectly. The interface import routine and the ADI pre-validation functionality call IGS_AS_AIO_VAL_UPLD to check individual rows, while the two grade process procedures are run to commit validated interface records into the base assessment tables. Typical invocation points are the ADI concurrent programs and the assessment upload forms in the Student Systems responsibility, with custom extensions calling the wrapper procedures where unit and assessment item grades must be written together. Because the grade routines accept user, batch timestamp, grade creation method, and delete-rows parameters, they are suited to batch execution where previously staged rows are purged after processing. GET_SUA_YOP is a lightweight helper intended for callers that already hold person, course, calendar type, and sequence context and require only the resulting program year.