DBA Data[Home] [Help]

APPS.IEM_CLIENT_PUB dependencies on JTF_IH_INTERACTIONS

Line 2368: ELSE --lkullamb interaction_id is present already. Not a pure outbound.Fix for bug 12746288, change jtf_ih_interactions_vl to jtf_ih_interactions

2364: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2365: raise IHError;
2366: end if;
2367: -- following ELSE added for 11737525 ,FP of bug 9791525
2368: ELSE --lkullamb interaction_id is present already. Not a pure outbound.Fix for bug 12746288, change jtf_ih_interactions_vl to jtf_ih_interactions
2369:
2370: select party_id, contact_party_id into l_old_party_id, l_old_contact_id from jtf_ih_interactions where interaction_id = l_interaction_id;
2371:
2372: if( (l_old_party_id <> p_customer_id) -- in case of customer change

Line 2370: select party_id, contact_party_id into l_old_party_id, l_old_contact_id from jtf_ih_interactions where interaction_id = l_interaction_id;

2366: end if;
2367: -- following ELSE added for 11737525 ,FP of bug 9791525
2368: ELSE --lkullamb interaction_id is present already. Not a pure outbound.Fix for bug 12746288, change jtf_ih_interactions_vl to jtf_ih_interactions
2369:
2370: select party_id, contact_party_id into l_old_party_id, l_old_contact_id from jtf_ih_interactions where interaction_id = l_interaction_id;
2371:
2372: if( (l_old_party_id <> p_customer_id) -- in case of customer change
2373: OR (l_old_contact_id is null AND l_ih_contact_id is not null) -- in case the contact has been added. Emp bin. Or from cust bin, another reln. record
2374: OR (l_old_contact_id is not null AND l_ih_contact_id is null) -- in case from cust bin we remove the contact