Function
name

Type Oracle or MSSQL

Parameter Type Oracle or MSSQL

Returns
Oracle/MSSQL

Description

ExpandGroups

Function

WGNWC_HIER_EXPAND_GROUP_TAB/

TABLE(

GroupIDM INTEGER,
GroupID INTEGER,
RollupIDM INTEGER,
RollupID INTEGER,
ManagerIDM INTEGER,
ManagerID INTEGER,
Hierarchy INTEGER,
GrpLevel INTEGER,
GroupName NVARCHAR(255),
FullPath NVARCHAR(1000)
)

Expands the group hierarchy from the defined point (default is root) and returns a table of groups.

NUMBER/ INTEGER

The IDM of the start group

NUMBER/ INTEGER

The ID of the start group