Search Results igs_en_gen_010




Overview
Explore in AI Chat

Overview

IGS_EN_GEN_010 is a valid PL/SQL package owned by the APPS schema within the Oracle E-Business Suite student system (Oracle Student System / IGS product family). It belongs to the enrollment (IGS_EN) module and serves as a low-level generation and processing utility for student unit attempt (SUA) data. Its principal responsibility is to insert, transfer, and validate student unit attempt records, including historical, transfer-credit, discontinued, and place-related variants of that data.

The package is classified as API type OTHER, indicating it is not a formally published public API but rather an internal engine package consumed by other enrollment processes. The ETRM metadata records eighteen documented procedures and functions, and the package is composed of both a specification and a body, with a documented dependency on the IGS_CA_INST_ALL, IGS_EN_METHOD_TYPE, IGS_EN_STDNT_PS_ATT_ALL, and IGS_EN_SU_ATTEMPT(_ALL) objects.

Key Procedures and Functions

The documented entry points are dominated by the ENRP_INS_* naming convention, where "ENRP" denotes an enrollment process routine and "INS" indicates an insert operation. These procedures create student unit attempt rows and their associated history or transfer records:

Validation and lookup functions include ENRP_VALD_INST_SUA, which validates an institution's SUA data, ENRF_SUP_SUA_EXISTS, which reports whether supporting SUA data exists, ENRF_UNIT_FROM_PAST, which retrieves unit information from prior terms, and UNIT_EFFECT_OR_FUTURE_TERM, which determines whether a unit is effective in or applies to a future term. ADV_STAND_TRANS supports advanced standing transfer processing.

Tables Accessed

Reachable through APPS synonyms, the package reads and writes core enrollment and academic structures. IGS_EN_SU_ATTEMPT_ALL, IGS_EN_STDNT_PS_ATT_ALL, and IGS_EN_SU_ATTEMPT hold the primary student unit attempt and attempt-all records. IGS_EN_METHOD_TYPE provides the enrollment method reference data, and IGS_CA_INST_ALL supplies calendar instance context. Supporting academic tables include IGS_AS_SU_SETATMPT (and its sequence-number sibling IGS_AS_SU_SETATMPT_SEQ_NUM_S), IGS_AS_SU_ATMPT_ITM, IGS_AS_SC_ATMPT_ENR, IGS_AS_GRD_SCH_GRADE, IGS_AS_SUA_AI_GROUP, and IGS_AS_SUA_REF_CDS. Admissions and party data are touched via IGS_AD_UNIT_OU_STAT, IGS_AD_OU_STAT, IGS_AD_OFR_RESP_STAT, and HZ_PARTIES.

Usage Notes

IGS_EN_GEN_010 is invoked indirectly by higher-level enrollment packages rather than called from forms or concurrent programs directly. The ETRM dependency list confirms it is referenced by IGS_EN_GEN_008, IGS_EN_GEN_009, IGS_EN_GEN_011, IGS_EN_FUTURE_DT_TRANS, IGS_EN_SU_ATTEMPT_PKG, IGS_EN_SUA_LGCY_PUB, IGS_EN_TRANSFER_APIS, IGS_AS_SU_SETATMPT_PKG, and IGS_AD_UPD_INITIALISE. Customizations should therefore treat it as an internal utility and route new development through the published packages and transfer APIs that consume it.