APPS.RLM_WF_SV dependencies on FND_USER

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

3330: FUNCTION NAME: Notification_ToUser
3331:
3332: DESCRIPTION: This function returns the To User to whom the notifications
3333: are to be send. The To User is set as an attribute in the Work
3334: Flow. The To User is retrieved from the FND_USER table.
3335:
3336: PARAMETERS: user_id IN NUMBER
3337:
3338: RETURN: VARCHAR2

Line 3346: FROM fnd_user

3342: FUNCTION Notification_ToUser(user_id IN NUMBER) RETURN VARCHAR2 is
3343: --
3344: CURSOR c_user(v_user_id IN NUMBER) is
3345: SELECT user_name
3346: FROM fnd_user
3347: WHERE user_id = v_user_id;
3348: --
3349: v_ToUserName fnd_user.user_name%TYPE;
3350: e_UserNotFound EXCEPTION;

Line 3349: v_ToUserName fnd_user.user_name%TYPE;

3345: SELECT user_name
3346: FROM fnd_user
3347: WHERE user_id = v_user_id;
3348: --
3349: v_ToUserName fnd_user.user_name%TYPE;
3350: e_UserNotFound EXCEPTION;
3351: --
3352: BEGIN
3353: --

Line 3442: v_FromUserName := FND_USER_RESP_GROUPS_API. upgrade_resp_role

3438: rlm_core_sv.dlog(C_DEBUG, 'Responsibility Id :', responsibility_id);
3439: rlm_core_sv.dlog(C_DEBUG, 'Application Id :', resp_appl_id);
3440: END IF;
3441: --
3442: v_FromUserName := FND_USER_RESP_GROUPS_API. upgrade_resp_role
3443: (respid => responsibility_id,
3444: appid => resp_appl_id);
3445: --
3446: IF (l_debug <> -1) THEN