eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_COMMUNICATION_PVT dependencies on FND_LANGUAGES

Line 380: l_language_code fnd_languages.language_code%type;

376: l_document_subtype po_headers.type_lookup_code%TYPE;
377: l_revision_num number;
378: l_orgid number;
379: l_entity_name varchar2(30);
380: l_language_code fnd_languages.language_code%type;
381: x_progress varchar2(100);
382: l_document_type po_headers.type_lookup_code%TYPE;
383:
384: Begin

Line 464: l_language_code fnd_languages.language_code%type;

460: actid IN NUMBER,
461: funcmode IN VARCHAR2,
462: resultout OUT NOCOPY VARCHAR2) is
463:
464: l_language_code fnd_languages.language_code%type;
465: l_document_id number;
466: l_revision_num number;
467: l_terms_flag po_headers_all.CONTERMS_EXIST_FLAG%type;
468: l_document_subtype po_headers_all.type_lookup_code%TYPE;

Line 808: FROM wf_languages wfl, fnd_languages_vl flv

804:
805: IF l_vendor_site_lang is NOT NULL then
806:
807: SELECT wfl.nls_language, wfl.nls_territory INTO l_adhocuser_lang, l_adhocuser_territory
808: FROM wf_languages wfl, fnd_languages_vl flv
809: WHERE wfl.code = flv.language_code AND flv.nls_language = l_vendor_site_lang;
810:
811: ELSE
812:

Line 814: FROM wf_languages wfl, fnd_languages_vl flv

810:
811: ELSE
812:
813: SELECT wfl.nls_language, wfl.nls_territory into l_adhocuser_lang, l_adhocuser_territory
814: FROM wf_languages wfl, fnd_languages_vl flv
815: WHERE wfl.code = flv.language_code AND flv.installed_flag = 'B';
816:
817: END IF;
818:

Line 937: l_territory fnd_languages.nls_territory%type;

933: l_document_id po_headers.po_header_id%TYPE;
934: l_revision_num po_headers.revision_num%TYPE;
935: l_document_subtype po_headers.type_lookup_code%TYPE;
936: l_document_type po_headers.type_lookup_code%TYPE;
937: l_territory fnd_languages.nls_territory%type;
938: l_language_code fnd_languages.language_code%type;
939: l_supp_lang po_vendor_sites_all.language%TYPE;
940: l_language fnd_languages.nls_language%type;
941: l_authorization_status po_headers.authorization_status%TYPE;

Line 938: l_language_code fnd_languages.language_code%type;

934: l_revision_num po_headers.revision_num%TYPE;
935: l_document_subtype po_headers.type_lookup_code%TYPE;
936: l_document_type po_headers.type_lookup_code%TYPE;
937: l_territory fnd_languages.nls_territory%type;
938: l_language_code fnd_languages.language_code%type;
939: l_supp_lang po_vendor_sites_all.language%TYPE;
940: l_language fnd_languages.nls_language%type;
941: l_authorization_status po_headers.authorization_status%TYPE;
942: l_header_id po_headers.po_header_id%TYPE;

Line 940: l_language fnd_languages.nls_language%type;

936: l_document_type po_headers.type_lookup_code%TYPE;
937: l_territory fnd_languages.nls_territory%type;
938: l_language_code fnd_languages.language_code%type;
939: l_supp_lang po_vendor_sites_all.language%TYPE;
940: l_language fnd_languages.nls_language%type;
941: l_authorization_status po_headers.authorization_status%TYPE;
942: l_header_id po_headers.po_header_id%TYPE;
943:
944: l_with_terms varchar2(1);

Line 1013: FROM fnd_languages

1009: --set the suppliers language before launching the concurrent request
1010: --Bug6841986/6528046 userenv('LANG')==> l_language_code
1011: SELECT nls_language
1012: INTO l_language
1013: FROM fnd_languages
1014: WHERE language_code = l_language_code;
1015: --End Bug6841986/6528046
1016:
1017: IF l_language <> l_supp_lang then

Line 1020: FROM fnd_languages

1016:
1017: IF l_language <> l_supp_lang then
1018: SELECT nls_territory
1019: INTO l_territory
1020: FROM fnd_languages
1021: WHERE nls_language = l_supp_lang;
1022:
1023: l_set_lang := fnd_request.set_options('NO', 'NO', l_supp_lang,l_territory, NULL);
1024:

Line 1649: l_language_code fnd_languages.language_code%type;

1645: l_request_id number;
1646: l_territory varchar2(30);
1647: l_set_lang boolean;
1648: x_progress varchar2(100);
1649: l_language_code fnd_languages.language_code%type;
1650: l_supp_lang varchar2(30);
1651: l_language varchar2(25);
1652: l_authorization_status varchar2(25);
1653: --l_old_request_id number; --Bug 7299381

Line 1719: FROM fnd_languages

1715:
1716: --set the suppliers language before launching the concurrent request
1717: -- Bug6841986/6528046 changed userenv('LANG')==> l_language_code
1718: SELECT nls_language INTO l_language
1719: FROM fnd_languages
1720: WHERE language_code = l_language_code;
1721: --End Bug6841986/6528046
1722:
1723: if l_language <> l_supp_lang then

Line 1725: select nls_territory into l_territory from fnd_languages where

1721: --End Bug6841986/6528046
1722:
1723: if l_language <> l_supp_lang then
1724:
1725: select nls_territory into l_territory from fnd_languages where
1726: nls_language = l_supp_lang;
1727:
1728: l_set_lang := fnd_request.set_options('NO', 'NO', l_supp_lang,l_territory, NULL);
1729:

Line 1845: select nls_territory into l_territory from fnd_languages where

1841: aname =>'LANGUAGE_CODE');
1842:
1843: --set the suppliers language before launching the concurrent request
1844:
1845: select nls_territory into l_territory from fnd_languages where
1846: language_code = l_language_code;
1847:
1848:
1849: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 1879: select nls_language,nls_territory into l_language , l_territory from fnd_languages where

1875: IF l_language_code <> userenv('LANG') THEN
1876:
1877: --set the suppliers language before launching the concurrent request
1878:
1879: select nls_language,nls_territory into l_language , l_territory from fnd_languages where
1880: language_code = l_language_code;
1881:
1882:
1883: l_set_lang := fnd_request.set_options('NO', 'NO', l_language,l_territory, NULL);

Line 2249: l_supp_lang fnd_languages.nls_language%type;

2245: p_request_id out nocopy number)
2246: IS
2247:
2248: l_conterm_exists_flag po_headers_all.CONTERMS_EXIST_FLAG%type;
2249: l_supp_lang fnd_languages.nls_language%type;
2250: l_territory fnd_languages.nls_territory%type;
2251: l_revision_num number;
2252: l_set_lang boolean;
2253: l_doctype po_document_types_all.document_type_code%type;

Line 2250: l_territory fnd_languages.nls_territory%type;

2246: IS
2247:
2248: l_conterm_exists_flag po_headers_all.CONTERMS_EXIST_FLAG%type;
2249: l_supp_lang fnd_languages.nls_language%type;
2250: l_territory fnd_languages.nls_territory%type;
2251: l_revision_num number;
2252: l_set_lang boolean;
2253: l_doctype po_document_types_all.document_type_code%type;
2254: l_document_subtype po_document_types_all.document_subtype%type;

Line 2255: l_language_code fnd_languages.language_code%type;

2251: l_revision_num number;
2252: l_set_lang boolean;
2253: l_doctype po_document_types_all.document_type_code%type;
2254: l_document_subtype po_document_types_all.document_subtype%type;
2255: l_language_code fnd_languages.language_code%type;
2256: l_api_name CONSTANT VARCHAR2(25):= 'Communicate';
2257:
2258: l_pdf_tc_buyer_exists number(1); -- Whether PDF with Terms in buyers language already exists in Contracts Repository
2259: l_pdf_nt_buyer_exists number(1); -- Whether PDF without Terms in buyers language already exists in PO Repository

Line 2346: select language_code,nls_territory into l_language_code,l_territory from fnd_languages fl where

2342: end;
2343:
2344: l_progress := '020';
2345: if l_supp_lang is not null then
2346: select language_code,nls_territory into l_language_code,l_territory from fnd_languages fl where
2347: fl.nls_language = l_supp_lang;
2348: end if;
2349:
2350: l_buyer_language_code := userenv('LANG');

Line 2551: select nls_language,nls_territory into l_supp_lang,l_territory from fnd_languages fl where

2547: else -- if p_language_code = l_buyer_language_code
2548:
2549: l_progress := '095';
2550: -- Bug 4116063: Set the language if different from buyers lang
2551: select nls_language,nls_territory into l_supp_lang,l_territory from fnd_languages fl where
2552: fl.language_code = p_language_code ;
2553: l_set_lang := fnd_request.set_options('NO', 'NO', l_supp_lang,l_territory, NULL);
2554:
2555: if l_pdf_tc_sup_exists = 0 then

Line 2590: select nls_language,nls_territory into l_supp_lang,l_territory from fnd_languages fl where

2586:
2587: else -- if p_language_code = l_buyer_language_code
2588:
2589: l_progress := '100';
2590: select nls_language,nls_territory into l_supp_lang,l_territory from fnd_languages fl where
2591: fl.language_code = p_language_code ;
2592: l_set_lang := fnd_request.set_options('NO', 'NO', l_supp_lang,l_territory, NULL);
2593:
2594: if l_pdf_nt_sup_exists = 0 then

Line 2678: select nls_language,nls_territory into l_supp_lang,l_territory from fnd_languages fl where

2674: p_message => 'Generate Cache PDFs and store them in the repository');
2675: END IF;
2676:
2677: if l_tc_buyer_gen_flag = 'Y' then
2678: select nls_language,nls_territory into l_supp_lang,l_territory from fnd_languages fl where
2679: fl.language_code = l_buyer_language_code;
2680: l_set_lang := fnd_request.set_options('NO', 'NO', l_supp_lang,l_territory, NULL);
2681:
2682: l_progress := '170';

Line 2700: select nls_language,nls_territory into l_supp_lang,l_territory from fnd_languages fl where

2696: end if;
2697:
2698: l_progress := '180';
2699: if l_nt_buyer_gen_flag = 'Y' then
2700: select nls_language,nls_territory into l_supp_lang,l_territory from fnd_languages fl where
2701: fl.language_code = l_buyer_language_code;
2702: l_set_lang := fnd_request.set_options('NO', 'NO', l_supp_lang,l_territory, NULL);
2703:
2704: l_progress := '190';

Line 2734: select language_code,nls_territory into l_language_code,l_territory from fnd_languages fl where

2730: if l_nt_sup_gen_flag = 'Y' then
2731:
2732: l_progress := '210';
2733: if l_supp_lang is not null then
2734: select language_code,nls_territory into l_language_code,l_territory from fnd_languages fl where
2735: fl.nls_language = l_supp_lang;
2736: l_set_lang := fnd_request.set_options('NO', 'NO', l_supp_lang,l_territory, NULL);
2737:
2738: l_progress := '220';

Line 2760: select language_code,nls_territory into l_language_code,l_territory from fnd_languages fl where

2756: if l_tc_sup_gen_flag = 'Y' then
2757:
2758: l_progress := '220';
2759: if l_supp_lang is not null then
2760: select language_code,nls_territory into l_language_code,l_territory from fnd_languages fl where
2761: fl.nls_language = l_supp_lang;
2762: l_set_lang := fnd_request.set_options('NO', 'NO', l_supp_lang,l_territory, NULL);
2763:
2764: l_progress := '220';

Line 3095: l_language fnd_languages.language_code%type;

3091: l_document_id number;
3092: l_document_type po_headers.type_lookup_code%TYPE;
3093: l_org_id number;
3094: l_revision_number number;
3095: l_language fnd_languages.language_code%type;
3096: l_entity_name varchar2(30);
3097: l_itemtype po_document_types.wf_approval_itemtype%type;
3098: l_itemkey varchar2(60);
3099: l_document blob;

Line 3212: l_language fnd_languages.language_code%type;

3208: l_document_id number;
3209: l_document_type po_headers.type_lookup_code%TYPE;
3210: l_org_id number;
3211: l_revision_number number;
3212: l_language fnd_languages.language_code%type;
3213: l_entity_name varchar2(30);
3214: l_itemtype po_document_types.wf_approval_itemtype%type;
3215: l_itemkey varchar2(60);
3216: l_document blob;

Line 3325: l_language fnd_languages.language_code%type;

3321: l_document_id number;
3322: l_document_type po_headers.type_lookup_code%TYPE;
3323: l_org_id number;
3324: l_revision_number number;
3325: l_language fnd_languages.language_code%type;
3326: l_entity_name varchar2(30);
3327: l_itemtype po_document_types.wf_approval_itemtype%type;
3328: l_itemkey varchar2(60);
3329: l_document blob;

Line 3387: from po_vendor_sites_all pvs,po_headers_all ph,fnd_languages fl

3383: Begin
3384:
3385: if l_document_type in ('PO','PA') then
3386: select fl.language_code into l_language
3387: from po_vendor_sites_all pvs,po_headers_all ph,fnd_languages fl
3388: where ph.vendor_site_id = pvs.vendor_site_id
3389: and ph.po_header_id = l_document_id
3390: and pvs.language = fl.nls_language;
3391: elsif l_document_type = 'RELEASE' then

Line 3394: po_releases_all pr, fnd_languages fl

3390: and pvs.language = fl.nls_language;
3391: elsif l_document_type = 'RELEASE' then
3392: select fl.language_code into l_language
3393: from po_vendor_sites_all pvs , po_headers_all ph,
3394: po_releases_all pr, fnd_languages fl
3395: where ph.po_header_id = pr.po_header_id
3396: and pr.po_release_id = l_document_id
3397: and ph.vendor_site_id = pvs.vendor_site_id
3398: and pvs.language = fl.nls_language;

Line 3517: l_language fnd_languages.language_code%type;

3513: l_po_document_type po_headers.type_lookup_code%TYPE;
3514: l_po_document_subtype po_headers.type_lookup_code%TYPE;
3515: l_po_org_id number;
3516: l_po_revision_number number;
3517: l_language fnd_languages.language_code%type;
3518: l_withTerms varchar2(1);
3519:
3520: l_itemtype po_document_types.wf_approval_itemtype%type;
3521: l_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;

Line 3686: l_language fnd_languages.language_code%type;

3682: l_document_number po_headers_all.segment1%type;
3683: l_document_type po_headers_all.type_lookup_code%TYPE;
3684: l_org_id po_headers_all.org_id%type;
3685: l_revision_number po_headers_all.revision_num%type;
3686: l_language fnd_languages.language_code%type;
3687: l_entity_name fnd_attached_documents.entity_name%type;
3688: l_itemtype wf_items.item_type%type;
3689: l_itemkey wf_items.item_key%type;
3690: l_document fnd_lobs.file_data%type;

Line 6415: l_language_code fnd_languages.language_code%type;

6411: p_language_code varchar2,
6412: p_extension varchar2) RETURN varchar2 IS
6413:
6414: l_po_number po_headers_all.segment1%type;
6415: l_language_code fnd_languages.language_code%type;
6416: l_api_name CONSTANT VARCHAR2(25):= 'PDFFileName';
6417: l_file_name fnd_lobs.file_name%type;
6418: l_progress VARCHAR2(3);
6419: BEGIN