DBA Data[Home] [Help]

APPS.ARP_CMERGE_ARCUS dependencies on HZ_CUST_ACCT_RELATE_ALL_M

Line 8208: ---------Insert into hz_cust_acct_relate_all_m--------------

8204: AND su.org_id = m.org_id; --SSUptake
8205:
8206: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_SITE_USES_ALL_M');
8207:
8208: ---------Insert into hz_cust_acct_relate_all_m--------------
8209: INSERT INTO hz_cust_acct_relate_all_m(
8210: customer_merge_header_id,
8211: cust_account_id ,
8212: related_cust_account_id ,

Line 8209: INSERT INTO hz_cust_acct_relate_all_m(

8205:
8206: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_SITE_USES_ALL_M');
8207:
8208: ---------Insert into hz_cust_acct_relate_all_m--------------
8209: INSERT INTO hz_cust_acct_relate_all_m(
8210: customer_merge_header_id,
8211: cust_account_id ,
8212: related_cust_account_id ,
8213: last_update_date ,

Line 8302: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCT_RELATE_ALL_M');

8298: WHERE ( yt.cust_account_id = duplicate_id OR
8299: yt.related_cust_account_id = duplicate_id )
8300: AND m.org_id = yt.org_id ; --SSUptake
8301:
8302: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCT_RELATE_ALL_M');
8303:
8304:
8305: ---After storing the merge data sucessfully initialize the status to 0
8306: status := 0;