Search Results update_plansheet_unitdetails

Overview

IGS_EN_PLAN_UTILS is a PL/SQL utility package owned by the APPS schema in Oracle E-Business Suite, classified under the Student Systems (IGS) product family for Higher Education. Its purpose is to encapsulate the low-level business logic that maintains student enrolment study plans and the associated Plan Sheet structures used by the Enrolment subsystem. The package operates between the student's study attempt records and the unit-level plan detail rows that define which units of study a student intends to undertake in a given teaching period.

Functionally, the package supports the full lifecycle of plan manipulation: adding units to a plan, removing units, updating plan sheet and unit detail attributes, maintaining term-level flags, and managing the "swap" operations that allow a student to exchange one enrolled unit for another. It also exposes validation helpers that determine whether a unit can be credited or replaced. Because the package is a utility layer rather than a self-contained API, it is invoked indirectly by the enrolment forms and by higher-level processing routines rather than being called directly by end users.

Key Procedures and Functions

The ETRM metadata documents sixteen program units within the package:

• ADD_UNITS_TO_PLAN — Inserts one or more units of study into a student's existing study plan, creating the corresponding plan unit detail rows.
• UPDATE_SPA_TERMS_PLAN_SHT_FLAG — Maintains the plan sheet indicator on the Student Program Attempt terms record, keeping the term-level flag consistent with plan sheet activity.
• UPDATE_PLANSHEET_UNITDETAILS — Applies changes to the unit-level detail attributes of a plan sheet entry.
• DELETE_PLANSHEET_UNIT — Removes a single unit from a plan sheet.
• DELETE_SUA_FROM_PLAN — Removes a student unit attempt association from the plan.
• IS_CORE_REPLACED — Returns whether a core unit has been replaced within the plan.
• SWAP_DELETE, SWAP_SUBMIT, SWAP_DROP, SWAP_UPDATE — Manage the unit swap workflow, covering submission, update, drop, and deletion of swap requests held in the swap cart.
• RELEASE_SWAP_CART — Releases the swap cart, finalising or clearing pending swap requests.
• IS_CREDIT_UPDATABLE — Determines whether credit values on the plan may be updated.
• PLAN_UPDATE — Performs general updates against the student's plan.
• DROP_SUBMIT — Submits a drop request for a planned unit.
• GET_SUA_FIN_MARK and GET_SUA_FIN_GRADE — Retrieve the final mark and final grade for a student unit attempt.

Tables Accessed

The package reads and writes several core Enrolment and Scheduling tables through APPS synonyms:

• IGS_EN_SU_ATTEMPT_ALL — The student unit attempt table, the central transactional record for unit enrolment and the source for final marks and grades.
• IGS_EN_PLAN_UNITS — Stores the individual units that make up a student's plan sheet.
• IGS_EN_SPA_TERMS — Term-level records for the Student Program Attempt, updated by the plan sheet flag routine.
• IGS_EN_SPL_PERM, IGS_EN_STD_WARNINGS, IGS_EN_CAL_CONF, IGS_EN_METHOD_TYPE, IGS_EN_NSTD_USEC_DL — Supporting configuration and warning tables.
• IGS_CA_INST_ALL, IGS_PS_UNIT_OFR_OPT_ALL, IGS_PS_RSV_EXT, IGS_PE_PERSON_TYPES, IGS_PE_USR_ARG_ALL — Calendar instance, unit offering option, reservation, person type, and user parameter tables used for validation and defaults.

Usage Notes

IGS_EN_PLAN_UTILS is called internally by the Student Enrolment forms and by the higher-level enrolment processing packages. It is referenced by the view IGS_EN_SUA_YEAR_V and by one other package, indicating that reporting and dependent logic rely on its outputs. Customisations should call the individual procedures rather than manipulating the underlying tables directly, since the package enforces validation and keeps the swap cart, plan sheet, and student unit attempt records synchronised. Because it is a utility package with no documented public API contract, implementers should treat it as internal and confine extensions to wrapper code.