APPS.MSC_CL_OTHER_ODS_LOAD dependencies on FND_USER

Line 3546: FND_USER y

3542: x.ELECTRONIC_MAIL_ADDRESS,
3543: x.EMPLOYEE_ID,
3544: x.ORGANIZATION_ID
3545: FROM MSC_ST_PLANNERS x,
3546: FND_USER y
3547: WHERE UPPER(x.USER_NAME) = y.USER_NAME
3548: AND x.CURRENT_EMPLOYEE_FLAG = 1
3549: AND x.EMPLOYEE_ID IS NOT NULL
3550: AND x.ELECTRONIC_MAIL_ADDRESS IS NOT NULL

Line 3658: UPDATE FND_USER

3654: /* For Bug: 1121172, update the E-mail address of the planner*/
3655: FOR c_rec IN c2 LOOP
3656:
3657: BEGIN
3658: UPDATE FND_USER
3659: SET EMAIL_ADDRESS = c_rec.ELECTRONIC_MAIL_ADDRESS
3660: WHERE USER_NAME = UPPER(c_rec.USER_NAME);
3661:
3662: EXCEPTION

Line 3671: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_USER');

3667:
3668: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3669: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3670: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PLANNERS');
3671: FND_MESSAGE.SET_TOKEN('TABLE', 'FND_USER');
3672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3673:
3674: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3675: FND_MESSAGE.SET_TOKEN('COLUMN', 'USER_NAME');