Results for “igs_pr_cp_gpa”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_PR_CP_GPA is an Oracle EBS Student System (Higher Education) PL/SQL package owned by the APPS schema. Its purpose, stated in the package header, is to provide the calculation routines for Academic Statistics and GPA within the Student Records / Academic Progression functional area. The package encapsulates the business logic required to derive credit points, attempted and earned credit, grade point average, GPA credit points, and GPA quality points for a student's unit attempt records, and to aggregate those values against organizational and institutional statistics definitions.

The package has been maintained since 2001 and carries a documented change history. Bug# 2829262 added the p_uoo_id parameter to GET_SUA_ALL and GET_SUA_CP. Bug# 3547126 modified GET_CP_STATS, GET_GPA_STATS, GET_SUA_GPA, GET_SUA_CP, and GET_SUA_ALL to introduce the p_use_released_grade parameter. Bug# 4491456 later revised the signatures of the "get all stats" and "get sua" routines. These signatures remain the authoritative interface for the package.

Key Procedures and Functions

• GET_SUA_ALL — Primary aggregation routine. Accepts person, course, unit, unit version, teaching calendar and teaching period identifiers together with a statistics type and a system statistics indicator, and returns earned credit points, attempted credit points, GPA value, GPA credit points, and GPA quality points. It also supports p_uoo_id and p_use_released_grade (the latter governing whether released or unreleased grades are considered).
• GET_SUA_CP — Returns credit point information for a student's unit attempt at the individual unit level.
• GET_SUA_GPA — The routine sought by the "get_sua_gpa" search. Calculates the grade point average for a student unit attempt, honoring the p_use_released_grade control added for Bug# 3547126.
• GET_ALL_STATS — Retrieves the complete set of academic statistics for the supplied context.
• GET_CP_STATS — Derives credit point statistics, modified to respect the released-grade flag.
• GET_GPA_STATS — Derives GPA statistics, likewise modified for the released-grade flag.
• GET_ALL_STATS_NEW — Revised variant of the all-statistics routine introduced under Bug# 4491456.

Tables Accessed

The package reads across the Student System base and reference tables exposed through APPS synonyms:

• IGS_EN_SU_ATTEMPT_ALL — the student unit attempt records that supply the core facts for every calculation.
• IGS_AS_GRD_SCH_GRADE, IGS_AS_SUA_REF_CDS — grade scheme definitions and student unit attempt reference codes used to resolve grades into quality points.
• IGS_PR_ORG_STAT, IGS_PR_STAT_TYPE, IGS_PR_INST_STAT, IGS_PR_INST_STA_REF, IGS_PR_ORG_STAT_REF, IGS_PR_STU_ACAD_STAT — statistics type and status definitions that determine which statistic is being computed and stored.
• IGS_AV_STND_UNIT_ALL, IGS_AV_UNT_REF_CDS, IGS_PS_UNIT_REF_CD, IGS_PS_STDNT_UNT_TRN, IGS_PS_PRG_UNIT_REL — unit, program-unit relationship, and student unit transfer data used to resolve unit versions, credit values, and program context.
• IGS_GE_REF_CD — general reference code lookup.

Usage Notes

IGS_PR_CP_GPA is an internal engine package rather than a user-facing API. It is referenced by ten other packages in the Student System, and its routines are typically invoked from progression and award processing, academic statistics concurrent programs, and Student Records forms that display or persist GPA values. Because the OUT parameters are declared NOCOPY and message-list parameters are standard, callers are expected to follow the usual EBS PL/SQL API conventions: initialize the message list, inspect p_return_status, and drain messages via FND_MSG_PUB. The p_use_released_grade flag must be supplied appropriately — passing a value that includes unreleased grades will produce provisional statistics, which is significant for official transcript and progression determinations. Custom code should call the documented signatures only; no other interface is supported.