Search Results change_unit_section_status

Overview

IGS_PS_GEN_001 is a general-purpose PL/SQL package in the APPS schema belonging to the Oracle Student System (formerly Oracle iLearning / Student Records) product family. Its internal name prefix IGS_PS identifies it as part of the Student Programs/Progression area, while the GEN suffix indicates a shared "generic" utility package rather than a single business entity. In Oracle EBS 12.1.1 and 12.2.2 the package is classified as VALID and its API classification is OTHER, meaning it is not exposed as a formally published public API but is instead consumed internally by other Student System packages. The package aggregates cross-cutting logic — course version creation, unit/section handling, unit section status transitions, faculty workload validation, and waitlist exceedance checks — that would otherwise be duplicated across the Student Programs and Timetabling modules. Because a significant block of its dependencies are wired through IGS_CA_INST_PKG (calendar instances) and IGS_PS_CREATE_GENERIC_PKG, it effectively serves as a low-level helper layer beneath the higher-level Student Program processes. Its presence on many call paths means changes here propagate widely, so it should be treated as infrastructure rather than as an end-user-facing API.

Key Procedures and Functions

The ETRM documentation records five callable units:

• CRSP_INS_CRS_VER — Inserts a course version record, most likely against the course version tables that back the Student Programs catalog. It handles the creation step for a new curriculum version.
• CRSP_INS_UNIT_SECTION — Inserts a unit section, i.e. creates a teaching offering (unit plus section/tutorial grouping) that students can subsequently be enrolled into.
• CHANGE_UNIT_SECTION_STATUS — Transitions a unit section between statuses (for example open, closed, cancelled), driving the state machine that governs whether a section is available for enrolment.
• FAC_EXCEED_EXP_WL — Faculty, Exceed Expectation, Wait List — validates or flags whether a faculty member has exceeded an expected waitlist capacity, supporting workload control.
• TEACH_FAC_WL — Teaching Faculty Wait List — manages the assignment of teaching faculty against waitlisted offerings.

No formal parameter lists are documented in the ETRM extract; callers should retrieve signatures from the package specification (APPS.IGS_PS_GEN_001) before invoking.

Tables Accessed

The package reads and writes a broad set of APPS synonyms. Enrolment and academic structure tables include IGS_CA_INST_ALL, IGS_CA_INST_REL, IGS_CA_STAT, IGS_CA_TYPE, IGS_AS_US_AI_GROUP, IGS_AS_GRD_SCHEMA, IGS_PS_ANL_LOAD and IGS_PS_ANL_LOAD_U_LN, which underpin calendar instances, grading schemes, and load calculations. Party and person data is reached via HZ_PARTIES and IGS_PE_ALTERNATV_EXT, supporting the faculty/waitlist logic. Notes and status management use IGS_GE_NOTE, IGS_GE_NOTE_RF_NUM_S and IGS_OR_STATUS. Fee and term routing uses IGS_FI_FND_SRC_RSTN and IGS_EN_PSV_TERM_IT. In aggregate these tables confirm the package spans course versioning, section status, waitlists, and note/status handling.

Usage Notes

IGS_PS_GEN_001 is referenced by six other packages — IGS_CA_INST_PKG, IGS_PS_CREATE_GENERIC_PKG, IGS_PS_EMP_CATS_WL_PKG, IGS_PS_GEN_008, IGS_PS_VALIDATE_LGCY_PKG and IGS_PS_WF_EVENT_PKG — so it is normally invoked indirectly through Student System forms, concurrent programs, and workflow event handlers rather than directly by end users. Customisations should call it only through its documented wrappers, and regressions here can ripple into calendar instance generation, generic course creation, employee category waitlists, legacy validation and workflow events. Before patching, verify status remains VALID in both 12.1.1 and 12.2.2.