DBA Data[Home] [Help]

APPS.WF_LOCAL_SYNCH dependencies on WF_ROLE_HIERARCHIES

Line 1650: UPDATE WF_ROLE_HIERARCHIES

1646:
1647: --These tables are not partitioned, but do have fk references and may later
1648: --be partitioned on one of these partition ids so we are specifying the
1649: --partition id here.
1650: UPDATE WF_ROLE_HIERARCHIES
1651: SET SUB_NAME = g_name
1652: WHERE SUB_NAME = g_oldName
1653: AND PARTITION_ID = l_partitionID;
1654:

Line 1655: UPDATE WF_ROLE_HIERARCHIES

1651: SET SUB_NAME = g_name
1652: WHERE SUB_NAME = g_oldName
1653: AND PARTITION_ID = l_partitionID;
1654:
1655: UPDATE WF_ROLE_HIERARCHIES
1656: SET SUPER_NAME = g_name
1657: WHERE SUPER_NAME = g_oldName
1658: AND SUPERIOR_PARTITION_ID = l_partitionID;
1659: