Search Results igs_pr_class_rank




Overview
Explore in AI Chat

Overview

The APPS.IGS_PR_CLASS_RANK package body is a component of the Oracle Student System (formerly Oracle Student Systems / OSS) module within Oracle E-Business Suite, delivered under the APPS schema. Its core business function is to compute class rank — the comparative academic standing of students within a cohort or class instance — based on cumulative grade point average (GPA) and related academic performance data. Class rank is significant for progression decisions, award classifications, honors eligibility, and institutional reporting.

The object is classified under the generic API classification OTHER, meaning it is not a formal public interface API (such as those adhering strictly to the FND_API standard) but rather an internally orchestrated processing package. It is documented as VALID in both EBS 12.1.1 and 12.2.2 environments. The metadata states that it references numerous dependency packages and is referenced by two other packages, indicating it occupies a mid-tier position within the Student System ranking architecture.

Key Procedures and Functions

The ETRM documentation lists eight documented procedures and functions within this package body. Their documented purposes are as follows:

  • RULP_VAL_SENNA_RES — a validation routine, likely handling validation of ranking result data (the "SENNA" token suggests a specific internal validation rule or result set naming convention). It performs pre-processing or result-set verification prior to persistence.
  • GET_CUM_GPA — retrieves the cumulative GPA for a student. This is the foundational data accessor that supplies the ranking key used throughout the package.
  • RUN_RANKING_PROCESS — the principal driver procedure. It orchestrates the full class-ranking computation across a cohort or class instance, invoking the GPA retrieval, comparison, and ranking-write logic.
  • RAISE_CLSRANK_BE_CR001, RAISE_CLSRANK_BE_CR002, RAISE_CLSRANK_BE_CR003 — three business-event raising routines ("BE_CR" denotes Business Event / Change Request style event handlers). These raise WF_EVENT-based workflow events tied to class rank changes, corresponding to distinct event codes 001, 002, and 003.
  • GET_FORMATTED_RANK — returns a presentation-formatted rank value, useful where rank is displayed as a positional string (e.g., ordinal or tied-rank notation) rather than a raw number.

No parameter lists are documented in the supplied metadata, and none should be assumed.

Tables Accessed

The package reads and writes the following documented tables (accessed via APPS synonyms):

  • IGS_PR_COHORT and IGS_PR_COHORT_INST — cohort and cohort-instance definitions, providing the grouping scope within which ranking occurs.
  • IGS_PR_COHINST_RANK — the cohort-instance ranking table, the principal target for writing computed rank values.
  • IGS_CA_INST_REL and IGS_CA_TYPE — calendar instance relationships and types, used to resolve the academic period context of the ranking.
  • DUAL — standard single-row utility access.

Additional dependencies include IGS_PR_COHINST_RANK_PKG, IGS_PR_COHORT_INST_PKG, IGS_PR_CP_GPA, and IGS_EN_SCA_V/IGS_EN_SU_ATTEMPT, which supply GPA and student-attempt data feeding the rank calculation.

Usage Notes

This package is typically invoked from a concurrent program submitting the class-ranking process, from Student System forms that display cohort rank, or from custom code performing batch ranking. Given its workflow-event dependencies (WF_EVENT, WF_PARAMETER_LIST_T) and message-stack usage (IGS_GE_MSG_STACK, FND_MSG_PUB), it follows a standard EBS error-handling and business-event publication pattern. Because it is not referenced by any database object and is not a formal FND_API-style public interface, direct calls should be treated as internal and version-sensitive across 12.1.1 and 12.2.2.