APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on FND_PROFILE_OPTIONS

Line 451: FROM FND_PROFILE_OPTIONS

447:
448: UPDATE FND_PROFILE_OPTION_VALUES
449: SET PROFILE_OPTION_VALUE = 'N'
450: WHERE PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID
451: FROM FND_PROFILE_OPTIONS
452: WHERE PROFILE_OPTION_NAME = 'MSC_SOURCE_SETUP');
453: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Profile Option MSC_SOURCE_SETUP has been updated No ');
454: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The Value No indicates that the Collection Setup Objects have been applied');
455: COMMIT;

Line 2994: FROM FND_PROFILE_OPTIONS

2990:
2991: UPDATE FND_PROFILE_OPTION_VALUES
2992: SET PROFILE_OPTION_VALUE = 'Y'
2993: WHERE PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID
2994: FROM FND_PROFILE_OPTIONS
2995: WHERE PROFILE_OPTION_NAME = 'MSC_SOURCE_SETUP');
2996: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Profile Option MSC_SOURCE_SETUP has been updated Yes ');
2997: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The Value Yes indicates that the Collection Setup Objects need to be recreated');
2998: COMMIT;

Line 3081: FROM FND_PROFILE_OPTIONS

3077:
3078: UPDATE FND_PROFILE_OPTION_VALUES
3079: SET PROFILE_OPTION_VALUE = 'Y'
3080: WHERE PROFILE_OPTION_ID = (SELECT PROFILE_OPTION_ID
3081: FROM FND_PROFILE_OPTIONS
3082: WHERE PROFILE_OPTION_NAME = 'MSC_SOURCE_SETUP');
3083: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Profile Option MSC_SOURCE_SETUP has been updated Yes ');
3084: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The Value Yes indicates that the Collection Setup Objects need to be recreated');
3085: COMMIT;