APPS.AMS_PARTY_MERGE_PVT dependencies on AMS_TCOP_CONTACT_SUMMARY

Line 2768: -- TCOP_CONTACT_SUMM_PARTY_MERGE created for (AMS_TCOP_CONTACT_SUMMARY)

2764:
2765:
2766: -----------------------------------------------------------------------
2767: -- PROCEDURE
2768: -- TCOP_CONTACT_SUMM_PARTY_MERGE created for (AMS_TCOP_CONTACT_SUMMARY)
2769: --
2770: -- HISTORY
2771: -- 02-Jan-2004 mayjain Created
2772: -----------------------------------------------------------------------

Line 2794: FROM AMS_TCOP_CONTACT_SUMMARY

2790:
2791: CURSOR party_cur(to_party NUMBER)
2792: IS
2793: SELECT 1
2794: FROM AMS_TCOP_CONTACT_SUMMARY
2795: WHERE party_id = to_party;
2796:
2797: BEGIN
2798:

Line 2873: DELETE FROM AMS_TCOP_CONTACT_SUMMARY

2869:
2870: IF l_party_val_flag = 'Y'
2871: THEN
2872:
2873: DELETE FROM AMS_TCOP_CONTACT_SUMMARY
2874: WHERE party_id = p_from_fk_id;
2875:
2876: ELSE
2877: UPDATE AMS_TCOP_CONTACT_SUMMARY

Line 2877: UPDATE AMS_TCOP_CONTACT_SUMMARY

2873: DELETE FROM AMS_TCOP_CONTACT_SUMMARY
2874: WHERE party_id = p_from_fk_id;
2875:
2876: ELSE
2877: UPDATE AMS_TCOP_CONTACT_SUMMARY
2878: SET party_id = p_to_fk_id,
2879: last_update_date = hz_utility_pub.last_update_date,
2880: last_updated_by = hz_utility_pub.user_id,
2881: last_update_login = hz_utility_pub.last_update_login