Search Results grdp_val_gac_insert

Overview

IGS_GR_VAL_GAC is an Oracle EBS validation package owned by APPS and classified under the OTHER API category. It belongs to the Student System (IGS) product family and specifically supports the Graduation Management module, where it enforces the business rules governing graduand award ceremony records. The package consolidates the validation logic applied whenever award ceremony data for graduands is created, modified, or checked for completeness within the graduation processing cycle.

The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the calling user rather than the package owner, a convention typical of the IGS validation packages in releases 12.1.1 and 12.2.2. All routines use OUT NOCOPY VARCHAR2 message parameters to return user-facing error text, and BOOLEAN return values to signal success or failure — an interface pattern consistent with the Forms-based validation architecture used throughout Oracle Student System.

Key Procedures and Functions

• GRDP_VAL_GAC_INSERT — Validates the insertion of a graduand award ceremony record, accepting a person identifier and creation date. This is the routine referenced by the search term "grdp_val_gac_insert."
• GRDP_VAL_GAC_IU — Validates insert or update operations against a graduand award ceremony, keyed by graduation calendar type, calendar instance sequence number, and ceremony number.
• GRDP_VAL_GAC_RQRD — Verifies that required ceremony attributes are present, including award course details, award code, unit set group, and academic dress information such as gown and hat sizes.
• GRDP_VAL_GAC_SEAT — Confirms that a graduand seat number is unique for a given person within a ceremony.
• GRDP_VAL_GAC_SUSA — Validates attendance or scheduling details for the graduand ceremony record.
• GRDP_VAL_GAC_GRD_CI — Validates graduation calendar instance data associated with the ceremony.
• GRDP_VAL_GAC_ORDER — Enforces ordering rules for graduands within the ceremony sequence.
• GRDP_VAL_MSR_CLOSED — Checks whether the relevant measurement or status period is closed, preventing updates once processing is locked.

Tables Accessed

Validation queries and lookups reference the following tables through APPS synonyms:

• IGS_GR_AWD_CRMN — the graduand award ceremony table, the primary subject of validation.
• IGS_GR_AWD_CRM_US_GP and IGS_GR_AWD_CRM_UT_ST — ceremony unit set group and unit attempt status details tied to the graduand record.
• IGS_GR_STAT — graduand status values used in rule evaluation.
• IGS_GE_MEASUREMENT — measurement or period definitions used by the closure check.
• IGS_PS_COURSE — course validation against award course codes.
• IGS_AS_SU_SETATMPT — student unit set attempt records, confirming academic completion.
• IGS_CA_STAT — calendar status, used to confirm the graduation calendar instance is open.

Usage Notes

IGS_GR_VAL_GAC is documented as referenced by two other packages, indicating it is called programmatically rather than executed directly by end users. Its functions are most commonly invoked from the Graduation Management Forms when registrars insert or amend award ceremony records, and from batch or concurrent processing that prepares ceremony data. Customizations that insert into IGS_GR_AWD_CRMN should call GRDP_VAL_GAC_INSERT and the related validators first, honoring the OUT NOCOPY message parameter to surface the returned error text. Because validations depend on calendar and status tables, the package assumes the relevant graduation calendar instance is open; GRDP_VAL_MSR_CLOSED exists to guard against updates in closed periods.