Search Results corp_val_cort_closed

Overview

IGS_GR_VAL_TT is a placeholder PL/SQL package in the APPS schema belonging to the Oracle Student System (formerly Oracle Grants/Student) product family, identified by the IGS_ prefix and classified in the ETRM repository as an "OTHER" API utility. In Oracle EBS 12.1.1 and 12.2.2 the package exists purely as a shell; its entire body consists of the declaration PACKAGE IGS_GR_VAL_TT AUTHID CURRENT_USER AS ... END IGS_GR_VAL_TT; with no executable program units remaining. The package name suggests its historic role was to serve as a validation container for "GR" (Graduation/Grade or Grants) data, invoked as a library of standalone validation routines rather than as a stateful business API.

The 12.1.1 ETRM metadata records an empty program-unit inventory (0 procedures/functions), no referenced tables, and no dependent packages, confirming that the package is dormant in the current release.

Key Procedures and Functions

The ETRM metadata for 12.1.1 lists no documented procedures or functions. The source header documents the historical contents and their removal:

• corp_val_cort_closed (Function) — the only program unit historically associated with this package. It was removed under Bug ID 1956374, "Removal of Duplicate Program Units from OSS." The header notes that the code was removed because the only remaining program unit(s) had to be removed; no replacement object is named. The function name indicates a validation routine intended to return a Boolean or status indicator of whether a "corporate validation" / "CORT" (cohort) record is closed, but the parameter list and return type are not preserved in the current metadata and must not be assumed.
• Procedures — none were ever declared (the header explicitly records "Procedures : --").

Because the function no longer exists, any 12.1.1 or 12.2.2 code that calls IGS_GR_VAL_TT.corp_val_cort_closed will raise ORA-06550 / PLS-00302 (component must be declared).

Tables Accessed

The documented ETRM metadata lists no tables referenced through APPS synonyms. Consistent with the removal of the sole function, the package currently performs no DML or queries and therefore has no table-level dependencies. Historically, a validation routine named corp_val_cort_closed would most plausibly have queried an IGS cohort or graduation-status table (for example, an IGS_GR_* or IGS_CO_* base table) to determine whether a record was closed, but this cannot be confirmed from the surviving metadata and should not be treated as authoritative.

Usage Notes

IGS_GR_VAL_TT should be treated as a dead object in Oracle EBS 12.1.1 and 12.2.2. It is not invoked by any standard form, concurrent program, or dependent package per the ETRM "Referenced by 0 other packages" data. The package is retained only because the compiled specification remains in the APPS schema following the duplicate-object cleanup in Bug 1956374; Oracle did not drop the specification, leaving an empty shell.

Practical guidance for implementers and custom developers:

• Do not call IGS_GR_VAL_TT.corp_val_cort_closed or any other member of this package; no callable members exist.
• Any custom code inherited from an earlier release that references this package must be re-pointed to the replacement validation logic delivered elsewhere in the IGS/OSS schema, or rewritten locally.
• Do not drop the APPS synonym or specification without confirming that no legacy custom code still resolves the name; removal is otherwise safe but unsupported.
• When troubleshooting ORA-06550 or PLS-00302 errors mentioning IGS_GR_VAL_TT, treat the error as evidence of obsolete custom code rather than a defect in the EBS-delivered package.

In summary, IGS_GR_VAL_TT is a documentation-only remnant whose sole historical function, corp_val_cort_closed, was removed before the 12.1.1 baseline; it carries no runtime behaviour in 12.1.1 or 12.2.2.