DBA Data[Home] [Help]

APPS.EDW_GL_ACCT_M_C dependencies on DBMS_STATS

Line 307: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_sob_vset_lookup_table);

303: execute immediate l_stmt;
304: commit;
305:
306: --bug fix 3355535
307: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_sob_vset_lookup_table);
308:
309: logTime('Creating SOB-Value_set Lookup Table', l_log_timstamp);
310:
311: exception

Line 362: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_value_set_temp_table);

358: execute immediate l_stmt;
359: commit;
360:
361: --bug fix 3355535
362: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_value_set_temp_table);
363:
364: logTime('Creating Value_set Temp table', l_log_timstamp);
365: exception
366: when others then

Line 439: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_hie_temp_table_name);

435: execute immediate l_stmt;
436: VBHDEBUG('Created index on '||g_hie_temp_table_name||'(flex_value_set_id)');
437: commit;
438: --bug fix 3355535
439: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_hie_temp_table_name);
440:
441: logTime('Creating hierarchy temp table', l_log_timstamp);
442: exception
443: when others then

Line 521: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_value_temp_table);

517:
518: commit;
519:
520: --bug fix 3355535
521: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_value_temp_table);
522:
523: logTime('Creating value temp table', l_log_timstamp);
524: exception
525: when others then

Line 694: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_source_temp_table_name);

690: VBHDEBUG('');
691: execute immediate l_stmt;
692:
693: --bug fix 3355535
694: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_source_temp_table_name);
695:
696: EXCEPTION
697: WHEN OTHERS THEN
698: l_errbuf :=sqlerrm;

Line 924: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_value_orp_dup_table);

920:
921: commit;
922:
923: --bug fix 3355535
924: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_value_orp_dup_table);
925:
926: logTime('Creating orphan value duplication holder table', l_log_timstamp);
927: exception
928: when others then

Line 1027: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_value_con_dup_table);

1023:
1024: commit;
1025:
1026: --bug fix 3355535
1027: DBMS_STATS.GATHER_TABLE_STATS(l_owner,l_value_con_dup_table);
1028:
1029: logTime('Creating consolidation value duplication holder table', l_log_timstamp);
1030: exception
1031: when others then