APPS.EGO_BROWSE_PVT dependencies on FND_PROFILE

Line 48: IF (l_num_rows_inserted > nvl(fnd_profile.value('EGO_GATHER_STATS'),100)) THEN --{

44:
45: --Comupte stats on EGO_ITEM_CAT_DENORM_HIER
46: /* Bug 7042156. Collect statistics only if the no.of records is bigger than the profile
47: option threshold */
48: IF (l_num_rows_inserted > nvl(fnd_profile.value('EGO_GATHER_STATS'),100)) THEN --{
49: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER');
50: FND_STATS.GATHER_INDEX_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER_U1');
51: END IF; --}
52:

Line 169: IF (l_num_rows_updated > nvl(fnd_profile.value('EGO_GATHER_STATS'),100)) THEN --{

165:
166: --Comupte stats on EGO_ITEM_CAT_DENORM_HIER
167: /* Bug 7042156. Collect statistics only if the no.of records is bigger than the profile
168: option threshold */
169: IF (l_num_rows_updated > nvl(fnd_profile.value('EGO_GATHER_STATS'),100)) THEN --{
170: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER');
171: FND_STATS.GATHER_INDEX_STATS(l_schema, 'EGO_ITEM_CAT_DENORM_HIER_U1');
172: END IF; --}
173: