The following lines contain the word 'select', 'insert', 'update' or 'delete':
select role1.id from_cpl_id, role2.id to_cpl_id
from okc_k_party_roles_b role1,okc_k_party_roles_b role2
where role1.cle_id = role2.cle_id
and role1.rle_code = role2.rle_code
and role1.jtot_object1_code = role2.jtot_object1_code
and role1.jtot_object1_code IN (SELECT ojt.object_code
FROM jtf_objects_b ojt
,jtf_object_usages oue
WHERE ojt.object_code = oue.object_code
AND oue.object_user_code = l_object_user_code)
and role1.object1_id1 = p_from_fk_id
and role2.object1_id1 = p_to_fk_id;
select merge_reason_code
into l_merge_reason_code
from hz_merge_batch
where batch_id = p_batch_id;
INSERT INTO OKC_K_VERS_NUMBERS_H(
chr_id,
major_version,
minor_version,
object_version_number,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
(SELECT
chr_id,
major_version,
minor_version,
object_version_number,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login
FROM OKC_K_VERS_NUMBERS
WHERE chr_id IN (select dnz_chr_id
from okc_k_party_roles_b kpr
where kpr.object1_id1 = to_char(p_from_fk_id)
AND kpr.jtot_object1_code IN
(SELECT ojt.object_code
FROM jtf_objects_b ojt
,jtf_object_usages oue
WHERE ojt.object_code = oue.object_code
AND oue.object_user_code = l_object_user_code)));
UPDATE okc_k_vers_numbers ver
SET ver.minor_version = ver.minor_version + 1
,ver.object_version_number = ver.object_version_number + 1
,ver.last_update_date = SYSDATE
,ver.last_updated_by = arp_standard.profile.user_id
,ver.last_update_login = arp_standard.profile.last_update_login
WHERE chr_id IN (select dnz_chr_id
from okc_k_party_roles_b kpr
where kpr.object1_id1 = to_char(p_from_fk_id) -- added for Bug 3611998
AND kpr.jtot_object1_code IN (SELECT ojt.object_code
FROM jtf_objects_b ojt
,jtf_object_usages oue
WHERE ojt.object_code = oue.object_code
AND oue.object_user_code = l_object_user_code));
fnd_file.put_line(fnd_file.log, 'No of Rows Updated : '||l_count);
arp_message.set_name('AR','AR_ROWS_UPDATED');
UPDATE okc_contacts cntc
SET cntc.cpl_id = l_to_cpl_id(i)
,cntc.object_version_number = cntc.object_version_number + 1
,cntc.last_update_date = SYSDATE
,cntc.last_updated_by = arp_standard.profile.user_id
,cntc.last_update_login = arp_standard.profile.last_update_login
WHERE cntc.cpl_id = l_from_cpl_id(i);
fnd_file.put_line(fnd_file.log, 'No of Rows Updated : '||l_count);
arp_message.set_name('AR','AR_ROWS_UPDATED');
DELETE from okc_k_party_roles_tl rtl
WHERE rtl.id = l_from_cpl_id(i);
fnd_file.put_line(fnd_file.log, 'No of Rows Deleted : '||l_count);
DELETE FROM okc_k_party_roles_B role1
WHERE role1.id = l_from_cpl_id(i);
fnd_file.put_line(fnd_file.log, 'No of Rows Deleted : '||l_count);
l_from_cpl_id.DELETE;
l_to_cpl_id.DELETE;
UPDATE okc_k_party_roles_b kpr
SET kpr.object1_id1 = p_to_fk_id
,kpr.object_version_number = kpr.object_version_number + 1
,kpr.last_update_date = SYSDATE
,kpr.last_updated_by = arp_standard.profile.user_id
,kpr.last_update_login = arp_standard.profile.last_update_login
WHERE kpr.object1_id1 = to_char(p_from_fk_id)
AND kpr.jtot_object1_code IN (SELECT ojt.object_code
FROM jtf_objects_b ojt
,jtf_object_usages oue
WHERE ojt.object_code = oue.object_code
AND oue.object_user_code = l_object_user_code) ;
fnd_file.put_line(fnd_file.log, 'No of Rows Updated : '||l_count);
fnd_file.put_line(fnd_file.log, 'Before call to OKC_OKS_PUB.OKS_UPDATE_CONTRACT ');
OKC_OKS_PUB.OKS_UPDATE_CONTRACT(p_from_id => p_from_fk_id,
p_to_id => p_to_fk_id,
x_return_status => l_return_status);
fnd_file.put_line(fnd_file.log, 'No of Rows Updated : '||l_count);
arp_message.set_name('AR','AR_ROWS_UPDATED');
select merge_reason_code
into l_merge_reason_code
from hz_merge_batch
where batch_id = p_batch_id;
UPDATE okc_rules_b rle
SET rle.object1_id1 = p_to_fk_id
,rle.object_version_number = rle.object_version_number + 1
,rle.last_update_date = SYSDATE
,rle.last_updated_by = arp_standard.profile.user_id
,rle.last_update_login = arp_standard.profile.last_update_login
-- WHERE rle.object1_id1 = p_from_fk_id
WHERE rle.object1_id1 = to_char(p_from_fk_id) -- for Bug# 6896186
AND rle.jtot_object1_code IN (SELECT ojt.object_code
FROM jtf_objects_b ojt
,jtf_object_usages oue
WHERE ojt.object_code = oue.object_code
AND oue.object_user_code = l_object_user_code)
;
fnd_file.put_line(fnd_file.log, 'No of Rows Updated : '||l_count);
arp_message.set_name('AR','AR_ROWS_UPDATED');
select merge_reason_code
into l_merge_reason_code
from hz_merge_batch
where batch_id = p_batch_id;
UPDATE okc_rules_b rle
SET rle.object2_id1 = p_to_fk_id
,rle.object_version_number = rle.object_version_number + 1
,rle.last_update_date = SYSDATE
,rle.last_updated_by = arp_standard.profile.user_id
,rle.last_update_login = arp_standard.profile.last_update_login
-- WHERE rle.object2_id1 = p_from_fk_id
WHERE rle.object2_id1 = to_char(p_from_fk_id) -- For Bug# 6896186
AND rle.jtot_object2_code IN (SELECT ojt.object_code
FROM jtf_objects_b ojt
,jtf_object_usages oue
WHERE ojt.object_code = oue.object_code
AND oue.object_user_code = l_object_user_code)
;
fnd_file.put_line(fnd_file.log, 'No of Rows Updated : '||l_count);
arp_message.set_name('AR','AR_ROWS_UPDATED');
select merge_reason_code
into l_merge_reason_code
from hz_merge_batch
where batch_id = p_batch_id;
UPDATE okc_rules_b rle
SET rle.object3_id1 = p_to_fk_id
,rle.object_version_number = rle.object_version_number + 1
,rle.last_update_date = SYSDATE
,rle.last_updated_by = arp_standard.profile.user_id
,rle.last_update_login = arp_standard.profile.last_update_login
-- WHERE rle.object3_id1 = p_from_fk_id
WHERE rle.object3_id1 = to_char(p_from_fk_id) -- For Bug# 6896186
AND rle.jtot_object3_code IN (SELECT ojt.object_code
FROM jtf_objects_b ojt
,jtf_object_usages oue
WHERE ojt.object_code = oue.object_code
AND oue.object_user_code = l_object_user_code)
;
fnd_file.put_line(fnd_file.log, 'No of Rows Updated : '||l_count);
arp_message.set_name('AR','AR_ROWS_UPDATED');
select merge_reason_code
into l_merge_reason_code
from hz_merge_batch
where batch_id = p_batch_id;
UPDATE okc_k_items cim
SET cim.object1_id1 = p_to_fk_id
,cim.object_version_number = cim.object_version_number + 1
,cim.last_update_date = SYSDATE
,cim.last_updated_by = arp_standard.profile.user_id
,cim.last_update_login = arp_standard.profile.last_update_login
WHERE cim.object1_id1 = p_from_fk_id
AND cim.jtot_object1_code IN (SELECT ojt.object_code
FROM jtf_objects_b ojt
,jtf_object_usages oue
WHERE ojt.object_code = oue.object_code
AND oue.object_user_code = l_object_user_code)
;
fnd_file.put_line(fnd_file.log, 'No of Rows Updated : '||l_count);
arp_message.set_name('AR','AR_ROWS_UPDATED');
select merge_reason_code
into l_merge_reason_code
from hz_merge_batch
where batch_id = p_batch_id;
UPDATE okc_contacts ctc
SET ctc.object1_id1 = p_to_fk_id
,ctc.object_version_number = ctc.object_version_number + 1
,ctc.last_update_date = SYSDATE
,ctc.last_updated_by = arp_standard.profile.user_id
,ctc.last_update_login = arp_standard.profile.last_update_login
WHERE ctc.object1_id1 = to_char(p_from_fk_id)
AND ctc.jtot_object1_code IN (SELECT ojt.object_code
FROM jtf_objects_b ojt
,jtf_object_usages oue
WHERE ojt.object_code = oue.object_code
AND oue.object_user_code = l_object_user_code)
;
fnd_file.put_line(fnd_file.log, 'No of Rows Updated : '||l_count);
arp_message.set_name('AR','AR_ROWS_UPDATED');