Search Results enrp_get_scaeh_eff_end




Overview
Explore in AI Chat

Overview

The APPS.IGS_EN_GET_SCAEH_DTL package is a PL/SQL database object residing in the APPS schema of Oracle E-Business Suite, classified as a component of the Oracle Student System (IGS) product family. Its name reflects its role within the Student Course Attempt Effective History (SCAEH) model: IGS_EN identifies the Student System enrollment module, GET indicates a retrieval or query function, and SCAEH_DTL denotes Student Course Attempt Effective History detail. The package therefore serves as a utility layer that supplies derived effective-dating attributes for student course attempt records to views and other dependent objects, rather than acting as a transactional API. Its status is recorded as VALID in the ETRM repository for release 12.1.1, and the same signature is preserved under 12.2.x, indicating that the object has not changed across the documented releases.

Key Procedures and Functions

The ETRM metadata documents three callable program units, all carrying the ENRP_GET_SCAEH prefix. Their names indicate that each returns a scalar value used to derive an effective-date column for the SCAEH reporting views:

  • ENRP_GET_SCAEH_EFF_ST — Returns the effective start date associated with a student course attempt history record. This value represents the point in time from which the supplied course attempt row becomes current.
  • ENRP_GET_SCAEH_EFF_END — Returns the effective end date for the same record. Where a row is still current, this function typically yields the open-ended high date used throughout the IGS schema (for example, 31-DEC-4712).
  • ENRP_GET_SCAEH_COL — A generic column-retrieval function that returns a specific effective-history attribute for a given student course attempt, allowing the calling view to project individual detail values without duplicating query logic.

No formal parameter lists are published in the ETRM extract; parameter signatures should be confirmed against the actual package specification in the target instance before invoking the functions directly from custom code.

Tables Accessed

The package resolves three underlying objects through APPS synonyms:

  • IGS_AS_SC_ATTEMPT_H_ALL — The primary source table, holding the dated history rows for student course attempts. The effective start and end functions derive their results from the date ranges recorded here.
  • IGS_PS_COURSE — The course catalog table, consulted to supply course-level attributes that form part of the SCAEH detail result set.
  • USER_TAB_COLUMNS — The data dictionary view, used for dynamic column resolution supporting the generic ENRP_GET_SCAEH_COL retrieval path.

Usage Notes

The package is referenced by two dependent views, IGS_AS_SCAH_EFFECTIVE_H_V and IGS_FI_SCAH_EFFECTIVE_H_CAT_V. These views expose effective-history data to Student System inquiry forms, self-service pages, and reporting. Consequently the package executes implicitly whenever those views are queried — most commonly through the Student Course Attempt or Enrollment History windows in the Oracle Student System responsibility, and through concurrent programs and Discoverer or BI Publisher reports that select from the views. Direct calls from custom PL/SQL should be treated cautiously: because retrieval is date-sensitive and dictionary-driven, the functions should be invoked only with valid history row identifiers, and any customer extension should be re-validated after an upgrade from 12.1.1 to 12.2.2 to confirm that the expected effective ranges are still returned.