Search Results igs_ps_val_unit




Overview
Explore in AI Chat

Overview

The APPS.IGS_PS_VAL_UNIT package body is a component of the Oracle E-Business Suite Student System (formerly Oracle Student System, OSS), classified under the IGS (Institution of Higher/Graduate Studies) module family. It belongs to the academic structure and prospectus-to-schedule domain that governs how academic units (courses, modules, and unit versions) are defined, validated, and maintained across institutions. The package encapsulates business logic for validating and persisting changes to unit version detail records. Its presence in the APPS schema, with a status of VALID in the ETRM 12.1.1 documentation set and continuity into 12.2.2, confirms it is a supported seeded object rather than a customization.

The package is not exposed as a public API for third-party consumption; the ETRM classification is OTHER, meaning it is an internal implementation package invoked by other seeded components rather than being advertised for customer extension. Its dependency footprint—including IGS_PS_UNIT_STAT, IGS_PS_UNIT_VER, IGS_GE_MSG_STACK, FND_MESSAGE, and APP_EXCEPTION—demonstrates that it participates in a broader validation and error-messaging framework shared with sibling unit-processing packages.

Key Procedures and Functions

The ETRM documentation records a single documented procedure or function within this package body:

  • CRSP_VAL_IUD_UV_DTL — The naming convention follows the IGS house style: VAL denotes validation, IUD denotes Insert/Update/Delete operations, and UV_DTL refers to unit version detail. The routine is therefore responsible for validating unit version detail rows as part of an insert, update, or delete transaction, raising application errors via the exception and message-stack utilities when the requested change violates unit-version business rules.

No parameter lists are documented in the ETRM metadata, and none should be inferred. Practically, the procedure is invoked internally by higher-level unit maintenance logic rather than called directly.

Tables Accessed

Two core tables are documented as being referenced or accessed through APPS synonyms:

  • IGS_PS_UNIT_STAT — The unit version status table. This holds status information associated with unit versions and is the primary table referenced by the APPS-level package. The validation logic in CRSP_VAL_IUD_UV_DTL reads this table to confirm the status context of the unit version detail being manipulated.
  • IGS_PS_UNIT_VER — The unit version base table. As the parent entity for the version detail records being validated, it is consulted to establish the version record to which the detail belongs and to enforce referential and status consistency.

Because the documented procedure covers insert/update/delete maintenance, the package may also write to unit version detail storage; the ETRM excerpt lists only the read dependencies, so write targets should be confirmed against the seeded source or database trace before customization.

Usage Notes

IGS_PS_VAL_UNIT is not referenced by any other database object according to the dependency report, yet it references 19 other packages and is itself an internal utility. This combination indicates a leaf-level validation routine consumed by user-facing academic structure forms (for example, unit and unit version maintenance windows in the Student System responsibility) and by concurrent programs that load or amend prospectus and unit data. It should not be modified, and its procedures should not be called directly from custom code: the supported extension points for unit validation are the documented public APIs in the IGS_PS family.

Customers on 12.1.1 and 12.2.2 can rely on the package remaining VALID across both releases, but because its procedures are internal, dependency ordering during patching matters. Any custom trigger or concurrent program touching IGS_PS_UNIT_STAT or IGS_PS_UNIT_VER should tolerate the validation errors this package raises through FND_MESSAGE and IGS_GE_MSG_STACK.