Search Results jtf_task_resource_tasks

Overview

The APPS.JTF_TASK_SECURITY_PVT package is a private PL/SQL API within Oracle E-Business Suite that implements data-level security for the Oracle Tasks (JTF) framework. It governs which users and resources may view or modify task records, including globally shared tasks, private tasks, and tasks associated with specific resources, teams, or groups. The package encapsulates the privilege-checking logic used by the Task Management and interaction/calendar modules, evaluating grants against the object model stored in the FND security tables and the JTF resource structures.

The source header declares the package with AUTHID CURRENT_USER, indicating that privilege evaluation and any dynamic SQL execute under the privileges of the calling schema at runtime. The package body (version 115.13, last shipped 2003) exposes constants such as TASK_OBJECT mapped to JTF_TASKS, the access roles JTF_TASK_READ_ONLY and JTF_TASK_FULL_ACCESS, and the resource set JTF_TASK_RESOURCE_TASKS. These constants align the package’s security vocabulary with the functional security configuration maintained through FND grants and menus. Being classified as a private (PVT) package, it is intended for internal use by other JTF components rather than as a public integration point.

Key Procedures and Functions

The package documents eight program units. The most prominent, and the entry the user searched for, is GET_PRIVILEGES. This procedure acts as a wrapper around a lower-level FND privilege utility, purpose-built to support the Java API for task security. It resolves the privileges available to a named user against a specified object and, optionally, a specific instance identified by up to five primary key values; when no instance key is supplied, only global grants are checked. It returns a status code and a table of privilege names. The source comment explicitly cautions that the procedure should not be used without consultation with its original owners.

The remaining units provide focused security and metadata queries:

• CHECK_PRIVELEGE_FOR_TASK — returns the privilege held by a resource (identified by resource ID and type) for a given task.
• CHECK_PRIVATE_TASK_PRIVELEGE — validates access to a private task for a specific resource and resource type code.
• PRIVELEGES_FROM_OTHER_RESOURCE — derives privileges inherited from an associated resource.
• GET_OBJECT_NAME — maps an object code to its object name.
• GET_CATEGORY_ID — retrieves the category identifier for a task/resource combination.
• GET_DEFAULT_QUERY — resolves a query identifier from a profile name and parameter name.
• DELETE_CATEGORY — removes a category assignment.

Tables Accessed

The package queries the FND security infrastructure — FND_OBJECTS, FND_GRANTS, FND_FORM_FUNCTIONS, FND_MENUS, and FND_MENU_ENTRIES — to translate functional configuration into effective privileges. Task definitions are read from JTF_OBJECTS_B, JTF_OBJECTS_TL, and JTF_TASKS_B. Resource and team context is obtained from JTF_RS_TEAM_MEMBERS and JTF_RS_GROUP_MEMBERS, while address data comes from JTF_CAL_ADDRESSES. Personalization and saved query configuration is sourced from JTF_PERZ_DATA, JTF_PERZ_PROFILE, JTF_PERZ_QUERY, and JTF_PERZ_QUERY_PARAM.

Usage Notes

Because JTF_TASK_SECURITY_PVT is classified as private, it is invoked internally by JTF task UI forms, the task Java API, and other JTF packages — the metadata records three dependent packages. Custom code should treat it as unsupported and subject to change across releases such as 12.1.1 and 12.2.2; no direct calls should be introduced without validating behavior against the specific patch level.