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 OKC_CONTACTS

Line 27: -- OKC_CONTACTS

23: -- When merging Party ids are looked for in:
24: -- OKC_K_PARTY_ROLES
25: -- OKC_RULES
26: -- OKC_K_ITEMS
27: -- OKC_CONTACTS
28: -- For customer site merges, cust_acct_site_ids are looked for in:
29: -- OKC_K_PARTY_ROLES
30: -- OKC_RULES
31: -- OKC_K_ITEMS

Line 32: -- OKC_CONTACTS

28: -- For customer site merges, cust_acct_site_ids are looked for in:
29: -- OKC_K_PARTY_ROLES
30: -- OKC_RULES
31: -- OKC_K_ITEMS
32: -- OKC_CONTACTS
33: -- For customer site use merges, site_use_ids are looked for in:
34: -- OKC_K_PARTY_ROLES
35: -- OKC_RULES
36: -- OKC_K_ITEMS

Line 37: -- OKC_CONTACTS

33: -- For customer site use merges, site_use_ids are looked for in:
34: -- OKC_K_PARTY_ROLES
35: -- OKC_RULES
36: -- OKC_K_ITEMS
37: -- OKC_CONTACTS
38: --
39: -- JTF Objects:
40: -- The merge depends upon the proper usages being set for the JTF objects used
41: -- as party roles, rules, and items. These usages are as follows:

Line 265: fnd_file.put_line(fnd_file.log, 'Updating Table okc_contacts');

261: -- nechatur for bug#5378426 added on 9/7/06
262: EXIT WHEN l_from_cpl_id.COUNT <= 0 ;
263: -- end nechatur
264:
265: fnd_file.put_line(fnd_file.log, 'Updating Table okc_contacts');
266:
267: FORALL i IN l_from_cpl_id.FIRST .. l_from_cpl_id.LAST
268: UPDATE okc_contacts cntc
269: SET cntc.cpl_id = l_to_cpl_id(i)

Line 268: UPDATE okc_contacts cntc

264:
265: fnd_file.put_line(fnd_file.log, 'Updating Table okc_contacts');
266:
267: FORALL i IN l_from_cpl_id.FIRST .. l_from_cpl_id.LAST
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)

Line 869: -- Merge procedure for OKC_CONTACTS

865: end;
866: end if;
867: END OKC_CIM_MERGE_PARTY;
868: --
869: -- Merge procedure for OKC_CONTACTS
870: --
871: PROCEDURE OKC_CTC_MERGE_PARTY (
872: p_entity_name IN VARCHAR2,
873: p_from_id IN NUMBER,

Line 945: arp_message.set_token('TABLE_NAME','OKC_CONTACTS',FALSE);

941:
942: if p_from_fk_id <> p_to_fk_id then
943: begin
944: arp_message.set_name('AR','AR_UPDATING_TABLE');
945: arp_message.set_token('TABLE_NAME','OKC_CONTACTS',FALSE);
946: fnd_file.put_line(fnd_file.log, 'Updating Table okc_contacts');
947: --
948: --
949: UPDATE okc_contacts ctc

Line 946: fnd_file.put_line(fnd_file.log, 'Updating Table okc_contacts');

942: if p_from_fk_id <> p_to_fk_id then
943: begin
944: arp_message.set_name('AR','AR_UPDATING_TABLE');
945: arp_message.set_token('TABLE_NAME','OKC_CONTACTS',FALSE);
946: fnd_file.put_line(fnd_file.log, 'Updating Table okc_contacts');
947: --
948: --
949: UPDATE okc_contacts ctc
950: SET ctc.object1_id1 = p_to_fk_id

Line 949: UPDATE okc_contacts ctc

945: arp_message.set_token('TABLE_NAME','OKC_CONTACTS',FALSE);
946: fnd_file.put_line(fnd_file.log, 'Updating Table okc_contacts');
947: --
948: --
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)