Results for “p_group_type”

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

Overview

CSM_GROUP_DOWNLOAD_PVT is a private PL/SQL package in the APPS schema that supports the group download and synchronization features of Oracle E-Business Suite's customer-facing group management framework. It provides the programmatic interface used to populate and remove the associations between application users and the "groups" to which they belong within the CSM (Customer Service Management / group download) subsystem. In EBS 12.1.1 and 12.2.2, this package is classified as a PVT (private) API, meaning it is intended for internal consumption by other EBS packages and does not constitute a public, supported integration interface. Its procedures handle both the assignment of a user's personal "my group" construct and the assignment of users to shared groups owned by another party, with a group type discriminator used to distinguish categories of group membership.

Key Procedures and Functions

• INSERT_MY_GROUP — Establishes a user's own (personal) group record. It is invoked to create the "my group" entry associated with a given user identifier.
• DELETE_MY_GROUP — Removes the personal group record previously created for a user, typically on teardown, reassignment, or cleanup operations.
• INSERT_GROUP_ACC — Inserts a group access/membership association, linking a user to a specific group owned by a given owner and qualified by a group type. The p_group_type parameter (the term the user searched for) is the value that classifies the nature of the group being downloaded or shared, allowing the same routine to service multiple group categories without separate code paths.
• DELETE_GROUP_ACC — Removes an existing group access association for a user and group, reversing the effect of INSERT_GROUP_ACC.

Each procedure returns a standard EBS return status and error message so callers may inspect success or failure without raising unhandled exceptions.

Tables Accessed

• ASG_USER — Holds user-related assignment data used to validate and locate the user whose group records are being maintained.
• CSM_GROUPS — The core group definition table that stores the group records created and deleted by the "my group" procedures.
• JTF_RS_GROUPS_B — The resource group base table used to resolve and persist the group access associations handled by the INSERT_GROUP_ACC and DELETE_GROUP_ACC procedures.

All three tables are referenced through APPS synonyms, consistent with the package's AUTHID CURRENT_USER declaration and its position within the APPS schema.

Usage Notes

Because CSM_GROUP_DOWNLOAD_PVT is classified as a private API and is referenced by two other EBS packages, it is normally invoked indirectly rather than from custom code or directly bound to a form or concurrent program. In practice it acts as a back-end worker called during group download processing, when user-to-group assignments must be materialized or purged as part of broader CSM synchronization logic. The p_group_type parameter on INSERT_GROUP_ACC is significant because it lets the calling package drive multiple group classifications through a single insertion routine, so the value supplied must correspond to a valid group type known to the CSM framework. As a PVT object, its signature and behavior may change between releases and it carries no public API guarantee; any custom dependency should be reviewed carefully during upgrades from 12.1.1 to 12.2.2 and beyond.