APPS.HXC_APPROVAL_WF_PKG dependencies on FND_USER

Line 930: p_user_name IN fnd_user.user_name%TYPE

926: end if;
927: END link_ap_details_all;
928:
929: FUNCTION get_person_id(
930: p_user_name IN fnd_user.user_name%TYPE
931: )
932: RETURN fnd_user.employee_id%TYPE
933: IS
934: CURSOR c_person_id(p_user_name fnd_user.user_name%TYPE)

Line 932: RETURN fnd_user.employee_id%TYPE

928:
929: FUNCTION get_person_id(
930: p_user_name IN fnd_user.user_name%TYPE
931: )
932: RETURN fnd_user.employee_id%TYPE
933: IS
934: CURSOR c_person_id(p_user_name fnd_user.user_name%TYPE)
935: IS
936: SELECT u.employee_id

Line 934: CURSOR c_person_id(p_user_name fnd_user.user_name%TYPE)

930: p_user_name IN fnd_user.user_name%TYPE
931: )
932: RETURN fnd_user.employee_id%TYPE
933: IS
934: CURSOR c_person_id(p_user_name fnd_user.user_name%TYPE)
935: IS
936: SELECT u.employee_id
937: FROM FND_USER u
938: WHERE u.user_name = p_user_name;

Line 937: FROM FND_USER u

933: IS
934: CURSOR c_person_id(p_user_name fnd_user.user_name%TYPE)
935: IS
936: SELECT u.employee_id
937: FROM FND_USER u
938: WHERE u.user_name = p_user_name;
939:
940: l_person_id fnd_user.employee_id%TYPE;
941: BEGIN

Line 940: l_person_id fnd_user.employee_id%TYPE;

936: SELECT u.employee_id
937: FROM FND_USER u
938: WHERE u.user_name = p_user_name;
939:
940: l_person_id fnd_user.employee_id%TYPE;
941: BEGIN
942: OPEN c_person_id(p_user_name);
943:
944: FETCH c_person_id INTO l_person_id;

Line 993: (userId in fnd_user.user_id%type) is

989: and wlr.name = wn.recipient_role
990: and wias.item_type = pa.activity_item_type;
991:
992: cursor c_find_employee_id
993: (userId in fnd_user.user_id%type) is
994: select employee_id
995: from fnd_user
996: where user_id = userId;
997:

Line 995: from fnd_user

991:
992: cursor c_find_employee_id
993: (userId in fnd_user.user_id%type) is
994: select employee_id
995: from fnd_user
996: where user_id = userId;
997:
998: l_approver_id wf_local_roles.orig_system_id%type;
999: l_approver_system wf_local_roles.orig_system%type;