DBA Data[Home] [Help]

APPS.WF_LOCAL_SYNCH dependencies on FND_STATS

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

2214: end;
2215:
2216: if (l_importSuccess) then
2217: --Gather Table Statistics
2218: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2219: TABNAME=>'WF_LOCAL_ROLES_TL_STAGE',
2220: PERCENT=>10);
2221:
2222: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

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

2369: end;
2370:
2371: if (l_importSuccess) then
2372: --Gather Table Statistics
2373: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2374: TABNAME=>'WF_LOCAL_ROLES_STAGE',
2375: PERCENT=>10);
2376:
2377: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

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

2593: --synchronize.
2594:
2595: if (l_importSuccess) then
2596: --Gather Table Statistics
2597: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2598: TABNAME=>'WF_LOCAL_USER_ROLES_STAGE',
2599: PERCENT=>10);
2600:
2601: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT, l_modulePkg,

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

2603:
2604: Create_Stage_Indexes (p_sourceTable=>'WF_LOCAL_USER_ROLES',
2605: p_targetTable=>'WF_LOCAL_USER_ROLES_STAGE');
2606:
2607: FND_STATS.Gather_Table_Stats(OWNNAME=>wf_schema,
2608: TABNAME=>'WF_UR_ASSIGNMENTS_STAGE',
2609: PERCENT=>10);
2610:
2611: Create_Stage_Indexes (p_sourceTable=>'WF_USER_ROLE_ASSIGNMENTS',