DBA Data[Home] [Help]

APPS.OKC_PARTY_MERGE_PUB dependencies on OKC_K_ITEMS

Line 26: -- OKC_K_ITEMS

22: --
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

Line 31: -- 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
32: -- OKC_CONTACTS
33: -- For customer site use merges, site_use_ids are looked for in:
34: -- OKC_K_PARTY_ROLES
35: -- OKC_RULES

Line 36: -- 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
37: -- OKC_CONTACTS
38: --
39: -- JTF Objects:
40: -- The merge depends upon the proper usages being set for the JTF objects used

Line 753: -- Merge Procedure for OKC_K_ITEMS

749: end;
750: end if;
751: END OKC_RUL_MERGE_PARTY_ID3;
752: --
753: -- Merge Procedure for OKC_K_ITEMS
754: --
755: PROCEDURE OKC_CIM_MERGE_PARTY (
756: p_entity_name IN VARCHAR2,
757: p_from_id IN NUMBER,

Line 831: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);

827:
828: if p_from_fk_id <> p_to_fk_id then
829: begin
830: arp_message.set_name('AR','AR_UPDATING_TABLE');
831: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
832: fnd_file.put_line(fnd_file.log, 'Updating Table okc_k_items');
833: --
834: --
835: UPDATE okc_k_items cim

Line 832: fnd_file.put_line(fnd_file.log, 'Updating Table okc_k_items');

828: if p_from_fk_id <> p_to_fk_id then
829: begin
830: arp_message.set_name('AR','AR_UPDATING_TABLE');
831: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
832: fnd_file.put_line(fnd_file.log, 'Updating Table okc_k_items');
833: --
834: --
835: UPDATE okc_k_items cim
836: SET cim.object1_id1 = p_to_fk_id

Line 835: UPDATE okc_k_items cim

831: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
832: fnd_file.put_line(fnd_file.log, 'Updating Table okc_k_items');
833: --
834: --
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)