APPS.JTF_FM_PARTY_MERGE_PKG SQL Statements

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

Line: 24

   select party_name
   from hz_parties
   where party_id = p_to_fk_id;

Line: 47

   select merge_reason_code
   into   l_merge_reason_code
   from   hz_merge_batch
   where  batch_id  = p_batch_id;

Line: 80

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

Line: 91

          update JTF_FM_PREVIEWS
          set fm_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  fm_party_id    = p_from_fk_id;

Line: 100

           update JTF_FM_PROCESSED
           set party_id          = p_to_fk_id,
             party_name          = l_party_name,
	          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: 108

           update JTF_FM_CONTENT_HISTORY
           set party_id          = p_to_fk_id,
             party_name          = l_party_name,
	          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: 119

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