APPS.JTF_IH_PARTY_MERGE_PKG dependencies on JTF_IH_INTERACTIONS

Line 6: -- Purpose : Merges duplicate parties in JTF_IH_INTERACTIONS table.

2: /* $Header: JTFIHPMB.pls 120.2 2006/02/16 23:33:17 nchouras ship $ */
3:
4: -- Start of Comments
5: -- Package name : JTF_IH_PARTY_MERGE_PKG
6: -- Purpose : Merges duplicate parties in JTF_IH_INTERACTIONS table.
7:
8: --
9: -- History
10: -- MM-DD-YYYY NAME MODIFICATIONS

Line 39: from jtf_ih_interactions

35: x_return_status OUT NOCOPY VARCHAR2)
36: IS
37: cursor c1 is
38: select 1
39: from jtf_ih_interactions
40: where party_id = p_from_fk_id
41: for update nowait;
42:
43:

Line 84: -- In the case of JTF_IH_INTERACTIONS table, if party id 1000 got merged to party id 2000

80: -- dependent record exists on the new parent. If a duplicate exists then do
81: -- not transfer and return the id of the duplicate record as the Merged To Id
82:
83:
84: -- In the case of JTF_IH_INTERACTIONS table, if party id 1000 got merged to party id 2000
85: -- then, we have to update all records with customer_id = 1000 to 2000
86:
87: if p_from_fk_id <> p_to_fk_id then
88: begin

Line 91: arp_message.set_token('TABLE_NAME', 'JTF_IH_INTERACTIONS', FALSE);

87: if p_from_fk_id <> p_to_fk_id then
88: begin
89: -- obtain lock on records to be updated.
90: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
91: arp_message.set_token('TABLE_NAME', 'JTF_IH_INTERACTIONS', FALSE);
92:
93: open c1;
94: close c1;
95: select party_type into s_Party_Type from hz_parties where party_id = p_to_fk_id;

Line 96: update jtf_ih_interactions

92:
93: open c1;
94: close c1;
95: select party_type into s_Party_Type from hz_parties where party_id = p_to_fk_id;
96: update jtf_ih_interactions
97: -- set party_id = decode(party_id, p_to_fk_id, p_to_fk_id, party_id),
98: set party_id = p_to_fk_id,
99: last_update_date = hz_utility_pub.last_update_date,
100: last_updated_by = hz_utility_pub.user_id,

Line 129: 'JTF_IH_INTERACTIONS for party_id = ' || p_from_fk_id );

125: exception
126: when resource_busy then
127: arp_message.set_line(g_proc_name || '.' || l_api_name ||
128: '; Could not obtain lock for records in table ' ||
129: 'JTF_IH_INTERACTIONS for party_id = ' || p_from_fk_id );
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: --dbms_output.put_line('Busy');
132: raise;
133: