APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on FND_PROFILE_OPTIONS

Line 430: FROM FND_PROFILE_OPTIONS

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');
432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Profile Option MSC_SOURCE_SETUP has been updated No ');
433: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The Value No indicates that the Collection Setup Objects have been applied');
434: COMMIT;

Line 2539: FROM FND_PROFILE_OPTIONS

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');
2541: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Profile Option MSC_SOURCE_SETUP has been updated Yes ');
2542: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The Value Yes indicates that the Collection Setup Objects need to be recreated');
2543: COMMIT;