Search Results igs_en_prc_load




Overview
Explore in AI Chat

Overview

IGS_EN_PRC_LOAD is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, part of the Student Systems (IGS) product family that supports the Higher Education and institutional enrollment functionality delivered with EBS 12.1.1 and 12.2.2. The package is classified as an "OTHER" API rather than a formal public API, meaning it is primarily an internal processing engine consumed by other IGS packages and by the enrollment forms and concurrent programs that depend on it. Its central business purpose is the calculation of student load, attendance, and derived enrollment metrics. The ENRP_ prefix used by nearly all of its documented program units identifies the package as belonging to the enrollment processing (EN PRC) layer, and the LOAD suffix confirms its focus on computing study load values such as effective full-time student units (EFTSU) and credit points. The package is marked VALID in the data dictionary and is referenced by 35 other database objects while itself referencing none of the IGS objects in reverse, indicating it sits at the base of a dependency chain rather than calling upward into application APIs. It exposes 22 documented procedures and functions and is not directly referenced by any external database object, reinforcing its role as a reusable computational library.

Key Procedures and Functions

The documented program units fall into several functional groups. The EFTSU calculation family includes ENRP_CLC_SUA_EFTSU, ENRP_CLC_EFTSU_TOTAL, ENRP_CLC_SUA_WEFTSU, ENRP_CLC_EFTSU_TRUNC, and ENRP_GET_PRG_EFTSU_CP, which compute effective full-time student unit values at the student unit attempt, program, and aggregate levels, with truncation handling for rounding rules. The load aggregation family includes ENRP_CLC_LOAD_TOTAL, ENRP_CLC_SUA_LOAD, ENRP_GET_ANN_LOAD, ENRP_GET_PRG_LOAD_CP, ENRP_GET_LOAD_ATT, ENRP_GET_LOAD_INCUR, and ENRP_GET_LOAD_APPLY, which derive annual, program, attendance-related, incurred, and applied load figures. Attendance and credit-point routines include ENRP_GET_INST_LATT, ENRP_GET_INST_LATT_FTE, ENRP_GET_INST_ATTENDANCE, ENRP_GET_INST_CP, ENRP_CLC_CP_UPTO_TP_START_DT, and ENRP_GET_LATEST_LOAD_FOR_ACAD_CAL, which obtain the latest load snapshot for an academic calendar and credit points accrued up to a teaching period start date. Progress and attribute routines include ENRP_CLC_KEY_PROG and ENRP_GET_PRG_ATT_TYPE, supporting key program identification and attendance type resolution.

Tables Accessed

The package reads and writes a broad range of IGS enrollment and calendar tables through APPS synonyms. Enrollment and attempt data is sourced from IGS_EN_STDNT_PS_ATT, IGS_EN_STDNT_PS_ATT_ALL, and IGS_EN_SU_ATTEMPT. Program and unit definitions are drawn from IGS_PS_COURSE, IGS_PS_UNIT_VER, IGS_PS_VER, IGS_PS_VER_ALL, IGS_PS_UNIT_INT_LVL, IGS_PS_UNIT_DSCP, IGS_PS_DSCP, IGS_PS_UNIT_OFR_OPT, IGS_PS_USEC_CPS, and IGS_PS_TCH_RESP with its override table IGS_PS_TCH_RESP_OVRD. Calendar and institution context comes from IGS_CA_INST, IGS_CA_INST_REL, IGS_CA_DA_INST and its view, IGS_CA_TYPE, IGS_CA_STAT, IGS_EN_CAL_CONF, IGS_GE_S_GEN_CAL_CON, and IGS_OR_INSTITUTION. Load storage and analysis use IGS_PS_ANL_LOAD and IGS_PS_ANL_LOAD_U_LN. Waiting-list and status data is held in IGS_EN_INST_WL_STPS and IGS_EN_OR_UNIT_WLST. Person and party identifiers are resolved through HZ_PARTIES, IGS_PE_PERSON, and IGS_ST_DFT_LOAD_APPO. Several IGS_CA_* and IGS_CA_LOAD_TO_TEACH_V, IGS_CA_TEACH_TO_LOAD_V views are referenced for calendar-to-teaching-period mapping.

Usage Notes

IGS_EN_PRC_LOAD is invoked indirectly rather than through direct form or concurrent program calls. It underpins the enrollment load calculation routines executed when a student's unit attempt record is created, amended, or re-assessed, and when load snapshots are recalculated for an academic period. The dependency metadata shows it calls supporting packages such as IGS_EN_GEN_001, IGS_EN_GEN_002, IGS_EN_GEN_008, IGS_CA_GEN_001, IGS_RE_GEN_001, IGS_AD_ADM_UT_STT_LD, IGS_PS_VAL_UV, and IGS_SS_ENR_DETAILS, plus APP_EXCEPTION, FND_MESSAGE, and FND_PROFILE for error handling and profile option reads. Because ENRP_ procedures are not published as a formal API, customizations should call higher-level enrollment APIs wherever possible. When direct invocation is required, callers must first establish the correct APPS session context and ensure calendar and institution profile values are initialized, as the load logic depends on those settings. The absence of reverse dependencies confirms the package is safe to modify only when all 35 dependent packages are regression-tested.