APPS.RLM_WF_SV dependencies on FND_USER

Line 3312: Flow. The To User is retrieved from the FND_USER table.

3308: FUNCTION NAME: Notification_ToUser
3309:
3310: DESCRIPTION: This function returns the To User to whom the notifications
3311: are to be send. The To User is set as an attribute in the Work
3312: Flow. The To User is retrieved from the FND_USER table.
3313:
3314: PARAMETERS: user_id IN NUMBER
3315:
3316: RETURN: VARCHAR2

Line 3324: FROM fnd_user

3320: FUNCTION Notification_ToUser(user_id IN NUMBER) RETURN VARCHAR2 is
3321: --
3322: CURSOR c_user(v_user_id IN NUMBER) is
3323: SELECT user_name
3324: FROM fnd_user
3325: WHERE user_id = v_user_id;
3326: --
3327: v_ToUserName fnd_user.user_name%TYPE;
3328: e_UserNotFound EXCEPTION;

Line 3327: v_ToUserName fnd_user.user_name%TYPE;

3323: SELECT user_name
3324: FROM fnd_user
3325: WHERE user_id = v_user_id;
3326: --
3327: v_ToUserName fnd_user.user_name%TYPE;
3328: e_UserNotFound EXCEPTION;
3329: --
3330: BEGIN
3331: --

Line 3420: v_FromUserName := FND_USER_RESP_GROUPS_API. upgrade_resp_role

3416: rlm_core_sv.dlog(C_DEBUG, 'Responsibility Id :', responsibility_id);
3417: rlm_core_sv.dlog(C_DEBUG, 'Application Id :', resp_appl_id);
3418: END IF;
3419: --
3420: v_FromUserName := FND_USER_RESP_GROUPS_API. upgrade_resp_role
3421: (respid => responsibility_id,
3422: appid => resp_appl_id);
3423: --
3424: IF (l_debug <> -1) THEN