Search Results igs_ps_usec_schedule




Overview
Explore in AI Chat

Overview

IGS_PS_USEC_SCHEDULE is an Oracle EBS PL/SQL package owned by the APPS schema and validated in both release 12.1.1 and 12.2.2. Its name reflects the Student System (IGS) product family and its focus on "usec," the internal term for a unit section occurrence, combined with scheduling logic. The package acts as the central scheduling engine for student unit section occurrences, orchestrating the generation of occurrence schedules, the assignment of facilities, rooms, buildings, locations, and instructors, and the maintenance of scheduling status throughout the lifecycle of an occurrence.

The dependency metadata confirms this architectural role. IGS_PS_USEC_SCHEDULE references SYS.STANDARD and is itself referenced by seven sibling packages, including IGS_PS_UNIT_LGCY_PKG, IGS_PS_UNIT_VER_PKG, IGS_PS_USEC_LIM_WLST_PKG, IGS_PS_USEC_OCUR_REF_PKG, IGS_PS_USO_FACILITY_PKG, IGS_PS_VALIDATE_GENERIC_PKG, and IGS_PS_VALIDATE_LGCY_PKG. This inbound dependency pattern demonstrates that the package supplies scheduling primitives consumed across validation, occurrence reference, facility, waitlist, and legacy unit processing routines, rather than serving a single narrow caller.

Key Procedures and Functions

The ETRM documentation records ten procedures and functions in this package, classified as OTHER (not a public API). Their documented names and purposes are:

  • PRGP_INIT_PRS_SCHED — Initializes the scheduling process for a set of unit section occurrences, establishing the working context before scheduling records are created or evaluated.
  • PRGP_INIT_SCHEDULING — Performs the primary initialization step for the scheduling run, preparing the data structures and reference rows required by subsequent processing.
  • PRGP_GET_SCHD_STATUS — Retrieves the current status of a scheduling run or occurrence, allowing callers to test completion, progress, or error conditions.
  • PRGP_SCHD_PURGE_DATA — Removes transient scheduling data generated during a run, supporting cleanup and repeat executions.
  • PRGP_UPD_USEC_DTLS — Updates occurrence-level scheduling detail, writing back dates, facility, or instructor assignments resolved by the engine.
  • PRGP_GET_SCHD_RECORDS — Fetches the scheduling records produced or consumed during processing, typically for evaluation or reporting.
  • PRGP_WRITE_REF_FILE — Writes a reference file, generally an output or interface artifact generated as part of the scheduling run.
  • ABORT_SCHED — Terminates an in-progress scheduling run, allowing graceful or forced cancellation.
  • GET_ENROLLMENT_MAX — Returns the maximum enrollment figure applicable to an occurrence, used when validating capacity against scheduled facilities.
  • UPDATE_OCCURRENCE_STATUS — Changes the status of an occurrence, reflecting the outcome of scheduling or validation activity.

All ten are internal helpers; no formal parameter lists are published in the ETRM metadata, and callers should not treat them as a supported public API.

Tables Accessed

The package reads and writes via APPS synonyms across several IGS schemas:

Usage Notes

IGS_PS_USEC_SCHEDULE is invoked indirectly. Student System forms and concurrent programs for unit section occurrence scheduling, facility allocation, and enrollment capacity validation call the sibling packages named in the dependency list, which in turn invoke this package's procedures. It is not exposed as a public API, and the ETRM classification of OTHER indicates that direct custom calls carry upgrade risk. Customers extending scheduling behaviour should prefer the documented public APIs of the calling packages and treat IGS_PS_USEC_SCHEDULE as an internal implementation detail subject to change between 12.1.1 and 12.2.2.