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 FND_GLOBAL

Line 81: G_USER_ID CONSTANT NUMBER(15) := FND_GLOBAL.USER_ID;

77: -- c_c_site CONSTANT VARCHAR2(20) := 'OKX_C_SITE'; -- HZ_CUST_ACCT_SITES_ALL
78: -- c_c_site_use CONSTANT VARCHAR2(20) := 'OKX_C_SITE_USE'; -- HZ_CUST_SITE_USES_ALL
79: --
80: G_PROC_NAME CONSTANT VARCHAR2(30) := 'OKC_PARTY_MERGE_PUB';
81: G_USER_ID CONSTANT NUMBER(15) := FND_GLOBAL.USER_ID;
82: G_LOGIN_ID CONSTANT NUMBER(15) := FND_GLOBAL.LOGIN_ID;
83: -- Parameters:
84: -- IN - All IN parameters are REQUIRED.
85: -- p_entity_name VARCHAR2 - Name of the entity that is being merged

Line 82: G_LOGIN_ID CONSTANT NUMBER(15) := FND_GLOBAL.LOGIN_ID;

78: -- c_c_site_use CONSTANT VARCHAR2(20) := 'OKX_C_SITE_USE'; -- HZ_CUST_SITE_USES_ALL
79: --
80: G_PROC_NAME CONSTANT VARCHAR2(30) := 'OKC_PARTY_MERGE_PUB';
81: G_USER_ID CONSTANT NUMBER(15) := FND_GLOBAL.USER_ID;
82: G_LOGIN_ID CONSTANT NUMBER(15) := FND_GLOBAL.LOGIN_ID;
83: -- Parameters:
84: -- IN - All IN parameters are REQUIRED.
85: -- p_entity_name VARCHAR2 - Name of the entity that is being merged
86: -- p_from_id NUMBER - Id of the record that is being merged

Line 239: ,ver.last_updated_by = nvl(fnd_global.user_id, -1)

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

Line 240: ,ver.last_update_login = fnd_global.conc_login_id

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

Line 272: ,cntc.last_updated_by = nvl(fnd_global.user_id, -1)

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

Line 273: ,cntc.last_update_login = fnd_global.conc_login_id

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

Line 318: ,kpr.last_updated_by = nvl(fnd_global.user_id, -1)

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

Line 319: ,kpr.last_update_login = fnd_global.conc_login_id

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

Line 485: ,rle.last_updated_by = nvl(fnd_global.user_id, -1)

481: UPDATE okc_rules_b rle
482: SET rle.object1_id1 = p_to_fk_id
483: ,rle.object_version_number = rle.object_version_number + 1
484: ,rle.last_update_date = SYSDATE
485: ,rle.last_updated_by = nvl(fnd_global.user_id, -1)
486: ,rle.last_update_login = fnd_global.conc_login_id
487: -- WHERE rle.object1_id1 = p_from_fk_id
488: WHERE rle.object1_id1 = to_char(p_from_fk_id) -- for Bug# 6896186
489: AND rle.jtot_object1_code IN (SELECT ojt.object_code

Line 486: ,rle.last_update_login = fnd_global.conc_login_id

482: SET rle.object1_id1 = p_to_fk_id
483: ,rle.object_version_number = rle.object_version_number + 1
484: ,rle.last_update_date = SYSDATE
485: ,rle.last_updated_by = nvl(fnd_global.user_id, -1)
486: ,rle.last_update_login = fnd_global.conc_login_id
487: -- WHERE rle.object1_id1 = p_from_fk_id
488: WHERE rle.object1_id1 = to_char(p_from_fk_id) -- for Bug# 6896186
489: AND rle.jtot_object1_code IN (SELECT ojt.object_code
490: FROM jtf_objects_b ojt

Line 604: ,rle.last_updated_by = nvl(fnd_global.user_id, -1)

600: UPDATE okc_rules_b rle
601: SET rle.object2_id1 = p_to_fk_id
602: ,rle.object_version_number = rle.object_version_number + 1
603: ,rle.last_update_date = SYSDATE
604: ,rle.last_updated_by = nvl(fnd_global.user_id, -1)
605: ,rle.last_update_login = fnd_global.conc_login_id
606: -- WHERE rle.object2_id1 = p_from_fk_id
607: WHERE rle.object2_id1 = to_char(p_from_fk_id) -- For Bug# 6896186
608: AND rle.jtot_object2_code IN (SELECT ojt.object_code

Line 605: ,rle.last_update_login = fnd_global.conc_login_id

601: SET rle.object2_id1 = p_to_fk_id
602: ,rle.object_version_number = rle.object_version_number + 1
603: ,rle.last_update_date = SYSDATE
604: ,rle.last_updated_by = nvl(fnd_global.user_id, -1)
605: ,rle.last_update_login = fnd_global.conc_login_id
606: -- WHERE rle.object2_id1 = p_from_fk_id
607: WHERE rle.object2_id1 = to_char(p_from_fk_id) -- For Bug# 6896186
608: AND rle.jtot_object2_code IN (SELECT ojt.object_code
609: FROM jtf_objects_b ojt

Line 721: ,rle.last_updated_by = nvl(fnd_global.user_id, -1)

717: UPDATE okc_rules_b rle
718: SET rle.object3_id1 = p_to_fk_id
719: ,rle.object_version_number = rle.object_version_number + 1
720: ,rle.last_update_date = SYSDATE
721: ,rle.last_updated_by = nvl(fnd_global.user_id, -1)
722: ,rle.last_update_login = fnd_global.conc_login_id
723: -- WHERE rle.object3_id1 = p_from_fk_id
724: WHERE rle.object3_id1 = to_char(p_from_fk_id) -- For Bug# 6896186
725: AND rle.jtot_object3_code IN (SELECT ojt.object_code

Line 722: ,rle.last_update_login = fnd_global.conc_login_id

718: SET rle.object3_id1 = p_to_fk_id
719: ,rle.object_version_number = rle.object_version_number + 1
720: ,rle.last_update_date = SYSDATE
721: ,rle.last_updated_by = nvl(fnd_global.user_id, -1)
722: ,rle.last_update_login = fnd_global.conc_login_id
723: -- WHERE rle.object3_id1 = p_from_fk_id
724: WHERE rle.object3_id1 = to_char(p_from_fk_id) -- For Bug# 6896186
725: AND rle.jtot_object3_code IN (SELECT ojt.object_code
726: FROM jtf_objects_b ojt

Line 839: ,cim.last_updated_by = nvl(fnd_global.user_id, -1)

835: UPDATE okc_k_items cim
836: SET cim.object1_id1 = p_to_fk_id
837: ,cim.object_version_number = cim.object_version_number + 1
838: ,cim.last_update_date = SYSDATE
839: ,cim.last_updated_by = nvl(fnd_global.user_id, -1)
840: ,cim.last_update_login = fnd_global.conc_login_id
841: WHERE cim.object1_id1 = p_from_fk_id
842: AND cim.jtot_object1_code IN (SELECT ojt.object_code
843: FROM jtf_objects_b ojt

Line 840: ,cim.last_update_login = fnd_global.conc_login_id

836: SET cim.object1_id1 = p_to_fk_id
837: ,cim.object_version_number = cim.object_version_number + 1
838: ,cim.last_update_date = SYSDATE
839: ,cim.last_updated_by = nvl(fnd_global.user_id, -1)
840: ,cim.last_update_login = fnd_global.conc_login_id
841: WHERE cim.object1_id1 = p_from_fk_id
842: AND cim.jtot_object1_code IN (SELECT ojt.object_code
843: FROM jtf_objects_b ojt
844: ,jtf_object_usages oue

Line 953: ,ctc.last_updated_by = nvl(fnd_global.user_id, -1)

949: UPDATE okc_contacts ctc
950: SET ctc.object1_id1 = p_to_fk_id
951: ,ctc.object_version_number = ctc.object_version_number + 1
952: ,ctc.last_update_date = SYSDATE
953: ,ctc.last_updated_by = nvl(fnd_global.user_id, -1)
954: ,ctc.last_update_login = fnd_global.conc_login_id
955: WHERE ctc.object1_id1 = to_char(p_from_fk_id)
956: AND ctc.jtot_object1_code IN (SELECT ojt.object_code
957: FROM jtf_objects_b ojt

Line 954: ,ctc.last_update_login = fnd_global.conc_login_id

950: SET ctc.object1_id1 = p_to_fk_id
951: ,ctc.object_version_number = ctc.object_version_number + 1
952: ,ctc.last_update_date = SYSDATE
953: ,ctc.last_updated_by = nvl(fnd_global.user_id, -1)
954: ,ctc.last_update_login = fnd_global.conc_login_id
955: WHERE ctc.object1_id1 = to_char(p_from_fk_id)
956: AND ctc.jtot_object1_code IN (SELECT ojt.object_code
957: FROM jtf_objects_b ojt
958: ,jtf_object_usages oue