The following lines contain the word 'select', 'insert', 'update' or 'delete':
select discount_line_id
from so_discount_lines
where entity_value in (select to_char(m.duplicate_site_id)
from ra_customer_merges m
where m.process_flag = 'N'
and m.request_id = req_id
and m.set_number = set_num)
and entity_id = 1009
for update nowait;
select discount_line_id
from so_discount_lines
where entity_value in (select to_char(m.duplicate_site_id)
from ra_customer_merges m
where m.process_flag = 'N'
and m.request_id = req_id
and m.set_number = set_num)
and entity_id = 1008
for update nowait;
select discount_line_id
from so_discount_lines
where entity_value in (select to_char(m.duplicate_site_id)
from ra_customer_merges m
where m.process_flag = 'N'
and m.request_id = req_id
and m.set_number = set_num)
and entity_id = 1007
for update nowait;
select discount_line_id
from so_discount_lines
where entity_value in (select to_char(m.duplicate_id)
from ra_customer_merges m
where m.process_flag = 'N'
and m.request_id = req_id
and m.set_number = set_num)
and entity_id = 1000
for update nowait;
/* site level update */
arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
UPDATE SO_DISCOUNT_LINES a
set (entity_value) = (select distinct to_char(m.customer_site_id)
from ra_customer_merges m
where to_number(a.entity_value) =
m.duplicate_site_id
and m.request_id = req_id
and m.process_flag = 'N'
and m.set_number = set_num),
last_update_date = sysdate,
last_updated_by = arp_standard.profile.user_id,
last_update_login = arp_standard.profile.last_update_login
where entity_value in (select to_char(m.duplicate_site_id)
from ra_customer_merges m
where m.process_flag = 'N'
and m.request_id = req_id
and m.set_number = set_num)
and entity_id = 1009;
arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
/* site level update */
arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
UPDATE SO_DISCOUNT_LINES a
set (entity_value) = (select distinct to_char(m.customer_site_id)
from ra_customer_merges m
where to_number(a.entity_value) =
m.duplicate_site_id
and m.request_id = req_id
and m.process_flag = 'N'
and m.set_number = set_num),
last_update_date = sysdate,
last_updated_by = arp_standard.profile.user_id,
last_update_login = arp_standard.profile.last_update_login
where entity_value in (select to_char(m.duplicate_site_id)
from ra_customer_merges m
where m.process_flag = 'N'
and m.request_id = req_id
and m.set_number = set_num)
and entity_id = 1008;
arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
/* site level update */
arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
UPDATE SO_DISCOUNT_LINES a
set (entity_value) = (select distinct to_char(m.customer_site_id)
from ra_customer_merges m
where to_number(a.entity_value) =
m.duplicate_site_id
and m.request_id = req_id
and m.process_flag = 'N'
and m.set_number = set_num),
last_update_date = sysdate,
last_updated_by = arp_standard.profile.user_id,
last_update_login = arp_standard.profile.last_update_login
where entity_value in (select to_char(m.duplicate_site_id)
from ra_customer_merges m
where m.process_flag = 'N'
and m.request_id = req_id
and m.set_number = set_num)
and entity_id = 1003;
arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
/* customer level update */
arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
UPDATE SO_DISCOUNT_LINES a
set entity_value = (select distinct to_char(m.customer_id)
from ra_customer_merges m
where to_number(a.entity_value) =
m.duplicate_id
and m.process_flag = 'N'
and m.request_id = req_id
and m.set_number = set_num),
last_update_date = sysdate,
last_updated_by = arp_standard.profile.user_id,
last_update_login = arp_standard.profile.last_update_login
where entity_value in (select to_char(m.duplicate_id)
from ra_customer_merges m
where m.process_flag = 'N'
and m.request_id = req_id
and m.set_number = set_num)
and entity_id = 1000;
arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
select discount_customer_id
from so_discount_customers
where site_use_id in (select m.duplicate_site_id
from ra_customer_merges m
where m.process_flag = 'N'
and m.request_id = req_id
and m.set_number = set_num)
for update nowait;
select discount_customer_id
from so_discount_customers
where customer_id in (select m.duplicate_id
from ra_customer_merges m
where m.process_flag = 'N'
and m.request_id = req_id
and m.set_number = set_num)
for update nowait;
/* site level update */
arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
UPDATE SO_DISCOUNT_CUSTOMERS a
set (site_use_id) = (select distinct m.customer_site_id
from ra_customer_merges m
where a.site_use_id =
m.duplicate_site_id
and m.request_id = req_id
and m.process_flag = 'N'
and m.set_number = set_num),
last_update_date = sysdate,
last_updated_by = arp_standard.profile.user_id,
last_update_login = arp_standard.profile.last_update_login
where site_use_id in (select m.duplicate_site_id
from ra_customer_merges m
where m.process_flag = 'N'
and m.request_id = req_id
and m.set_number = set_num);
arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
/* customer level update */
arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
UPDATE SO_DISCOUNT_CUSTOMERS a
set customer_id = (select distinct m.customer_id
from ra_customer_merges m
where a.customer_id =
m.duplicate_id
and m.process_flag = 'N'
and m.request_id = req_id
and m.set_number = set_num),
last_update_date = sysdate,
last_updated_by = arp_standard.profile.user_id,
last_update_login = arp_standard.profile.last_update_login
where customer_id in (select m.duplicate_id
from ra_customer_merges m
where m.process_flag = 'N'
and m.request_id = req_id
and m.set_number = set_num);
arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );