Search Results raise_clsrank_be_cr003

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

Overview

IGS_PR_CLASS_RANK is an Oracle EBS Student System (IGS) package classified under the OTHER API category. Its stated purpose is to rank students within a cohort or within an organization, typically for academic progression, scholarship eligibility, or reporting purposes. The package is designed to be invoked either from the concurrent manager or from the "Class Rank Cohort" form, which makes it a dual-purpose component bridging both batch and interactive processing.

Reflecting its origin in the Student Systems product family, the package bears the dated header annotation (IGSPR37S.pls 115.3, 29-NOV-2002) and was originally authored by DDEY. It is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the defining schema.

Key Procedures and Functions

The package exposes eight documented procedures and functions according to ETRM metadata. These include:

• RULP_VAL_SENNA_RES — A validation function used in the context of Senate rule processing. It returns a VARCHAR2 value and is associated with the rule engine that evaluates student progression against institutional regulations. It operates on person, course, unit, calendar, and rule identifiers.
• GET_CUM_GPA — The function that generated the user's search query. It returns a NUMBER representing cumulative grade point average. It accepts person, course, cohort, calendar, status type, and cumulative indicator parameters, making it central to ranking logic where GPA is a key ranking metric.
• RUN_RANKING_PROCESS — The primary concurrent program entry point. It accepts the standard errbuf and retcode OUT parameters, along with cohort name, calendar period, and organizational unit code.
• RAISE_CLSRANK_BE_CR001, RAISE_CLSRANK_BE_CR002, RAISE_CLSRANK_BE_CR003 — Three business event raise procedures associated with class rank processing. These are likely tied to specific ranking events (e.g., rank calculated, rank updated).
• GET_FORMATTED_RANK — Returns a formatted representation of student rank, presumably for display or reporting.

Tables Accessed

The package reads from and writes to the following documented tables via APPS synonyms:

• IGS_PR_COHORT — Stores cohort definitions used to scope the ranking group.
• IGS_PR_COHORT_INST — Cohort instance data linking cohorts to specific calendar instances.
• IGS_PR_COHINST_RANK — The principal output table where computed student rankings are persisted.
• IGS_CA_INST_REL and IGS_CA_TYPE — Calendar instance relationship and type reference data used to resolve calendar periods.
• DUAL — Used for simple single-row computations, confirming the package's use of lightweight SQL.

Usage Notes

Because GET_CUM_GPA is a public function within this package, it can be called directly from custom PL/SQL blocks, forms personalizations, or reports where a cumulative GPA value is required for a given person and course. However, the primary operational entry point remains RUN_RANKING_PROCESS, which orchestrates the ranking computation and writes results to IGS_PR_COHINST_RANK.

The package is referenced by two other packages, indicating a dependency chain within the Student Systems module. Given that the DDL header dates to 2002 and it appears across both 12.1.1 and 12.2.2, the package is stable and largely unchanged across releases. Its limitation set should be reviewed before extending, as the original author flagged known limitations in the header block.