DBA Data[Home] [Help]

APPS.WF_EVENT dependencies on FND_USER

Line 3620: l_user_id fnd_user.user_id%TYPE;

3616:
3617: l_count number := 0;
3618: l_request_id number;
3619: l_returncode boolean;
3620: l_user_id fnd_user.user_id%TYPE;
3621: l_user_name fnd_user.user_name%TYPE;
3622: l_resp_appl_id fnd_responsibility.application_id%TYPE;
3623: l_resp_key fnd_responsibility.responsibility_key%TYPE;
3624: l_resp_id fnd_responsibility.responsibility_id%TYPE;

Line 3621: l_user_name fnd_user.user_name%TYPE;

3617: l_count number := 0;
3618: l_request_id number;
3619: l_returncode boolean;
3620: l_user_id fnd_user.user_id%TYPE;
3621: l_user_name fnd_user.user_name%TYPE;
3622: l_resp_appl_id fnd_responsibility.application_id%TYPE;
3623: l_resp_key fnd_responsibility.responsibility_key%TYPE;
3624: l_resp_id fnd_responsibility.responsibility_id%TYPE;
3625: l_appl_short_name fnd_application.application_short_name%TYPE;

Line 3655: FROM fnd_user u

3651: begin
3652:
3653: SELECT u.user_id
3654: INTO l_user_id
3655: FROM fnd_user u
3656: WHERE u.user_name = l_user_name;
3657:
3658: SELECT r.application_id, r.responsibility_id
3659: INTO l_resp_appl_id, l_resp_id