eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_PARTY_MERGE_PUB dependencies on STANDARD

Line 238: ,ver.last_updated_by = arp_standard.profile.user_id

234: UPDATE okc_k_vers_numbers ver
235: SET ver.minor_version = ver.minor_version + 1
236: ,ver.object_version_number = ver.object_version_number + 1
237: ,ver.last_update_date = SYSDATE
238: ,ver.last_updated_by = arp_standard.profile.user_id
239: ,ver.last_update_login = arp_standard.profile.last_update_login
240: WHERE chr_id IN (select dnz_chr_id
241: from okc_k_party_roles_b kpr
242: where kpr.object1_id1 = to_char(p_from_fk_id) -- added for Bug 3611998

Line 239: ,ver.last_update_login = arp_standard.profile.last_update_login

235: SET ver.minor_version = ver.minor_version + 1
236: ,ver.object_version_number = ver.object_version_number + 1
237: ,ver.last_update_date = SYSDATE
238: ,ver.last_updated_by = arp_standard.profile.user_id
239: ,ver.last_update_login = arp_standard.profile.last_update_login
240: WHERE chr_id IN (select dnz_chr_id
241: from okc_k_party_roles_b kpr
242: where kpr.object1_id1 = to_char(p_from_fk_id) -- added for Bug 3611998
243: AND kpr.jtot_object1_code IN (SELECT ojt.object_code

Line 271: ,cntc.last_updated_by = arp_standard.profile.user_id

267: UPDATE okc_contacts cntc
268: SET cntc.cpl_id = l_to_cpl_id(i)
269: ,cntc.object_version_number = cntc.object_version_number + 1
270: ,cntc.last_update_date = SYSDATE
271: ,cntc.last_updated_by = arp_standard.profile.user_id
272: ,cntc.last_update_login = arp_standard.profile.last_update_login
273: WHERE cntc.cpl_id = l_from_cpl_id(i);
274:
275: l_count := sql%rowcount;

Line 272: ,cntc.last_update_login = arp_standard.profile.last_update_login

268: SET cntc.cpl_id = l_to_cpl_id(i)
269: ,cntc.object_version_number = cntc.object_version_number + 1
270: ,cntc.last_update_date = SYSDATE
271: ,cntc.last_updated_by = arp_standard.profile.user_id
272: ,cntc.last_update_login = arp_standard.profile.last_update_login
273: WHERE cntc.cpl_id = l_from_cpl_id(i);
274:
275: l_count := sql%rowcount;
276: fnd_file.put_line(fnd_file.log, 'No of Rows Updated : '||l_count);

Line 317: ,kpr.last_updated_by = arp_standard.profile.user_id

313: UPDATE okc_k_party_roles_b kpr
314: SET kpr.object1_id1 = p_to_fk_id
315: ,kpr.object_version_number = kpr.object_version_number + 1
316: ,kpr.last_update_date = SYSDATE
317: ,kpr.last_updated_by = arp_standard.profile.user_id
318: ,kpr.last_update_login = arp_standard.profile.last_update_login
319: WHERE kpr.object1_id1 = to_char(p_from_fk_id)
320: AND kpr.jtot_object1_code IN (SELECT ojt.object_code
321: FROM jtf_objects_b ojt

Line 318: ,kpr.last_update_login = arp_standard.profile.last_update_login

314: SET kpr.object1_id1 = p_to_fk_id
315: ,kpr.object_version_number = kpr.object_version_number + 1
316: ,kpr.last_update_date = SYSDATE
317: ,kpr.last_updated_by = arp_standard.profile.user_id
318: ,kpr.last_update_login = arp_standard.profile.last_update_login
319: WHERE kpr.object1_id1 = to_char(p_from_fk_id)
320: AND kpr.jtot_object1_code IN (SELECT ojt.object_code
321: FROM jtf_objects_b ojt
322: ,jtf_object_usages oue

Line 470: ,rle.last_updated_by = arp_standard.profile.user_id

466: UPDATE okc_rules_b rle
467: SET rle.object1_id1 = p_to_fk_id
468: ,rle.object_version_number = rle.object_version_number + 1
469: ,rle.last_update_date = SYSDATE
470: ,rle.last_updated_by = arp_standard.profile.user_id
471: ,rle.last_update_login = arp_standard.profile.last_update_login
472: -- WHERE rle.object1_id1 = p_from_fk_id
473: WHERE rle.object1_id1 = to_char(p_from_fk_id) -- for Bug# 6896186
474: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 471: ,rle.last_update_login = arp_standard.profile.last_update_login

467: SET rle.object1_id1 = p_to_fk_id
468: ,rle.object_version_number = rle.object_version_number + 1
469: ,rle.last_update_date = SYSDATE
470: ,rle.last_updated_by = arp_standard.profile.user_id
471: ,rle.last_update_login = arp_standard.profile.last_update_login
472: -- WHERE rle.object1_id1 = p_from_fk_id
473: WHERE rle.object1_id1 = to_char(p_from_fk_id) -- for Bug# 6896186
474: AND rle.jtot_object1_code IN (SELECT ojt.object_code
475: FROM jtf_objects_b ojt

Line 589: ,rle.last_updated_by = arp_standard.profile.user_id

585: UPDATE okc_rules_b rle
586: SET rle.object2_id1 = p_to_fk_id
587: ,rle.object_version_number = rle.object_version_number + 1
588: ,rle.last_update_date = SYSDATE
589: ,rle.last_updated_by = arp_standard.profile.user_id
590: ,rle.last_update_login = arp_standard.profile.last_update_login
591: -- WHERE rle.object2_id1 = p_from_fk_id
592: WHERE rle.object2_id1 = to_char(p_from_fk_id) -- For Bug# 6896186
593: AND rle.jtot_object2_code IN (SELECT ojt.object_code

Line 590: ,rle.last_update_login = arp_standard.profile.last_update_login

586: SET rle.object2_id1 = p_to_fk_id
587: ,rle.object_version_number = rle.object_version_number + 1
588: ,rle.last_update_date = SYSDATE
589: ,rle.last_updated_by = arp_standard.profile.user_id
590: ,rle.last_update_login = arp_standard.profile.last_update_login
591: -- WHERE rle.object2_id1 = p_from_fk_id
592: WHERE rle.object2_id1 = to_char(p_from_fk_id) -- For Bug# 6896186
593: AND rle.jtot_object2_code IN (SELECT ojt.object_code
594: FROM jtf_objects_b ojt

Line 706: ,rle.last_updated_by = arp_standard.profile.user_id

702: UPDATE okc_rules_b rle
703: SET rle.object3_id1 = p_to_fk_id
704: ,rle.object_version_number = rle.object_version_number + 1
705: ,rle.last_update_date = SYSDATE
706: ,rle.last_updated_by = arp_standard.profile.user_id
707: ,rle.last_update_login = arp_standard.profile.last_update_login
708: -- WHERE rle.object3_id1 = p_from_fk_id
709: WHERE rle.object3_id1 = to_char(p_from_fk_id) -- For Bug# 6896186
710: AND rle.jtot_object3_code IN (SELECT ojt.object_code

Line 707: ,rle.last_update_login = arp_standard.profile.last_update_login

703: SET rle.object3_id1 = p_to_fk_id
704: ,rle.object_version_number = rle.object_version_number + 1
705: ,rle.last_update_date = SYSDATE
706: ,rle.last_updated_by = arp_standard.profile.user_id
707: ,rle.last_update_login = arp_standard.profile.last_update_login
708: -- WHERE rle.object3_id1 = p_from_fk_id
709: WHERE rle.object3_id1 = to_char(p_from_fk_id) -- For Bug# 6896186
710: AND rle.jtot_object3_code IN (SELECT ojt.object_code
711: FROM jtf_objects_b ojt

Line 824: ,cim.last_updated_by = arp_standard.profile.user_id

820: UPDATE okc_k_items cim
821: SET cim.object1_id1 = p_to_fk_id
822: ,cim.object_version_number = cim.object_version_number + 1
823: ,cim.last_update_date = SYSDATE
824: ,cim.last_updated_by = arp_standard.profile.user_id
825: ,cim.last_update_login = arp_standard.profile.last_update_login
826: WHERE cim.object1_id1 = p_from_fk_id
827: AND cim.jtot_object1_code IN (SELECT ojt.object_code
828: FROM jtf_objects_b ojt

Line 825: ,cim.last_update_login = arp_standard.profile.last_update_login

821: SET cim.object1_id1 = p_to_fk_id
822: ,cim.object_version_number = cim.object_version_number + 1
823: ,cim.last_update_date = SYSDATE
824: ,cim.last_updated_by = arp_standard.profile.user_id
825: ,cim.last_update_login = arp_standard.profile.last_update_login
826: WHERE cim.object1_id1 = p_from_fk_id
827: AND cim.jtot_object1_code IN (SELECT ojt.object_code
828: FROM jtf_objects_b ojt
829: ,jtf_object_usages oue

Line 938: ,ctc.last_updated_by = arp_standard.profile.user_id

934: UPDATE okc_contacts ctc
935: SET ctc.object1_id1 = p_to_fk_id
936: ,ctc.object_version_number = ctc.object_version_number + 1
937: ,ctc.last_update_date = SYSDATE
938: ,ctc.last_updated_by = arp_standard.profile.user_id
939: ,ctc.last_update_login = arp_standard.profile.last_update_login
940: WHERE ctc.object1_id1 = to_char(p_from_fk_id)
941: AND ctc.jtot_object1_code IN (SELECT ojt.object_code
942: FROM jtf_objects_b ojt

Line 939: ,ctc.last_update_login = arp_standard.profile.last_update_login

935: SET ctc.object1_id1 = p_to_fk_id
936: ,ctc.object_version_number = ctc.object_version_number + 1
937: ,ctc.last_update_date = SYSDATE
938: ,ctc.last_updated_by = arp_standard.profile.user_id
939: ,ctc.last_update_login = arp_standard.profile.last_update_login
940: WHERE ctc.object1_id1 = to_char(p_from_fk_id)
941: AND ctc.jtot_object1_code IN (SELECT ojt.object_code
942: FROM jtf_objects_b ojt
943: ,jtf_object_usages oue