DBA Data[Home] [Help]

APPS.PA_PROJECT_SET_UTILS dependencies on FND_USER

Line 16: l_employee_id fnd_user.employee_id%type;

12: ,x_party_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
13: ,x_party_name OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
14: )
15: IS
16: l_employee_id fnd_user.employee_id%type;
17: l_customer_id fnd_user.person_party_id%type; -- 4586987 changed from customer_id to person_party_id
18: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
19: BEGIN
20: -- 4586987 changed customer_id to person_party_id

Line 17: l_customer_id fnd_user.person_party_id%type; -- 4586987 changed from customer_id to person_party_id

13: ,x_party_name OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
14: )
15: IS
16: l_employee_id fnd_user.employee_id%type;
17: l_customer_id fnd_user.person_party_id%type; -- 4586987 changed from customer_id to person_party_id
18: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
19: BEGIN
20: -- 4586987 changed customer_id to person_party_id
21: /*

Line 24: FROM fnd_user

20: -- 4586987 changed customer_id to person_party_id
21: /*
22: SELECT employee_id, customer_id
23: INTO l_employee_id, l_customer_id
24: FROM fnd_user
25: WHERE user_id = p_user_id;
26: */
27:
28: SELECT employee_id,person_party_id -- selecting person_party_id instead of customer_id

Line 30: from fnd_user

26: */
27:
28: SELECT employee_id,person_party_id -- selecting person_party_id instead of customer_id
29: INTO l_employee_id,l_customer_id
30: from fnd_user
31: WHERE user_id = p_user_id;
32:
33: -- 4586987 end
34: