APPS.BIM_I_SRC_CODE_PKG dependencies on DBMS_STATS

Line 718: DBMS_STATS.gather_table_stats('BIM','BIM_I_SOURCE_CODES', estimate_percent => 5,

714: --fnd_file.put_line(fnd_file.log,fnd_message.get);
715: bis_collection_utilities.log('Before Analyze of the table BIM_I_SOURCE_CODES');
716:
717: --Analyze the facts table
718: DBMS_STATS.gather_table_stats('BIM','BIM_I_SOURCE_CODES', estimate_percent => 5,
719: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
720:
721: --EXECUTE IMMEDIATE ('TRUNCATE TABLE '||l_schema||'.MLOG$_BIM_I_SOURCE_CODES');
722:

Line 761: DBMS_STATS.gather_table_stats('BIM','bim_i_resource', estimate_percent => 5,

757:
758:
759:
760:
761: DBMS_STATS.gather_table_stats('BIM','bim_i_resource', estimate_percent => 5,
762: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
763:
764: bis_collection_utilities.log('End Initial Load of Resource_ids');
765:

Line 1451: DBMS_STATS.gather_table_stats('BIM','BIM_I_SOURCE_CODES', estimate_percent => 5,

1447:
1448: bis_collection_utilities.log('Before Analyze of the table BIM_I_SOURCE_CODES');
1449:
1450: --Analyze the facts table
1451: DBMS_STATS.gather_table_stats('BIM','BIM_I_SOURCE_CODES', estimate_percent => 5,
1452: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
1453:
1454: /************--Start--********To get Resource ids of Active Employees***************************/
1455:

Line 1506: DBMS_STATS.gather_table_stats('BIM','bim_i_resource', estimate_percent => 5,

1502:
1503:
1504:
1505:
1506: DBMS_STATS.gather_table_stats('BIM','bim_i_resource', estimate_percent => 5,
1507: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
1508:
1509: bis_collection_utilities.log('End Initial Load of Resource_ids');
1510: