APPS.OKS_PARTY_MERGE_PKG SQL Statements

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

Line: 6

g_login_id    constant  number(15)   := arp_standard.profile.last_update_login;

Line: 44

      update oks_billing_profiles_b
	 set owned_party_id1    = p_to_fk_id,
	     last_update_date   = sysdate,
	     last_updated_by    = g_user_id,
	     last_update_login  = g_login_id,
		object_version_number = object_version_number+1
      where owned_party_id1 = p_from_fk_id;

Line: 53

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

Line: 93

  SELECT start_date,end_date
  FROM  oks_k_defaults
  where segment_id1 =p_fk_id;

Line: 151

         update oks_k_defaults
	     set segment_id1    = p_to_fk_id,
	     last_update_date   = sysdate,
         last_updated_by    = g_user_id,
		 object_version_number = object_version_number+1
         where segment_id1 = p_from_fk_id
	     and jtot_object_code = 'OKX_PARTY';

Line: 162

                update oks_k_defaults
	            set
                start_date    =   l_to_start_date1,
                end_date      =   l_to_end_date1,
                last_update_date   = sysdate,
                last_updated_by    = g_user_id,
		        object_version_number = object_version_number+1
                where segment_id1 = p_to_fk_id
	            and jtot_object_code = 'OKX_PARTY';

Line: 173

               update oks_k_defaults
 	           set
                start_date    =   l_to_start_date1,
                last_update_date   = sysdate,
                last_updated_by    = g_user_id,
		        object_version_number = object_version_number+1
                where segment_id1 = p_to_fk_id
	            and jtot_object_code = 'OKX_PARTY';

Line: 183

               update oks_k_defaults
 	           set
                end_date    =   l_to_end_date1,
                last_update_date   = sysdate,
                last_updated_by    = g_user_id,
		        object_version_number = object_version_number+1
                where segment_id1 = p_to_fk_id
	            and jtot_object_code = 'OKX_PARTY';

Line: 194

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

Line: 196

         update oks_k_defaults
	     set segment_id1    = p_to_fk_id,
	     last_update_date   = sysdate,
         last_updated_by    = g_user_id,
         start_date  =  l_from_start_date,
         end_date  =  l_from_end_date,
		 object_version_number = object_version_number+1
         where segment_id1 = p_from_fk_id
	     and jtot_object_code = 'OKX_PARTY';

Line: 206

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

Line: 257

      update oks_serv_avail_excepts
	 set object1_id1        = p_to_fk_id,
	     last_update_date   = sysdate,
	     last_updated_by    = g_user_id,
	     last_update_login  = g_login_id,
		object_version_number = object_version_number+1
      where object1_id1 = p_from_fk_id
	   and jtot_object1_code = 'OKX_PARTY';

Line: 267

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

Line: 272

      delete from oks_serv_avail_excepts
      where object1_id1 in (p_from_fk_id,p_to_fk_id)
	   and jtot_object1_code = 'OKX_PARTY';

Line: 277

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