Search Results get_current_user

Overview

IGS_SC_GRANTS_PVT is a private PL/SQL package owned by APPS that implements the grant-processing engine for the Oracle Student System (Higher Education) module in Oracle E-Business Suite 12.1.1 and 12.2.2. It was created by Arkadi Tereshenkov in October 2002 (header revision IGSSC01S.pls 120.1) and is classified as a PVT API, meaning it is intended for internal use by sibling packages and public wrappers rather than direct invocation by external integrations. Its core business function is to generate, construct, validate, and administer the "grants" that govern access to student-system objects — that is, the entitlement records that determine which users, parties, or groups may perform which functions against which data objects. The package builds dynamic WHERE clauses, evaluates grant conditions, persists grant rows, and manages session context, effectively providing the authorization backbone behind the Student System security model.

Key Procedures and Functions

The documented interface exposes fifteen procedures and functions. The principal entry points are GENERATE_GRANT (overloaded as both a procedure it returns a WHERE-clause fragment through an OUT parameter, and as a function returning a VARCHAR2) and CONSTRUCT_GRANT, which materializes a specific grant identified by grant ID. CHECK_GRANT_TEXT, the object of the user's search, validates the textual definition of a grant, ensuring the stored grant condition text is syntactically and semantically acceptable before it is applied. CHECK_ATTRIB_TEXT performs the analogous validation for user-attribute text.

Supporting routines include SET_CTX, which populates session context values; POPULATE_USER_ATTRIB, which loads user-attribute data; LOCK_ALL_GRANTS and UNLOCK_ALL_GRANTS, which manage concurrency over grant definitions; GET_CURRENT_USER and GET_CURRENT_PARTY, which resolve the acting user and party; ADMIN_MODE, which toggles administrative processing; GENERATE_MESSAGE, which returns diagnostic messaging; RUN_DIAGNOSTIC, a self-test utility; and GETBODMASCONDITION, which parses or evaluates condition expressions using BODMAS precedence rules. The package follows the standard EBS API conventions (p_api_version, p_init_msg_list, p_commit, p_validation_level, x_return_status, x_msg_count, x_msg_data).

Tables Accessed

The package operates across the IGS_SC_* security schema. It reads and writes grant definitions in IGS_SC_GRANTS and their conditions in IGS_SC_GRANT_CONDS. Object metadata and object-level grants are handled through IGS_SC_OBJECTS, IGS_SC_OBJ_GRANTS, IGS_SC_OBJ_GROUPS, IGS_SC_OBJ_ATT_MTHS, and IGS_SC_OBJ_ATT_VALS. User-attribute data is sourced from IGS_SC_USR_ATTRIBS and IGS_SC_USR_ATT_VALS. The package resolves object registrations through FND_OBJECTS and role membership through WF_LOCAL_USER_ROLES. It uses the DBMS_SESSION built-in to set context and UTL_FILE for diagnostic output.

Usage Notes

Because IGS_SC_GRANTS_PVT is private, it is invoked indirectly: by the public IGS_SC_GRANTS API layer, by Student System forms that evaluate user entitlements at runtime, and by concurrent programs that regenerate grant records. The three packages that reference it call GENERATE_GRANT to obtain the WHERE-clause needed to filter object access, and call CONSTRUCT_GRANT when a specific grant must be resolved. CHECK_GRANT_TEXT is typically called during grant maintenance, when an administrator edits or imports grant text and the system must confirm the condition is valid before committing. Custom code should not call this package directly; the supported path is through the accompanying public API. In 12.2.2 the package behaves identically to 12.1.1, as no functional change is documented in the supplied metadata.