APPS.AMS_PARTY_MERGE_PVT SQL Statements

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

Line: 27

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 83

         UPDATE AMS_EVENT_REGISTRATIONS
         set REGISTRANT_PARTY_ID = p_to_fk_id,
           last_update_date = hz_utility_pub.last_update_date,
           last_updated_by = hz_utility_pub.user_id,
           last_update_login = hz_utility_pub.last_update_login,
           program_application_id = hz_utility_pub.program_application_id,
           program_id = hz_utility_pub.program_id,
           program_update_date = sysdate
         where REGISTRANT_PARTY_ID = p_from_fk_id;

Line: 96

         UPDATE AMS_EVENT_REGISTRATIONS
         set REGISTRANT_CONTACT_ID = p_to_fk_id,
           last_update_date = hz_utility_pub.last_update_date,
           last_updated_by = hz_utility_pub.user_id,
           last_update_login = hz_utility_pub.last_update_login,
           program_application_id = hz_utility_pub.program_application_id,
           program_id = hz_utility_pub.program_id,
           program_update_date = sysdate
         where REGISTRANT_CONTACT_ID = p_from_fk_id;

Line: 111

         UPDATE AMS_EVENT_REGISTRATIONS
         set REGISTRANT_CONTACT_ID = p_to_fk_id,
           last_update_date = hz_utility_pub.last_update_date,
           last_updated_by = hz_utility_pub.user_id,
           last_update_login = hz_utility_pub.last_update_login,
           program_application_id = hz_utility_pub.program_application_id,
           program_id = hz_utility_pub.program_id,
           program_update_date = sysdate
         where REGISTRANT_CONTACT_ID = p_from_fk_id;

Line: 155

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 210

         UPDATE AMS_EVENT_REGISTRATIONS
         set ATTENDANT_PARTY_ID = p_to_fk_id,
           last_update_date = hz_utility_pub.last_update_date,
           last_updated_by = hz_utility_pub.user_id,
           last_update_login = hz_utility_pub.last_update_login,
           program_application_id = hz_utility_pub.program_application_id,
           program_id = hz_utility_pub.program_id,
           program_update_date = sysdate
         where ATTENDANT_PARTY_ID = p_from_fk_id;

Line: 223

         UPDATE AMS_EVENT_REGISTRATIONS
         set ATTENDANT_CONTACT_ID = p_to_fk_id,
           last_update_date = hz_utility_pub.last_update_date,
           last_updated_by = hz_utility_pub.user_id,
           last_update_login = hz_utility_pub.last_update_login,
           program_application_id = hz_utility_pub.program_application_id,
           program_id = hz_utility_pub.program_id,
           program_update_date = sysdate
         where ATTENDANT_CONTACT_ID = p_from_fk_id;

Line: 238

         UPDATE AMS_EVENT_REGISTRATIONS
         set ATTENDANT_CONTACT_ID = p_to_fk_id,
           last_update_date = hz_utility_pub.last_update_date,
           last_updated_by = hz_utility_pub.user_id,
           last_update_login = hz_utility_pub.last_update_login,
           program_application_id = hz_utility_pub.program_application_id,
           program_id = hz_utility_pub.program_id,
           program_update_date = sysdate
         where ATTENDANT_CONTACT_ID = p_from_fk_id;

Line: 289

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 346

            UPDATE AMS_CHANNELS_B
            SET   party_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where party_id = p_from_fk_id;

Line: 397

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 454

            UPDATE AMS_PARTY_SOURCES
            SET   party_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where party_id = p_from_fk_id;

Line: 505

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 562

            UPDATE AMS_PARTY_MARKET_SEGMENTS
            SET   party_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where party_id = p_from_fk_id;

Line: 613

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 670

            UPDATE AMS_IBA_POSTINGS_B
            SET customer_party_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login
               --, program_application_id = hz_utility_pub.program_application_id,
               -- program_id = hz_utility_pub.program_id,
               -- program_update_date = sysdate
            where customer_party_id = p_from_fk_id;

Line: 721

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 778

            UPDATE AMS_IBA_POSTINGS_B
            SET affiliate_party_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login
               -- ,program_application_id = hz_utility_pub.program_application_id,
               -- program_id = hz_utility_pub.program_id,
               -- program_update_date = sysdate
            where affiliate_party_id = p_from_fk_id;

Line: 830

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 848

            UPDATE AMS_ACT_PARTNERS
            SET partner_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login
               --, 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: 899

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 917

            UPDATE AMS_ACT_PARTNERS
            SET preferred_vad_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login
               --,program_application_id = hz_utility_pub.program_application_id,
               -- program_id = hz_utility_pub.program_id,
               -- program_update_date = sysdate
            where preferred_vad_id = p_from_fk_id;

Line: 968

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 986

            UPDATE AMS_ACT_PARTNERS
            SET primary_contact_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login
               --, program_application_id = hz_utility_pub.program_application_id,
               -- program_id = hz_utility_pub.program_id,
               -- program_update_date = sysdate
            where primary_contact_id = p_from_fk_id;

Line: 1016

select trade_profile_id
from   ozf_cust_trd_prfls_all
where  party_id = p_party_id
and    cust_account_id is null;

Line: 1064

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 1086

               UPDATE OZF_CUST_TRD_PRFLS_ALL
               SET party_id = p_to_fk_id,
                last_update_date = hz_utility_pub.last_update_date,
                last_updated_by = hz_utility_pub.user_id,
                last_update_login = hz_utility_pub.last_update_login,
                program_application_id = hz_utility_pub.program_application_id,
                program_id = hz_utility_pub.program_id,
                program_update_date = sysdate
               where party_id = p_from_fk_id;

Line: 1097

               DELETE FROM OZF_CUST_TRD_PRFLS_ALL
               WHERE party_id = p_from_fk_id
               AND   cust_account_id is null;

Line: 1144

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 1162

            UPDATE OZF_CLAIMS_ALL
            SET broker_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where broker_id = p_from_fk_id;

Line: 1214

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 1232

            UPDATE OZF_CLAIMS_ALL
            SET contact_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where contact_id = p_from_fk_id;

Line: 1285

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 1303

            UPDATE OZF_CLAIMS_HISTORY_ALL
            SET broker_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where broker_id = p_from_fk_id;

Line: 1356

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 1374

            UPDATE OZF_CLAIMS_HISTORY_ALL
            SET contact_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login,
               program_application_id = hz_utility_pub.program_application_id,
               program_id = hz_utility_pub.program_id,
               program_update_date = sysdate
            where contact_id = p_from_fk_id;

Line: 1426

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 1444

            UPDATE AMS_ACT_BUDGETS
            SET budget_source_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login
               -- ,program_application_id = hz_utility_pub.program_application_id,
               -- program_id = hz_utility_pub.program_id,
               -- program_update_date = sysdate
            where budget_source_id = p_from_fk_id
            and   budget_source_type = 'PTNR' ;

Line: 1497

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 1515

            UPDATE AMS_ACT_BUDGETS
            SET vendor_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login
               -- ,program_application_id = hz_utility_pub.program_application_id,
               -- program_id = hz_utility_pub.program_id,
               -- program_update_date = sysdate
            where vendor_id = p_from_fk_id;

Line: 1560

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 1578

            UPDATE AMS_OFFERS
            SET BUYING_GROUP_CONTACT_ID  = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login
            where BUYING_GROUP_CONTACT_ID = p_from_fk_id;

Line: 1628

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 1646

            UPDATE ams_competitor_products_b
            SET COMPETITOR_PARTY_ID = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login
            where COMPETITOR_PARTY_ID = p_from_fk_id  ;

Line: 1694

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 1712

            UPDATE AMS_IBA_PL_SITES_B
            SET SITE_CATEGORY_OBJECT_ID = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login
            where SITE_CATEGORY_OBJECT_ID = p_from_fk_id
            and   SITE_CATEGORY_TYPE = 'AFFILIATES' ;

Line: 1761

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 1818

            UPDATE AMS_IMP_SOURCE_LINES
            SET   party_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login
            where party_id = p_from_fk_id;

Line: 1866

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 1923

            UPDATE AMS_LIST_ENTRIES
            SET   party_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login
            where party_id = p_from_fk_id;

Line: 1971

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 2028

            UPDATE AMS_LIST_ENTRIES
            SET   parent_party_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login
            where parent_party_id = p_from_fk_id;

Line: 2076

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 2133

            UPDATE AMS_VENUES_B
            SET   party_id = p_to_fk_id,
               last_update_date = hz_utility_pub.last_update_date,
               last_updated_by = hz_utility_pub.user_id,
               last_update_login = hz_utility_pub.last_update_login
	       --enabled_flag = 'N'  -- added to fix bug#3483075:anchaudh
            where party_id = p_from_fk_id;

Line: 2177

  SELECT qp_list_header_id
  FROM   ams_offer_parties
  WHERE  party_id = p_from_fk_id;

Line: 2182

  SELECT 'Y'
  FROM   ams_offer_parties
  WHERE  qp_list_header_id = l_list_header_id
  AND    party_id = l_party_id;

Line: 2195

    SELECT merge_reason_code INTO l_merge_reason_code
    FROM HZ_MERGE_BATCH
    WHERE batch_id = p_batch_id;

Line: 2258

            DELETE FROM ams_offer_parties
            WHERE qp_list_header_id = l_list_header_id.qp_list_header_id
            AND   party_id = p_from_fk_id;

Line: 2262

            UPDATE ams_offer_parties
            SET    party_id = p_to_fk_id
	                ,last_update_date = hz_utility_pub.last_update_date
                  ,last_updated_by = hz_utility_pub.user_id
                  ,last_update_login = hz_utility_pub.last_update_login
            WHERE  qp_list_header_id = l_list_header_id.qp_list_header_id
            AND    party_id = p_from_fk_id;

Line: 2319

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 2379

               UPDATE AMS_ACT_RESOURCES
               SET   resource_id = p_to_fk_id,
                     last_update_date = hz_utility_pub.last_update_date,
                     last_updated_by = hz_utility_pub.user_id,
                     last_update_login = hz_utility_pub.last_update_login
               where resource_id = p_from_fk_id;

Line: 2430

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 2489

               UPDATE AMS_AGENDAS_B
               SET   coordinator_id = p_to_fk_id,
                     last_update_date = hz_utility_pub.last_update_date,
                     last_updated_by = hz_utility_pub.user_id,
                     last_update_login = hz_utility_pub.last_update_login
               where coordinator_id = p_from_fk_id;

Line: 2542

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 2598

	      	 -- Delete all the rows with which have the p_from_fk_id and media_id combination same as p_to_fk_id and media_id
		 DELETE FROM AMS_TCOP_CHANNEL_SUMMARY
		 WHERE party_id = p_from_fk_id
		 and channel_summary_id in
		 (SELECT f.channel_summary_id
		  FROM AMS_TCOP_CHANNEL_SUMMARY f, AMS_TCOP_CHANNEL_SUMMARY t
		  WHERE f.party_id = p_from_fk_id
		        AND t.party_id = p_to_fk_id
                        AND f.MEDIA_ID  = t.MEDIA_ID);

Line: 2608

		   -- Update the rows which do not satisfy the above criteria
                   UPDATE AMS_TCOP_CHANNEL_SUMMARY
		   SET   party_id = p_to_fk_id,
                         last_update_date = hz_utility_pub.last_update_date,
                         last_updated_by = hz_utility_pub.user_id,
                         last_update_login = hz_utility_pub.last_update_login
		   WHERE party_id = p_from_fk_id
		   and channel_summary_id not in
		  (SELECT f.channel_summary_id
		   FROM AMS_TCOP_CHANNEL_SUMMARY f, AMS_TCOP_CHANNEL_SUMMARY t
		   WHERE f.party_id = p_from_fk_id
		        AND t.party_id = p_to_fk_id
                        AND f.MEDIA_ID  = t.MEDIA_ID);

Line: 2671

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 2727

	         DELETE FROM AMS_TCOP_CONTACTS
		 WHERE party_id = p_from_fk_id
		 and CONTACT_ID  in
		 (SELECT f.CONTACT_ID
		  FROM AMS_TCOP_CONTACTS f, AMS_TCOP_CONTACTS t
		  WHERE f.party_id = p_from_fk_id
		        AND t.party_id = p_to_fk_id
                        AND f.SCHEDULE_ID  = t.SCHEDULE_ID);

Line: 2737

                   UPDATE AMS_TCOP_CONTACTS
		   SET   party_id = p_to_fk_id,
                         last_update_date = hz_utility_pub.last_update_date,
                         last_updated_by = hz_utility_pub.user_id,
                         last_update_login = hz_utility_pub.last_update_login
		   WHERE party_id = p_from_fk_id
		   and CONTACT_ID not in
		 (SELECT f.CONTACT_ID
		  FROM AMS_TCOP_CONTACTS f, AMS_TCOP_CONTACTS t
		  WHERE f.party_id = p_from_fk_id
		        AND t.party_id = p_to_fk_id
                        AND f.SCHEDULE_ID  = t.SCHEDULE_ID);

Line: 2793

	SELECT 1
	FROM AMS_TCOP_CONTACT_SUMMARY
	WHERE party_id = to_party;

Line: 2804

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 2873

		  DELETE FROM AMS_TCOP_CONTACT_SUMMARY
		  WHERE party_id = p_from_fk_id;

Line: 2877

	          UPDATE AMS_TCOP_CONTACT_SUMMARY
                  SET   party_id = p_to_fk_id,
                        last_update_date = hz_utility_pub.last_update_date,
                        last_updated_by = hz_utility_pub.user_id,
                        last_update_login = hz_utility_pub.last_update_login
                  WHERE party_id = p_from_fk_id;

Line: 2931

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 2989

		  UPDATE AMS_TCOP_PRVW_CONTACTS
                  SET   party_id = p_to_fk_id,
                        last_update_date = hz_utility_pub.last_update_date,
                        last_updated_by = hz_utility_pub.user_id,
                        last_update_login = hz_utility_pub.last_update_login
                  WHERE party_id = p_from_fk_id;

Line: 3042

    select merge_reason_code into l_merge_reason_code
    from HZ_MERGE_BATCH
    where batch_id = p_batch_id;

Line: 3098

	       DELETE FROM AMS_TCOP_PRVW_FTG_DTLS
		 WHERE party_id = p_from_fk_id
		 and FATIGUE_DETAIL_ID  in
		 (SELECT f.FATIGUE_DETAIL_ID
		  FROM AMS_TCOP_PRVW_FTG_DTLS f, AMS_TCOP_PRVW_FTG_DTLS t
		  WHERE f.party_id = p_from_fk_id
		        AND t.party_id = p_to_fk_id
                        AND f.PREVIEW_ID  = t.PREVIEW_ID);

Line: 3107

               UPDATE AMS_TCOP_PRVW_FTG_DTLS
               SET   party_id = p_to_fk_id,
                     last_update_date = hz_utility_pub.last_update_date,
                     last_updated_by = hz_utility_pub.user_id,
                     last_update_login = hz_utility_pub.last_update_login
               where party_id = p_from_fk_id
	       and FATIGUE_DETAIL_ID not in
		 (SELECT f.FATIGUE_DETAIL_ID
		  FROM AMS_TCOP_PRVW_FTG_DTLS f, AMS_TCOP_PRVW_FTG_DTLS t
		  WHERE f.party_id = p_from_fk_id
		        AND t.party_id = p_to_fk_id
                        AND f.PREVIEW_ID  = t.PREVIEW_ID);