APPS.INV_CONSIGN_NOTIF_UTL dependencies on FND_LANGUAGES

Line 65: p_lang_code IN fnd_languages.language_code%TYPE,

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,
68: x_return_status OUT NOCOPY VARCHAR2
69: )

Line 231: l_language fnd_languages.nls_language%TYPE;

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
235: mtl_consigned_diag_errors.notification_id%TYPE

Line 232: l_lang_code fnd_languages.language_code%TYPE;

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
235: mtl_consigned_diag_errors.notification_id%TYPE
236: INDEX BY BINARY_INTEGER;

Line 310: FROM FND_LANGUAGES

306: IF l_language IS NOT NULL THEN
307:
308: SELECT language_code
309: INTO l_lang_code
310: FROM FND_LANGUAGES
311: WHERE nls_language = l_language;
312:
313: Call_Workflow_Notification(
314: p_user_name => rec.user_name