DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on FND_USER

Line 1162: FROM fnd_user

1158: -- the person_id column in WDT properly.
1159: BEGIN
1160: SELECT employee_id
1161: INTO l_emp_id
1162: FROM fnd_user
1163: WHERE user_id = p_user_id;
1164: EXCEPTION
1165: WHEN NO_DATA_FOUND THEN
1166: IF (l_debug = 1) THEN

Line 3739: FROM fnd_user

3735: -- Bug# 2750060: Catch for no data found exception
3736: BEGIN
3737: SELECT employee_id
3738: INTO l_emp_id
3739: FROM fnd_user
3740: WHERE user_id = p_user_id;
3741: EXCEPTION
3742: WHEN NO_DATA_FOUND THEN
3743: IF (l_debug = 1) THEN

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

5752: x_return_status := fnd_api.g_ret_sts_unexp_error;
5753: END discrepancy;
5754:
5755: -- Important, please note that the input parameter, p_user_id
5756: -- does NOT refer to the fnd user id. Instead it refers to the employee id.
5757: -- It is used against the wms_dispatched_tasks.person_id column which
5758: -- is populated with the employee id.
5759: PROCEDURE check_lpn_validity(
5760: p_org_id IN NUMBER

Line 6149: FROM fnd_user

6145: --because while creating the task, employee_id is stored.
6146: BEGIN
6147: SELECT employee_id
6148: INTO l_emp_id
6149: FROM fnd_user
6150: WHERE user_id = p_user_id;
6151: EXCEPTION
6152: WHEN NO_DATA_FOUND THEN
6153: IF (l_debug = 1) THEN

Line 8144: FROM fnd_user

8140:
8141: BEGIN
8142: SELECT employee_id
8143: INTO l_emp_id
8144: FROM fnd_user
8145: WHERE user_id = p_user_id;
8146: EXCEPTION
8147: WHEN NO_DATA_FOUND THEN
8148: IF (l_debug = 1) THEN