Search Results icx_session

Overview

The APPS.IGS_SESSION_VALIDITY package body is a server-side PL/SQL utility belonging to the Oracle Student System (IGS) module of Oracle E-Business Suite. Its core business function is to determine whether a given Oracle EBS (ICX) session is still valid before allowing restricted operations to proceed. The package bridges the generic Oracle Applications session framework — represented by the ICX_SESSIONS table and the profile option ICX_SESSION_TIMEOUT — with Student System enrollment and worksheet functionality.

The package header carries a version marker indicating it was last shipped under patch level 120.10, dated 24-Aug-2006 (IGSSS10B.pls). A global variable, g_icx_session_timeout, is initialised at package elaboration time by reading the ICX_SESSION_TIMEOUT profile option through FND_PROFILE.VALUE. This design means the timeout value is captured once per session, consistent with the behaviour of the standard Oracle Applications session validator.

Key Procedures and Functions

Four documented program units comprise the package:

• IS_VALID_SESSION — The primary validation entry point. It accepts a session identifier and returns a boolean indicating validity. Validity is assessed against four conditions: the session record must exist in ICX_SESSIONS; the record must not carry a disabled flag; the interval since last connect must fall within the configured ICX_SESSION_TIMEOUT; and the interval since first connect must fall within the session's declared limit time.
• VALIDATE_FIRST_CONNECT — Evaluates the elapsed time between the current login and the session's first connect timestamp against a supplied limit time. Returns FALSE (invalid) when the elapsed seconds exceed the limit; otherwise TRUE.
• VALIDATE_LAST_CONNECT — Compares the difference between the current time and the last connect timestamp against the global g_icx_session_timeout value. Returns FALSE when the session has been idle beyond the timeout threshold.
• CLEAN_ENROLL_WRKSHT — A maintenance routine associated with the enrollment worksheet, supporting the wider IGS enrollment data model.

Both validation functions include change history entries attributed to developer "ckasu" on 23-Aug-2004, modifying conditional logic under bug 3855996.

Tables Accessed

The package reads from ICX_SESSIONS to obtain first_connect, last_connect, limit_time, and disabled_flag for the supplied session identifier. The documented foreign tables — IGS_EN_PLAN_UNITS, IGS_EN_SPA_TERMS, IGS_EN_STD_WARNINGS, and IGS_EN_SU_ATTEMPT_ALL — support the enrollment worksheet cleanup path and the broader IGS enrollment context in which session validation is applied. All access is performed through APPS synonyms, as is standard for Oracle EBS packages.

Usage Notes

The package is typically invoked during Student System enrollment flows where the validity of the current ICX session must be confirmed before allowing a user to continue an enrollment worksheet or related transaction. The ICX_SESSION_TIMEOUT profile option governs its idle-session logic, so administrators controlling that profile directly influence validation outcomes. Because the package is referenced by no other documented packages, it functions as a leaf-level utility called directly by forms, OAF pages, or custom PL/SQL. Any custom code performing session checks in the Student System context should call IS_VALID_SESSION rather than re-implementing the four-condition logic, ensuring consistency with the shipped behaviour across Oracle EBS 12.1.1 and 12.2.2.