Search Results get_sua_grade

Overview

IGS_PR_ACAD_DETAILS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as a general-purpose (OTHER) API within the Student Systems product family. Its designation as an academic details package reflects its role as a data aggregation and retrieval layer for student academic records, specifically covering Student Unit Attempt (SUA) outcomes, per-load academic performance, and cumulative academic performance.

The package populates PL/SQL collections from the underlying student records tables and exposes a set of scalar accessor functions that return individual academic metrics from those collections. This pattern allows callers — typically other PL/SQL packages, forms, or reporting logic — to avoid repeatedly querying base tables and instead resolve metrics such as grade point average, credit points earned, credit points attempted, and grade values from an in-memory structure. The package also supports a YOP (Year of Program) accessor, indicating that it serves progression and academic standing evaluation as well as raw grade reporting.

Key Procedures and Functions

The package exposes 20 documented procedures and functions, organized around three levels of aggregation and a pair of table population routines.

• POPULATE_SUA_TABLE — Loads the package-level sua_table collection with per-attempt records drawn from student unit attempt and statement-of-outcome data, including grade, mark, GPA, earned and attempted credit points, and the unit offering option identifier.
• POPULATE_LOAD_TABLE — Loads the load_table collection with per-load and cumulative academic performance values for a person, including load GPA, load earned and attempted credit points, cumulative GPA, and cumulative earned and attempted credit points.
• GET_SUA_GPA, GET_SUA_GPA_CP, GET_SUA_GPA_QP — Return the grade point average, grade point average credit points, and grade point average quality points respectively for a specific student unit attempt held in the SUA collection.
• GET_SUA_EARNED_CP — Returns the credit points earned for a specific student unit attempt. This is the function matched by the search term and is the typical entry point for callers that need the earned credit value associated with a single attempt.
• GET_SUA_ATTEMPTED_CP — Returns the credit points attempted for a specific student unit attempt.
• GET_SUA_GRADE and GET_SUA_MARK — Return the recorded grade and mark for the attempt.
• GET_SUA_YOP — Returns the year of program associated with the attempt, supporting progression and cohort analysis.
• GET_LOAD_GPA, GET_LOAD_GPA_CP, GET_LOAD_GPA_QP — Return load-level GPA and its associated credit point and quality point components.
• GET_LOAD_EARNED_CP and GET_LOAD_ATTEMPTED_CP — Return load-level earned and attempted credit point totals.
• GET_CUM_GPA, GET_CUM_GPA_CP, GET_CUM_GPA_QP — Return cumulative GPA and its credit point and quality point components across a student's record.
• GET_CUM_EARNED_CP and GET_CUM_ATTEMPTED_CP — Return cumulative earned and attempted credit point totals, the values most often consumed by progression, award, and completion rules.

Tables Accessed

The package reads from the following tables through APPS synonyms:

• IGS_AS_GRD_SCH_GRADE — Supplies grade scale and GPA value definitions used when computing GPA and quality points.
• IGS_AS_SU_SETATMPT — The statement of outcome / attempt outcome table providing grade and mark values for student unit attempts.
• IGS_EN_UNIT_SET_CAT — Provides unit set and unit offering information used to resolve credit point and unit attribution.
• IGS_PR_ORG_STAT — Provides organisational and progression/standing-related context used in academic detail computation.
• PLITBLM — A standard Oracle applications utility table, generally used for temporary PL/SQL table storage support.

Usage Notes

IGS_PR_ACAD_DETAILS is an internal supporting package rather than a public integration API. It has been referenced by six other packages, indicating that it is called principally from within the Student Systems PL/SQL layer — most likely from progression, award, and academic standing packages that require consolidated credit point and GPA figures. The typical invocation sequence is to call POPULATE_SUA_TABLE or POPULATE_LOAD_TABLE first, then invoke the appropriate GET_* function for each value required.

Because the package relies on package-level state, it is not inherently thread-safe across concurrent sessions in the sense of shared state; each session maintains its own instantiation. Callers in custom code should populate the relevant collection before calling any accessor, and should re-populate when the underlying academic data changes within the same session. As with other APPS-owned IGS packages in 12.1.1 and 12.2.2, the API is not documented for direct external use, and any direct call from custom code carries upgrade risk.