eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CZ_IMP_SINGLE dependencies on FND_STATS

Line 1477: fnd_stats.gather_table_stats('CZ', 'CZ_IMP_PS_NODES');

1473: --IF (czGatherStatsCnt > v_batchSize OR inPlanLevel = 0) THEN
1474: IF (czGatherStatsCnt > v_batchSize) THEN
1475: czGatherStatsCnt := 0;
1476: x_error:=cz_utils.log_report('Gather Stats : Start' ,1,'EXTRACTION',11299,inRun_Id);
1477: fnd_stats.gather_table_stats('CZ', 'CZ_IMP_PS_NODES');
1478: --bug 9496782 comment out following call
1479: -- fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');
1480: fnd_stats.gather_table_stats('CZ', 'CZ_XFR_PROJECT_BILLS');
1481: x_error:=cz_utils.log_report('Gather Stats : End',1,'EXTRACTION',11299,inRun_Id);

Line 1479: -- fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');

1475: czGatherStatsCnt := 0;
1476: x_error:=cz_utils.log_report('Gather Stats : Start' ,1,'EXTRACTION',11299,inRun_Id);
1477: fnd_stats.gather_table_stats('CZ', 'CZ_IMP_PS_NODES');
1478: --bug 9496782 comment out following call
1479: -- fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');
1480: fnd_stats.gather_table_stats('CZ', 'CZ_XFR_PROJECT_BILLS');
1481: x_error:=cz_utils.log_report('Gather Stats : End',1,'EXTRACTION',11299,inRun_Id);
1482:
1483: if (CZ_IMP_ALL.get_time) then

Line 1480: fnd_stats.gather_table_stats('CZ', 'CZ_XFR_PROJECT_BILLS');

1476: x_error:=cz_utils.log_report('Gather Stats : Start' ,1,'EXTRACTION',11299,inRun_Id);
1477: fnd_stats.gather_table_stats('CZ', 'CZ_IMP_PS_NODES');
1478: --bug 9496782 comment out following call
1479: -- fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');
1480: fnd_stats.gather_table_stats('CZ', 'CZ_XFR_PROJECT_BILLS');
1481: x_error:=cz_utils.log_report('Gather Stats : End',1,'EXTRACTION',11299,inRun_Id);
1482:
1483: if (CZ_IMP_ALL.get_time) then
1484: end_time := dbms_utility.get_time();

Line 3527: fnd_stats.gather_table_stats('BOM', 'BOM_EXPLOSIONS');

3523: COMMIT;
3524:
3525: IF(inGenStatistics = 1)THEN
3526:
3527: fnd_stats.gather_table_stats('BOM', 'BOM_EXPLOSIONS');
3528: END IF;
3529:
3530: IF(outError_code <> 0)THEN
3531: xERROR:=cz_utils.log_report(outErr_msg, 1, 'BOM_EXPLODER', 11276,inRunId);

Line 4206: fnd_stats.GATHER_TABLE_STATS('CZ',i.src_table);

4202: IF(genStatisticsCz = 1)THEN
4203: FOR i IN (SELECT src_table FROM cz_xfr_tables
4204: WHERE xfr_group='IMPORT'
4205: AND disabled='0') LOOP
4206: fnd_stats.GATHER_TABLE_STATS('CZ',i.src_table);
4207: END LOOP;
4208: END IF;
4209:
4210: ----4) Call all the import procedures in the order specified by ORDER_SEQ field of CZ_XFR_TABLES with XFR_GROUP='IMPORT'