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 738: -- Merge Procedure for OKC_K_ITEMS

734: end;
735: end if;
736: END OKC_RUL_MERGE_PARTY_ID3;
737: --
738: -- Merge Procedure for OKC_K_ITEMS
739: --
740: PROCEDURE OKC_CIM_MERGE_PARTY (
741: p_entity_name IN VARCHAR2,
742: p_from_id IN NUMBER,

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

812:
813: if p_from_fk_id <> p_to_fk_id then
814: begin
815: arp_message.set_name('AR','AR_UPDATING_TABLE');
816: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
817: fnd_file.put_line(fnd_file.log, 'Updating Table okc_k_items');
818: --
819: --
820: UPDATE okc_k_items cim

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

813: if p_from_fk_id <> p_to_fk_id then
814: begin
815: arp_message.set_name('AR','AR_UPDATING_TABLE');
816: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
817: fnd_file.put_line(fnd_file.log, 'Updating Table okc_k_items');
818: --
819: --
820: UPDATE okc_k_items cim
821: SET cim.object1_id1 = p_to_fk_id

Line 820: UPDATE okc_k_items cim

816: arp_message.set_token('TABLE_NAME','OKC_K_ITEMS',FALSE);
817: fnd_file.put_line(fnd_file.log, 'Updating Table okc_k_items');
818: --
819: --
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