DBA Data[Home] [Help]

APPS.PO_XML_DELIVERY dependencies on PO_VENDOR_SITES_ALL

Line 1476: from po_vendor_sites_all pvsa

1472: lang_name varchar2(100);
1473: begin
1474: /* default language be AMERICAN. */
1475: select nvl(pvsa.language, 'AMERICAN') into lang_name
1476: from po_vendor_sites_all pvsa
1477: where vendor_id = p_vendor_id and
1478: vendor_site_id = p_vendor_site_id;
1479:
1480: FND_GLOBAL.set_nls_context( lang_name);

Line 2020: from po_vendor_sites_all pvsa

2016:
2017: begin
2018: /* default language be AMERICAN. */
2019: select nvl(pvsa.language, 'AMERICAN') into lang_name
2020: from po_vendor_sites_all pvsa
2021: where vendor_id = p_vendor_id and
2022: vendor_site_id = p_vendor_site_id;
2023: exception when others then
2024: null;