DBA Data[Home] [Help]

APPS.ARP_CMERGE_ARCUS dependencies on HZ_CUST_ACCT_SITES_ALL_M

Line 7786: ---------Insert into hz_cust_acct_sites_all_m--------------

7782: OR (pa.site_use_id = duplicate_site_id);
7783:
7784: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_PROFILE_AMTS_M');
7785:
7786: ---------Insert into hz_cust_acct_sites_all_m--------------
7787: INSERT INTO hz_cust_acct_sites_all_m(
7788: customer_merge_header_id,
7789: cust_acct_site_id ,
7790: cust_account_id ,

Line 7787: INSERT INTO hz_cust_acct_sites_all_m(

7783:
7784: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_PROFILE_AMTS_M');
7785:
7786: ---------Insert into hz_cust_acct_sites_all_m--------------
7787: INSERT INTO hz_cust_acct_sites_all_m(
7788: customer_merge_header_id,
7789: cust_acct_site_id ,
7790: cust_account_id ,
7791: party_site_id ,

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

7950: and cm.set_number = set_num ) m,hz_cust_acct_sites_all acs
7951: WHERE acs.cust_acct_site_id = duplicate_address_id
7952: AND acs.org_id = m.org_id ;
7953:
7954: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCT_SITES_ALL_M');
7955:
7956: ---------Insert into hz_cust_site_uses_all_m--------------
7957: INSERT INTO hz_cust_site_uses_all_m(
7958: customer_merge_header_id,