Search Results prgp_get_sua_prg_prd

Overview

IGS_PR_GEN_002 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Student System (IGS) product family. Its naming convention and dependency graph place it within the Progression and Awarding (PR) subsystem, which governs the academic progression of students, the calculation of weighted assessment marks, and the determination of progression outcomes across academic periods. The package serves as a computational utility layer: rather than exposing user-facing business events, it provides reusable program units that retrieve and derive values from student attempt, grade scheme, and calendar instance data for consumption by higher-level progression engine packages.

The object is documented as VALID in ETRM and is classified as API type OTHER, indicating it is an internal helper package rather than a published public API. In EBS 12.1.1 and 12.2.2 the package resides in the same compiled state, and its behavior is driven entirely by the underlying IGS tables rather than by any concurrent program registration.

Key Procedures and Functions

Six documented program units constitute the package interface. Each is described below by purpose only; parameter signatures are not published in the available metadata.

• PRGP_GET_SCA_WAM — Returns a weighted assessment mark (WAM) associated with a student course attempt. It derives the weighted aggregate used when assessing a student's performance within a course offering.
• PRGP_GET_STG_COMP — Retrieves staging or component-level completion information, supporting the assembly of component marks that feed into an overall course result.
• PRGP_GET_SUA_GPA_VAL — Returns the grade point average value associated with a student unit attempt, providing the numeric GPA contribution for the attempt under evaluation.
• PRGP_GET_SUA_PRG_NUM — Returns the progression number for a student unit attempt, identifying the sequence position of the attempt within the student's progression record.
• PRGP_GET_SUA_PRG_PRD — Returns the progression period linked to a student unit attempt, establishing the academic period in which the attempt is counted.
• PRGP_GET_SUA_WAM — Returns the weighted assessment mark for a student unit attempt, the unit-level analogue of PRGP_GET_SCA_WAM.

Tables Accessed

The package references the following APPS synonyms: IGS_AS_GRD_SCH_GRADE, IGS_CA_INST_ALL, IGS_EN_SU_ATTEMPT_ALL, IGS_CA_DA_INST, IGS_CA_INST_REL, IGS_CA_STAT, and IGS_CA_TYPE.

• IGS_EN_SU_ATTEMPT_ALL — The student unit attempt table, the primary source of attempt records from which GPA values, progression numbers, progression periods, and weighted marks are derived.
• IGS_AS_GRD_SCH_GRADE — Grade scheme grade definitions, supplying the grade values used to resolve GPA and mark outcomes.
• IGS_CA_INST_ALL — Calendar instance data, resolving the teaching and progression periods attached to attempts.
• IGS_CA_DA_INST, IGS_CA_INST_REL, IGS_CA_STAT, IGS_CA_TYPE — Supporting calendar structures providing instance relationships, statuses, and type classifications for period resolution.

Usage Notes

IGS_PR_GEN_002 is not invoked directly by end users. It is referenced by four other packages — IGS_PR_GEN_001, IGS_PR_GEN_005, IGS_PR_GEN_006, and IGS_RU_GEN_001 — which act as the orchestration layer for progression and results processing. IGS_PR_GEN_002 also references itself, consistent with internal recursive or shared helper calls. Typical invocation is therefore indirect, occurring when progression calculations, GPA derivation, or awarding processes are executed through the Student System's progression engine, whether triggered from the relevant EBS forms or from batch processing. The standard SYS.STANDARD dependency confirms normal PL/SQL compilation dependencies only.