Search Results delete_unrelated_warnings




Overview

The APPS.IGS_EN_ADD_UNITS_API package is a public PL/SQL API within the Oracle E-Business Suite Student Systems (formerly Oracle Student System, now part of the Higher Education / Student Information domain, marketed as Oracle Student Information System or PeopleSoft Campus Solutions lineage objects in some deployments). It resides in the APPS schema and operates against the IGS (Oracle Student System) tables. Its core business function is to support the enrollment process by allowing selected academic units — typically course units, modules, or teaching units — to be added to a student's enrollment record for a given teaching period. In EBS 12.1.1 and 12.2.2, this package is classified as an API and forms part of the enrollment management layer that governs how students register for units, subject to eligibility, valid available units, and institutional rules.

Key Procedures and Functions

The ETRM documentation lists four documented procedures/functions. Their intended purposes are as follows:

  • ADD_SELECTED_UNITS — The principal routine responsible for adding one or more selected units to a student's enrollment. It validates the units against enrollment criteria before persisting the enrollment records.
  • GET_UNIT_SEC — A retrieval routine used to obtain the unit reference or section information required when adding units, supporting lookups and validation of the units to be enrolled.
  • DELETE_SS_WARNINGS — Removes "self-service" warnings associated with the enrollment activity, clearing prior warning messages generated during the add-units process.
  • DELETE_UNRELATED_WARNINGS — Clears warnings that are not relevant to the current add-units operation, ensuring that only pertinent, current warnings remain visible to the user.

No parameter lists are documented in the ETRM metadata, so exact signatures are not enumerated here.

Tables Accessed

The package references the following tables (via APPS synonyms), which support its validation and persistence logic:

  • IGS_EN_PLAN_UNITS — Defines the units available within a student's enrolled plan, central to identifying which units may be added.
  • IGS_EN_SU_ATTEMPT_ALL — Records student unit attempt information, the primary store of unit enrollment attempts.
  • IGS_EN_SPL_PERM — Holds special permission data governing non-standard enrollment permissions.
  • IGS_EN_METHOD_TYPE — Enrollment method type reference, used to classify how units are added.
  • IGS_EN_STD_WARNINGS — Stores warnings associated with student enrollment, referenced by the warning-deletion routines.
  • IGS_CA_INST_ALL — Calendar/instance data providing the teaching period context.
  • IGS_GE_S_GEN_CAL_CON — General calendar configuration controlling valid dates.
  • IGS_PE_PERSON_TYPES — Person type reference used during validation.
  • HZ_PARTIES — The party/person base table, linking enrollment to the student.
  • PLITBLM — Standard EBS utility table supporting messaging/logging.

These tables collectively enable eligibility checks, permission validation, and warning management during unit addition.

Usage Notes

IGS_EN_ADD_UNITS_API is typically invoked indirectly rather than called directly by end users. It is referenced by five other packages: IGS_EN_DROP_UNITS_API, IGS_EN_ELGBL_PERSON, IGS_EN_ELGBL_UNIT, IGS_EN_PLAN_UTILS, and IGS_SS_EN_WRAPPERS. The presence of IGS_SS_EN_WRAPPERS indicates it underlies self-service (iLearn/Student Self-Service) enrollment flows, while the eligibility packages confirm it participates in eligibility determination. It is generally called from student enrollment forms, self-service wrappers, and custom enrollment extensions. Because it operates within the APPS schema and is API-classified, developers should invoke it through its documented public interface rather than manipulating the underlying IGS tables directly, preserving validation and warning-handling behavior across both 12.1.1 and 12.2.2 releases.