Search Results get_grouproles

Overview

APPS.AMV_USER_PVT_W is a private PL/SQL package within the Oracle E-Business Suite application module commonly associated with resource and role management. It operates in the context of the AMV (Applications Management/User and Resource) schema family and functions as a wrapper layer that mediates interactions between the higher-level public API package AMV_USER_PVT and the outer interfaces consumed by forms, concurrent programs, and integration layers. The package is declared with AUTHID CURRENT_USER, meaning that its database objects are resolved under the privileges of the invoking user rather than the package owner, which is a deliberate design choice that enforces the security context of the caller when manipulating user, group, and resource role assignments.

The wrapper naming convention ("_W") and the presence of the ROSETTA_TABLE_COPY_IN and ROSETTA_TABLE_COPY_OUT procedures indicate this package serves as a bridge between the PL/SQL table-based interface expected by the public API and the Java or JTF-style nested table structures used by the middle tier and the applications framework. The user's search term, "get_grouproles," maps directly to the GET_GROUPROLES procedure exposed by this package, which retrieves the set of role assignments (responsibilities, access objects, or functional roles) associated with a user group.

Key Procedures and Functions

The documented procedures fall into three functional categories. The table-copy procedures — ROSETTA_TABLE_COPY_IN_P31 through P40 and their matching ROSETTA_TABLE_COPY_OUT counterparts — convert data between the JTF_VARCHAR2_TABLE, JTF_NUMBER_TABLE, and JTF_DATE_TABLE structures and the internal AMV varray types (amv_char_varray_type, amv_number_varray_type, amv_resource_obj_varray, amv_group_obj_varray, amv_access_obj_varray). These are plumbing routines invoked to marshal bulk collections across the interface boundary.

The role management procedures provide the substantive business functionality. FIND_RESOURCE locates a resource record. ADD_RESOURCEROLE, REMOVE_RESOURCEROLE, and REPLACE_RESOURCEROLE manage the assignment of roles to individual resources. Their counterparts ADD_GROUPROLE, REMOVE_GROUPROLE, REPLACE_GROUPROLE, and the retrieval procedure GET_GROUPROLES manage role assignment at the group level, which is the procedure relevant to the user's query. ADD_GROUP creates a new group definition. Together these form a complete CRUD surface for group- and resource-level role administration.

Tables Accessed

The metadata documents a single referenced table, PLITBLM, accessed through an APPS synonym. PLITBLM is a standard EBS transient work table used to stage PL/SQL collections for SQL operations, which is consistent with the bulk-conversion design of the rosetta procedures. The underlying persistent tables for users, groups, and role assignments are referenced indirectly through the base package AMV_USER_PVT rather than directly, keeping the wrapper largely independent of physical table layouts.

Usage Notes

AMV_USER_PVT_W is typically invoked from the resource and role administration forms within Oracle Applications, from concurrent programs that synchronize user/group role data, or from custom code that needs to call GET_GROUPROLES to enumerate group role assignments. Because the package is a wrapper, custom integrations should generally call the public AMV_USER_PVT API unless direct access to the specific typed wrappers is required. The package is not referenced by any other package, indicating it sits at the outer edge of the call stack and is intended for direct invocation.