Search Results get_partyid

Overview

IGS_SC_VARS is a small utility package body owned by APPS and classified under the OTHER API category in Oracle EBS 12.1.1 and 12.2.2. Its header comment identifies the package as a "Grant variables package," created by Arkadi Tereshenkov in October 2002 as part of the Oracle Student System (IGS) product family. The package belongs to the IGS_SC module, which relates to student system self-service and grant-related processing.

Functionally, IGS_SC_VARS provides centralized resolution of commonly needed session and attribute values. Rather than allowing each caller to determine the currently connected user or a stored user attribute independently, the package exposes simple wrapper functions that return a user identifier, a party identifier, or a named attribute value. This makes it a convenience layer over the underlying attribute storage and the FND_GLOBAL session context.

Key Procedures and Functions

• GET_ATT — Returns the stored attribute value for a given attribute identifier belonging to the current user. It queries the attribute values table for the specified attribute of the session user. This is the only function in the package that accepts an input argument.
• GET_USERID — Returns the numeric user identifier of the currently connected EBS user. This is the function most commonly searched for, since it provides a lightweight, package-local alternative to a direct call to FND_GLOBAL.USER_ID.
• GET_PARTYID — Returns the party identifier associated with the current user. It does so indirectly, by resolving attribute identifier 1 for the session user, meaning the party ID is stored as a user attribute record rather than being read from a party table directly.

Tables Accessed

The package reads a single documented table via its APPS synonym: IGS_SC_USR_ATT_VALS. This table stores user attribute values, keyed by user attribute identifier and user identifier. GET_ATT selects ATTR_VALUE from this table, filtering on the supplied user attribute identifier and the current user ID obtained through GET_USERID. The table is read-only within this package; no inserts, updates, or deletes are documented. Because GET_PARTYID delegates to GET_ATT(1), the party ID lookup also depends on the same table, provided that attribute ID 1 is populated for the user with a party value.

Usage Notes

This package is typically invoked as a helper from other PL/SQL units within the IGS_SC module. The documentation records that IGS_SC_VARS is referenced by one other package, confirming its role as a dependent utility rather than an entry point. In practice, such packages are called from forms, concurrent programs, or custom extensions during grant-related processing, wherever code needs to identify the current user, the session party, or a specific user attribute value without duplicating SQL.

Because GET_USERID ultimately returns FND_GLOBAL.USER_ID, calls must occur in a valid EBS session; the value reflects the application user under which the session (or the concurrent request) runs. GET_PARTYID returns a numeric value via the generic attribute accessor, and callers should be aware that it depends entirely on a row existing for attribute ID 1 in IGS_SC_USR_ATT_VALS for that user. No initialization or commit logic exists in the package body, and no exceptions are explicitly handled; if no matching attribute row is found, GET_ATT returns a null value rather than raising a NO_DATA_FOUND error.