Results for “igs_gr_venue_addr_pkg”

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

Overview

IGS_GR_VENUE_ADDR_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Student System / Higher Education (IGS) product family, specifically the Graduation (GR) module, and manages the relationship between graduation venues and the physical addresses at which they are located. In the EBS 12.1.1 and 12.2.2 codelines this package is classified under the generic API classification "OTHER", meaning it is a table-maintenance style API rather than a fully governed public interface. Its principal role is to encapsulate insert and update operations against graduation venue address records, ensuring that venue-to-location mappings remain consistent with the underlying Oracle Trading Community Architecture (TCA) location model. The package is declared with AUTHID CURRENT_USER and a header signature dated 2002, reflecting its origin in the early Oracle Student System releases that were later folded into the EBS footprint.

Key Procedures and Functions

The package exposes two documented procedures:

• INSERT_ROW — Creates a new graduation venue address record. It accepts an extensive attribute set covering the venue address identifier, the associated location identifier, venue code, validity dates (start and end), country, address style, four free-form address lines, city, state, province, county, postal code, phonetic address lines, delivery point code, supplementary detail attributes, source type, a contact person, and a last-verified date. The procedure returns the generated ROWID and venue address identifier through IN OUT NOCOPY parameters and a status message via an OUT NOCOPY parameter. It also accepts an X_MODE parameter defaulting to 'R'.
• UPDATE_ROW — Modifies an existing graduation venue address record. It takes the ROWID plus the same descriptive attribute set as INSERT_ROW, along with the status message output and the X_MODE parameter defaulting to 'R'. The presence of the X_MODE argument indicates the procedures support multiple execution modes (for example, validation-only versus commit), a common convention in Oracle Student System APIs.

No functions are documented for this package.

Tables Accessed

The package operates against two documented tables exposed through APPS synonyms:

• IGS_PE_HZ_LOCATIONS — The IGS extension table that associates person or party location records with TCA locations. This is the operative table for venue address maintenance.
• HZ_LOCATIONS — The base TCA locations table, which stores canonical address data such as country, address lines, city, state, province, county, and postal code. The package references this table to keep venue address rows aligned with the master location definition.

Usage Notes

Because this package is not an approved public interface (classification "OTHER") and is referenced by no other documented packages, it is normally invoked indirectly. Typical invocation paths include the Graduation venue maintenance forms, concurrent programs that load or migrate venue address data, and custom extensions that must create or amend venue addresses. Integrators should treat INSERT_ROW and UPDATE_ROW as internal maintenance routines: callers must supply a valid TCA location identifier, respect the effective start and end dates, and honour the X_MODE convention rather than assuming implicit commits. Direct use in custom code is permissible but should be preceded by impact analysis, since the package sits beneath the documented API layer and its behaviour is tightly coupled to the IGS and TCA data model.