APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_VENDOR_SITES

Line 664: l_vendor_site_code po_vendor_sites_all.vendor_site_code%type; --Bug 4254468

660: l_autoapprove_retro varchar2(1);
661:
662: l_okc_doc_type varchar2(20); --
663: l_vendor po_vendors.vendor_name%type; --Bug 4254468
664: l_vendor_site_code po_vendor_sites_all.vendor_site_code%type; --Bug 4254468
665:
666: l_communicatePriceChange VARCHAR2(1); -- bug4176111
667: BEGIN
668:

Line 1404: from po_vendors pov,po_headers poh,po_vendor_sites_all pvs

1400: select pov.vendor_name,
1401: pvs.vendor_site_code
1402: into l_vendor,
1403: l_vendor_site_code
1404: from po_vendors pov,po_headers poh,po_vendor_sites_all pvs
1405: where pov.vendor_id = poh.vendor_id
1406: and poh.po_header_id = DocumentId
1407: and poh.vendor_site_id = pvs.vendor_site_id;
1408: else

Line 1414: po_vendors pov,po_vendor_sites_all pvs

1410: pvs.vendor_site_code
1411: into l_vendor,
1412: l_vendor_site_code
1413: from po_releases por,po_headers poh,
1414: po_vendors pov,po_vendor_sites_all pvs
1415: where por.po_release_id = DocumentId
1416: and por.po_header_id = poh.po_header_id
1417: and poh.vendor_id = pov.vendor_id
1418: and poh.vendor_site_id = pvs.vendor_site_id;

Line 4587: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;

4583: l_po_header_id number;
4584: l_vendor_site_code varchar2(15);
4585: l_vendor_site_id number;
4586: --EMAILPO FPH START--
4587: l_vendor_site_lang PO_VENDOR_SITES.LANGUAGE%TYPE;
4588: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
4589: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
4590: --EMAILPO FPH START--
4591: /* Bug 2989951 Increased the width of the following variables */

Line 4621: * sql query which selecs vendor_site_id below from po_vendor_sites

4617: end if;
4618:
4619: /* Bug 2687751.
4620: * For blankets, the org context was not getting set and hence
4621: * sql query which selecs vendor_site_id below from po_vendor_sites
4622: * was throwing an exception. Hence setting the org context here.
4623: */
4624: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
4625: itemkey => itemkey,

Line 4690: from po_headers poh, po_vendor_sites pvs

4686: --EMAILPO FPH--
4687: --also retrieve language to set the adhocuser language to supplier site preferred language
4688: select poh.vendor_site_id, pvs.vendor_site_code, pvs.language
4689: into l_vendor_site_id, l_vendor_site_code, l_vendor_site_lang
4690: from po_headers poh, po_vendor_sites pvs
4691: where pvs.vendor_site_id = poh.vendor_site_id
4692: and poh.po_header_id = l_po_header_id;
4693:
4694: /* Bug 2989951