APPS.AP_PARTYMERGE_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 70

      SELECT count(*)
      INTO   l_vndrsites_not_merged
      FROM   ap_supplier_sites_all	pav,
             ap_duplicate_vendors_all	adv
      WHERE  pav.vendor_site_id         =  adv.duplicate_vendor_site_id(+)
      AND    pav.party_site_id		=  p_from_fk_id
      AND    nvl(adv.process_flag,'N') 	<>  'Y';

Line: 103

         SELECT COUNT(*)
         INTO   l_unpaid_invoices
         FROM   ap_invoices_all     ai,
                ap_supplier_sites_all pav
         WHERE  ai.vendor_site_id               = pav.vendor_site_id
         AND    pav.party_site_id               = p_from_fk_id
         AND    nvl(ai.payment_status_flag,'N') <> 'Y';

Line: 150

         SELECT COUNT(*)
         INTO   l_po_unchecked_sites
         FROM   ap_duplicate_vendors_all adv,
                ap_supplier_sites_all    pav
         WHERE  pav.vendor_site_id    =  adv.duplicate_vendor_site_id
         AND    pav.party_site_id     =  p_from_fk_id
         AND    nvl(adv.process, 'N') =  'I';

Line: 182

         SELECT  count(*)
         INTO    l_no_mergedto_site
         FROM    ap_supplier_sites_all pav
         WHERE   pav.party_site_id = p_from_fk_id
         AND NOT EXISTS
			(select vendor_site_id
			 from   ap_supplier_sites_all pav1
	                 where  pav1.party_site_id = p_to_fk_id);

Line: 220

         SELECT count(*)
         INTO   l_mismatch_merge_sites
         FROM   ap_duplicate_vendors_all adv,
                ap_supplier_sites_all	 pav
         WHERE  pav.party_site_id 	 = p_from_fk_id
         AND    pav.vendor_site_id	 = adv.duplicate_vendor_site_id
         AND NOT EXISTS
			(select adv1.vendor_site_id
			 from   ap_duplicate_vendors_all adv1,
				ap_supplier_sites_all    pav1
			 where  adv1.vendor_site_id	  = pav1.vendor_site_id
			 and    pav1.party_site_id	  = p_to_fk_id);

Line: 339

     SELECT count(*)
     INTO   l_vndrsites_not_merged
     FROM   ap_suppliers  		 pov,
            ap_supplier_sites_all        pvs,
            ap_duplicate_vendors_all     adv
     WHERE  pov.party_id                 = p_from_fk_id
     AND    pov.vendor_id                = pvs.vendor_id
     AND    pvs.vendor_site_id           = adv.duplicate_vendor_site_id (+)
     AND    nvl(adv.process_flag, 'N')	 <> 'Y';

Line: 375

        SELECT COUNT(*)
        INTO   l_unpaid_invoices
        FROM   ap_invoices_all	     ai,
               ap_suppliers	     pov,
               ap_supplier_sites_all pvs
        WHERE  ai.vendor_site_id                = pvs.vendor_site_id
        AND    pvs.vendor_id                    = pov.vendor_id
        AND    pov.party_id                     = p_from_fk_id
        AND    nvl(ai.payment_status_flag,'N')  <> 'Y';

Line: 424

        SELECT COUNT(*)
        INTO   l_po_unchecked_sites
        FROM   ap_duplicate_vendors_all adv,
               ap_supplier_sites_all    pvs,
               ap_suppliers		pov
        WHERE pov.party_id		= p_from_fk_id
        and   pov.vendor_id		= pvs.vendor_id
        and   pvs.vendor_site_id	= adv.duplicate_vendor_site_id
        and   nvl(adv.process, 'N')	= 'I';

Line: 461

        SELECT count(*)
        INTO   l_no_mergedto_site
        FROM   ap_supplier_sites_all pvs,
               ap_suppliers          pov
        WHERE  pov.party_id	   = p_from_fk_id
        AND    pov.vendor_id	   = pvs.vendor_id
        AND NOT EXISTS
		     (select vendor_site_id
		      from   ap_supplier_sites_all pvs1,
			     ap_suppliers          pov1
		      where  pov1.party_id    = p_to_fk_id
		      and    pov1.vendor_id   = pvs1.vendor_id);

Line: 503

        SELECT count(*)
        INTO   l_mismatch_merge_sites
        FROM   ap_duplicate_vendors_all    adv,
               ap_supplier_sites_all	   apss,
               ap_suppliers		   aps
        WHERE  aps.party_id	  =  p_from_fk_id
        AND    aps.vendor_id	  =  apss.vendor_id
        AND    apss.vendor_site_id =  adv.duplicate_vendor_site_id
        AND NOT EXISTS
		(select adv1.vendor_site_id
                 from	ap_duplicate_vendors_all    adv1,
			ap_supplier_sites_all       apss1,
			ap_suppliers                aps1
		 where  adv1.vendor_site_id = apss1.vendor_site_id
		 and	apss1.vendor_id     = aps1.vendor_id
		 and	aps1.party_id       = p_to_fk_id);

Line: 557

Procedure Update_PerPartyid
		(p_Entity_name        IN     VARCHAR2,
		 p_from_id            IN     NUMBER,
		 p_to_id              IN     NUMBER,
		 p_From_Fk_id         IN     NUMBER,
		 p_To_Fk_id           IN     NUMBER,
		 p_Parent_Entity_name IN     VARCHAR2,
		 p_batch_id           IN     NUMBER,
		 p_Batch_Party_id     IN     NUMBER,
		 x_return_status      IN OUT NOCOPY VARCHAR2) IS

     new_per_party_id	NUMBER := p_to_fk_id;

Line: 570

     l_api_name		CONSTANT VARCHAR2(30) := 'Update_PerPartyid';

Line: 584

     UPDATE ap_supplier_contacts
--po_vendor_contacts
     SET    per_party_id   = new_per_party_id
     WHERE  per_party_id   = old_per_party_id;

Line: 609

END Update_PerPartyid ;

Line: 615

Procedure Update_RelPartyid
		(p_Entity_name        IN     VARCHAR2,
		 p_from_id            IN     NUMBER,
		 p_to_id              IN     NUMBER,
		 p_From_Fk_id         IN     NUMBER,
		 p_To_Fk_id           IN     NUMBER,
		 p_Parent_Entity_name IN     VARCHAR2,
		 p_batch_id           IN     NUMBER,
		 p_Batch_Party_id     IN     NUMBER,
		 x_return_status      IN OUT NOCOPY VARCHAR2) IS

     new_rel_party_id  NUMBER := p_to_fk_id;

Line: 628

     l_api_name              CONSTANT VARCHAR2(30)   := 'Update_RelPartyid';

Line: 642

     UPDATE ap_supplier_contacts
--po_vendor_contacts
     SET    rel_party_id   = new_rel_party_id
     WHERE  rel_party_id = old_rel_party_id;

Line: 667

END Update_RelPartyid;

Line: 673

Procedure Update_PartySiteid
		(p_Entity_name        IN     VARCHAR2,
		 p_from_id            IN     NUMBER,
		 p_to_id              IN     NUMBER,
		 p_From_Fk_id         IN     NUMBER,
		 p_To_Fk_id           IN     NUMBER,
		 p_Parent_Entity_name IN     VARCHAR2,
		 p_batch_id           IN     NUMBER,
		 p_Batch_Party_id     IN     NUMBER,
		 x_return_status      IN OUT NOCOPY VARCHAR2) IS

     new_party_site_id  NUMBER := p_to_fk_id;

Line: 686

     l_api_name              CONSTANT VARCHAR2(30)   := 'Update_PartySiteid';

Line: 700

     UPDATE ap_supplier_contacts
-- po_vendor_contacts
     SET    party_site_id   = new_party_site_id
     WHERE  party_site_id = old_party_site_id;

Line: 725

END Update_PartySiteid ;