Search Results jtf_resource

Overview

JTF_CAL_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, documented for releases 12.1.1 and 12.2.2. It belongs to the Oracle CRM Technology Foundation (JTF) calendar infrastructure and serves as the internal engine behind the user-facing calendar functionality delivered through the Oracle Calendar and Resource Manager modules. The package is classified as PVT (private), meaning it is not intended as a public integration API; its subprograms are called by other JTF packages and by the calendar user interface layer rather than by customer extensions.

The package is closely tied to the JTF_RESOURCE entity model. Its record definitions explicitly reference JTF_RESOURCE identifiers, such as the ResourceID and ResourceType fields within the CalLstRec structure, which capture the logged-on user's resource identifier and resource type for persistence in the session cookie. Functional roles, groups, and group memberships defined in the JTF_RS tables determine which calendars a user may view and the access level granted to each. The package also manages calendar display preferences, including per-day start and end times, through the WeekTimePrefRec and Preference record types, and interacts with task-related tables to expose calendar items and task assignments.

Key Procedures and Functions

• GETCALENDARLIST — Returns the set of calendars available to the current user. The results are structured using the CalLstRec record type (ResourceID, ResourceType, CalendarName, AccessLevel) and collected into the CalLstTblType PL/SQL table. This procedure drives calendar selection lists in the user interface and reflects the user's resource identity, group memberships, and granted access levels.
• GETVIEW — Returns the calendar view for the requesting user, combining calendar items and task information with the user's stored preferences, such as day start and day end times. It supports rendering of day, week, and similar calendar presentations in the JTF calendar UI.

Both subprograms are documented entries in the 12.2.2 ETRM metadata; their parameter lists are not disclosed in the available documentation and should not be assumed.

Tables Accessed

The package reads and writes several categories of data through APPS synonyms. Calendar content is stored in JTF_CAL_ITEMS_B. Task-driven calendar entries come from JTF_TASKS_B and JTF_TASKS_TL, with task ownership and participation resolved through JTF_TASK_ALL_ASSIGNMENTS and JTF_TASK_STATUSES_B.

Resource identity and authorization data derive from JTF_RS_RESOURCE_EXTNS_TL, JTF_RS_GROUPS_TL, JTF_RS_GROUP_MEMBERS, and JTF_RS_GROUP_USAGES. Menu and object security checks draw on FND_GRANTS, FND_MENUS, and FND_OBJECTS, which govern function and data access for the logged-on resource. PLITBLM is the standard JTF PL/SQL table manipulation utility used for array handling within the package.

Usage Notes

JTF_CAL_PVT is invoked indirectly. The JTF calendar forms and the Oracle Calendar web components call the package to populate calendar lists and views, and five other packages reference it, indicating its role as a shared internal service layer. Because it is a private package, direct invocation from custom code is not supported; customizations requiring calendar data should use the documented public JTF APIs instead. Administrators troubleshooting calendar display or access issues should verify the underlying JTF_RS and FND_GRANTS configuration, since the package resolves visibility and access level from those tables at runtime.