APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on FND_PROFILE_OPTION_VALUES

Line 427: UPDATE FND_PROFILE_OPTION_VALUES

423:
424: begin
425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Updating Profile Option MSC_SOURCE_SETUP to No ');
426:
427: UPDATE FND_PROFILE_OPTION_VALUES
428: SET PROFILE_OPTION_VALUE = 'N'
429: WHERE PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID
430: FROM FND_PROFILE_OPTIONS
431: WHERE PROFILE_OPTION_NAME = 'MSC_SOURCE_SETUP');

Line 2536: UPDATE FND_PROFILE_OPTION_VALUES

2532: if drop_count > 0 then
2533: begin
2534: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Updating Profile Option MSC_SOURCE_SETUP to Yes ');
2535:
2536: UPDATE FND_PROFILE_OPTION_VALUES
2537: SET PROFILE_OPTION_VALUE = 'Y'
2538: WHERE PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID
2539: FROM FND_PROFILE_OPTIONS
2540: WHERE PROFILE_OPTION_NAME = 'MSC_SOURCE_SETUP');