Search Results update_grants

Overview

The APPS.CAC_CAL_PRIVS_PVT package is a private PL/SQL API within the Oracle E-Business Suite Calendar and Appointment management module. Its principal business function is to administer privilege grants that control user access to calendar-related resources such as appointments, tasks, and bookings. The package encapsulates the logic required to create and modify entries in the Oracle Applications security model, specifically the FND_GRANTS framework, so that individual users (grantees) are assigned defined levels of access for a specified effective date range.

As indicated by the _PVT suffix, this is an internal implementation package. It is not intended to be called directly by external developers or integrators. Instead, it supports the public-facing calendar privilege UI and the associated business logic that drives grant management. It operates within a defined grantee model, where a grantee is identified by user name and receives a set of access flags governing appointments, tasks, and bookings over a bounded validity period.

Key Procedures and Functions

The package exposes two documented procedures:

• CREATE_GRANTS — Establishes a new privilege grant for a specified grantee. It accepts the grantee user name together with start and end dates that bound the grant's active period, and three access indicators governing appointment access, task access, and booking access. It returns a standard API return status along with message count and message data for error handling. This procedure seeds the initial grant record.
• UPDATE_GRANTS — Modifies an existing privilege grant for a grantee. It mirrors the parameter structure of CREATE_GRANTS, allowing the caller to revise the grantee's effective dates and the three access flags, and likewise returns the standard status, message count, and message data outputs.

The symmetry between these two procedures reflects a straightforward lifecycle: grants are first created and subsequently amended as a grantee's access requirements change. Both follow the conventional EBS PL/SQL API contract of returning x_return_status, x_msg_count, and x_msg_data to communicate success or failure.

Tables Accessed

The package interacts with the Oracle Applications security and menu infrastructure through APPS synonyms:

• FND_GRANTS — Stores the actual grant records created and updated by the package, linking grantees to the objects and permissions they may access.
• FND_MENUS — Represents the menu structures associated with the calendar privilege objects, ensuring access is scoped to the correct functional navigation.
• FND_OBJECTS — Defines the securable objects (appointments, tasks, bookings) against which grants are applied.
• FND_OBJECT_INSTANCE_SETS — Provides instance set definitions that qualify which object instances a grant applies to.

Together these tables constitute the foundation of the Oracle Applications object-grant security model that the package manipulates.

Usage Notes

CAC_CAL_PRIVS_PVT is invoked indirectly through the Calendar privilege maintenance forms and supporting calendar business logic. It is documented as being referenced by zero other packages, confirming that it represents a leaf-level implementation detail rather than a widely reused API. The package header carries a $Header tag dated 2005 with the "noship" designation, indicating it is a shipped-private object not exposed for customer extension.

Developers should not call this package directly. Customizations requiring calendar privilege changes should use the supported public APIs or forms that internally delegate to this private package. Direct invocation risks bypassing validation enforced at the public layer and could produce inconsistent grant records across FND_GRANTS and the related object definitions.