APPS.INVCIINT dependencies on FND_PROFILE

Line 31: IF l_records > nvl(fnd_profile.value('EGO_GATHER_STATS'),100) AND FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema) THEN

27: FROM mtl_ci_interface
28: WHERE process_flag = 1;
29: -- Bug 6983407 Collect statistics only if the no. of records is bigger than the profile
30: -- option threshold
31: IF l_records > nvl(fnd_profile.value('EGO_GATHER_STATS'),100) AND FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema) THEN
32: IF l_schema IS NOT NULL THEN
33: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_CI_INTERFACE');
34: END IF;
35: END IF;

Line 3072: IF l_records > nvl(fnd_profile.value('EGO_GATHER_STATS'),100) AND FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema) THEN

3068: WHERE process_flag = 1;
3069:
3070: -- Bug 6983407 Collect statistics only if the no. of records is bigger than the profile
3071: -- option threshold
3072: IF l_records > nvl(fnd_profile.value('EGO_GATHER_STATS'),100) AND FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema) THEN
3073: IF l_schema IS NOT NULL THEN
3074: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_CI_XREFS_INTERFACE');
3075: END IF;
3076: END IF;