APPS.WIP_MOVE_VALIDATOR dependencies on FND_USER

Line 2285: -- validate last_updated_by against fnd_user table. The caller have an option

2281: TRUNC(wmti.transaction_date)))));
2282:
2283: END scrap_account_id;
2284:
2285: -- validate last_updated_by against fnd_user table. The caller have an option
2286: -- to provide either last_updated_by or last_updated_by_name. If the caller
2287: -- pass last_updated_by, the id need to be valid. If the caller pass
2288: -- last_updated_by_name, we will derive the ID. If the caller pass both
2289: -- both value must be consistent to each other.

Line 2297: FROM fnd_user fu

2293: -- Derive LAST_UPDATED_BY if user provided only LAST_UPDATED_BY_NAME
2294: UPDATE wip_move_txn_interface wmti
2295: SET wmti.last_updated_by =
2296: (SELECT fu.user_id
2297: FROM fnd_user fu
2298: WHERE fu.user_name = wmti.last_updated_by_name
2299: AND SYSDATE BETWEEN fu.start_date AND NVL(fu.end_date, SYSDATE))
2300: WHERE wmti.group_id = g_group_id
2301: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL

Line 2347: -- validate created_by against fnd_user table. The caller have an option

2343: AND wmti.last_updated_by IS NULL; -- cannot derive LAST_UPDATED_BY
2344:
2345: END last_updated_by;
2346:
2347: -- validate created_by against fnd_user table. The caller have an option
2348: -- to provide either created_by or created_by_name. If the caller
2349: -- pass created_by, the id need to be valid. If the caller pass
2350: -- created_by_name, we will derive the ID. If the caller pass both
2351: -- both value must be consistent to each other.

Line 2359: FROM fnd_user fu

2355: -- Derive CREATED_BY if user provided only CREATED_BY_NAME
2356: UPDATE wip_move_txn_interface wmti
2357: SET wmti.created_by =
2358: (SELECT fu.user_id
2359: FROM fnd_user fu
2360: WHERE fu.user_name = wmti.created_by_name
2361: AND SYSDATE BETWEEN fu.start_date AND NVL(fu.end_date, SYSDATE))
2362: WHERE wmti.group_id = g_group_id
2363: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL

Line 2409: FROM fnd_user fu

2405: AND ((wmti.created_by IS NULL) -- cannot derive LAST_UPDATED_BY
2406: OR
2407: (NOT EXISTS
2408: (SELECT 'X'
2409: FROM fnd_user fu
2410: WHERE fu.user_name = NVL(wmti.created_by_name,
2411: fu.user_name)
2412: AND fu.user_id = wmti.created_by
2413: AND SYSDATE BETWEEN fu.start_date AND

Line 2569: FROM fnd_user fu,

2565: AND wrs.status_type IN (WIP_CONSTANTS.RELEASED,
2566: WIP_CONSTANTS.COMP_CHRG)))))
2567: AND NOT EXISTS
2568: (SELECT 'Current user is an employee'
2569: FROM fnd_user fu,
2570: per_people_f ppf
2571: WHERE fu.user_id = wmti.created_by
2572: AND fu.employee_id = ppf.person_id);
2573: