Search Results validate_usec_rsvpri

Overview

IGS_PS_VALIDATE_GENERIC_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Higher Education Student System (also known as Oracle Student System, or IGS). The package provides the generic validation and post-processing layer used when creating and maintaining scheduled unit offerings and their associated delivery, enrolment, reservation, and assessment entities. It serves as the server-side counterpart to the IGS_PS_CREATE_GENERIC_PKG creation package; the two are mutually dependent, with IGS_PS_CREATE_GENERIC_PKG invoking the validation routines here and this package calling back into the creation package and the IGS_PS_GENERIC_PUB public API. In the documented ETRM metadata for Release 12.1.1 the package is classified as an OTHER API rather than a public or private API.

The package enforces institutional business rules — facility and room suitability, category and class standards, cross-group membership consistency, and assessment constraints — before records are committed, and it performs post-validation persistence for override, cross-group, and reservation data.

Key Procedures and Functions

The documented interface contains 21 procedures and functions. They fall into two natural groupings:

• VALIDATE_* routines — these perform pre-commit checks against configuration and transactional data. Documented validation entry points include VALIDATE_FACILITY, VALIDATE_CATEGORY, and VALIDATE_TCH_RSP_OVRD (teaching responsibility override), together with a family of use/offering validations: VALIDATE_USEC_NOTES, VALIDATE_USEC_ASSMNT, VALIDATE_USEC_RSVPRI, VALIDATE_USEC_RSVPRF, VALIDATE_USEC_WLSTPRI, VALIDATE_USEC_WLSTPRF, VALIDATE_USEC_X_GRP, and VALIDATE_USEC_X_GRPMEM. Additional validations cover unit set/assessment item relationships (VALIDATE_AS_US_AI_GROUP, VALIDATE_UNITASS_ITEM), class meeting and offering group data (VALIDATE_USO_CM_GRP, VALIDATE_USO_CLAS_MEET).
• POST_* routines — these commit the corresponding transactional records once validation succeeds: POST_TCH_RSP_OVRD, POST_USEC_CROSS_GROUP, POST_AS_US_AI, POST_USEC_MEET_WITH, and POST_USEC_RSV.

The routines are predominantly row-level and are typically called from the generic creation flow rather than directly by end users. Their names correspond to specific Oracle Student System concepts: USE/unit section comments (NOTES), assessment (ASSMNT), reservation priorities (RSVPRI/RSVPRF), waitlist priorities (WLSTPRI/WLSTPRF), cross-group enrolments (X_GRP/X_GRPMEM), teaching responsibility (TCH_RSP), and unit set/assessment item grouping (AS_US_AI).

Tables Accessed

The package reads and writes through APPS synonyms. Documented dependencies include:

• Offering and delivery: IGS_PS_UNIT_OFR_OPT_ALL, IGS_PS_MEDIA_EQUIP_ALL, IGS_PS_RSV_USEC_PRF.
• Facilities and scheduling: IGS_AD_BUILDING_ALL, IGS_AD_ROOM_ALL, IGS_CA_INST_ALL, IGS_PR_CLASS_STD.
• Assessment and grading: IGS_AS_US_AI_GROUP, IGS_AS_APPR_GRD_SCH, IGS_AS_GRD_SCHEMA.
• Unit set and status configuration: IGS_EN_UNIT_SET_STAT, IGS_OR_STATUS, IGS_PS_USEC_AS.
• Person identifiers and messaging: IGS_PE_PERSID_GROUP_ALL, FND_NEW_MESSAGES.

The FND_NEW_MESSAGES reference indicates use of the Oracle Forms message dictionary for error and information messages surfaced to the user. IGS_PS_USEC_AS stores unit section assessment records, and IGS_AS_US_AI_GROUP stores assessment item groupings that the VALIDATE_AS_US_AI_GROUP and POST_AS_US_AI routines act upon.

Usage Notes

The package is invoked indirectly through the Oracle Student System scheduled unit offerings form and through the generic creation package, IGS_PS_CREATE_GENERIC_PKG, which is both the primary caller and a dependency. It also references IGS_PS_GENERIC_PUB, the public API for generic scheduled unit offerings. Custom integrations that create or amend offering delivery, reservation, waitlist, or assessment data should call the public API (IGS_PS_GENERIC_PUB) rather than these validation routines directly, because the private routines assume the calling context and sequencing established by the creation package. ETRM lists the package as referenced by only one other package, confirming it is an internal supporting component. There is a self-reference in the dependency tree, indicating internal recursive or shared helper calls within the package body.