Search Results has_access_level

Overview

The APPS.JTF_CAL_GRANTS_PVT_W package is a PL/SQL wrapper in the Oracle E-Business Suite Calendar (JTF) module, declared with AUTHID CURRENT_USER so that it executes under the privileges of the calling session rather than its owner. The _W suffix and the presence of Rosetta table copy procedures identify this as a thin interoperability layer generated to expose the private package JTF_CAL_GRANTS_PVT to non-PL/SQL clients, most commonly Java-based middle-tier services, OAF/BC4J components, or SOA/Bpel integrations. Its core business function is to answer authorization questions about calendar resources: given a resource and a group, the package determines whether the group has been granted a particular access level on that resource. In this way it supports the access control model that governs shared calendars, resource scheduling, and group-based visibility within Oracle EBS.

Key Procedures and Functions

The package exposes three documented procedures. Two are structural utilities used for data marshalling between the PL/SQL record type jtf_cal_grants_pvt.granteetbl and the scalar collection types acceptable across a JDBC or .NET boundary:

• ROSETTA_TABLE_COPY_IN_P1 — converts inbound scalar collections (a 300-character VARCHAR2 table, a NUMBER table, and a 100-character VARCHAR2 table) into the internal grantee table record structure for processing inside the private package.
• ROSETTA_TABLE_COPY_OUT_P1 — performs the reverse conversion, taking the internal grantee table and populating the outbound scalar collections so results can be serialized back to the calling client.
• HAS_ACCESS_LEVEL — the substantive API. It accepts a resource identifier (p_resourceid) and a group identifier (p_groupid) and returns a boolean-equivalent numeric value through ddrosetta_retval_bool, indicating whether the specified group holds an access level on the given resource. It is the direct answer to the has_access_level search term.

No other public members appear in the documented specification; all remaining logic resides in the underlying private package.

Tables Accessed

The only table documented as referenced through APPS synonyms is PLITBLM. This is a PL/SQL internal table used by the Rosetta/table-copy mechanism to stage collection data during the copy-in and copy-out operations. The package does not directly read or write the persistent grant definition tables; those reads are delegated to JTF_CAL_GRANTS_PVT, which the wrapper calls. Consequently, the wrapper itself is largely stateless and performs no transactional DML of its own.

Usage Notes

Because the package is a wrapper, it is seldom invoked directly by end users or concurrent programs. It is typically called from:

• Java or middle-tier code that must evaluate calendar resource permissions without embedding PL/SQL record semantics.
• Custom PL/SQL or OAF pages that need a lightweight grant-check call when full grant maintenance forms are unnecessary.
• Integration flows that mirror the same authorization rule as the standard Calendar UI.

Callers should treat the returned numeric flag as a boolean, since the wrapper performs no exception translation beyond what the private package raises. As the header indicates a 2002 vintage and the metadata classifies the API as OTHER, this object should be considered stable but internal; direct dependencies are unsupported, and any custom code relying on it should be validated against the target release (12.1.1 or 12.2.2) before deployment.