APPS.INV_CONSIGN_NOTIF_UTL dependencies on FND_USER

Line 63: p_user_name IN fnd_user.user_name%TYPE,

59: -- CHANGE HISTORY :
60: -- 10/06/03 vma Created.
61: --=========================================================================
62: PROCEDURE Call_Workflow_Notification(
63: p_user_name IN fnd_user.user_name%TYPE,
64: p_agent_id IN mtl_consigned_diag_errors.agent_id%TYPE,
65: p_lang_code IN fnd_languages.language_code%TYPE,
66: x_notification_id OUT NOCOPY mtl_consigned_diag_errors.notification_id%TYPE,
67: x_notification_date OUT NOCOPY mtl_consigned_diag_errors.last_notification_date%TYPE,

Line 230: l_user_name fnd_user.user_name%TYPE;

226: l_api_name CONSTANT VARCHAR2(30) := 'Send_Notification';
227: l_api_version CONSTANT NUMBER := 1.0;
228:
229: l_agent_id mtl_consigned_diag_errors.agent_id%TYPE;
230: l_user_name fnd_user.user_name%TYPE;
231: l_language fnd_languages.nls_language%TYPE;
232: l_lang_code fnd_languages.language_code%TYPE;
233:
234: TYPE notif_id_tbl_type IS TABLE OF

Line 300: FROM fnd_user

296: notif_id_tbl(i) := NULL;
297: notif_date_tbl(i) := NULL;
298:
299: FOR rec IN (SELECT user_name, user_id
300: FROM fnd_user
301: WHERE employee_id = l_agent_id)
302: LOOP
303: -- get user's preferred lanaguage
304: l_language := FND_PROFILE.Value_Specific('ICX_LANGUAGE', rec.user_id);