Search Results igs_pr_gen_004




Overview
Explore in AI Chat

Overview

IGS_PR_GEN_004 is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Student System (IGS) product family. Based on its naming convention and dependent objects, it belongs to the Student Progress / Academic Standing generation layer ("PR" denotes Progress, "GEN" denotes generation), and its role is to generate and maintain progression, outcome application, and standing records for students. The package operates as a supporting generation engine rather than an end-user interface; it is invoked by higher-level validation and processing packages to compute and persist derived student status data.

The package is documented as VALID in ETRM and exposes six procedures. It references only SYS.STANDARD as an external dependency at the package level, confirming that its logic is self-contained and driven by the APPS synonym layer. It is referenced by four other packages: IGS_AS_SU_STMPTOUT_PKG, IGS_PR_VAL_SPC, IGS_PR_VAL_SPU, and IGS_PR_VAL_SPUS. These callers indicate the package is a shared utility used during academic standing validation and student attempt processing.

Key Procedures and Functions

  • IGS_PR_INS_SUAO_TODO — Inserts "to-do" (pending action) records associated with a student's academic outcome or standing process. It drives the creation of outstanding work items that require student or administrative follow-up.
  • IGS_PR_UPD_OUT_APPLY — Updates the application of an outcome to a student record, recording that a progression or standing outcome has been applied.
  • IGS_PR_UPD_RULE_APPLY — Updates the application of progression rules, tracking which rule set was evaluated and applied to a student's standing.
  • IGS_PR_UPD_SCA_APPLY — Updates the application of a special consideration or standing adjustment ("SCA") against a student's progression record.
  • IGS_PR_UPD_SPO_APLY_DT — Updates the applied date on a Student Progression Outcome (SPO) record, stamping the effective date of an outcome.
  • IGS_PR_UPD_SPO_MAINT — Performs maintenance updates on Student Progression Outcome records, keeping the outcome row consistent with the latest generation results.

Tables Accessed

The package reads and writes across several IGS and HZ tables. Student and party identity data is drawn from HZ_PARTIES. Academic attempt and standing data is sourced from IGS_AS_SC_ATMPT_ENR, IGS_AS_SU_SETATMPT, and IGS_EN_STDNT_PS_ATT_ALL, which provide the enrolment and attempt context against which outcomes are applied. Calendar and instance context is provided by IGS_CA_DA_INST, IGS_CA_INST_ALL, IGS_CA_INST_REL, IGS_CA_STAT, and IGS_CA_TYPE, allowing outcomes to be tied to a teaching period and its status. Financial and default handling is referenced through IGS_FI_ENC_DFLT_EFT. Special award handling uses IGS_GR_SPECIAL_AWARD_ALL. Logging is written to IGS_GE_S_LOG and IGS_GE_S_LOG_ENTRY, and pending student actions are persisted in IGS_PE_STD_TODO and IGS_PE_STD_TODO_REF.

Usage Notes

IGS_PR_GEN_004 is not intended for direct end-user invocation. It is called from the progression validation packages (IGS_PR_VAL_SPC, IGS_PR_VAL_SPU, IGS_PR_VAL_SPUS) and from the attempt processing package IGS_AS_SU_STMPTOUT_PKG. These callers are typically triggered from Student System forms, concurrent programs, or batch progression runs. Because it writes to logging and to-do tables, it should be invoked within a defined transaction, and any custom code reusing it must commit or roll back the surrounding transaction appropriately. Under EBS 12.1.1 and 12.2.2 the synonym resolution is handled by the APPS schema, so callers should reference the package as APPS.IGS_PR_GEN_004.