Search Results enrp_clear_sua_dupl

Overview

IGS_EN_VAL_SUA is a PL/SQL validation package in the APPS schema of Oracle E-Business Suite, belonging to the Student Systems / Student Records (IGS) product family. The suffix "SUA" denotes "Student Unit Attempt," and the package serves as the central validation engine governing the creation, confirmation, update, and deletion of student unit attempt records stored in IGS_EN_SU_ATTEMPT_ALL. In the Oracle Student System data model, a student unit attempt represents a student's enrolment in a specific unit offering within a teaching period, and it is one of the most heavily validated entities in the enrolment subsystem.

The package enforces institutional enrolment rules at the database tier, ensuring that every insert or modification to a unit attempt satisfies academic, administrative, and structural constraints before it is committed. Its documented API classification is OTHER, indicating it is an internal validation utility rather than a public-facing extension API, though its procedures are invoked extensively throughout the IGS enrolment codebase.

Key Procedures and Functions

The package exposes 31 documented procedures, whose names reveal a clear division of responsibilities:

• Confirmation validation — RESP_VAL_SUA_CNFRM and RESP_VAL_SUA_ALL validate a unit attempt prior to confirmation, with the latter providing a comprehensive validation pass across all applicable rules.
• Exclusion and clearance — ENRP_VAL_SUA_EXCLD checks exclusion conditions, while ENRP_CLEAR_SUA_EXIST, ENRP_CLEAR_SUA_DUPL, and ENRP_CLEAR_SUA_DISC clear prior existence, duplicate, and discontinued status flags respectively.
• Attribute and reason validation — ENRP_VAL_SUA_CP_RSN, ENRP_VAL_SUA_CI, ENRP_VAL_SUA_ALT_TTL, and ENRP_VAL_SUA_ADVSTND validate change-of-reason codes, campus/instance data, alternate title assignments, and advanced standing eligibility.
• Status and lifecycle validation — ENRP_VAL_SUA_PRE, ENRP_VAL_SUA_INTRMT, ENRP_VAL_SUA_DISCONT, ENRP_VAL_DISCONT_AUS, and ENRP_VAL_SUA_ENR_DT validate prerequisite satisfaction, interruption handling, discontinuation, associated unit status, and enrolment dates.
• Retrieval helpers — ENRP_GET_SUA_GS and ENRP_GET_SUA_AUSG retrieve grade scheme and associated unit status/grade information used by the validation rules.
• Persistence operations — ENRP_VAL_SUA_INSERT, ENRP_VAL_SUA_UPDATE, and ENRP_VAL_SUA_DELETE combine validation with the corresponding DML against the unit attempt table.

Tables Accessed

The package reads and writes IGS_EN_SU_ATTEMPT_ALL as its primary table. Supporting validation draws on a broad set of reference and transactional tables, including IGS_AD_ADM_UT_STA_GD and IGS_AV_STND_UNIT_ALL for admission and standing unit data, IGS_AS_GRD_SCHEMA and IGS_AS_GRD_SCH_GRADE for grade scheme definitions, IGS_AS_SC_ATMPT_ENR for assessed attempt enrolment records, IGS_AS_UNIT_MODE for unit mode of delivery, IGS_CA_INST_ALL, IGS_CA_INST_REL, IGS_CA_STAT, and IGS_CA_TYPE for calendar instance and status information, IGS_EN_INTM_TYPES and IGS_EN_METHOD_TYPE for intermediate and enrolment method types, and HZ_PARTIES for party (person) identity data. FND_NEW_MESSAGES is referenced for the standard Oracle message dictionary, allowing validation failures to be surfaced as translatable, user-facing errors.

Usage Notes

IGS_EN_VAL_SUA is referenced by 18 other packages, including IGS_EN_ADD_UNITS_API, IGS_EN_SU_ATTEMPT_PKG, IGS_EN_SUA_LGCY_PUB, IGS_EN_ELGBL_UNIT, IGS_EN_ELGB_OVR_UOO_PKG, IGS_EN_ENROLL_WLST, IGS_EN_TRANSFER_APIS, IGS_EN_VAL_BULKRULE, IGS_EN_VAL_SCA, and several IGS_EN_GEN_xxx and IGS_AV_GEN_001 generic processing packages. This breadth of dependency confirms that the package is invoked indirectly whenever a student's unit attempt is created, amended, discontinued, or transferred through the standard enrolment forms, self-service pages, bulk processing concurrent programs, and legacy import routines. Custom code that manipulates unit attempts should call the public enrolment APIs such as IGS_EN_ADD_UNITS_API and IGS_EN_SU_ATTEMPT_PKG rather than IGS_EN_VAL_SUA directly, ensuring validation is applied consistently and that message handling remains compatible with the delivered validation framework. Because the object is delivered as a VALID APPS package, it should be treated as read-only reference code; extensions should be implemented through supported APIs or documented personalisation points.