DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE_PO_PVT dependencies on FND_USER

Line 2824: --though Fnd User id of old buyer is fetched or not.

2820: END IF;
2821:
2822: --For Bug 13711743
2823: --Handling this SQL in exception to continue the process
2824: --though Fnd User id of old buyer is fetched or not.
2825: BEGIN
2826: SELECT user_id
2827: INTO p_old_buyer_user_id
2828: FROM fnd_user

Line 2828: FROM fnd_user

2824: --though Fnd User id of old buyer is fetched or not.
2825: BEGIN
2826: SELECT user_id
2827: INTO p_old_buyer_user_id
2828: FROM fnd_user
2829: WHERE employee_id = p_old_personid
2830: AND user_name = p_old_username;
2831: EXCEPTION
2832: WHEN OTHERS THEN

Line 2848: FROM fnd_user

2844: */
2845: BEGIN
2846: SELECT user_id
2847: INTO p_new_buyer_user_id
2848: FROM fnd_user
2849: WHERE employee_id = p_new_personid
2850: AND user_name = p_new_username;
2851: EXCEPTION
2852: WHEN NO_DATA_FOUND THEN