Search Results replace_grouprole

Overview

AMV_USER_PVT is a private PL/SQL API within the Oracle E-Business Suite Advanced Marketing (AMV) module, declared with AUTHID CURRENT_USER. Its header revision ($Header: amvvusrs.pls 120.1 2005/06/30) places its origins in the early 11i-era codebase that was carried forward into EBS 12.1.1 and 12.2.2. The package forms the core of the user profile block API in AMV, handling users (marketing resources) and their associated profile attributes, including privileges and access rights.

The package is classified as PVT (private), meaning it is intended for internal consumption by other AMV packages rather than direct invocation by customers. The metadata records 59 documented procedures and functions, and the package is referenced by eight other packages, confirming its role as a foundational service layer. It governs three interrelated domains: resource management, group management, and the assignment of roles, membership, and access rights among them.

Key Procedures and Functions

The user's search term "replace_grouprole" corresponds to REPLACE_GROUPROLE, one of the group role maintenance procedures. Its purpose is to replace the existing role assignment for a marketing group with a new role configuration, a common pattern in AMV where incremental add/remove calls are consolidated into a single replace operation.

• Resource procedures: GET_RESOURCEID and FIND_RESOURCE locate and identify marketing resources.
• Resource role procedures: ADD_RESOURCEROLE, REMOVE_RESOURCEROLE, REPLACE_RESOURCEROLE, GET_RESOURCEROLES, and CHECK_RESOURCEROLE manage direct role assignments to individual resources.
• Privilege checks: IS_ADMINISTRATOR, CAN_PUBLISHCONTENT, CAN_APPROVECONTENT, CAN_SETUPCHANNEL, CAN_SETUPCATEGORY, and CAN_SETUPDISTRULE return authorization flags used for UI and workflow gating.
• Group role procedures: ADD_GROUPROLE, REMOVE_GROUPROLE, REPLACE_GROUPROLE, GET_GROUPROLES, and CHECK_GROUPROLE parallel the resource role set but apply to groups.
• Group procedures: ADD_GROUP, UPDATE_GROUP, and related maintenance routines manage the group entity itself.

Tables Accessed

The package operates against AMV and shared JTF tables through APPS synonyms. AMV_U_ACCESS and AMV_U_ACCESS_S store resource and group access grants, with the _S table supporting primary key generation. AMV_C_CHANNELS_B and AMV_C_CHANNELS_TL define channels and their translations, while AMV_U_MY_CHANNELS supports personalized channel listings. AMS_DELIVERABLES_ALL_B underpins content and category operations tied to the CAN_* privilege checks.

Group data resides in JTF_RS_GROUP_MEMBERS, JTF_RS_GROUPS_TL, and JTF_RS_GROUP_USAGES, with resource extensions and role relationships in JTF_RS_RESOURCE_EXTNS and JTF_RS_ROLE_RELATIONS. DUAL and PLITBLM are used for constant evaluation and PL/SQL table handling in bulk operations.

Usage Notes

Because AMV_USER_PVT is private, it is not exposed through the standard concurrent program or form interface. It is invoked by the eight dependent AMV packages and by AMV forms that need to persist resource, group, role, or access changes. Custom code should prefer the public AMV API layers; direct calls to AMV_USER_PVT risk breakage across patch levels, as evidenced by the 2005 header revision still shipping in 12.x. When troubleshooting "replace_grouprole" issues, verify that the group exists, that the acting resource passes IS_ADMINISTRATOR or the relevant CAN_* check, and that JTF_RS_ROLE_RELATIONS and JTF_RS_GROUP_MEMBERS rows are consistent.