Search Results igs_pr_gen_001




Overview
Explore in AI Chat

Overview

IGS_PR_GEN_001 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified within the ETRM repository as an OTHER-type API. It belongs to the Student System (IGS) product family, specifically the Academic Records and program progression area. The package serves as a utility and retrieval layer for program-related academic calculations, supplying derived values such as calendar streams, effective dates, elapsed time, and grade point averages that drive progression rules and academic standing evaluation. Its status is VALID, and it exposes seven documented program units used by other packages in the IGS_PR_GEN series and related processing components.

Key Procedures and Functions

The package contains seven documented program units, all following the PRGP_ naming prefix:

  • PRGP_GET_CAL_STREAM — Retrieves the calendar stream associated with a program or student record, used to determine the applicable academic calendar context.
  • PRGP_GET_CRV_CMT — Obtains curriculum version comment or associated curriculum version detail relevant to program progression evaluation.
  • PRGP_GET_DRTN_EFCTV — Determines the effective duration for a program or program version, supporting duration-based progression checks.
  • PRGP_GET_MSR_EFCTV — Returns the effective measure value, typically related to credit or assessment measures applied in progression rules.
  • PRGP_GET_PRG_EFCTV — Establishes the effective program date or version applicable to a given student's progression calculation.
  • PRGP_GET_SCA_ELPS_TM — Calculates elapsed time for a student course attempt, used to assess time-based progression criteria.
  • PRGP_GET_SCA_GPA — Computes the grade point average for a student course attempt, feeding progression and academic standing rules.

These functions are designed to be called by sibling packages rather than directly by end users.

Tables Accessed

IGS_PR_GEN_001 accesses a controlled set of IGS tables via APPS synonyms. The principal dependency is IGS_CA_INST_ALL, the calendar instance table, which supplies calendar and instance context essential to PRGP_GET_CAL_STREAM and related date-effective logic. Supporting calendar structures include IGS_CA_DA_INST, IGS_CA_INST_REL, IGS_CA_STAT, and IGS_CA_TYPE, which together provide calendar instance dates, relationships, statuses, and types. Program and organizational structures are read from IGS_OR_REL_PS_TYPE, IGS_OR_UNIT_REL, and IGS_PS_OWN. Supervised program curriculum data is drawn from IGS_PR_S_CRV_PRG_CAL, IGS_PR_S_OU_PRG_CAL, IGS_PR_S_PRG_CAL, and IGS_PR_S_PRG_CONF. These reads supply the configuration and calendar mappings the package requires to resolve effective dates, duration, and GPA values.

Usage Notes

The package is referenced by seven other packages, most notably IGS_AS_ADI_UPLD_PR_PKG and the sibling packages IGS_PR_GEN_002 through IGS_PR_GEN_006, as well as the view IGS_PR_SCA_PRG_RULE_APPL_V. This indicates it is a foundational component invoked during progression rule application, student progression upload processing, and rule evaluation routines. Because it exposes only retrieval and calculation functions and holds no documented entry points intended for direct form or concurrent program invocation, it is typically called from custom PL/SQL, from progression rule application logic, and from the application wrapper packages. Developers extending or debugging progression behavior in Oracle EBS 12.1.1 or 12.2.2 should treat IGS_PR_GEN_001 as an internal helper and reference the dependent packages for the higher-level processing context. Standard APPS schema grants apply, and no public synonym or standalone concurrent program is documented for the package.