DBA Data[Home] [Help]

APPS.WF_LOCAL_SYNCH dependencies on FND_STATS

Line 2164: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,

2160: end;
2161:
2162: if (l_importSuccess) then
2163: --Gather Table Statistics
2164: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2165: TABNAME=>'WF_LOCAL_ROLES_TL_STAGE',
2166: PERCENT=>10);
2167:
2168: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

Line 2315: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,

2311: end;
2312:
2313: if (l_importSuccess) then
2314: --Gather Table Statistics
2315: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2316: TABNAME=>'WF_LOCAL_ROLES_STAGE',
2317: PERCENT=>10);
2318:
2319: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

Line 2531: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,

2527: --synchronize.
2528:
2529: if (l_importSuccess) then
2530: --Gather Table Statistics
2531: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2532: TABNAME=>'WF_LOCAL_USER_ROLES_STAGE',
2533: PERCENT=>10);
2534:
2535: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

Line 2541: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,

2537:
2538: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_USER_ROLES',
2539: p_targetTable=>'WF_LOCAL_USER_ROLES_STAGE');
2540:
2541: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2542: TABNAME=>'WF_UR_ASSIGNMENTS_STAGE',
2543: PERCENT=>10);
2544:
2545: Create_Stage_Indexes (p_sourceTable=>'WF_USER_ROLE_ASSIGNMENTS',