APPS.AS_SALES_LEADS_MERGE_PKG dependencies on AS_SALES_LEAD_CONTACTS

Line 248: UPDATE AS_SALES_LEAD_CONTACTS

244:
245: IF p_from_fk_id <> p_to_fk_id THEN
246: BEGIN
247: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
248: UPDATE AS_SALES_LEAD_CONTACTS
249: set customer_id = p_to_fk_id,
250: last_update_date = hz_utility_pub.last_update_date,
251: last_updated_by = hz_utility_pub.user_id,
252: last_update_login = hz_utility_pub.last_update_login,

Line 259: UPDATE AS_SALES_LEAD_CONTACTS

255: program_id = hz_utility_pub.program_id,
256: program_update_date = sysdate
257: where customer_id = p_from_fk_id;
258:
259: UPDATE AS_SALES_LEAD_CONTACTS
260: set contact_party_id = p_to_fk_id,
261: last_update_date = hz_utility_pub.last_update_date,
262: last_updated_by = hz_utility_pub.user_id,
263: last_update_login = hz_utility_pub.last_update_login,

Line 270: UPDATE AS_SALES_LEAD_CONTACTS

266: program_id = hz_utility_pub.program_id,
267: program_update_date = sysdate
268: where contact_party_id = p_from_fk_id;
269: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
270: UPDATE AS_SALES_LEAD_CONTACTS
271: set address_id = p_to_fk_id,
272: last_update_date = hz_utility_pub.last_update_date,
273: last_updated_by = hz_utility_pub.user_id,
274: last_update_login = hz_utility_pub.last_update_login,

Line 281: UPDATE AS_SALES_LEAD_CONTACTS

277: program_id = hz_utility_pub.program_id,
278: program_update_date = sysdate
279: where address_id = p_from_fk_id;
280: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN -- merge org_contact
281: UPDATE AS_SALES_LEAD_CONTACTS
282: set contact_id = p_to_fk_id,
283: last_update_date = hz_utility_pub.last_update_date,
284: last_updated_by = hz_utility_pub.user_id,
285: last_update_login = hz_utility_pub.last_update_login,

Line 292: UPDATE AS_SALES_LEAD_CONTACTS

288: program_id = hz_utility_pub.program_id,
289: program_update_date = sysdate
290: where contact_id = p_from_fk_id;
291: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points
292: UPDATE AS_SALES_LEAD_CONTACTS
293: set phone_id = p_to_fk_id,
294: last_update_date = hz_utility_pub.last_update_date,
295: last_updated_by = hz_utility_pub.user_id,
296: last_update_login = hz_utility_pub.last_update_login,