APPS.AMS_PARTY_MERGE_PVT dependencies on AMS_TCOP_CHANNEL_SUMMARY

Line 2512: -- TCOP_CHANNEL_PARTY_MERGE created for (AMS_TCOP_CHANNEL_SUMMARY)

2508: END Agendas_Party_Merge;
2509:
2510: -----------------------------------------------------------------------
2511: -- PROCEDURE
2512: -- TCOP_CHANNEL_PARTY_MERGE created for (AMS_TCOP_CHANNEL_SUMMARY)
2513: --
2514: -- HISTORY
2515: -- 02-Jan-2004 mayjain Created
2516: -----------------------------------------------------------------------

Line 2599: DELETE FROM AMS_TCOP_CHANNEL_SUMMARY

2595: BEGIN
2596: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
2597:
2598: -- Delete all the rows with which have the p_from_fk_id and media_id combination same as p_to_fk_id and media_id
2599: DELETE FROM AMS_TCOP_CHANNEL_SUMMARY
2600: WHERE party_id = p_from_fk_id
2601: and channel_summary_id in
2602: (SELECT f.channel_summary_id
2603: FROM AMS_TCOP_CHANNEL_SUMMARY f, AMS_TCOP_CHANNEL_SUMMARY t

Line 2603: FROM AMS_TCOP_CHANNEL_SUMMARY f, AMS_TCOP_CHANNEL_SUMMARY t

2599: DELETE FROM AMS_TCOP_CHANNEL_SUMMARY
2600: WHERE party_id = p_from_fk_id
2601: and channel_summary_id in
2602: (SELECT f.channel_summary_id
2603: FROM AMS_TCOP_CHANNEL_SUMMARY f, AMS_TCOP_CHANNEL_SUMMARY t
2604: WHERE f.party_id = p_from_fk_id
2605: AND t.party_id = p_to_fk_id
2606: AND f.MEDIA_ID = t.MEDIA_ID);
2607:

Line 2609: UPDATE AMS_TCOP_CHANNEL_SUMMARY

2605: AND t.party_id = p_to_fk_id
2606: AND f.MEDIA_ID = t.MEDIA_ID);
2607:
2608: -- Update the rows which do not satisfy the above criteria
2609: UPDATE AMS_TCOP_CHANNEL_SUMMARY
2610: SET party_id = p_to_fk_id,
2611: last_update_date = hz_utility_pub.last_update_date,
2612: last_updated_by = hz_utility_pub.user_id,
2613: last_update_login = hz_utility_pub.last_update_login

Line 2617: FROM AMS_TCOP_CHANNEL_SUMMARY f, AMS_TCOP_CHANNEL_SUMMARY t

2613: last_update_login = hz_utility_pub.last_update_login
2614: WHERE party_id = p_from_fk_id
2615: and channel_summary_id not in
2616: (SELECT f.channel_summary_id
2617: FROM AMS_TCOP_CHANNEL_SUMMARY f, AMS_TCOP_CHANNEL_SUMMARY t
2618: WHERE f.party_id = p_from_fk_id
2619: AND t.party_id = p_to_fk_id
2620: AND f.MEDIA_ID = t.MEDIA_ID);
2621: