2294: l_ui_features_value VARCHAR2(240);
2295:
2296: BEGIN
2297:
2298: l_ui_features_value := FND_PROFILE.value('BSC_ADVANCED_UI_FEATURES');
2299:
2300: IF l_ui_features_value IS NULL THEN -- first time setup value
2301:
2302: l_summerization_value :=FND_PROFILE.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');
2298: l_ui_features_value := FND_PROFILE.value('BSC_ADVANCED_UI_FEATURES');
2299:
2300: IF l_ui_features_value IS NULL THEN -- first time setup value
2301:
2302: l_summerization_value :=FND_PROFILE.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');
2303: IF l_summerization_value IS NULL THEN
2304: l_return_status := FND_PROFILE.save('BSC_ADVANCED_UI_FEATURES','No', 'SITE');
2305: ELSE
2306: l_return_status := FND_PROFILE.save('BSC_ADVANCED_UI_FEATURES','Yes', 'SITE');
2300: IF l_ui_features_value IS NULL THEN -- first time setup value
2301:
2302: l_summerization_value :=FND_PROFILE.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');
2303: IF l_summerization_value IS NULL THEN
2304: l_return_status := FND_PROFILE.save('BSC_ADVANCED_UI_FEATURES','No', 'SITE');
2305: ELSE
2306: l_return_status := FND_PROFILE.save('BSC_ADVANCED_UI_FEATURES','Yes', 'SITE');
2307: END IF;
2308:
2302: l_summerization_value :=FND_PROFILE.value('BSC_ADVANCED_SUMMARIZATION_LEVEL');
2303: IF l_summerization_value IS NULL THEN
2304: l_return_status := FND_PROFILE.save('BSC_ADVANCED_UI_FEATURES','No', 'SITE');
2305: ELSE
2306: l_return_status := FND_PROFILE.save('BSC_ADVANCED_UI_FEATURES','Yes', 'SITE');
2307: END IF;
2308:
2309: COMMIT;
2310: END IF;