DBA Data[Home] [Help]

APPS.CZ_IMP_SINGLE dependencies on FND_STATS

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

1420: END;
1421:
1422: IF(genStatisticsCz = 1)THEN
1423:
1424: fnd_stats.gather_table_stats('CZ', 'CZ_IMP_PS_NODES');
1425: fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');
1426: fnd_stats.gather_table_stats('CZ', 'CZ_XFR_PROJECT_BILLS');
1427: END IF;
1428:

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

1421:
1422: IF(genStatisticsCz = 1)THEN
1423:
1424: fnd_stats.gather_table_stats('CZ', 'CZ_IMP_PS_NODES');
1425: fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');
1426: fnd_stats.gather_table_stats('CZ', 'CZ_XFR_PROJECT_BILLS');
1427: END IF;
1428:
1429: --AT: The calculation of maximum_selected is moved here as we do reading into memory in batches and cannot

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

1422: IF(genStatisticsCz = 1)THEN
1423:
1424: fnd_stats.gather_table_stats('CZ', 'CZ_IMP_PS_NODES');
1425: fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');
1426: fnd_stats.gather_table_stats('CZ', 'CZ_XFR_PROJECT_BILLS');
1427: END IF;
1428:
1429: --AT: The calculation of maximum_selected is moved here as we do reading into memory in batches and cannot
1430: --calculate this inside the cycle which is possibly incomplete.

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

3295: COMMIT;
3296:
3297: IF(inGenStatistics = 1)THEN
3298:
3299: fnd_stats.gather_table_stats('BOM', 'BOM_EXPLOSIONS');
3300: END IF;
3301:
3302: IF(outError_code <> 0)THEN
3303: xERROR:=cz_utils.log_report(outErr_msg, 1, 'BOM_EXPLODER', 11276,inRunId);

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

3852: IF(genStatisticsCz = 1)THEN
3853: FOR i IN (SELECT src_table FROM cz_xfr_tables
3854: WHERE xfr_group='IMPORT'
3855: AND disabled='0') LOOP
3856: fnd_stats.GATHER_TABLE_STATS('CZ',i.src_table);
3857: END LOOP;
3858: END IF;
3859:
3860: ----4) Call all the import procedures in the order specified by ORDER_SEQ field of CZ_XFR_TABLES with XFR_GROUP='IMPORT'