Search Results igs_en_gen_012




Overview
Explore in AI Chat

Overview

IGS_EN_GEN_012 is a PL/SQL package in the APPS schema belonging to the Oracle Student System (formerly Oracle Student Administration) module of Oracle E-Business Suite. It is classified as a server-side API package of type OTHER and is registered as VALID in the ETRM repository for Release 12.1.1 and 12.2.2. The package provides the procedural logic behind student enrollment record maintenance, specifically the bulk update of expiry dates, status codes, and related attributes on student program and course attempt records. Its naming convention places it among the IGS_EN_GEN_0xx series of generated enrollment packages, which are typically invoked by the higher-level enrollment APIs and concurrent processing rather than directly by end users. The package depends on the STANDARD package provided by SYS, and it is itself referenced by IGS_EN_GEN_011, IGS_EN_PLAN_UTILS, IGS_EN_SU_ATTEMPT_PKG, IGS_EN_TRANSFER_APIS, IGS_PE_PERS_ENCUMB_PKG, and IGS_PR_GEN_004, indicating that it sits low in the enrollment call stack and is called by several public-facing APIs.

Key Procedures and Functions

The package exposes eight documented procedures, all prefixed ENRP_UPD_, reflecting a consistent role of updating enrollment registration period attributes:

  • ENRP_UPD_EXPIRY_DTS — Updates expiry dates on the relevant student enrollment or attempt period records, typically used when a registration period is extended or truncated.
  • ENRP_UPD_SCA_COO — Updates system calculated attempt (SCA) data associated with a change of outcome or completion-override scenario.
  • ENRP_UPD_SCA_DISCONT — Handles SCA updates when a student discontinues a program or course attempt.
  • ENRP_UPD_SCA_LAPSE — Handles SCA updates when an attempt lapses through non-completion or expiry.
  • ENRP_UPD_SCA_STATUS — Recalculates and stores the SCA status derived from the underlying attempt record.
  • ENRP_UPD_SCA_STATUSB — A body-level companion routine to ENRP_UPD_SCA_STATUS, providing the internal implementation used by the public wrapper.
  • ENRP_UPD_SCA_URULE — Applies the applicable unit rule when deriving system calculated attempt values.
  • ENRP_UPD_SCHO_TFN — Updates school transfer-related attributes on the student program attempt record.

Because the ETRM extract does not publish parameter lists, signatures should be inspected in the database before direct invocation.

Tables Accessed

The package reads and writes several core Student System tables through APPS synonyms. Student program attempt data is maintained in IGS_EN_STDNT_PS_ATT_ALL, IGS_EN_STDNTPSHECSOP, and IGS_EN_STDNT_PS_INTM (intermission records), while course attempt detail is held in IGS_AS_SC_ATMPT_ENR. Calendar and configuration lookups include IGS_CA_INST_ALL, IGS_EN_CAL_CONF, IGS_EN_INTM_TYPES, and IGS_EN_SPI_RCONDS. Status derivation uses IGS_OR_STATUS, and exclusion rules are resolved from IGS_PE_COURSE_EXCL, IGS_PE_CRS_GRP_EXCL, and IGS_PE_FUND_EXCL. Party identity data is read from HZ_PARTIES, and audit or processing messages are written to IGS_GE_S_LOG. Student program availability data is drawn from IGS_HE_ST_SPA_ALL.

Usage Notes

IGS_EN_GEN_012 is an internal package and is not normally called directly from a form or concurrent program. It is invoked by the enrollment APIs that reference it — IGS_EN_SU_ATTEMPT_PKG, IGS_EN_PLAN_UTILS, IGS_EN_TRANSFER_APIS, and the IGS_EN_GEN_011 package — during student program and course attempt amendment, discontinuation, lapse processing, and school transfer. Customizations should call the documented public APIs higher in the stack rather than this package, since its procedures assume the calling context has already validated the enrollment record. Any direct use must be regression-tested against both 12.1.1 and 12.2.2, as the package is shipped as Oracle proprietary code and is subject to change between patch levels.