Search Results get_instance_set_id

Overview

APPS.JTF_CAL_GRANTS_PVT is a private (PVT-classified) PL/SQL package body in the Oracle E-Business Suite CRM Foundation / Task Manager module. Its responsibility is to manage the granting and revoking of menu-based function security for Oracle Calendar and Task Manager resources. The package acts as a thin abstraction layer over the FND_GRANTS security framework, translating resource-level authorization requests into underlying fnd_grants_pkg calls that create and maintain rows in the FND security grant tables. In the 12.1.1 and 12.2.2 releases it is one of the supporting packages underpinning resource-level task access control, and it is referenced by three other packages in the EBS schema.

Key Procedures and Functions

The ETRM metadata records five documented program units in the package:

• UPDATEGRANTS — refreshes or synchronizes existing function/menu grants for calendar resources, aligning the FND_GRANTS records with current resource-task authorization data.
• REVOKEGRANTS — removes grants previously issued for a resource, effectively withdrawing access to the associated menu functions.
• INVOKEGRANTS — applies a set of grants to a resource, invoking the underlying fnd_grants_pkg.grant_function API to create the grant entries.
• GET_GRANT_GUID — returns the globally unique identifier (GUID) associated with a specific grant, allowing callers to reference the grant for later update or revocation.
• HAS_ACCESS_LEVEL — evaluates whether a given resource possesses a required access level, serving as the runtime authorization check used by calendar and task security logic.

Source excerpts from the same family of code also show helper functions such as get_username and get_instance_set_id, which resolve a resource's login name from JTF_RS_RESOURCE_EXTNS and look up the FND_OBJECT_INSTANCE_SETS identifier used to scope the grant set. The get_instance_set_id function is frequently referenced when diagnosing grants that fail to resolve to the correct instance set.

Tables Accessed

• FND_GRANTS — the primary store of grant records created, updated, or revoked by the package.
• FND_OBJECT_INSTANCE_SETS — supplies the instance-set identifier used to scope grants to the correct object instance set.
• FND_MENUS and FND_OBJECTS — resolve menu names and object definitions referenced during grant creation.
• FND_USER — resolves user information associated with resources.
• JTF_RS_RESOURCE_EXTNS — maps resource identifiers to user names and related resource attributes.
• PLITBLM — the FND PL/SQL index-by table type used by the grants API for bulk processing.

Usage Notes

JTF_CAL_GRANTS_PVT is typically invoked indirectly. Oracle Forms-based Calendar and Task Manager screens, as well as concurrent programs that provision or reconcile resource security, call this package to create, refresh, or remove function grants. The package follows the FND_API convention — procedures accept api_version, return success/error code outputs, and raise FND_API.G_EXC_UNEXPECTED_ERROR when the underlying grants call does not return 'T' for success. Because it is classified PVT, it is not part of the public API surface, and customizations should not call it directly; the supported integration point remains fnd_grants_pkg. Troubleshooting efforts centered on get_instance_set_id usually trace back to mismatches between the resource task instance set and the records in FND_OBJECT_INSTANCE_SETS.