APPS.PO_WF_PO_NOTIFICATION dependencies on FND_LANGUAGES

Line 2595: l_language_code fnd_languages.language_code%TYPE;

2591: l_notification_preference varchar2(240);
2592: l_language varchar2(240);
2593: l_territory varchar2(240);
2594: l_msg_text varchar2(2000) := NULL; -- Bug 3430545
2595: l_language_code fnd_languages.language_code%TYPE;
2596:
2597: cursor c_lookup_value_user(p_doc_type varchar2, p_doc_subtype varchar2,
2598: p_language varchar2) is
2599: select type_name

Line 2600: from po_document_types_tl tl, FND_LANGUAGES fl

2596:
2597: cursor c_lookup_value_user(p_doc_type varchar2, p_doc_subtype varchar2,
2598: p_language varchar2) is
2599: select type_name
2600: from po_document_types_tl tl, FND_LANGUAGES fl
2601: where fl.nls_language = p_language
2602: and tl.LANGUAGE = fl.language_code
2603: and tl.document_type_code = p_doc_type
2604: and tl.document_subtype = p_doc_subtype;

Line 2702: FROM fnd_languages

2698: BEGIN
2699:
2700: SELECT language_code
2701: INTO l_language_code
2702: FROM fnd_languages
2703: WHERE nls_language = l_language;
2704:
2705: EXCEPTION
2706: WHEN OTHERS THEN

Line 2741: from fnd_new_messages fm,fnd_languages fl

2737: avalue => l_doc_disp);
2738: BEGIN
2739: select message_text
2740: into l_msg_text
2741: from fnd_new_messages fm,fnd_languages fl
2742: where fm.message_name = 'PO_WF_NOTIF_REQUIRES_APPROVAL'
2743: and fm.language_code = fl.language_code
2744: and fl.nls_language = l_language
2745: and fm.application_id = 201; -- Include application_id to better use PK index

Line 2763: from fnd_new_messages fm,fnd_languages fl

2759: Fetching and setting REQUIRES_REVIEW_MSG attribute */
2760: BEGIN
2761: select message_text
2762: into l_msg_text
2763: from fnd_new_messages fm,fnd_languages fl
2764: where fm.message_name = 'PO_WF_NOTIF_REQUIRES_REVIEW'
2765: and fm.language_code = fl.language_code
2766: and fl.nls_language = l_language
2767: and fm.application_id = 201;

Line 2783: from fnd_new_messages fm,fnd_languages fl

2779:
2780: BEGIN
2781: select message_text
2782: into l_msg_text
2783: from fnd_new_messages fm,fnd_languages fl
2784: where fm.message_name = 'PO_WF_NOTIF_REQUIRES_ESIGN'
2785: and fm.language_code = fl.language_code
2786: and fl.nls_language = l_language
2787: and fm.application_id = 201;