APPS.FUN_PARTY_MERGE_PUB SQL Statements

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

Line: 31

  Select 'X' from
  FUN_TRX_BATCHES
  Where initiator_id = p_from_fk_id
  for update nowait;

Line: 37

  Select 'X' from
  FUN_TRX_HEADERS
  Where initiator_id = p_from_fk_id
  for update nowait;

Line: 48

   SELECT merge_reason_code
   INTO   l_merge_reason_code
   FROM   hz_merge_batch
   WHERE  batch_id  = p_batch_id;

Line: 92

         /*delete the existing target party ID  */
--         DELETE FROM FUN_TRX_BATCHES
--         WHERE party_id = p_To_Fk_id;

Line: 96

          /*  Update the "From" Party_ID to be equal to the new target  */
         UPDATE FUN_TRX_BATCHES
         SET initiator_id = p_To_FK_id,
             LAST_UPDATED_BY = hz_utility_pub.user_id,
             LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
             LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
         WHERE initiator_id = p_From_FK_id;

Line: 107

         UPDATE FUN_TRX_HEADERS
         SET initiator_id = p_To_FK_id,
             LAST_UPDATED_BY = hz_utility_pub.user_id,
             LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
             LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
         WHERE initiator_id = p_From_FK_id;

Line: 161

  Select 'X' from
  FUN_TRX_HEADERS
  Where recipient_id = p_from_fk_id
  for update nowait;

Line: 172

   SELECT merge_reason_code
   INTO   l_merge_reason_code
   FROM   hz_merge_batch
   WHERE  batch_id  = p_batch_id;

Line: 216

         /*delete the existing target party ID  */
--         DELETE FROM FUN_TRX_BATCHES
--         WHERE party_id = p_To_Fk_id;

Line: 221

         /*  Update the "From" Party_ID to be equal to the new target  */
         UPDATE FUN_TRX_HEADERS
         SET recipient_id = p_To_FK_id,
             LAST_UPDATED_BY = hz_utility_pub.user_id,
             LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
             LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
         WHERE recipient_id = p_From_FK_id;

Line: 276

  Select 'X' from
  FUN_DIST_LINES
  Where party_id = p_from_fk_id
  for update nowait;

Line: 287

   SELECT merge_reason_code
   INTO   l_merge_reason_code
   FROM   hz_merge_batch
   WHERE  batch_id  = p_batch_id;

Line: 331

         /*delete the existing target party ID  */
--         DELETE FROM FUN_TRX_BATCHES
--         WHERE party_id = p_To_Fk_id;

Line: 336

         /*  Update the "From" Party_ID to be equal to the new target  */
         UPDATE FUN_DIST_LINES
         SET party_id = p_To_FK_id,
             LAST_UPDATED_BY = hz_utility_pub.user_id,
             LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
             LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
         WHERE party_id = p_From_FK_id;

Line: 391

  Select 'X' from
  FUN_CUSTOMER_MAPS
  Where site_use_id = p_from_fk_id
  for update nowait;

Line: 402

   SELECT merge_reason_code
   INTO   l_merge_reason_code
   FROM   hz_merge_batch
   WHERE  batch_id  = p_batch_id;

Line: 445

         /*delete the existing target party ID  */
--         DELETE FROM FUN_TRX_BATCHES
--         WHERE party_id = p_To_Fk_id;

Line: 450

         /*  Update the "From" Party_ID to be equal to the new target  */
         UPDATE FUN_CUSTOMER_MAPS
         SET site_use_id = p_To_FK_id,
             LAST_UPDATED_BY = hz_utility_pub.user_id,
             LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
             LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
         WHERE site_use_id = p_From_FK_id;

Line: 503

  Select 'X' from
  FUN_SUPPLIER_MAPS
  Where vendor_site_id = p_from_fk_id
  for update nowait;

Line: 514

   SELECT merge_reason_code
   INTO   l_merge_reason_code
   FROM   hz_merge_batch
   WHERE  batch_id  = p_batch_id;

Line: 557

         /*delete the existing target party ID  */
--         DELETE FROM FUN_TRX_BATCHES
--         WHERE party_id = p_To_Fk_id;

Line: 562

         /*  Update the "From" Party_ID to be equal to the new target  */
         UPDATE FUN_SUPPLIER_MAPS
         SET vendor_site_id = p_To_FK_id,
             LAST_UPDATED_BY = hz_utility_pub.user_id,
             LAST_UPDATE_DATE = hz_utility_pub.last_update_date,
             LAST_UPDATE_LOGIN = hz_utility_pub.last_update_login
         WHERE vendor_site_id = p_From_FK_id;