APPS.PO_AME_WF_PVT dependencies on FND_LANGUAGES

Line 3001: l_language_code fnd_languages.language_code%TYPE;

2997: l_authorization_status VARCHAR2(25);
2998: l_progress VARCHAR2(200);
2999: l_withterms VARCHAR2(1);
3000: l_set_lang BOOLEAN;
3001: l_language_code fnd_languages.language_code%TYPE;
3002: l_language fnd_languages.nls_language%TYPE;
3003: l_territory fnd_languages.nls_territory%TYPE;
3004: submission_error EXCEPTION;
3005: l_msg VARCHAR2(500);

Line 3002: l_language fnd_languages.nls_language%TYPE;

2998: l_progress VARCHAR2(200);
2999: l_withterms VARCHAR2(1);
3000: l_set_lang BOOLEAN;
3001: l_language_code fnd_languages.language_code%TYPE;
3002: l_language fnd_languages.nls_language%TYPE;
3003: l_territory fnd_languages.nls_territory%TYPE;
3004: submission_error EXCEPTION;
3005: l_msg VARCHAR2(500);
3006: l_terms_param VARCHAR2(1);

Line 3003: l_territory fnd_languages.nls_territory%TYPE;

2999: l_withterms VARCHAR2(1);
3000: l_set_lang BOOLEAN;
3001: l_language_code fnd_languages.language_code%TYPE;
3002: l_language fnd_languages.nls_language%TYPE;
3003: l_territory fnd_languages.nls_territory%TYPE;
3004: submission_error EXCEPTION;
3005: l_msg VARCHAR2(500);
3006: l_terms_param VARCHAR2(1);
3007: l_api_name VARCHAR2(500) := 'generate_pdf_ame_buyer';

Line 3043: FROM fnd_languages

3039: l_progress := '020';
3040: BEGIN
3041: SELECT nls_language, nls_territory
3042: INTO l_language, l_territory
3043: FROM fnd_languages
3044: WHERE language_code = l_language_code;
3045: EXCEPTION
3046: WHEN NO_DATA_FOUND THEN
3047: IF (g_po_wf_debug = 'Y') THEN

Line 3164: l_territory fnd_languages.nls_territory%type;

3160: l_document_id po_headers.po_header_id%TYPE;
3161: l_revision_num po_headers.revision_num%TYPE;
3162: l_document_subtype po_headers.type_lookup_code%TYPE;
3163: l_document_type po_headers.type_lookup_code%TYPE;
3164: l_territory fnd_languages.nls_territory%type;
3165: l_language_code fnd_languages.language_code%type;
3166: l_supp_lang po_vendor_sites_all.language%TYPE;
3167: l_language fnd_languages.nls_language%type;
3168: l_authorization_status po_headers.authorization_status%TYPE;

Line 3165: l_language_code fnd_languages.language_code%type;

3161: l_revision_num po_headers.revision_num%TYPE;
3162: l_document_subtype po_headers.type_lookup_code%TYPE;
3163: l_document_type po_headers.type_lookup_code%TYPE;
3164: l_territory fnd_languages.nls_territory%type;
3165: l_language_code fnd_languages.language_code%type;
3166: l_supp_lang po_vendor_sites_all.language%TYPE;
3167: l_language fnd_languages.nls_language%type;
3168: l_authorization_status po_headers.authorization_status%TYPE;
3169: l_header_id po_headers.po_header_id%TYPE;

Line 3167: l_language fnd_languages.nls_language%type;

3163: l_document_type po_headers.type_lookup_code%TYPE;
3164: l_territory fnd_languages.nls_territory%type;
3165: l_language_code fnd_languages.language_code%type;
3166: l_supp_lang po_vendor_sites_all.language%TYPE;
3167: l_language fnd_languages.nls_language%type;
3168: l_authorization_status po_headers.authorization_status%TYPE;
3169: l_header_id po_headers.po_header_id%TYPE;
3170: l_with_terms VARCHAR2(1);
3171: l_request_id NUMBER;

Line 3276: FROM fnd_languages

3272: l_progress := '030';
3273: BEGIN
3274: SELECT nls_language
3275: INTO l_language
3276: FROM fnd_languages
3277: WHERE language_code = l_language_code;
3278: EXCEPTION
3279: WHEN NO_DATA_FOUND THEN
3280: IF (g_po_wf_debug = 'Y') THEN

Line 3473: FROM fnd_languages

3469: l_progress := '080';
3470: IF l_language <> l_supp_lang THEN
3471: SELECT nls_territory
3472: INTO l_territory
3473: FROM fnd_languages
3474: WHERE nls_language = l_supp_lang;
3475:
3476: l_set_lang := fnd_request.set_options('NO', 'NO', l_supp_lang, l_territory, NULL, FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS'));
3477: po_moac_utils_pvt.set_request_context(po_moac_utils_pvt.get_current_org_id);