Search Results validate_last_connect




Overview
Explore in AI Chat

Overview

IGS_SESSION_VALIDITY is an Oracle EBS PL/SQL package owned by the APPS schema and classified as an OTHER API. In the Oracle Student System (formerly Oracle iLearning / Student Information) module lineage, this package provides session-level validation logic for the interactive enrollment and self-service experience. Its documented header embeds the source control string $Header: IGSSS10S.pls 120.0 2005/06/01 19:09:27 appldev noship $, confirming it is a shipped, non-customized component of the E-Business Suite 12.1.1 and 12.2.2 codebase. The package exposes a small, focused public surface: one cleanup routine and three Boolean validation functions. Collectively these routines decide whether a given user session remains eligible to continue processing enrollment activity, based on the timestamp of the user's most recent connection. This makes the package a gatekeeper against stale or expired user sessions in the enrollment workflow.

Key Procedures and Functions

  • CLEAN_ENROLL_WRKSHT — A procedure that removes or clears stale enrollment worksheet data. It supports the housekeeping of partially completed enrollment work so that abandoned sessions do not leave residual planning records behind.
  • IS_VALID_SESSION — A Boolean function that takes a session identifier and returns whether that session is still considered valid for continued enrollment processing.
  • VALIDATE_FIRST_CONNECT — A Boolean function that evaluates the first-connection timestamp against a supplied limit time, returning whether the initial connect occurred within the permitted window.
  • VALIDATE_LAST_CONNECT — A Boolean function that accepts a last-connect date and returns whether the user's most recent connection is still within acceptable tolerances. This is the routine most commonly sought by developers researching the validate_last_connect keyword; it is the mechanism that determines whether an idle session has aged out. No parameter list beyond the documented signature should be assumed.

Tables Accessed

The package operates against five documented tables referenced through APPS synonyms:

  • ICX_SESSIONS — The Oracle iStore/ICX session repository, used to identify and validate the caller's session context.
  • IGS_EN_PLAN_UNITS — Enrollment plan unit records, touched during worksheet cleanup.
  • IGS_EN_SPA_TERMS — Student program attempt term data, relevant to session-scoped enrollment validation.
  • IGS_EN_STD_WARNINGS — Student warning records that may be raised or cleared as part of worksheet maintenance.
  • IGS_EN_SU_ATTEMPT_ALL — The all-attempts denormalized enrollment view/table, providing the enrollment state context the validation functions consult.

Usage Notes

IGS_SESSION_VALIDITY is referenced by zero other documented packages, indicating it is invoked directly rather than as a dependency of a larger API chain. Typical invocation points are enrollment self-service forms and related concurrent or JSP-based flows that must confirm a user session is still live before committing enrollment changes. Developers calling the package should honor the Boolean return convention and check results before proceeding with worksheet operations. Because the header predates the 12.1.1/12.2.2 releases (last modified 2005), the implementation is stable but tightly coupled to ICX session semantics; custom code should not assume additional overloads exist. For diagnostics involving validate_last_connect, the routine is best exercised by passing a known last-connect timestamp and observing the Boolean outcome.