APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on FND_PROFILE_OPTION_VALUES

Line 448: UPDATE FND_PROFILE_OPTION_VALUES

444: begin
445: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Updating Profile Option MSC_SOURCE_SETUP to No ');
446: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Region Site Mapping not being called here ');
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');

Line 2991: UPDATE FND_PROFILE_OPTION_VALUES

2987: if drop_count > 0 then
2988: begin
2989: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Updating Profile Option MSC_SOURCE_SETUP to Yes ');
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');

Line 3078: UPDATE FND_PROFILE_OPTION_VALUES

3074: if drop_count > 0 then
3075: begin
3076: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Updating Profile Option MSC_SOURCE_SETUP to Yes ');
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');