DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on FND_USER

Line 1307: FROM fnd_user

1303: -- the person_id column in WDT properly.
1304: BEGIN
1305: SELECT employee_id
1306: INTO l_emp_id
1307: FROM fnd_user
1308: WHERE user_id = p_user_id;
1309: EXCEPTION
1310: WHEN NO_DATA_FOUND THEN
1311: IF (l_debug = 1) THEN

Line 3944: FROM fnd_user

3940: -- Bug# 2750060: Catch for no data found exception
3941: BEGIN
3942: SELECT employee_id
3943: INTO l_emp_id
3944: FROM fnd_user
3945: WHERE user_id = p_user_id;
3946: EXCEPTION
3947: WHEN NO_DATA_FOUND THEN
3948: IF (l_debug = 1) THEN

Line 6033: -- does NOT refer to the fnd user id. Instead it refers to the employee id.

6029: x_return_status := fnd_api.g_ret_sts_unexp_error;
6030: END discrepancy;
6031:
6032: -- Important, please note that the input parameter, p_user_id
6033: -- does NOT refer to the fnd user id. Instead it refers to the employee id.
6034: -- It is used against the wms_dispatched_tasks.person_id column which
6035: -- is populated with the employee id.
6036: PROCEDURE check_lpn_validity(
6037: p_org_id IN NUMBER

Line 6476: FROM fnd_user

6472: --because while creating the task, employee_id is stored.
6473: BEGIN
6474: SELECT employee_id
6475: INTO l_emp_id
6476: FROM fnd_user
6477: WHERE user_id = p_user_id;
6478: EXCEPTION
6479: WHEN NO_DATA_FOUND THEN
6480: IF (l_debug = 1) THEN

Line 8485: FROM fnd_user

8481:
8482: BEGIN
8483: SELECT employee_id
8484: INTO l_emp_id
8485: FROM fnd_user
8486: WHERE user_id = p_user_id;
8487: EXCEPTION
8488: WHEN NO_DATA_FOUND THEN
8489: IF (l_debug = 1) THEN