Search Results get_grant_guid

Overview

APPS.JTF_CAL_GRANTS_PVT is a private PL/SQL package in the Oracle E-Business Suite CRM technology stack that manages grant-based access control for calendar and task resources. Its central business function is to translate a requested set of resource access assignments — a granter plus lists of read-only and full-access grantees — into the corresponding rows in the FND_GRANTS security model. The package declares AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the APPS schema owner, which is consistent with its classification as a PVT (private) API that is invoked internally rather than called directly by end-user code.

The package header defines a Grantee record type carrying a GranteeKey, GrantType, and AccessLevel, and a GranteeTbl PL/SQL table type indexed by BINARY_INTEGER for passing resource lists. A set of constants binds the package to the calendar domain: the object name JTF_TASK_RESOURCE, the roles and privileges JTF_CAL_READ_ACCESS and JTF_CAL_FULL_ACCESS, the instance type INSTANCE, the resource type RS_EMPLOYEE, and the grantee type USER.

Key Procedures and Functions

The documented API surface consists of five entry points. UpdateGrants is the primary maintenance routine: given a granter, a list of read-only grantees, and a list of full-access grantees, it reconciles the stored grants so that the correct grants are created or deleted to match the requested state. RevokeGrants removes grant records, typically when a resource is unshared or a user's access is withdrawn. InvokeGrants performs the actual grant creation or invocation logic against the security model. Get_Grant_Guid returns the globally unique identifier associated with a grant, allowing callers to resolve or reference an existing grant record — this is the routine most commonly sought by developers searching for grant GUID resolution. Has_Access_Level is a validation function that determines whether a grantee holds a given access level, supporting authorization checks before calendar or task data is displayed or modified. No public parameter lists are declared; the procedures rely on the documented record and table types where lists of grantees are involved.

Tables Accessed

The package reads and writes FND_GRANTS, the core repository of grant records keyed by grantee, object, and instance. It consults FND_OBJECTS and FND_OBJECT_INSTANCE_SETS to resolve the JTF_TASK_RESOURCE object and its instance sets, and FND_MENUS where menu-based grant definitions apply. FND_USER resolves usernames to user identities, while JTF_RS_RESOURCE_EXTNS maps resource identifiers to the resource extension records used by the calendar and task modules. PLITBLM is the standard EBS PL/SQL table-to-string utility used for constructing and parsing delimited identifier lists, supporting the bulk grantee operations.

Usage Notes

As a PVT package, JTF_CAL_GRANTS_PVT is not intended for direct invocation from custom code. It is called by other packages — the metadata records three referencing packages — within the calendar and task resource sharing flows, and underlies the sharing and access-level functionality exposed through the Calendar and Task Manager forms in EBS 12.1.1 and 12.2.2. Customizations that need equivalent behavior should call the publicly documented wrapper APIs rather than this package, and any direct use of Get_Grant_Guid should account for the AUTHID CURRENT_USER semantics and the fact that grant records are keyed to the FND security model.