APPS.AMS_PARTY_MERGE_PVT dependencies on AMS_TCOP_CONTACTS

Line 2641: -- TCOP_CONTACT_PARTY_MERGE created for (AMS_TCOP_CONTACTS)

2637:
2638:
2639: -----------------------------------------------------------------------
2640: -- PROCEDURE
2641: -- TCOP_CONTACT_PARTY_MERGE created for (AMS_TCOP_CONTACTS)
2642: --
2643: -- HISTORY
2644: -- 02-Jan-2004 mayjain Created
2645: -----------------------------------------------------------------------

Line 2727: DELETE FROM AMS_TCOP_CONTACTS

2723: IF p_from_fk_id <> p_to_fk_id THEN
2724: BEGIN
2725: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2726:
2727: DELETE FROM AMS_TCOP_CONTACTS
2728: WHERE party_id = p_from_fk_id
2729: and CONTACT_ID in
2730: (SELECT f.CONTACT_ID
2731: FROM AMS_TCOP_CONTACTS f, AMS_TCOP_CONTACTS t

Line 2731: FROM AMS_TCOP_CONTACTS f, AMS_TCOP_CONTACTS t

2727: DELETE FROM AMS_TCOP_CONTACTS
2728: WHERE party_id = p_from_fk_id
2729: and CONTACT_ID in
2730: (SELECT f.CONTACT_ID
2731: FROM AMS_TCOP_CONTACTS f, AMS_TCOP_CONTACTS t
2732: WHERE f.party_id = p_from_fk_id
2733: AND t.party_id = p_to_fk_id
2734: AND f.SCHEDULE_ID = t.SCHEDULE_ID);
2735:

Line 2737: UPDATE AMS_TCOP_CONTACTS

2733: AND t.party_id = p_to_fk_id
2734: AND f.SCHEDULE_ID = t.SCHEDULE_ID);
2735:
2736:
2737: UPDATE AMS_TCOP_CONTACTS
2738: SET party_id = p_to_fk_id,
2739: last_update_date = hz_utility_pub.last_update_date,
2740: last_updated_by = hz_utility_pub.user_id,
2741: last_update_login = hz_utility_pub.last_update_login

Line 2745: FROM AMS_TCOP_CONTACTS f, AMS_TCOP_CONTACTS t

2741: last_update_login = hz_utility_pub.last_update_login
2742: WHERE party_id = p_from_fk_id
2743: and CONTACT_ID not in
2744: (SELECT f.CONTACT_ID
2745: FROM AMS_TCOP_CONTACTS f, AMS_TCOP_CONTACTS t
2746: WHERE f.party_id = p_from_fk_id
2747: AND t.party_id = p_to_fk_id
2748: AND f.SCHEDULE_ID = t.SCHEDULE_ID);
2749: