Search Results populate_load_table

Overview

The APPS.IGS_PR_ACAD_DETAILS package body is a Student System (IGS) academic progress utility within Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the "PR" product family, which covers progression, academic standing, and academic record evaluation. Its central business purpose is to derive and persist academic performance metrics — grade point averages, credit point totals, earned and attempted credit points, grades, marks, and year-of-program information — for individual students, for a specific teaching load, and cumulatively across the student's academic history. These computed values are staged into a load table structure so that downstream progression rules, academic standing evaluations, and official notification processes can consume consistent, pre-aggregated figures rather than recalculating them repeatedly. The package is documented under the ETRM repository with an API classification of OTHER and is referenced by six other packages, indicating it functions as a shared dependency within the IGS progression and records subsystem.

Key Procedures and Functions

The package exposes twenty documented program units. The primary driver is POPULATE_SUA_TABLE, which computes Student Unit Attempt (SUA) level metrics for a given person, course, unit, version, teaching calendar, and unit attempt status, accepting a p_uoo_id parameter introduced under Bug# 2829262. POPULATE_LOAD_TABLE performs the analogous staging operation for the teaching load context — this is the unit most directly associated with the user's "load_table" search term.

The remaining routines are accessor functions grouped into three families. The SUA family comprises GET_SUA_GPA, GET_SUA_GPA_CP, GET_SUA_GPA_QP, GET_SUA_EARNED_CP, GET_SUA_ATTEMPTED_CP, GET_SUA_GRADE, GET_SUA_MARK, and GET_SUA_YOP, returning grade point average, its credit point and quality point components, earned and attempted credit points, grade, mark, and year of program for a unit attempt. The load family — GET_LOAD_GPA, GET_LOAD_GPA_CP, GET_LOAD_GPA_QP, GET_LOAD_EARNED_CP, and GET_LOAD_ATTEMPTED_CP — returns equivalent measures scoped to the teaching load. The cumulative family — GET_CUM_GPA, GET_CUM_GPA_CP, GET_CUM_GPA_QP, GET_CUM_EARNED_CP, and GET_CUM_ATTEMPTED_CP — returns the same metrics aggregated across the student's entire record. This three-tier SUA/load/cumulative naming convention reflects the standard IGS aggregation hierarchy.

Tables Accessed

The package reads and writes data through APPS synonyms. IGS_AS_GRD_SCH_GRADE supplies grading schema definitions, including the SHOW_ON_OFFICIAL_NTFCTN_IND flag used by the internal cursor to restrict grades eligible for official notification. IGS_AS_SU_SETATMPT holds statement of results and attempt outcome data, and IGS_EN_SU_ATTEMPT (referenced in the source parameters) holds unit attempt records. IGS_PR_ORG_STAT provides organisation status and statistic type context. IGS_EN_UNIT_SET_CAT supports unit set categorisation, and PLITBLM is used for temporary storage of the staged load and SUA table rows that the populate routines build.

Usage Notes

IGS_PR_ACAD_DETAILS is typically invoked from progression and academic standing workflows — for example, when a student's results are finalised, when a load is evaluated against progression rules, or when official notification documents are generated. Because it is referenced by six other packages, it is best treated as an internal dependency rather than a standalone entry point. The populate routines should be executed before the corresponding getter functions, since the getters read the staged results. Custom code should call the documented procedures in the supported sequence rather than querying the underlying tables directly, and should preserve the p_uoo_id parameter introduced in the 2005 patch level. Direct calls should be made with the APPS schema and standard FND message handling.