Search Results igs_sc_grants_pvt




Overview
Explore in AI Chat

Overview

IGS_SC_GRANTS_PVT is a private PL/SQL package body in the APPS schema that underpins the Oracle E-Business Suite Student Systems "Sales and Catalog" (SC) subsystem, specifically the grant security model. Grants define what objects, object groups, and attribute methods a user, party, or role may access within the institution's self-service and administrative functions. This package encapsulates the internal logic that evaluates, constructs, locks, and unlocks those grants at runtime. Because it is classified as a PVT package, it is not intended to be called directly by external consumers; instead, it is invoked by the public API layer (notably IGS_SC_DATA_SEC_APIS_PKG) and by the grants metadata itself. The package body is reported VALID, confirming that it compiles cleanly against the APPS schema in EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents fifteen procedures and functions. Their names indicate the following responsibilities:

Parameter signatures are not reproduced here; only documented purpose is summarized.

Tables Accessed

The package reads and writes grant metadata across the SC schema. Configuration tables include IGS_SC_GRANTS (master grant definitions), IGS_SC_GRANT_CONDS (conditions attached to grants), IGS_SC_OBJECTS and IGS_SC_OBJ_GROUPS (securable objects and groupings), IGS_SC_OBJ_ATT_MTHS and IGS_SC_OBJ_ATT_VALS (object attribute methods and permitted values), IGS_SC_OBJ_GRANTS (object-to-grant mapping), IGS_SC_USR_ATTRIBS and IGS_SC_USR_ATT_VALS (user attribute definitions and values), and IGS_SC_VARS (runtime variables). External dependencies include FND_OBJECTS for object registration, WF_LOCAL_USER_ROLES for role resolution, and DBMS_SESSION and UTL_FILE for session and file operations.

Usage Notes

IGS_SC_GRANTS_PVT is typically invoked indirectly through IGS_SC_DATA_SEC_APIS_PKG from Oracle Forms, self-service pages, and concurrent programs that require grant evaluation. It is referenced by three other database objects, confirming its role as a shared internal service. Because it is a private package, customizations should call the public data-security APIs rather than the PVT procedures, and any direct invocation must respect the SET_CTX and ADMIN_MODE prerequisites established in the session.