APPS.AMS_PARTY_MERGE_PVT dependencies on AMS_TCOP_PRVW_FTG_DTLS

Line 3014: -- TCOP_PRVW_FTG_DTL_PARTY_MERGE created for (AMS_TCOP_PRVW_FTG_DTLS)

3010:
3011:
3012: -----------------------------------------------------------------------
3013: -- PROCEDURE
3014: -- TCOP_PRVW_FTG_DTL_PARTY_MERGE created for (AMS_TCOP_PRVW_FTG_DTLS)
3015: --
3016: -- HISTORY
3017: -- 02-Jan-2004 mayjain Created
3018: -----------------------------------------------------------------------

Line 3098: DELETE FROM AMS_TCOP_PRVW_FTG_DTLS

3094: IF p_from_fk_id <> p_to_fk_id THEN
3095: BEGIN
3096: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
3097:
3098: DELETE FROM AMS_TCOP_PRVW_FTG_DTLS
3099: WHERE party_id = p_from_fk_id
3100: and FATIGUE_DETAIL_ID in
3101: (SELECT f.FATIGUE_DETAIL_ID
3102: FROM AMS_TCOP_PRVW_FTG_DTLS f, AMS_TCOP_PRVW_FTG_DTLS t

Line 3102: FROM AMS_TCOP_PRVW_FTG_DTLS f, AMS_TCOP_PRVW_FTG_DTLS t

3098: DELETE FROM AMS_TCOP_PRVW_FTG_DTLS
3099: WHERE party_id = p_from_fk_id
3100: and FATIGUE_DETAIL_ID in
3101: (SELECT f.FATIGUE_DETAIL_ID
3102: FROM AMS_TCOP_PRVW_FTG_DTLS f, AMS_TCOP_PRVW_FTG_DTLS t
3103: WHERE f.party_id = p_from_fk_id
3104: AND t.party_id = p_to_fk_id
3105: AND f.PREVIEW_ID = t.PREVIEW_ID);
3106:

Line 3107: UPDATE AMS_TCOP_PRVW_FTG_DTLS

3103: WHERE f.party_id = p_from_fk_id
3104: AND t.party_id = p_to_fk_id
3105: AND f.PREVIEW_ID = t.PREVIEW_ID);
3106:
3107: UPDATE AMS_TCOP_PRVW_FTG_DTLS
3108: SET party_id = p_to_fk_id,
3109: last_update_date = hz_utility_pub.last_update_date,
3110: last_updated_by = hz_utility_pub.user_id,
3111: last_update_login = hz_utility_pub.last_update_login

Line 3115: FROM AMS_TCOP_PRVW_FTG_DTLS f, AMS_TCOP_PRVW_FTG_DTLS t

3111: last_update_login = hz_utility_pub.last_update_login
3112: where party_id = p_from_fk_id
3113: and FATIGUE_DETAIL_ID not in
3114: (SELECT f.FATIGUE_DETAIL_ID
3115: FROM AMS_TCOP_PRVW_FTG_DTLS f, AMS_TCOP_PRVW_FTG_DTLS t
3116: WHERE f.party_id = p_from_fk_id
3117: AND t.party_id = p_to_fk_id
3118: AND f.PREVIEW_ID = t.PREVIEW_ID);
3119: END IF;