Search Results igs_or_gen_001




Overview
Explore in AI Chat

Overview

IGS_OR_GEN_001 is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Student System (formerly Oracle iLearning/Student Information) product family. Its object name follows the IGS_OR naming convention, which designates the Organizations module of the Student System Data Model. The package provides the core utility layer for maintaining organizational unit (OU) and institution records, including their historical versions, status transitions, and hierarchical relationships. It is a dependency-bearing object rather than a leaf module: ETRM metadata shows it is referenced by eleven other packages, and it does not itself appear as a dependent of any database object, confirming its role as a foundational service package within the Organizations subsystem.

Key Procedures and Functions

The documented interface comprises ten procedures and functions:

  • ORGP_DEL_INSTN_HIST — Deletes institution history records, supporting the purge or rollback of historical institution data.
  • ORGP_DEL_OU_HIST — Removes organizational unit history rows, used when OU history must be pruned or corrected.
  • ORGP_GET_LOCAL_INST — Retrieves the local institution, typically resolving the operative institution for the current session or context.
  • ORGP_GET_S_LOC_TYPE — Returns a location type code, supporting validation and lookups against location-type reference data.
  • ORGP_GET_S_LOC_TYPE2 — A second location-type retrieval variant, indicating alternative lookup logic or a distinct parameter context.
  • ORGP_GET_WITHIN_OU — Determines whether a given organizational unit falls within another OU, supporting hierarchy-based security and validation checks.
  • ORGP_INS_OU_HIST — Inserts organizational unit history rows, capturing the state of an OU at a point in time.
  • ORGP_UPD_INS_OU_STS — Updates institution and organizational unit status values, propagating status changes across institution and OU records.
  • ORGP_UPD_OU_STS — Updates organizational unit status only, a narrower variant of the preceding procedure.
  • UPDATE_ORG — Provides the general organization update entry point, described simply as UPDATE_ORG in the documented interface.

Tables Accessed

Documented table dependencies, accessed through APPS synonyms, include HZ_PARTIES, the Oracle Trading Community Architecture (TCA) party table that stores the underlying party identity for organizations; IGS_AD_LOCATION_ALL, the address/location table holding site and address data for institutions and OUs; IGS_PE_HZ_PARTIES, the intersection linking person records to TCA parties; IGS_OR_STATUS, the status reference table governing institution and OU lifecycle states; and IGS_OR_UNIT_REL, which defines organizational unit relationships and is central to hierarchy resolution. Additional undirected dependencies include IGS_OR_INSTITUTION, IGS_OR_INST_HIST, IGS_OR_UNIT, IGS_OR_UNIT_HIST, IGS_AD_LOCATION, IGS_AD_LOCATION_TYPE, and IGS_AD_LOCATION_TYPE reference data, consistent with the history insert/delete and status update procedures described above. Utility packages such as APP_EXCEPTION, FND_MESSAGE, FND_PROFILE, IGS_GE_GEN_003, IGS_GE_MSG_STACK, IGS_OR_GEN_012_PKG, and IGS_OR_UNIT_HIST_PKG are also referenced, indicating that error handling, message stacking, profile lookups, and history maintenance are delegated to shared infrastructure.

Usage Notes

IGS_OR_GEN_001 is typically invoked indirectly by forms, concurrent programs, and other Student System packages rather than called directly by end users. Because eight of its dependencies are themselves packages and it is referenced by eleven packages, it functions as an internal service layer for the Organizations module. Customizations that insert, update, or delete organizational unit or institution history should preferably route through this package to preserve the integrity of status and history records. Direct DML against IGS_OR_UNIT, IGS_OR_UNIT_HIST, IGS_OR_INSTITUTION, or IGS_OR_INST_HIST risks bypassing history capture and status validation enforced here.