APPS.PON_VENDORMERGE_GRP dependencies on PO_VENDOR_SITES_ALL

Line 101: x_vendor_site_code po_vendor_sites_all.vendor_site_code%type;

97:
98: l_progress NUMBER;
99: x_trading_partner_id pon_bid_headers.trading_partner_id%type;
100: x_trading_partner_name pon_bid_headers.trading_partner_name%type;
101: x_vendor_site_code po_vendor_sites_all.vendor_site_code%type;
102: l_num_active_sites NUMBER;
103:
104: BEGIN --{
105:

Line 448: -- po_vendor_sites_all to check active sites.

444: BEGIN
445: -- select count of active sites (besides the site being merged)
446:
447: -- Note: Verify if we need to consider any ap table instead of
448: -- po_vendor_sites_all to check active sites.
449:
450: SELECT count(*)
451: INTO l_num_active_sites
452: FROM po_vendor_sites_all

Line 452: FROM po_vendor_sites_all

448: -- po_vendor_sites_all to check active sites.
449:
450: SELECT count(*)
451: INTO l_num_active_sites
452: FROM po_vendor_sites_all
453: WHERE vendor_id = p_dup_vendor_id
454: AND vendor_site_id <> p_dup_vendor_site_id
455: AND nvl(inactive_date, sysdate+1) > sysdate;
456: return l_num_active_sites;

Line 473: FROM po_vendors pv, po_vendor_sites_all pvs

469: BEGIN --{
470: -- select the vendor information for the site we're merging to
471: SELECT pv.vendor_name, pvs.vendor_site_code
472: INTO x_trading_partner_name, x_vendor_site_code
473: FROM po_vendors pv, po_vendor_sites_all pvs
474: WHERE pv.vendor_id = p_vendor_id
475: AND pv.vendor_id = pvs.vendor_id
476: AND pvs.vendor_site_id = p_vendor_site_id;
477:

Line 518: l_dup_vendor_site_code po_vendor_sites_all.vendor_site_code%type;

514: IS
515: l_procedure_name VARCHAR2(30) := 'MERGE_SAME_VENDOR_DIFF_SITES';
516: l_progress NUMBER;
517: l_trading_partner_id NUMBER;
518: l_dup_vendor_site_code po_vendor_sites_all.vendor_site_code%type;
519:
520: BEGIN --{
521:
522: /*

Line 568: FROM po_vendors pv, po_vendor_sites_all pvs

564: -- in list.
565:
566: SELECT pvs.vendor_site_code
567: INTO l_dup_vendor_site_code
568: FROM po_vendors pv, po_vendor_sites_all pvs
569: WHERE pv.vendor_id = p_dup_vendor_id
570: AND pv.vendor_id = pvs.vendor_id
571: AND pvs.vendor_site_id = p_dup_vendor_site_id;
572:

Line 666: l_dup_vendor_site_code po_vendor_sites_all.vendor_site_code%type;

662: x_msg_data IN OUT NOCOPY VARCHAR2)
663: IS
664: l_procedure_name VARCHAR2(30) := 'MERGE_DIFF_VENDOR_AND_SITE';
665: l_progress NUMBER;
666: l_dup_vendor_site_code po_vendor_sites_all.vendor_site_code%type;
667:
668: BEGIN --{
669:
670: /* CASE 2b - site being merged is not the last site

Line 734: FROM po_vendors pv, po_vendor_sites_all pvs

730: -- in list.
731:
732: SELECT pvs.vendor_site_code
733: INTO l_dup_vendor_site_code
734: FROM po_vendors pv, po_vendor_sites_all pvs
735: WHERE pv.vendor_id = p_dup_vendor_id
736: AND pv.vendor_id = pvs.vendor_id
737: AND pvs.vendor_site_id = p_dup_vendor_site_id;
738:

Line 840: l_dup_vendor_site_code po_vendor_sites_all.vendor_site_code%type;

836: x_msg_data IN OUT NOCOPY VARCHAR2)
837: IS
838: l_procedure_name VARCHAR2(35) := 'MERGE_DIFF_VENDOR_LAST_SITE';
839: l_progress NUMBER;
840: l_dup_vendor_site_code po_vendor_sites_all.vendor_site_code%type;
841: BEGIN --{
842:
843: /* CASE 2a - site being merged is the last site
844:

Line 921: FROM po_vendors pv, po_vendor_sites_all pvs

917: fnd_file.put_line (fnd_file.log, l_progress|| 'Done pon_bid_headers');
918:
919: SELECT pvs.vendor_site_code
920: INTO l_dup_vendor_site_code
921: FROM po_vendors pv, po_vendor_sites_all pvs
922: WHERE pv.vendor_id = p_dup_vendor_id
923: AND pv.vendor_id = pvs.vendor_id
924: AND pvs.vendor_site_id = p_dup_vendor_site_id;
925: