DBA Data[Home] [Help]

APPS.WF_MAINTENANCE dependencies on WF_ROLE_HIERARCHIES

Line 2256: -- Determine rows to change in WF_ROLE_HIERARCHIES. Applies to roles only

2252: AND USER_ORIG_SYSTEM_ID = l_roleInfoTAB(1).ORIG_SYSTEM_ID);
2253: l_wfcount_tab.TABLE_NAME := 'WF_USER_ROLE_ASSIGNMENTS';
2254: pipe ROW (l_wfcount_tab);
2255:
2256: -- Determine rows to change in WF_ROLE_HIERARCHIES. Applies to roles only
2257: if l_roleInfoTAB(1).ORIG_SYSTEM NOT in ('PER','FND_USR') then
2258: select sum (a.detail) into l_wfcount_tab.REC_CNT
2259: from (select nvl(count(1), 0) as detail
2260: from WF_ROLE_HIERARCHIES

Line 2260: from WF_ROLE_HIERARCHIES

2256: -- Determine rows to change in WF_ROLE_HIERARCHIES. Applies to roles only
2257: if l_roleInfoTAB(1).ORIG_SYSTEM NOT in ('PER','FND_USR') then
2258: select sum (a.detail) into l_wfcount_tab.REC_CNT
2259: from (select nvl(count(1), 0) as detail
2260: from WF_ROLE_HIERARCHIES
2261: WHERE SUPER_NAME = p_name
2262: AND SUPERIOR_PARTITION_ID = l_partitionID
2263: union
2264: select nvl(count(1), 0) as detail

Line 2265: from WF_ROLE_HIERARCHIES

2261: WHERE SUPER_NAME = p_name
2262: AND SUPERIOR_PARTITION_ID = l_partitionID
2263: union
2264: select nvl(count(1), 0) as detail
2265: from WF_ROLE_HIERARCHIES
2266: WHERE SUB_NAME = p_name
2267: AND PARTITION_ID = l_partitionID) a;
2268: else
2269: l_wfcount_tab.REC_CNT := 0;

Line 2271: l_wfcount_tab.TABLE_NAME := 'WF_ROLE_HIERARCHIES';

2267: AND PARTITION_ID = l_partitionID) a;
2268: else
2269: l_wfcount_tab.REC_CNT := 0;
2270: end if;
2271: l_wfcount_tab.TABLE_NAME := 'WF_ROLE_HIERARCHIES';
2272: pipe ROW (l_wfcount_tab);
2273: end if;
2274: return;
2275: exception