Search Results get_fk_igs_or_institution

Overview

IGS_OR_INST_ADDR_PKG is an Oracle E-Business Suite package owned by the APPS schema and classified under the "OTHER" API category. It forms part of the Oracle Student System (formerly Oracle iLearning / Oracle Higher Education) footprint, specifically the IGS_OR module that manages institutional and organizational reference data. The package is dedicated to the validation and referential integrity of institution address records — the intersection of an institution, an address type, a start date, postal information, and suburb/postcode data. In EBS 12.1.1 and 12.2.2 it is declared with AUTHID CURRENT_USER, meaning that name resolution and privilege checking for unqualified objects are performed against the invoker's schema rather than the owner's. The header comment dates the source to an early 11i-era release, but the packaged object remains present and callable in the later 12.x ETRM inventory, indicating it was carried forward without structural change.

Key Procedures and Functions

The package exposes four documented program units, all oriented toward validation rather than transactional processing.

• GET_PK_FOR_VALIDATION — A BOOLEAN function that verifies the existence of a valid primary key combination for an institution address record. It is the standard "does this row exist" check used before insert or update, ensuring the institution code, address type, and start date together identify a legitimate record.
• GET_FK_IGS_CO_ADDR_TYPE — A procedure that validates a supplied address type against the address type reference table, confirming the foreign key is a recognized value.
• GET_FK_IGS_OR_INSTITUTION — A procedure that validates the institution code foreign key, ensuring the referenced institution exists in the institution reference table before an address is attached to it. This is the unit most directly relevant to the search term get_fk_igs_or_institution.
• GET_FK_IGS_PE_SUBURB_POSTCD — A procedure that validates the suburb/postcode foreign key, confirming the location reference used on the address is valid.

Collectively these units implement the foreign key and primary key validation layer that a client form or API would call before committing an institution address.

Tables Accessed

The ETRM metadata for this object does not enumerate referenced tables. Based on the procedure names and standard Oracle Student System data model conventions, the package validates against the institution address base table (IGS_OR_INST_ADDR), the address type reference table (IGS_CO_ADDR_TYPE), the institution reference table (IGS_OR_INSTITUTION), and the suburb/postcode reference table (IGS_PE_SUBURB_POSTCD). Reads are predominantly single-row existence checks against these reference and master tables; the package performs validation lookups rather than bulk data manipulation.

Usage Notes

This is a server-side validation package, not a user-facing API. It is typically invoked from Oracle Forms-based institution address maintenance screens, from seed or conversion routines loading address data, or from custom PL/SQL that must enforce the same integrity rules before writing institution addresses directly. In EBS 12.2.2, database objects of this type behave identically whether deployed in the classic or Online Patching file system, since the package itself is not editioned through the usual AD_ZD path in the same manner as seed data.

The documented metadata records zero dependent packages, confirming that IGS_OR_INST_ADDR_PKG is a leaf-level utility with no downstream package callers in the shipped codebase. Because AUTHID CURRENT_USER is specified, custom callers must hold appropriate privileges on the underlying tables in their own schema context, or be granted execute on the package under the correct schema. Direct modification of this package is not supported under Oracle's product maintenance policy; extensions should be implemented by wrapping the package rather than editing it.