DBA Data[Home] [Help]

APPS.WF_LOCAL_SYNCH dependencies on WF_ROLE_HIERARCHIES

Line 1637: UPDATE WF_ROLE_HIERARCHIES

1633:
1634: --These tables are not partitioned, but do have fk references and may later
1635: --be partitioned on one of these partition ids so we are specifying the
1636: --partition id here.
1637: UPDATE WF_ROLE_HIERARCHIES
1638: SET SUB_NAME = g_name
1639: WHERE SUB_NAME = g_oldName
1640: AND PARTITION_ID = l_partitionID;
1641:

Line 1642: UPDATE WF_ROLE_HIERARCHIES

1638: SET SUB_NAME = g_name
1639: WHERE SUB_NAME = g_oldName
1640: AND PARTITION_ID = l_partitionID;
1641:
1642: UPDATE WF_ROLE_HIERARCHIES
1643: SET SUPER_NAME = g_name
1644: WHERE SUPER_NAME = g_oldName
1645: AND SUPERIOR_PARTITION_ID = l_partitionID;
1646: