Search Results get_fk_igs_ad_location

Overview

The APPS.IGS_OR_LOC_REGION_PKG package is a foundational Oracle E-Business Suite component within the Oracle Student System (also referred to as the Oracle Higher Education / Student Information System) product family. Its header comment identifies the file as IGSOI34S.pls, with an original revision dated April 2003, indicating this is a long-standing object in the IGS schema lineage. The package is owned by APPS and classified as OTHER in the ETRM repository.

Functionally, the package encapsulates the business logic for maintaining the relationship between a physical or logical location and a region. In the Oracle Student System data model, the IGS_OR_LOC_REGION entity acts as a cross-reference table binding a location_cd to a region_cd. This package therefore provides the canonical insert, lock, delete, validation, and foreign-key verification routines used to keep that cross-reference consistent. Because the package is declared AUTHID CURRENT_USER, it executes with the privileges of the calling schema rather than the definer, a design common to API-style packages that are invoked from multiple entry points.

Key Procedures and Functions

The package exposes six documented program units, all of which follow the standard Oracle Forms-generated table handler pattern.

• INSERT_ROW — Inserts a new location-to-region association. It accepts an x_rowid output handle, the location and region codes, and an x_mode parameter defaulting to 'R' (typical of Forms table handler conventions).
• LOCK_ROW — Acquires a row-level lock on an existing location/region record identified by rowid and the two business keys, supporting Forms-style optimistic locking.
• DELETE_ROW — Removes an existing association, identified solely by its rowid.
• GET_PK_FOR_VALIDATION — A Boolean validation function that confirms a primary key exists for a given location_cd / region_cd pair, returning TRUE when the combination is valid.
• GET_FK_IGS_AD_LOCATION — A foreign-key validation procedure that verifies the referenced location_cd exists in the IGS_AD_LOCATION parent entity. This is the routine associated with the user search term and is the trigger-level FK check invoked before insert or update.
• BEFORE_DML — The central DML coordination routine. It accepts an action code plus rowid, key columns, and the standard WHO audit columns (creation/update dates, user IDs, login), dispatching to the appropriate validation and write logic.

Tables Accessed

The package operates against three documented tables via APPS synonyms. The primary target is IGS_OR_LOC_REGION, which stores the actual location/region cross-reference records inserted, locked, and deleted by this package. IGS_PS_UNIT_OFR_OPT_ALL and IGS_PS_USEC_OCCURS_ALL are also referenced, reflecting the parent-child dependencies that must be satisfied or respected when a location/region assignment is manipulated within unit offering option and use-occurrence contexts. The IGS_AD_LOCATION table is implicitly referenced by GET_FK_IGS_AD_LOCATION.

Usage Notes

This package is a database-side table handler, not a self-contained business API. It is typically invoked from Oracle Forms (the standard Student System location/region maintenance UI) or from other PL/SQL packages. ETRM records that the package is referenced by one other package, confirming it is a dependency object rather than a top-level entry point. Since GET_FK_IGS_AD_LOCATION follows the Oracle naming convention for foreign-key validation (GET_FK_<parent_table>), it is conventionally called from BEFORE_DML or directly by Forms trigger code whenever a location code is entered or changed. Customizations should invoke these routines rather than issuing direct DML against IGS_OR_LOC_REGION, to preserve validation and audit semantics.