Search Results rollover_fac_task

Overview

The APPS.IGS_PS_RLOVR_FAC_TSK package is a PL/SQL library within the Oracle E-Business Suite Student System (Higher Education) that supports the rollover and validation of faculty teaching task assignments across academic periods. Its primary business purpose is to detect and resolve time conflicts when faculty assignment tasks from a prior term or offering are rolled over into a new one, ensuring that instructors are not scheduled into overlapping teaching slots and that inherited assignments remain consistent with the target institution and calendar configuration.

The package is classified under the ETRM metadata as an "OTHER" API classification, meaning it is not a formally published public API but is an internal supporting package invoked by other Student System components. It carries a VALID status in the APPS schema and exhibits a dependency on the SYS.STANDARD package, reflecting standard PL/SQL compilation dependencies. It is referenced by two other packages, IGS_EN_ELGBL_UNIT and IGS_PS_VALIDATE_LGCY_PKG, confirming its role as a shared utility within the faculty assignment and legacy validation processing chain.

Key Procedures and Functions

The documented metadata records four procedures or functions within the package:

• ROLLOVER_FAC_TASK — The principal entry point, responsible for performing the rollover of faculty assignment tasks. It copies or regenerates teaching task records from a source offering into a target offering, applying the relevant calendar and institutional context.
• CRSP_CHK_INST_TIME_CONFT — A conflict-checking routine that examines instructor time allocations against existing assignments to detect scheduling clashes for the target institution.
• CRSP_INSTRCT_TIME_CONFLCT — Evaluates instructor time conflicts, identifying overlaps in teaching time slots associated with the same instructor.
• CRSP_PRC_INST_TIME_CFT — Processes the instructor time conflict results, likely consolidating or resolving detected conflicts and staging them for further handling or reporting.

These procedures collectively form a conflict-detection and resolution cycle that wraps the rollover operation, ensuring data integrity before the new assignment records are committed.

Tables Accessed

The package reads and writes the following documented tables (via APPS synonyms):

• IGS_PS_FAC_ASG_TASK — The core faculty assignment task table, the primary target of the rollover operation.
• IGS_PS_FAC_WL — Faculty workload or waiting-list records consulted during assignment processing.
• IGS_PS_FAC_TCFT_TMP — A temporary staging table holding instructor time conflict findings prior to processing.
• IGS_PS_USO_CLAS_MEET — Class meeting times, used to determine scheduled teaching slots for conflict detection.
• IGS_PS_USO_INSTRCTRS — Instructor assignments for a unit offering, the source data for rollover.
• IGS_PS_USEC_X_GRPMEM — Cross-referenced group membership spanning use and class group structures.
• IGS_CA_INST_ALL — The calendar instance table, supplying the academic period and teaching calendar context.
• IGS_CA_TYPE — Calendar type definitions, used to classify the active calendar instance.
• HZ_PARTIES — The Trading Community Architecture party table, resolving instructor identities.
• PLITBLM — A standard Oracle date-range overlap utility package used to evaluate time intersections.

Usage Notes

This package is not intended as a standalone concurrent program or form-level API. It is invoked indirectly by higher-level Student System processes, most notably the legacy validation package IGS_PS_VALIDATE_LGCY_PKG and the eligible unit package IGS_EN_ELGBL_UNIT. Such calls typically occur during faculty task rollover batch operations or validation routines triggered when offerings are copied forward between teaching periods.

Because it is an internal, non-published package, customizations should avoid direct invocation where possible. Organizations extending faculty assignment behavior should call the supported parent packages instead, or replicate the rollover-conflict logic carefully, respecting the dependency on PLITBLM and the calendar instance tables. The package is expected to be present and valid in both Oracle EBS 12.1.1 and 12.2.2 Student System installations.