APPS.WF_EVENT dependencies on FND_RESPONSIBILITY

Line 3622: l_resp_appl_id fnd_responsibility.application_id%TYPE;

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;
3626:

Line 3623: l_resp_key fnd_responsibility.responsibility_key%TYPE;

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;
3626:
3627: PRAGMA AUTONOMOUS_TRANSACTION;

Line 3624: l_resp_id fnd_responsibility.responsibility_id%TYPE;

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;
3626:
3627: PRAGMA AUTONOMOUS_TRANSACTION;
3628:

Line 3660: FROM fnd_application a, fnd_responsibility r

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
3660: FROM fnd_application a, fnd_responsibility r
3661: WHERE r.application_id = a.application_id
3662: AND a.application_short_name = l_appl_short_name
3663: AND r.responsibility_key = l_resp_key;
3664: