6602: BEGIN
6603:
6604: arp_message.set_line( 'ARP_CMERGE_ARCUS.Merge_History()+' );
6605:
6606: ---------Insert into HZ_CUST_ACCOUNTS_M--------------
6607: INSERT INTO HZ_CUST_ACCOUNTS_M(
6608: customer_merge_header_id,
6609: cust_account_id,
6610: party_id ,
6603:
6604: arp_message.set_line( 'ARP_CMERGE_ARCUS.Merge_History()+' );
6605:
6606: ---------Insert into HZ_CUST_ACCOUNTS_M--------------
6607: INSERT INTO HZ_CUST_ACCOUNTS_M(
6608: customer_merge_header_id,
6609: cust_account_id,
6610: party_id ,
6611: last_update_date ,
6844: and cm.set_number = set_num) , HZ_CUST_ACCOUNTS c
6845: WHERE c.cust_account_id = duplicate_id
6846: AND duplicate_id <> customer_id;
6847:
6848: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCOUNTS_M');
6849:
6850:
6851:
6852: ---------Insert into hz_cust_account_roles_m--------------