Results for “igs_ad_location_pkg”

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

Overview

IGS_AD_LOCATION_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the Student System (IGS) product family as part of the Admissions (AD) module. Its primary business function is to manage the underlying table handler logic for location records used throughout the institution's administrative infrastructure — buildings, campuses, venues, and other physical or logical sites referenced by admissions, enrolment, assessment, finance, and timetabling processes. The package encapsulates the standard Oracle Forms server-side DML pattern, providing row-level insert, update, delete, locking, and validation services against the IGS_AD_LOCATION_ALL table. As a table handler package rather than a pure public API, it accepts surrogate key and foreign key values supplied by the client and enforces column-level and referential integrity constraints before committing changes. Its dependencies span more than forty institutional packages, reflecting the centrality of location data across the IGS schema.

Key Procedures and Functions

The documented interface exposes ten procedures and functions, most of which follow the conventional Oracle Forms table handler naming convention:

• INSERT_ROW — Inserts a new location record into the base table.
• UPDATE_ROW — Modifies an existing location record.
• DELETE_ROW — Removes a location record from the base table.
• LOCK_ROW — Issues a SELECT ... FOR UPDATE to serialize concurrent modification of the same location row.
• ADD_ROW — Provides the defaulting and pre-population logic used when a new row is created in the form.
• GET_PK_FOR_VALIDATION — Retrieves the primary key value used to validate that a submitted row corresponds to an existing database record.
• GET_FK_IGS_AD_LOCATION_TYPE — Returns the foreign key value identifying the associated location type, validating the classification of the location.
• GET_FK_IGS_PE_PERSON — Returns the foreign key value identifying the associated person, linking the location to a responsible individual where applicable.
• CHECK_CONSTRAINTS — Performs column-level and business-rule validation before DML proceeds, raising errors via FND_MESSAGE.
• BEFORE_DML — Centralizes pre-insert and pre-update processing such as audit column population and derived value calculation.

Tables Accessed

The package operates against IGS_AD_LOCATION_ALL, the core location entity table in the Admissions module. All insert, update, delete, and lock operations target this table. The "_ALL" suffix indicates that the table holds records across all operating units or organizational contexts rather than being partitioned by a single context. Foreign key resolution logic against IGS_AD_LOCATION_TYPE and IGS_PE_PERSON is reflected in the GET_FK procedures, though the metadata confirms direct reference only to IGS_AD_LOCATION_ALL via an APPS synonym.

Usage Notes

IGS_AD_LOCATION_PKG is invoked primarily from the EBS location maintenance Oracle Forms, where it executes as the standard table handler handler for the location block. It is referenced by forty-two other packages, including IGS_AD_BUILDING_PKG, IGS_AD_LOCATION_REL_PKG, IGS_GR_VENUE_PKG, IGS_OR_UNIT_LOC_PKG, and various assessment, enrolment, and finance packages, which call it to validate and maintain location data in the course of their own transactions. Custom code extending admissions or timetabling functionality should treat this package as a table handler and prefer the higher-level public APIs of the related entities unless direct table maintenance semantics are explicitly required. Error conditions surface through FND_MESSAGE and APP_EXCEPTION, consistent with the EBS message stack architecture.