Search Results igs_as_anon_grd_pkg




Overview
Explore in AI Chat

Overview

IGS_AS_ANON_GRD_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports anonymous grading within the Oracle Student System (formerly Oracle iLearning / Student Information System) assessment module. Its central purpose is to decouple a student's identity from the graded assessment items so that markers can evaluate submitted work without knowing which candidate produced it. The package manages the lifecycle of the anonymous grading identifier, providing the routine that returns a unique anonymous ID for a given person, course, unit, teaching calendar and assessment context, alongside the reciprocal routine that maps an anonymous ID back to the underlying person. It was created in January 2002 by pkpatel and carries no particular known limitations noted in the header comment. The object is classified under the ETRM API classification of OTHER, indicating it is not a formally published public API but an internal support package used by Oracle's delivered forms and concurrent programs. Because the user searched for "get_anon_id," that function is the focal entry point and is described in detail below.

Key Procedures and Functions

  • chk_anon_graded — a function that determines whether a specific assessment item for a given unit offering option has already been graded anonymously. It returns a VARCHAR2 flag used by callers to decide whether an anonymous ID already exists and therefore whether allocation should be skipped or reused.
  • mnt_anon_id — a procedure designed to be run as a concurrent program. It maintains (allocates, reallocates or reconciles) anonymous IDs across a range bounded by a minimum and maximum number, scoped to an award year derived from a concatenated calendar type and sequence number, with a flag controlling whether existing anonymous IDs are reallocated or preserved.
  • get_anon_id — the function of interest. Given a person ID, course code, unit code, teaching calendar type and sequence number, unit offering option ID, assessment ID and a unit grading indicator, it returns the anonymous identifier (VARCHAR2) that should be used to represent that student's submission for the assessment in question. It is the principal read path invoked at grading time.
  • get_person_id — the inverse function. Supplied with an anonymous ID and the teaching calendar type and sequence number, it returns the corresponding person identifier (NUMBER), enabling identity resolution for results processing and release.
  • user_anon_id — the additional documented routine completing the five-function set, supporting user-facing anonymous ID handling within the same grading workflow.

Tables Accessed

The package reads and writes across the assessment, enrolment and party model. HZ_PARTIES supplies the person identity anchored by party_id. IGS_AS_ANON_ID_PS, IGS_AS_ANON_ID_ASS, IGS_AS_ANON_ID_US and IGS_AS_ANON_NUMBER hold the anonymous ID assignments, their assessment associations, user scoping and the number ranges used for allocation. IGS_AS_ANON_METHOD defines the anonymous grading method configured for the context. IGS_AS_ASSESSMNT_ITM_ALL and IGS_AS_ASSESSMNT_TYP provide the assessment item and its type. IGS_EN_SU_ATTEMPT_ALL and IGS_AS_SU_ATMPT_ITM link attempts and attempt items to the assessment. IGS_PS_UNIT_OFR_OPT_ALL and IGS_PS_UNITASS_ITEM supply the unit offering option and unit assessment structure. IGS_CA_INST_ALL provides calendar instance data (calendar type and sequence number), and FND_LOOKUP_VALUES resolves reference lookup values. PLITBLM is the standard EBS PL/SQL table buffer used for in-memory collections. These tables are referenced through APPS synonyms.

Usage Notes

IGS_AS_ANON_GRD_PKG is not intended for direct end-user invocation. It is called from Oracle Student System assessment and grading forms whenever a marker opens or saves an anonymously graded assessment item, with get_anon_id resolving the identifier on fetch and get_person_id resolving the identity when results are released. The maintenance procedure mnt_anon_id is registered as a concurrent program so administrators can seed or realign anonymous ID ranges periodically, typically at the start of an award year. The package is referenced by five other packages, which are the supported call sites, and custom extensions should mirror those documented parameter contracts rather than passing ad hoc values. Because it is classified as OTHER, Oracle does not guarantee upward compatibility of its signature, so any custom code should be regression tested against both 12.1.1 and 12.2.2 before deployment.