Results for “get_effective_census_date”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGS_EN_GEN_015 is a VALID package body in the APPS schema within the Oracle E-Business Suite Student Systems (IGS) product family, specifically belonging to the Enrollment (IGS_EN) module. It is classified as an "OTHER" API type in the ETRM repository, meaning it is not a public open interface but an internal utility package referenced by other enrollment packages. Its primary business purpose is to support student enrollment processing — validating enrollment eligibility, resolving academic calendar and term dates, evaluating unit load, checking special and audit permissions, and determining seat availability against reserved category configurations. The package operates on the 12.1.1 and 12.2.2 releases and is dependent on a large set of institutional, calendar, and program-of-study tables.

Key Procedures and Functions

The package exposes sixteen documented procedures and functions:

• GET_EFFECTIVE_CENSUS_DATE — Returns the effective census date for enrollment processing.
• VALIDATION_STEP_IS_OVERRIDDEN — Determines whether a given validation step has been overridden by an eligibility override record.
• SEATS_IN_UNRESERVED_CATEGORY — Calculates available seats within an unreserved category.
• GET_USEC_STATUS — Retrieves the status of a unit section occurrence.
• GET_ACADEMIC_CAL — Returns the academic calendar for a given context.
• ENRP_VAL_PS_STAGE — Validates the program-of-study stage for enrollment.
• ENRP_GET_APPR_CR_PT — Retrieves approved credit points for a student.
• ENRP_GET_EFF_LOAD_CI — Returns the effective load for a calendar instance.
• ENRF_DRV_CMPL_DT — Derives the completion date for enrollment records.
• CHECK_SPL_PERM_EXISTS — Checks whether a special permission exists.
• CHECK_AUDIT_PERM_EXISTS — Checks whether an audit permission exists.
• EVAL_CORE_UNIT_DROP — Evaluates whether a core unit may be dropped.
• GET_CURR_ACAD_TERM_CAL — Returns the current academic term calendar.
• GET_CURR_TERM_FOR_SCHEDULE — Returns the current term for scheduling purposes.
• GET_ACADEMIC_CAL_POO_CHG — Returns the academic calendar when the program of study changes.
• ENRP_GET_EFF_LOAD_CI_POO_CHG — Returns effective load for a calendar instance upon program-of-study change.

Tables Accessed

The package references the FND_NEW_MESSAGES table for message handling and reads enrollment and calendar tables including IGS_AS_SC_ATTEMPT_H_ALL (attempt history), IGS_CA_DA_INST, IGS_CA_INST_ALL, IGS_CA_INST_REL, IGS_CA_STAT and IGS_CA_TYPE (calendar instance and status), IGS_EN_CAL_CONF (calendar configuration), IGS_EN_CAT_PRC_DTL (category pricing details), IGS_EN_ELGB_OVR_STEP and IGS_EN_ELGB_OVR_UOO (eligibility override steps and unit occurrences), IGS_EN_INST_WL_STPS (instance waitlist steps), IGS_EN_METHOD_TYPE (enrollment method types), IGS_EN_SPL_PERM (special permissions), and IGS_EN_STDNT_PS_ATT_ALL (student program-of-study attempts). These support calendar resolution, eligibility validation, and seat/permission checks.

Usage Notes

IGS_EN_GEN_015 is not directly referenced by any database object in the ETRM repository, but it is referenced by 39 other packages and itself depends on many sibling packages including IGS_CA_GEN_001, IGS_EN_GEN_001, IGS_EN_GEN_002, IGS_EN_GEN_003, IGS_EN_GEN_006, IGS_EN_GEN_008, IGS_EN_GEN_017, IGS_EN_VAL_SUA, IGS_AU_GEN_003 and IGS_PR_GEN_005. It is therefore typically invoked indirectly through higher-level enrollment processing packages and forms rather than called directly. Customizations should call the documented procedures only after checking the 12.1.1/12.2.2 patch level, as internal behavior may change across releases.