DBA Data[Home] [Help]

APPS.POS_BULKLOAD_ENTITIES dependencies on FND_STATS

Line 1078: fnd_stats.gather_table_stats('POS','POS_SUPP_PROF_EXT_INTF',cascade=>true,percent=>30);

1074:
1075: -- Bug 12747017 Adding gather stats to improve performance, only doing it when volume are large. Ref Implementation:RRSIMINB.pls
1076: IF l_cnt > 1000 THEN --hard-code threshold value 1000 here may need to use profile option in future
1077: Write_Conclog('Before Gathering Stats... l_cnt = '||l_cnt);
1078: fnd_stats.gather_table_stats('POS','POS_SUPP_PROF_EXT_INTF',cascade=>true,percent=>30);
1079: fnd_stats.gather_table_stats('POS','POS_SUPP_PROF_EXT_B',cascade=>true,percent=>30);
1080: fnd_stats.gather_table_stats('POS','POS_SUPP_PROF_EXT_TL',cascade=>true,percent=>30);
1081: Write_Conclog('Done Gathering Stats....');
1082: END IF;

Line 1079: fnd_stats.gather_table_stats('POS','POS_SUPP_PROF_EXT_B',cascade=>true,percent=>30);

1075: -- Bug 12747017 Adding gather stats to improve performance, only doing it when volume are large. Ref Implementation:RRSIMINB.pls
1076: IF l_cnt > 1000 THEN --hard-code threshold value 1000 here may need to use profile option in future
1077: Write_Conclog('Before Gathering Stats... l_cnt = '||l_cnt);
1078: fnd_stats.gather_table_stats('POS','POS_SUPP_PROF_EXT_INTF',cascade=>true,percent=>30);
1079: fnd_stats.gather_table_stats('POS','POS_SUPP_PROF_EXT_B',cascade=>true,percent=>30);
1080: fnd_stats.gather_table_stats('POS','POS_SUPP_PROF_EXT_TL',cascade=>true,percent=>30);
1081: Write_Conclog('Done Gathering Stats....');
1082: END IF;
1083:

Line 1080: fnd_stats.gather_table_stats('POS','POS_SUPP_PROF_EXT_TL',cascade=>true,percent=>30);

1076: IF l_cnt > 1000 THEN --hard-code threshold value 1000 here may need to use profile option in future
1077: Write_Conclog('Before Gathering Stats... l_cnt = '||l_cnt);
1078: fnd_stats.gather_table_stats('POS','POS_SUPP_PROF_EXT_INTF',cascade=>true,percent=>30);
1079: fnd_stats.gather_table_stats('POS','POS_SUPP_PROF_EXT_B',cascade=>true,percent=>30);
1080: fnd_stats.gather_table_stats('POS','POS_SUPP_PROF_EXT_TL',cascade=>true,percent=>30);
1081: Write_Conclog('Done Gathering Stats....');
1082: END IF;
1083:
1084: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'HZ_PARTIES: Supplier Hub' );