APPS.AHL_PARTY_MERGE_PKG SQL Statements

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

Line: 51

   select 1
   from   ahl_documents_b
   where  source_party_id = p_from_fk_id
   for    update nowait;

Line: 69

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 102

	    -- obtain lock on records to be updated.
         arp_message.set_name('AR', 'AR_LOCKING_TABLE');

Line: 109

	    update ahl_documents_b
	    set    source_party_id           =  p_to_fk_id,
	           last_update_date   = SYSDATE,
	           last_updated_by    = G_USER_ID,
	           last_update_login  = G_LOGIN_ID
            where  source_party_id    = p_from_fk_id;

Line: 118

         arp_message.set_name('AR', 'AR_ROWS_UPDATED');

Line: 152

   select 1
   from   ahl_supplier_documents
   where  supplier_id = p_from_fk_id
   for    update nowait;

Line: 173

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 206

	    -- obtain lock on records to be updated.
         arp_message.set_name('AR', 'AR_LOCKING_TABLE');

Line: 213

	    update ahl_supplier_documents
	    set    supplier_id           =  p_to_fk_id,
	           last_update_date   = SYSDATE,
	           last_updated_by    = G_USER_ID,
	           last_update_login  = G_LOGIN_ID
            where  supplier_id        = p_from_fk_id;

Line: 222

         arp_message.set_name('AR', 'AR_ROWS_UPDATED');

Line: 255

   select 1
   from   ahl_recipient_documents
   where  recipient_party_id = p_from_fk_id
   for    update nowait;

Line: 273

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 306

	    -- obtain lock on records to be updated.
         arp_message.set_name('AR', 'AR_LOCKING_TABLE');

Line: 313

	    update ahl_recipient_documents
	    set    recipient_party_id           =  p_to_fk_id,
	           last_update_date   = SYSDATE,
	           last_updated_by    = G_USER_ID,
	           last_update_login  = G_LOGIN_ID
            where  recipient_party_id = p_from_fk_id;

Line: 322

         arp_message.set_name('AR', 'AR_ROWS_UPDATED');

Line: 355

   select 1
   from   ahl_subscriptions_b
   where  requested_by_party_id = p_from_fk_id
   for    update nowait;

Line: 376

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 409

	    -- obtain lock on records to be updated.
         arp_message.set_name('AR', 'AR_LOCKING_TABLE');

Line: 416

	    update ahl_subscriptions_b
	    set    requested_by_party_id           =  p_to_fk_id,
	           last_update_date   = SYSDATE,
	           last_updated_by    = G_USER_ID,
	           last_update_login  = G_LOGIN_ID
            where  requested_by_party_id   = p_from_fk_id;

Line: 425

         arp_message.set_name('AR', 'AR_ROWS_UPDATED');

Line: 458

   select 1
   from   ahl_subscriptions_b
   where  SUBSCRIBED_FRM_PARTY_ID = p_from_fk_id
   for    update nowait;

Line: 479

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 512

	    -- obtain lock on records to be updated.
         arp_message.set_name('AR', 'AR_LOCKING_TABLE');

Line: 519

	    update ahl_subscriptions_b
	    set    SUBSCRIBED_FRM_PARTY_ID =  p_to_fk_id,
	           last_update_date   = SYSDATE,
	           last_updated_by    = G_USER_ID,
	           last_update_login  = G_LOGIN_ID
            where  SUBSCRIBED_FRM_PARTY_ID = p_from_fk_id;

Line: 528

         arp_message.set_name('AR', 'AR_ROWS_UPDATED');

Line: 561

   select 1
   from   ahl_doc_revisions_b
   where  approved_by_party_id = p_from_fk_id
   for    update nowait;

Line: 583

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 616

	    -- obtain lock on records to be updated.
         arp_message.set_name('AR', 'AR_LOCKING_TABLE');

Line: 623

	    update ahl_doc_revisions_b
	    set    approved_by_party_id           =  p_to_fk_id,
	           last_update_date   = SYSDATE,
	           last_updated_by    = G_USER_ID,
	           last_update_login  = G_LOGIN_ID
            where  approved_by_party_id  = p_from_fk_id;

Line: 632

         arp_message.set_name('AR', 'AR_ROWS_UPDATED');

Line: 665

   select 1
   from   ahl_doc_revision_copies
   where  received_by_party_id = p_from_fk_id
   for    update nowait;

Line: 683

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 716

	    -- obtain lock on records to be updated.
         arp_message.set_name('AR', 'AR_LOCKING_TABLE');

Line: 723

	    update ahl_doc_revision_copies
	    set    received_by_party_id           =  p_to_fk_id,
	           last_update_date   = SYSDATE,
	           last_updated_by    = G_USER_ID,
	           last_update_login  = G_LOGIN_ID
            where  received_by_party_id  = p_from_fk_id;

Line: 732

         arp_message.set_name('AR', 'AR_ROWS_UPDATED');

Line: 765

   select 1
   from   ahl_operations_b
   where  operator_party_id = p_from_fk_id
   for    update nowait;

Line: 783

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 813

	    -- obtain lock on records to be updated.
         arp_message.set_name('AR', 'AR_LOCKING_TABLE');

Line: 820

	    update ahl_operations_b
	    set    operator_party_id           =  p_to_fk_id,
	           last_update_date   = SYSDATE,
	           last_updated_by    = G_USER_ID,
	           last_update_login  = G_LOGIN_ID
            where  operator_party_id  = p_from_fk_id;

Line: 829

         arp_message.set_name('AR', 'AR_ROWS_UPDATED');

Line: 862

   select 1
   from   ahl_operations_h_b
   where  operator_party_id = p_from_fk_id
   for    update nowait;

Line: 880

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 910

	    -- obtain lock on records to be updated.
         arp_message.set_name('AR', 'AR_LOCKING_TABLE');

Line: 917

	    update ahl_operations_h_b
	    set    operator_party_id           =  p_to_fk_id,
	           last_update_date   = SYSDATE,
	           last_updated_by    = G_USER_ID,
	           last_update_login  = G_LOGIN_ID
            where  operator_party_id  = p_from_fk_id;

Line: 926

         arp_message.set_name('AR', 'AR_ROWS_UPDATED');

Line: 959

   select 1
   from   ahl_routes_b
   where  operator_party_id = p_from_fk_id
   for    update nowait;

Line: 977

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 1007

	    -- obtain lock on records to be updated.
         arp_message.set_name('AR', 'AR_LOCKING_TABLE');

Line: 1014

	    update ahl_routes_b
	    set    operator_party_id           =  p_to_fk_id,
	           last_update_date   = SYSDATE,
	           last_updated_by    = G_USER_ID,
	           last_update_login  = G_LOGIN_ID
            where  operator_party_id  = p_from_fk_id;

Line: 1023

         arp_message.set_name('AR', 'AR_ROWS_UPDATED');

Line: 1056

   select 1
   from   ahl_routes_h_b
   where  operator_party_id = p_from_fk_id
   for    update nowait;

Line: 1074

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 1104

	    -- obtain lock on records to be updated.
         arp_message.set_name('AR', 'AR_LOCKING_TABLE');

Line: 1111

	    update ahl_routes_h_b
	    set    operator_party_id           =  p_to_fk_id,
	           last_update_date   = SYSDATE,
	           last_updated_by    = G_USER_ID,
	           last_update_login  = G_LOGIN_ID
            where  operator_party_id  = p_from_fk_id;

Line: 1120

         arp_message.set_name('AR', 'AR_ROWS_UPDATED');

Line: 1154

   select 1
   from   ahl_osp_orders_b
   where  customer_id = p_from_fk_id
   for    update nowait;

Line: 1172

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 1205

	    -- obtain lock on records to be updated.
         arp_message.set_name('AR', 'AR_LOCKING_TABLE');

Line: 1212

	    update ahl_osp_orders_b
	    set    customer_id        = p_to_fk_id,
	           last_update_date   = SYSDATE,
	           last_updated_by    = G_USER_ID,
	           last_update_login  = G_LOGIN_ID
            where  customer_id        = p_from_fk_id;

Line: 1221

         arp_message.set_name('AR', 'AR_ROWS_UPDATED');