202:
203: IF FOUND_EXIST_OBJECTS = FALSE THEN
204: lv_setup_source_objs := 1;
205: ELSE
206: SELECT DECODE(NVL(fnd_profile.value('MST_SOURCE_SETUP') ,'1'), '1',1 ,2)
207: INTO lv_setup_source_objs
208: FROM DUAL;
209: END IF;
210:
330: IF lv_success THEN
331: begin
332: MSC_UTIL.MSC_LOG('Updating Profile Option MSC_SOURCE_SETUP to No ');
333:
334: UPDATE FND_PROFILE_OPTION_VALUES
335: SET PROFILE_OPTION_VALUE = '2'
336: WHERE PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID
337: FROM FND_PROFILE_OPTIONS
338: WHERE PROFILE_OPTION_NAME = 'MST_SOURCE_SETUP');
333:
334: UPDATE FND_PROFILE_OPTION_VALUES
335: SET PROFILE_OPTION_VALUE = '2'
336: WHERE PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID
337: FROM FND_PROFILE_OPTIONS
338: WHERE PROFILE_OPTION_NAME = 'MST_SOURCE_SETUP');
339: MSC_UTIL.MSC_LOG('Profile Option MSC_SOURCE_SETUP has been updated No ');
340:
341: COMMIT;