Search Results igs_en_stdnt_ps_att_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_EN_STDNT_PS_ATT_PKG package is a core Student System (IGS) enrollment entity handler within Oracle E-Business Suite, classified under the ETRM as an OTHER API. Its primary business function is to manage the persistence, retrieval, and referential integrity of Student Program Attempt (SPA) records — the enrollment attempt a student makes against a specific program of study, program version, and offer option. The package owns and masks the underlying IGS_EN_STDNT_PS_ATT_ALL table, providing the standard row-level operations (insert, update, delete, lock) required to keep this enrollment data consistent with the surrounding person, calendar, and program catalog structures.

Status is documented as VALID in the APPS schema on both Oracle EBS 12.1.1 and 12.2.2. The package sits near the centre of the IGS enrollment dependency graph: it references only SYS.STANDARD at the lowest level, yet it is referenced by 64 other packages, marking it as a heavily reused foundation object rather than a leaf-level utility.

Key Procedures and Functions

ETRM documents 24 callable units. They fall into three functional groups:

  • Row maintenance: INSERT_ROW, UPDATE_ROW, DELETE_ROW, LOCK_ROW, and ADD_ROW perform the standard transactional operations against the SPA record. LOCK_ROW exists to support optimistic concurrency control when a downstream caller (such as an enrollment form or batch process) must guarantee the row is unchanged between fetch and update.
  • Primary key resolution: GET_PK_FOR_VALIDATION resolves the surrogate primary key used to validate the entity prior to commit.
  • Foreign key lookup helpers: The remaining procedures and functions are a family of GET_FK_* and GET_UFK_* routines that resolve and validate the mandatory and unique foreign key relationships for the SPA record — to attendance mode and type, calendar category, offer option (both FK and UFK variants), program course, program version, fee category, funding source, admission location, and person. Resolving these through the package enforces IGS referential rules inside the PL/SQL layer rather than relying solely on database constraints.

No parameter lists are asserted here; names reflect their documented purpose only.

Tables Accessed

The package reads and writes through APPS synonyms, giving the following documented base tables:

These accesses confirm the package's role: validating calendar, person, and program catalog keys before persisting the SPA row.

Usage Notes

Because 64 IGS packages reference it — including admission (IGS_AD_*), assessment (IGS_AS_*), enrollment (IGS_EN_*), and finance (IGS_FI_*) modules — IGS_EN_STDNT_PS_ATT_PKG is typically invoked indirectly from enrolment forms, concurrent program logic, and other PL/SQL APIs rather than called directly by end users. The pattern of paired GET_FK_* helpers alongside INSERT_ROW/UPDATE_ROW suggests it underpins a generated or Forms-based maintenance screen for program attempts. Custom code should treat it as an internal API: prefer the higher-level published enrollment interfaces, and invoke this package directly only when maintaining SPA rows at the base-table level, always resolving foreign keys through the documented helpers to preserve IGS validation semantics.