Search Results igs_ps_gen_008




Overview
Explore in AI Chat

Overview

IGS_PS_GEN_008 is an internal PL/SQL generation package in the APPS schema of Oracle E-Business Suite, belonging to the Student Systems (IGS) product family that underpins Oracle Student System. The package is classified in the ETRM repository as an "OTHER" API, meaning it is not a formally published public API but rather a generated or implementation-support package invoked internally by higher-level student processing logic. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2, and its owner is APPS, consistent with the standard deployment model for IGS packages.

Functionally, IGS_PS_GEN_008 supports the creation and validation of student unit attempt and unit set data — the core records that describe what a student is enrolled in or assessed against during an academic period. The package bridges the assessment (IGS_AS) and enrolment (IGS_EN) subsystems, providing routines used to instantiate unit set assignments and their associated unit of proficiency (UOP) and unit occurrence (UOO) records. It is one member of a numbered generation-package family, and it is itself reported as dependent on, and referenced by, IGS_PS_GEN_006, which indicates a chain of generated calls between related packages.

Key Procedures and Functions

Three documented procedures are exposed by this package:

  • CRSP_INS_UNIT_SET — Creates (inserts) a unit set instance, establishing the enrolment or assessment unit set record used by downstream student progression and completion logic.
  • CRSP_INS_UNIT_VER — Creates the unit set version or versioned unit set association, ensuring that the unit set record is tied to the correct administrative version of the curriculum.
  • CRSP_INS_UOP_UOO — Creates the unit of proficiency and unit occurrence linkages, associating the student's unit attempt with the underlying offering and the proficiency/outcome records tracked by the assessment subsystem.

No parameter lists are documented in the ETRM metadata; the procedures should be treated as internal entry points whose signatures are reserved to APPS-internal callers. Because the package is classified as OTHER rather than a supported public API, direct custom invocation carries upgrade risk.

Tables Accessed

The package reads and writes through APPS synonyms across several IGS modules. In the assessment area, it touches IGS_AS_APPR_GRD_SCH, IGS_AS_ASSESSMNT_TYP, IGS_AS_GRD_SCHEMA, IGS_AS_UNITASS_ITEM_ALL, IGS_AS_UNITASS_ITEM_SEQ_NUM_S, and IGS_AS_UNIT_AI_GRP — these carry the assessment schema, assessment types, grade schema, unit assessment items, and item grouping used to drive grading. In the calendar area it references IGS_CA_INST_ALL, IGS_CA_INST_REL, and IGS_CA_TYPE, which define calendar instances and their relationships. In the enrolment area it uses IGS_EN_UNITSETPSTYPE, IGS_EN_UNIT_SET_NOTE, and IGS_EN_UNIT_SET_RULE, which describe unit set types, notes, and the rules governing unit set composition. Notes are generalised via IGS_GE_NOTE and its sequence, IGS_GE_NOTE_RF_NUM_S. FND_NEW_MESSAGES is referenced for message handling, and the SYS.STANDARD package underpins PL/SQL data types.

Usage Notes

IGS_PS_GEN_008 is not designed for direct end-user invocation. It is typically called from within the IGS Student System processing flows — notably enrolment, unit set assignment, and assessment generation routines — and from the companion package IGS_PS_GEN_006, which references it. It may be invoked through concurrent programs, Oracle Forms within the Student System responsibility, or by other generated IGS packages during batch processing of unit set and unit attempt data. Customisations should not call this package directly; instead, supported public IGS APIs should be used, with this package treated as an implementation detail subject to change between 12.1.1 and 12.2.2 patches.