Search Results igs_ss_faculty_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_SS_FACULTY_PKG package body is a component of the Oracle E-Business Suite Student System (IGS) module, specifically belonging to the Student Systems (SS) product family. In Oracle EBS 12.1.1 and 12.2.2, its documented API classification is "OTHER," indicating that it is not a formally published public API but rather a supporting or internal package used by other components within the Student System. The package encapsulates business logic concerned with faculty-related student data processing, including the retrieval of institution and unit offering option context and the maintenance of student unit attempt outcomes. It operates within the APPS schema and is validated as a VALID database object.

Key Procedures and Functions

ETRM documents two procedures or functions within this package body:

  • ASSP_INS_GET_BY_UOO — This routine retrieves institution-related student system information keyed by Unit Offering Option (UOO). It serves as a lookup mechanism to obtain contextual data associated with a specific unit offering option, likely supporting downstream faculty-facing or enrolment-related processing.
  • UPDATE_SUAO — This routine performs an update operation against Student Unit Attempt Outcome (SUAO) data. It is the principal data-modification entry point within the package, used to persist changes to student unit attempt outcomes as part of academic progression or results processing.

No parameter signatures are documented in the ETRM metadata, and none should be assumed. The two routines together define a narrow, focused interface: retrieval of institutional context by unit offering option and modification of student unit attempt outcome records.

Tables Accessed

The package body references the following documented database objects, accessed through APPS synonyms:

  • IGS_AS_GEN_004 — An assessment/general purpose object (likely a view or table) used in support of institutional or general student processing logic.
  • IGS_AS_SU_STMPTOUT — A student unit attempt outcome-related object, consistent with the UPDATE_SUAO routine's purpose.
  • IGS_AS_SU_STMPTOUT_PKG — The associated package providing logic for the student unit attempt outcome entity.
  • IGS_CA_INST — The institution table (Student Systems institution entity), used to resolve institution-level context.
  • IGS_EN_SU_ATTEMPT — The student unit attempt table, representing a student's enrolment attempt in a unit offering option; this aligns with the UOO-keyed lookup performed by ASSP_INS_GET_BY_UOO.

Dependencies also include FND_API and FND_PROFILE, indicating use of the standard Oracle Application Object Library API error-handling framework and profile option lookups, plus STANDARD for PL/SQL standard constructs.

Usage Notes

The package is not referenced by any other database object per ETRM, though it references itself internally, which is characteristic of a package body invoking its own declared subprograms. It is therefore invoked primarily by forms, concurrent programs, or custom extensions within the Student System rather than by peer packages. Typical invocation would occur during academic results processing, where faculty or administrative users record and update student unit attempt outcomes, and where institution context must be resolved for a given unit offering option. Because the package leverages FND_API, callers should expect standard EBS API error and message handling semantics. Because its API classification is "OTHER," it should be treated as an internal implementation package; customisations should avoid direct invocation where a published API exists and should instead rely on the documented Student System interfaces. As with all APPS-schema objects, changes should be applied via the supported patching mechanism.