Search Results igs_sc_vars

Overview

IGS_SC_VARS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM repository as an "OTHER" API type. The package forms part of the Oracle Student System (IGS) product family, specifically the Self-Service Credentials and grants subsystem. It functions as a lightweight server-side value access layer that supplies session-context and attribute values to other components of the IGS_SC module. Rather than exposing business transactions, IGS_SC_VARS acts as a supporting utility whose primary role is to resolve the current user's identity and to retrieve attribute values stored against that user for use by higher-level packages such as IGS_SC_GRANTS_PVT.

The dependency metadata confirms that IGS_SC_VARS depends only on the SYS STANDARD package, meaning it relies on base PL/SQL constructs rather than on elaborate nested APIs. It is referenced by one other package, IGS_SC_GRANTS_PVT, which indicates it sits low in the call hierarchy and is consumed by the grants processing logic.

Key Procedures and Functions

ETRM documents three callable units within IGS_SC_VARS. No parameter signatures are recorded in the metadata, so only their documented purpose is described here.

• GET_USERID — Returns the identifier of the current user in the context of the Self-Service Credentials module. This value is typically consumed by callers that need to attribute a grants or eligibility action to the logged-in user without re-querying the FND_USER tables.
• GET_PARTYID — Returns the party identifier (PARTY_ID from the TCA / HZ party model) associated with the current user. This enables downstream logic to map an application user to the corresponding person or organization record held in the trading community architecture.
• GET_ATT — Retrieves a stored attribute value for a user. The "ATT" designation aligns with the IGS_SC_USR_ATT_VALS table, which stores attribute name/value pairs keyed to users. GET_ATT allows callers to obtain a specific attribute without embedding the lookup SQL directly in their own code.

Tables Accessed

The documented table accessed through APPS synonyms is IGS_SC_USR_ATT_VALS. This table holds user-level attribute values used by the Student System Self-Service Credentials feature set. GET_ATT is the procedure most directly associated with this table, since its purpose is to return attribute values stored against a user. GET_USERID and GET_PARTYID likely resolve identity values through supporting views or package state rather than through this table directly, but the attribute table is the principal data source documented for the package. No insert, update, or delete operations are documented, suggesting IGS_SC_VARS is a read-only access layer; write responsibility for user attributes would reside elsewhere in the IGS_SC schema.

Usage Notes

IGS_SC_VARS is an internal implementation package rather than a public integration API. It is invoked from PL/SQL code within the IGS_SC module, most notably by IGS_SC_GRANTS_PVT, which depends on it for user and party context while evaluating grants and credentials. Because the package is not exposed through a concurrent program interface or a form-level trigger in the documented metadata, customizations should avoid calling it directly. Developers who require the current user's attribute values in extension code should reference the higher-level business APIs, or query IGS_SC_USR_ATT_VALS through a supported view, to preserve upgrade safety across EBS 12.1.1 and 12.2.2. Any direct dependency on IGS_SC_VARS should be treated as subject to change in future patches, since the package is a supporting utility and not a committed public interface.