Results for “delete_my_group”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSM_GROUP_DOWNLOAD_PVT is a private PL/SQL package belonging to the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It forms part of the CSM (Customer Support / group management) module architecture and provides the low-level implementation logic that keeps group membership records synchronized between the base group table and the access-control framework. Its header ($Header: csmegrpb.pls 120.4 2008/02/29) indicates it has been a stable component of the codebase since the early 12.x releases.

The package operates on the principle that the same physical table, CSM_GROUPS, serves as both the base table and the access (security) table for group records. Constants declared in the package body — g_grp_acc_table_name, g_grp_table_name, g_grp_seq_name, g_grp_pk1_name, and the publication item list g_grp_pubi_name — bind this dual role to the CSM_ACC_PKG access-control framework. Consequently, the package's core responsibility is to insert and delete rows in CSM_GROUPS while simultaneously registering or removing the corresponding access entries through CSM_ACC_PKG.

Key Procedures and Functions

• INSERT_MY_GROUP — Inserts a group record into CSM_GROUPS during user creation. It queries ASG_USER for enabled users that do not yet have an associated 'C' (customer) type group owned by their ASG owner, then calls CSM_ACC_PKG.Insert_Acc with the package's publication item list, sequence, and primary key metadata to register the access record, and finally updates the newly created group row.
• DELETE_MY_GROUP — Performs the inverse operation, removing the group record and its associated access entry when a user's personal group is no longer required.
• INSERT_GROUP_ACC — Creates the access-control row for a group in CSM_GROUPS, invoking the CSM_ACC_PKG framework with the group sequence and primary key values supplied by the caller.
• DELETE_GROUP_ACC — Removes the access-control row associated with a given group, ensuring that security entries do not become orphaned when groups are deleted.

All procedures return standard x_return_status and x_error_message OUT parameters and use CSM_UTIL_PKG.LOG for diagnostic logging at statement and exception levels.

Tables Accessed

• CSM_GROUPS — The central table, used as both the base group store and the access table. The package inserts, updates, and deletes rows here, and reads existing records to avoid duplicate group creation.
• ASG_USER — Read to identify the user and owner IDs for which a personal group must be created. The cursor filters to enabled users and excludes those already owning a 'C' type group.
• JTF_RS_GROUPS_B — The resource group base table, referenced in support of group definition and membership consistency across the CRM resource manager schema.

Usage Notes

As a private (PVT) package, CSM_GROUP_DOWNLOAD_PVT is not part of the public API surface and is not intended for direct invocation by customer extensions. It is referenced by two other packages within the CSM layer, which act as its callers. Typical invocation points include user-creation and user-termination workflows in Oracle EBS, where a personal group must be provisioned or removed automatically, and group maintenance processing triggered from CRM forms or concurrent programs that manage group-based access to customer information.

Customizations should avoid calling this package directly. Instead, integrators should invoke the higher-level public APIs or the standard user-management flows that trigger these private procedures, so that both the CSM_GROUPS record and its access-control counterpart remain consistent.