Results for “igs_pr_val_sopc”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The PL/SQL package APPS.IGS_PR_VAL_SOPC is an Other-classified API within the Oracle E-Business Suite student system, part of the higher-education product family designated by the "IGS" prefix and the "PR" (progression/awards) sub-module. Its documented purpose is the centralized validation of configuration flags that govern the suspension-or-progression-category (SOPC) business processes for organizational units. Specifically, the package verifies the appeal indicator and the show-cause indicator before these values are persisted in progression and award configuration tables, and confirms that the organizational unit referenced by those records is active for the given start date. Because it acts purely as a rules-checking layer, the package does not itself create or modify business transactions; instead it returns Boolean success flags together with an output message name so that calling programs can surface a standard, translatable error message to the user. The script header identifies a last build at version 115.4 and notes that several earlier function declarations — validations for appeal dates, cause dates, and date-closed conditions — were removed under Bug 1956374 in 2001, narrowing the surviving public interface to five validation entry points.

Key Procedures and Functions

• PRGP_VAL_SOPC_APL — Validates the appeal indicator being set for a specific organizational unit and organizational-unit start date, returning a Boolean result and an output message name describing any failure.
• PRGP_VAL_SOPC_CAUSE — Validates the show-cause indicator being set for a specific organizational unit and organizational-unit start date, returning a Boolean result and an output message name.
• PRGP_VAL_APPEAL_IND — Validates the appeal indicator value held in the organizational-unit configuration and curriculum-version configuration records.
• PRGP_VAL_CAUSE_IND — Validates the show-cause indicator value held in the organizational-unit configuration and curriculum-version configuration records.
• PRGP_VAL_OU_ACTIVE — Confirms that the specified organizational unit is active as of the supplied start date. This function carries a PRAGMA RESTRICT_REFERENCES declaration of WNDS, confirming it reads database state without writing to it.

All functions share a consistent call signature style: input parameters identifying the unit and indicator value, plus an OUT NOCOPY VARCHAR2 message name used to communicate the failed validation, with a BOOLEAN return indicating overall success.

Tables Accessed

• IGS_OR_STATUS — Consulted to determine organizational unit status, supporting the active-unit check performed by PRGP_VAL_OU_ACTIVE.
• IGS_PR_S_OU_PRG_CAL — The organizational-unit progression calendar setup table, read to resolve the organizational-unit configuration context for the appeal and show-cause indicator validations.
• IGS_PR_S_PRG_CONF — The progression configuration setup table, read to resolve curriculum-version-level configuration values validated by PRGP_VAL_APPEAL_IND and PRGP_VAL_CAUSE_IND.

Access is performed through APPS synonyms in keeping with the standard EBS APPS schema model. The package operates in AUTHID CURRENT_USER mode, so privileges resolve against the invoking schema.

Usage Notes

Given its classification and its dependence on static setup tables, IGS_PR_VAL_SOPC is invoked during the entry and maintenance of progression and award configuration data — most commonly from the Oracle Forms-based setup screens that maintain organizational-unit and curriculum-version configuration, and from any custom or wrapper code that programmatically seeds or updates those configuration rows. The package is documented as referenced by three other packages, indicating that it functions as a shared lower-level validation library for higher-level progression APIs rather than as an end-user entry point. Because it does not perform DML, it must be called before the caller commits indicator changes; the caller is responsible for acting on the Boolean result, retrieving the message text associated with the returned message name, and raising or displaying the appropriate error. Any modification to the validation rules should be made in this package so that all dependent packages inherit the corrected behavior consistently.