APPS.HXC_APPROVAL_WF_PKG dependencies on FND_USER

Line 778: p_user_name IN fnd_user.user_name%TYPE

774: end if;
775: END link_ap_details_all;
776:
777: FUNCTION get_person_id(
778: p_user_name IN fnd_user.user_name%TYPE
779: )
780: RETURN fnd_user.employee_id%TYPE
781: IS
782: CURSOR c_person_id(p_user_name fnd_user.user_name%TYPE)

Line 780: RETURN fnd_user.employee_id%TYPE

776:
777: FUNCTION get_person_id(
778: p_user_name IN fnd_user.user_name%TYPE
779: )
780: RETURN fnd_user.employee_id%TYPE
781: IS
782: CURSOR c_person_id(p_user_name fnd_user.user_name%TYPE)
783: IS
784: SELECT u.employee_id

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

778: p_user_name IN fnd_user.user_name%TYPE
779: )
780: RETURN fnd_user.employee_id%TYPE
781: IS
782: CURSOR c_person_id(p_user_name fnd_user.user_name%TYPE)
783: IS
784: SELECT u.employee_id
785: FROM FND_USER u
786: WHERE u.user_name = p_user_name;

Line 785: FROM FND_USER u

781: IS
782: CURSOR c_person_id(p_user_name fnd_user.user_name%TYPE)
783: IS
784: SELECT u.employee_id
785: FROM FND_USER u
786: WHERE u.user_name = p_user_name;
787:
788: l_person_id fnd_user.employee_id%TYPE;
789: BEGIN

Line 788: l_person_id fnd_user.employee_id%TYPE;

784: SELECT u.employee_id
785: FROM FND_USER u
786: WHERE u.user_name = p_user_name;
787:
788: l_person_id fnd_user.employee_id%TYPE;
789: BEGIN
790: OPEN c_person_id(p_user_name);
791:
792: FETCH c_person_id INTO l_person_id;

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

837: and wlr.name = wn.recipient_role
838: and wias.item_type = pa.activity_item_type;
839:
840: cursor c_find_employee_id
841: (userId in fnd_user.user_id%type) is
842: select employee_id
843: from fnd_user
844: where user_id = userId;
845:

Line 843: from fnd_user

839:
840: cursor c_find_employee_id
841: (userId in fnd_user.user_id%type) is
842: select employee_id
843: from fnd_user
844: where user_id = userId;
845:
846: l_approver_id wf_local_roles.orig_system_id%type;
847: l_approver_system wf_local_roles.orig_system%type;