APPS.PVX_PARTY_MERGE_PKG SQL Statements

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

Line: 82

             UPDATE pv_referrals_b
             SET    partner_id         = p_to_fk_id,
                    last_update_date   = SYSDATE,
                    last_updated_by    = G_USER_ID,
	            last_update_login  = G_LOGIN_ID
             WHERE  partner_id         = p_from_fk_id;

Line: 89

             UPDATE pv_referrals_b
             SET    customer_party_id  = p_to_fk_id,
                    last_update_date   = SYSDATE,
                    last_updated_by    = G_USER_ID,
	            last_update_login  = G_LOGIN_ID
             WHERE  customer_party_id  = p_from_fk_id;

Line: 100

             UPDATE pv_referrals_b
             SET    customer_party_site_id = p_to_fk_id,
                    last_update_date       = SYSDATE,
                    last_updated_by        = G_USER_ID,
	            last_update_login      = G_LOGIN_ID
             WHERE  customer_party_site_id = p_from_fk_id;

Line: 111

             UPDATE pv_referrals_b
             SET    customer_contact_party_id = p_to_fk_id,
                    last_update_date          = SYSDATE,
                    last_updated_by           = G_USER_ID,
	            last_update_login         = G_LOGIN_ID
             WHERE  customer_contact_party_id = p_from_fk_id;

Line: 122

             UPDATE pv_referrals_b
             SET    customer_org_contact_id = p_to_fk_id,
                    last_update_date        = SYSDATE,
                    last_updated_by         = G_USER_ID,
	            last_update_login       = G_LOGIN_ID
             WHERE  customer_org_contact_id = p_from_fk_id;

Line: 150

    SELECT partner_party_id from pv_partner_profiles where
                        partner_party_id = p_party_id and
                        (status = 'A' OR STATUS = 'I');

Line: 180

	SELECT hzr.object_id
	FROM pv_partner_profiles  ppp,
	     hz_relationships hzr
	WHERE ppp.partner_party_id = cv_party_id
	AND ppp.partner_id = cv_partner_id
	AND hzr.subject_id = ppp.partner_party_id
	AND hzr.party_id = ppp.partner_id
	AND hzr.subject_type = 'ORGANIZATION'
	AND hzr.subject_table_name = 'HZ_PARTIES'
	AND hzr.object_type = 'ORGANIZATION'
	AND hzr.object_table_name = 'HZ_PARTIES'
	AND hzr.relationship_code = 'PARTNER_OF' ;

Line: 283

      SELECT DISTINCT a.partner_profile_id, a.partner_party_id, b.party_id partner_id
      FROM   pv_partner_profiles a,
             hz_relationships    b
      WHERE  a.partner_party_id = p_from_fk_id AND
             a.partner_id = b.party_id AND
             b.relationship_code = 'PARTNER_OF' AND
             b.status = 'A'; */

Line: 293

            SELECT partner_profile_id, partner_party_id, partner_id
            FROM   pv_partner_profiles
            WHERE  partner_party_id = p_from_fk_id
	    AND status = 'A';

Line: 300

            SELECT partner_profile_id, partner_party_id, partner_id
            FROM   pv_partner_profiles
            WHERE  partner_party_id = p_to_fk_id
	    AND status = 'A';

Line: 323

      UPDATE pv_partner_profiles
      SET    partner_party_id   = p_to_fk_id,
             last_update_date   = SYSDATE,
             last_updated_by    = G_USER_ID,
	     last_update_login  = G_LOGIN_ID
      WHERE  partner_profile_id = x.partner_profile_id;

Line: 340

			UPDATE pv_partner_profiles
			SET    status   =  'M',
				last_update_date   = SYSDATE,
				last_updated_by    = G_USER_ID,
           			last_update_login  = G_LOGIN_ID
			WHERE  partner_profile_id = x.partner_profile_id;

Line: 348

			UPDATE pv_partner_profiles
			SET    partner_party_id   =  p_to_fk_id,
				last_update_date   = SYSDATE,
				last_updated_by    = G_USER_ID,
           			last_update_login  = G_LOGIN_ID
			WHERE  partner_profile_id = x.partner_profile_id;

Line: 361

                 UPDATE pv_partner_profiles
                 SET    partner_party_id   =  p_to_fk_id,
                        last_update_date   = SYSDATE,
                        last_updated_by    = G_USER_ID,
           	        last_update_login  = G_LOGIN_ID
                 WHERE  partner_profile_id = x.partner_profile_id;

Line: 449

   select 1
   from   PV_LEAD_ASSIGNMENTS
   where  partner_id = p_from_fk_id
   for    update nowait;

Line: 469

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 498

      FOR x IN (SELECT DISTINCT partner_id
                FROM   pv_lead_assignments
		WHERE  partner_id = p_to_fk_id)
      LOOP
         p_to_id := x.partner_id;

Line: 506

         FOR x IN (SELECT DISTINCT related_party_id
	           FROM   pv_lead_assignments
	           WHERE  related_party_id = p_to_fk_id)
         LOOP
	    p_to_id := x.related_party_id;

Line: 514

      UPDATE PV_LEAD_ASSIGNMENTS
      SET    partner_id         = p_to_fk_id,
	     last_update_date   = SYSDATE,
             last_updated_by    = G_USER_ID,
             last_update_login  = G_LOGIN_ID
      WHERE  partner_id         = p_from_fk_id;

Line: 549

   select 1
   from   PV_ASSIGNMENT_LOGS
   where  partner_id = p_from_fk_id
   for    update nowait;

Line: 569

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 600

            select DISTINCT partner_id into l_ppf_id
            from   PV_ASSIGNMENT_LOGS
            where  partner_id = p_to_fk_id;

Line: 609

	 update PV_ASSIGNMENT_LOGS
	 set    partner_id          = decode(partner_id, p_from_fk_id, p_to_fk_id, partner_id),
	        last_update_date   = SYSDATE,
	        last_updated_by    = G_USER_ID,
	        last_update_login  = G_LOGIN_ID
	 where  partner_id          = p_from_fk_id;

Line: 689

   select 1
   from   PV_LEAD_PSS_LINES
   where  partner_id = p_from_fk_id
   for    update nowait;

Line: 709

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 740

            select DISTINCT partner_id into l_ppf_id
            from   PV_LEAD_PSS_LINES
            where  partner_id = p_to_fk_id;

Line: 749

	 update PV_LEAD_PSS_LINES
	 set    partner_id          = decode(partner_id, p_from_fk_id, p_to_fk_id, partner_id),
	        last_update_date    = SYSDATE,
	        last_updated_by     = G_USER_ID,
	        last_update_login   = G_LOGIN_ID
         where  partner_id          = p_from_fk_id;

Line: 789

   select 1
   from   PV_GE_PARTY_NOTIFICATIONS
   where  partner_id = p_from_fk_id
   for    update nowait;

Line: 809

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 841

            SELECT DISTINCT partner_id INTO l_ppf_id
            FROM   PV_GE_PARTY_NOTIFICATIONS
            WHERE  partner_id = p_to_fk_id;

Line: 851

	 update PV_GE_PARTY_NOTIFICATIONS
	 set    partner_id          = p_to_fk_id,
	        last_update_date   = SYSDATE,
	        last_updated_by    = G_USER_ID,
	        last_update_login  = G_LOGIN_ID
	 where  partner_id          = p_from_fk_id;

Line: 890

   select 1
   from   PV_PG_ENRL_REQUESTS
   where  partner_id = p_from_fk_id
   for    update nowait;

Line: 947

   SELECT attr_value
   FROM   pv_enty_attr_values
   WHERE  entity='PARTNER'
   AND    entity_id=p_ptr_id
   AND    attribute_id=6
   AND    latest_flag='Y';

Line: 984

         SELECT DISTINCT partner_id INTO l_ppf_id
         FROM   PV_PG_MEMBERSHIPS
         WHERE  partner_id = p_to_fk_id;

Line: 994

      update PV_PG_MEMBERSHIPS
      set    partner_id          = p_to_fk_id,
             last_update_date   = SYSDATE,
             last_updated_by    = G_USER_ID,
             last_update_login  = G_LOGIN_ID
             where  partner_id          = p_from_fk_id;

Line: 1116

      select partner_access_id from pv_partner_accesses a
      where partner_id= c_from_fk_id
      and exists (select null from pv_partner_accesses b
                  where partner_id = c_to_fk_id
		  and b.resource_id = a.resource_id );

Line: 1124

    SELECT processed_flag, object_version_number
    FROM   pv_tap_batch_chg_partners
    WHERE  partner_id = cv_partner_id;

Line: 1154

   select merge_reason_code into l_merge_reason_code
   from HZ_MERGE_BATCH
   where batch_id = p_batch_id;

Line: 1195

                  DELETE FROM  pv_tap_access_terrs
                  WHERE partner_access_id = I.partner_access_id;

Line: 1198

                  DELETE FROM pv_partner_accesses
                  WHERE partner_access_id = I.partner_access_id;

Line: 1203

             UPDATE PV_PARTNER_ACCESSES
             set object_version_number =  nvl(object_version_number,0) + 1,
                  partner_id = p_to_fk_id,
                  last_update_date = SYSDATE,
	          last_updated_by    = G_USER_ID,
	          last_update_login  = G_LOGIN_ID,
                  program_application_id=hz_utility_pub.program_application_id,
                  program_id = hz_utility_pub.program_id,
                  program_update_date = SYSDATE
             where partner_id = p_from_fk_id;

Line: 1245

                      PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
                         p_api_version_number    => 1.0
                         ,p_init_msg_list        => FND_API.G_FALSE
                         ,p_commit               => FND_API.G_FALSE
                         ,p_validation_level     => FND_API.G_VALID_LEVEL_FULL
                         ,x_return_status        => l_return_status
                         ,x_msg_count            => l_msg_count
                         ,x_msg_data             => l_msg_data
                         ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);

Line: 1260

                             FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');

Line: 1362

   select 1
   from   PV_PG_ENRL_REQUESTS
   where  partner_id = p_from_fk_id
   for    update nowait;

Line: 1382

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 1414

            SELECT DISTINCT partner_id INTO l_ppf_id
            FROM   PV_PG_ENRL_REQUESTS
            WHERE  partner_id = p_to_fk_id;

Line: 1424

	 update PV_PG_ENRL_REQUESTS
	 set    contract_binding_contact_id = p_to_fk_id,
	        last_update_date   = SYSDATE,
	        last_updated_by    = G_USER_ID,
	        last_update_login  = G_LOGIN_ID
	 where  contract_binding_contact_id = p_from_fk_id;