Search Results assp_val_gsg_min_max

Overview

IGS_AS_VAL_GSG is a PL/SQL validation package owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Student Systems / Academic records family of products (the IGS module prefix denotes the legacy Oracle Student System). It is classified as a validation (VAL) package rather than a public API, meaning its routines are intended to be called by the forms, business logic, or other packages that maintain grading schema definitions, not by external integrations as a supported interface.

The package enforces the business rules that govern grading schema grades and their associated date and mark ranges. Its responsibilities include confirming that a grade's grading schema date range is current or future, verifying that start and end dates form a valid range, ensuring lower and upper mark ranges are consistent, ensuring minimum and maximum percentages are ordered correctly, detecting overlapping mark ranges between grades within the same grading schema version, and limiting the outstanding default indicator to a single grade per schema. Because these checks protect data integrity at the point of entry and update, they are the mechanism by which the application prevents ambiguous or contradictory grade definitions from being saved.

Key Procedures and Functions

• ASSP_VAL_GS_CUR_FUT — Validates that the date range defined for a grade's grading schema is current or in the future, returning a boolean result and an output message name.
• GENP_VAL_DT_RANGE — Generic date range validator (retrofitted) that confirms a supplied start date and end date constitute a valid range.
• ASSP_VAL_GSG_MRK_RNG — Validates that the upper mark range is greater than or equal to the lower mark range, and that both are populated if either one is set.
• ASSP_VAL_GSG_MIN_MAX — Validates that the maximum percentage is greater than or equal to the minimum percentage for a grade.
• ASSP_VAL_GSG_M_OVRLP — Validates that a grade's mark range does not overlap with the mark ranges of other grades in the same grading schema version.
• ASSP_VAL_GSG_DFLT — Validates that only one grade exists within a grading schema (and version) with the default outstanding indicator set.
• ASSP_VAL_GSG_GSGT — Additional grade-level validation routine documented in the package specification (8 functions/procedures total).
• ASSP_VAL_GSG_SSGT — Additional grade-level validation routine documented in the package specification.

Tables Accessed

The package references two base tables through APPS synonyms:

• IGS_AS_GRD_SCHEMA — The grading schema header, supplying grading_schema_cd and version_number, used to evaluate whether the schema's date range is current or future.
• IGS_AS_GRD_SCH_GRADE — The grading schema grade detail, supplying lower_mark_range, upper_mark_range, min_percentage, max_percentage, grade, and the default outstanding indicator used by the overlap, range, min/max, and default-indicator validations.

Usage Notes

IGS_AS_VAL_GSG is a server-side validation package typically invoked from the Oracle Forms that maintain grading schemas and grades, and from the surrounding IGS_AS packages that create or update those records. The ETRM metadata records five other packages referencing it, which confirms its role as a shared validation layer rather than a standalone program. It is not ordinarily scheduled as a concurrent program. Custom code should treat it as an internal validation utility: callers must expect a boolean return plus an OUT message name parameter, and should invoke the routines within the same transaction as the insert or update so that validation failures can be surfaced to the user before commit. Validation logic assumes the APPS schema context (AUTHID CURRENT_USER), and the message name returned by each function is intended to be resolved through the application's standard message lookup mechanism.