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 264: fnd_file.put_line(fnd_file.log, 'Updating Table okc_contacts');

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

Line 267: UPDATE okc_contacts cntc

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

Line 854: -- Merge procedure for OKC_CONTACTS

850: end;
851: end if;
852: END OKC_CIM_MERGE_PARTY;
853: --
854: -- Merge procedure for OKC_CONTACTS
855: --
856: PROCEDURE OKC_CTC_MERGE_PARTY (
857: p_entity_name IN VARCHAR2,
858: p_from_id IN NUMBER,

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

926:
927: if p_from_fk_id <> p_to_fk_id then
928: begin
929: arp_message.set_name('AR','AR_UPDATING_TABLE');
930: arp_message.set_token('TABLE_NAME','OKC_CONTACTS',FALSE);
931: fnd_file.put_line(fnd_file.log, 'Updating Table okc_contacts');
932: --
933: --
934: UPDATE okc_contacts ctc

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

927: if p_from_fk_id <> p_to_fk_id then
928: begin
929: arp_message.set_name('AR','AR_UPDATING_TABLE');
930: arp_message.set_token('TABLE_NAME','OKC_CONTACTS',FALSE);
931: fnd_file.put_line(fnd_file.log, 'Updating Table okc_contacts');
932: --
933: --
934: UPDATE okc_contacts ctc
935: SET ctc.object1_id1 = p_to_fk_id

Line 934: UPDATE okc_contacts ctc

930: arp_message.set_token('TABLE_NAME','OKC_CONTACTS',FALSE);
931: fnd_file.put_line(fnd_file.log, 'Updating Table okc_contacts');
932: --
933: --
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