Search Results en_sua_rec_type

Overview

IGS_EN_SUA_API is the public PL/SQL application programming interface for the Student Unit Attempt (SUA) entity within the Oracle EBS Student Systems product family. In Oracle EBS 12.1.1 and 12.2.2, the package resides in the APPS schema and is classified by ETRM as a supported API, meaning its signatures are stable and intended for direct invocation by other Oracle modules and by customer extensions. The package encapsulates the business rules governing the creation and maintenance of unit attempt records held in IGS_EN_SU_ATTEMPT_ALL, the central table that records a student's enrolment in a specific offering of a unit within a teaching calendar. By exposing the row type EN_SUA_REC_TYPE, defined as IGS_EN_SU_ATTEMPT_ALL%ROWTYPE, the API gives callers a strongly typed structure that mirrors the underlying table and insulates them from direct DML. The package is referenced by twenty other packages, confirming its position as a foundational service within the Student Unit Attempt subsystem.

Key Procedures and Functions

ETRM documents five procedures and functions. The parameter signature of create_unit_attempt is fully published in the source header and accepts a wide range of enrolment attributes, including person, course and unit identifiers; calendar and version context; status and administrative status values; waitlist and discontinued date information; rule waived details; and numerous override and attribute columns. A corresponding update_unit_attempt procedure provides the maintenance path for existing attempt rows and is the object most commonly associated with the search term. upd_enrollment_counts recalculates or reconciles the aggregate enrolment counters that drive availability and capacity checks. enr_sua_sup_sub_val performs referential or business validation of a unit attempt against its superior and subordinate unit relationships. chk_sup_del_alwd determines whether deletion of a superior unit record is permissible given existing subordinate enrolments.

Tables Accessed

The package reads and writes IGS_EN_SU_ATTEMPT_ALL, the primary base table for student unit attempts. It consults IGS_EN_INST_WL_STPS for waitlist step configuration, IGS_PE_PERSON_TYPES for the person type classification applicable to the enrolling person, and IGS_PS_UNIT_OFR_OPT_ALL for the unit offering option against which the attempt is validated. Waitlist and cross-group rules draw on IGS_PS_USEC_LIM_WLST, IGS_PS_USEC_X_GRP and IGS_PS_USEC_X_GRPMEM. Scheduling data used in validation and validation of class placement is sourced from IGS_PS_USO_CLAS_MEET and IGS_PS_USO_CM_GRP. All access is via APPS synonyms, so the package remains schema-independent.

Usage Notes

IGS_EN_SUA_API is normally invoked from Student Systems forms, from concurrent programs and enrolment batch processes, and from custom integration code that must create or amend unit attempts without bypassing validation logic. Because the API enforces the enrolment rule set, direct inserts or updates against IGS_EN_SU_ATTEMPT_ALL are not supported and risk leaving enrolment counts and derived data inconsistent. Callers should supply X_ORG_ID for multi-org enabled environments and observe the reserved X_MODE parameter, which follows the standard Oracle API mode convention where 'R' denotes runtime validation and 'B' denotes bulk processing without full validation. When invoking update_unit_attempt, only the attributes requiring change need to be passed, but the identifying keys of the attempt must be supplied exactly and unambiguously.