APPS.POS_PROFILE_PKG dependencies on FND_USER

Line 63: l_employee_id FND_USER.EMPLOYEE_ID%TYPE;

59: , x_exception_msg OUT nocopy VARCHAR2
60: )
61: IS
62:
63: l_employee_id FND_USER.EMPLOYEE_ID%TYPE;
64: l_user_party_id HZ_PARTIES.PARTY_ID%TYPE;
65: l_enterprise_id HZ_PARTIES.PARTY_ID%TYPE;
66: l_relationship_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
67: l_step NUMBER;

Line 68: l_username FND_USER.USER_NAME%TYPE;

64: l_user_party_id HZ_PARTIES.PARTY_ID%TYPE;
65: l_enterprise_id HZ_PARTIES.PARTY_ID%TYPE;
66: l_relationship_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
67: l_step NUMBER;
68: l_username FND_USER.USER_NAME%TYPE;
69: l_email_address FND_USER.EMAIL_ADDRESS%TYPE;
70:
71: BEGIN
72: x_status := 'E';

Line 69: l_email_address FND_USER.EMAIL_ADDRESS%TYPE;

65: l_enterprise_id HZ_PARTIES.PARTY_ID%TYPE;
66: l_relationship_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
67: l_step NUMBER;
68: l_username FND_USER.USER_NAME%TYPE;
69: l_email_address FND_USER.EMAIL_ADDRESS%TYPE;
70:
71: BEGIN
72: x_status := 'E';
73: l_step := 0;

Line 77: from fnd_user

73: l_step := 0;
74:
75: select employee_id, user_name,email_address into
76: l_employee_id, l_username, l_email_address
77: from fnd_user
78: where user_id = p_user_id;
79:
80: l_step := 1;
81: