[Home] [Help]
350:
351: -- Fix for bug#9336604
352: /* Bug 7042156. Collect statistics only if the no.of records is bigger than the profile
353: option threshold */
354: --IF (l_records > nvl(fnd_profile.value('EGO_GATHER_STATS'),100))
355: -- AND FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema)
356:
357: IF (nvl(fnd_profile.value('EGO_ENABLE_GATHER_STATS'),'N') = 'Y')
358: AND FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema)
353: option threshold */
354: --IF (l_records > nvl(fnd_profile.value('EGO_GATHER_STATS'),100))
355: -- AND FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema)
356:
357: IF (nvl(fnd_profile.value('EGO_ENABLE_GATHER_STATS'),'N') = 'Y')
358: AND FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema)
359: THEN
360: IF l_schema IS NOT NULL THEN
361: /* Bug 12669091 : Commenting the Gather Stats.
1553: ,p_user_id => user_id
1554: ,p_login_id => login_id
1555: ,x_err_text => err_text);
1556:
1557: IF('Y' = FND_PROFILE.VALUE('EGO_ENABLE_P4T')) THEN
1558: VALIDATE_RELEASED_ICC(
1559: p_set_id => xset_id
1560: ,p_prog_appid => prog_appid
1561: ,p_prog_id => prog_id
1807: ,p_user_id => user_id
1808: ,p_login_id => login_id
1809: ,x_err_text => err_text);
1810:
1811: IF('Y' = FND_PROFILE.VALUE('EGO_ENABLE_P4T')) THEN
1812: VALIDATE_RELEASED_ICC(
1813: p_set_id => xset_id
1814: ,p_prog_appid => prog_appid
1815: ,p_prog_id => prog_id
2207: return 0;
2208: END isMasterOrg;
2209:
2210: BEGIN
2211: fnd_profile.get('INV_UPDATEABLE_ITEM', l_updateable_item_number);
2212: FOR item_record IN c_items_table LOOP
2213: l_item_exist :=0;
2214: l_item_id := NULL;
2215: