APPS.WIP_MOVE_VALIDATOR dependencies on FND_USER

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

2349: TRUNC(wmti.transaction_date)))));
2350:
2351: END scrap_account_id;
2352:
2353: -- validate last_updated_by against fnd_user table. The caller have an option
2354: -- to provide either last_updated_by or last_updated_by_name. If the caller
2355: -- pass last_updated_by, the id need to be valid. If the caller pass
2356: -- last_updated_by_name, we will derive the ID. If the caller pass both
2357: -- both value must be consistent to each other.

Line 2365: FROM fnd_user fu

2361: -- Derive LAST_UPDATED_BY if user provided only LAST_UPDATED_BY_NAME
2362: UPDATE wip_move_txn_interface wmti
2363: SET wmti.last_updated_by =
2364: (SELECT fu.user_id
2365: FROM fnd_user fu
2366: WHERE fu.user_name = wmti.last_updated_by_name
2367: AND SYSDATE BETWEEN fu.start_date AND NVL(fu.end_date, SYSDATE))
2368: WHERE wmti.group_id = g_group_id
2369: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL

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

2411: AND wmti.last_updated_by IS NULL; -- cannot derive LAST_UPDATED_BY
2412:
2413: END last_updated_by;
2414:
2415: -- validate created_by against fnd_user table. The caller have an option
2416: -- to provide either created_by or created_by_name. If the caller
2417: -- pass created_by, the id need to be valid. If the caller pass
2418: -- created_by_name, we will derive the ID. If the caller pass both
2419: -- both value must be consistent to each other.

Line 2427: FROM fnd_user fu

2423: -- Derive CREATED_BY if user provided only CREATED_BY_NAME
2424: UPDATE wip_move_txn_interface wmti
2425: SET wmti.created_by =
2426: (SELECT fu.user_id
2427: FROM fnd_user fu
2428: WHERE fu.user_name = wmti.created_by_name
2429: AND SYSDATE BETWEEN fu.start_date AND NVL(fu.end_date, SYSDATE))
2430: WHERE wmti.group_id = g_group_id
2431: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL

Line 2477: FROM fnd_user fu

2473: AND ((wmti.created_by IS NULL) -- cannot derive LAST_UPDATED_BY
2474: OR
2475: (NOT EXISTS
2476: (SELECT 'X'
2477: FROM fnd_user fu
2478: WHERE fu.user_name = NVL(wmti.created_by_name,
2479: fu.user_name)
2480: AND fu.user_id = wmti.created_by
2481: AND SYSDATE BETWEEN fu.start_date AND

Line 2637: FROM fnd_user fu,

2633: AND wrs.status_type IN (WIP_CONSTANTS.RELEASED,
2634: WIP_CONSTANTS.COMP_CHRG)))))
2635: AND NOT EXISTS
2636: (SELECT 'Current user is an employee'
2637: FROM fnd_user fu,
2638: per_people_f ppf
2639: WHERE fu.user_id = wmti.created_by
2640: AND fu.employee_id = ppf.person_id);
2641: