APPS.ECX_TP_MERGE_PKG dependencies on ECX_TP_HEADERS

Line 6: -- Description: This routine takes care of the party merge for ECX_TP_HEADERS

2: /* $Header: ECXPMRGB.pls 115.7 2003/07/01 21:20:18 rdiwan ship $ */
3: --
4: -- Procedure: ecx_party_merge
5: --
6: -- Description: This routine takes care of the party merge for ECX_TP_HEADERS
7: -- table
8:
9:
10: PROCEDURE ecx_party_merge(p_Entity_name IN VARCHAR2,

Line 30: -- update ECX_TP_HEADERS for the merge

26: x_to_id := p_from_id;
27: return;
28: END IF;
29:
30: -- update ECX_TP_HEADERS for the merge
31: UPDATE ECX_TP_HEADERS
32: SET party_id = p_To_FK_id,
33: last_updated_by = hz_utility_pub.user_id,
34: last_update_login = hz_utility_pub.last_update_login

Line 31: UPDATE ECX_TP_HEADERS

27: return;
28: END IF;
29:
30: -- update ECX_TP_HEADERS for the merge
31: UPDATE ECX_TP_HEADERS
32: SET party_id = p_To_FK_id,
33: last_updated_by = hz_utility_pub.user_id,
34: last_update_login = hz_utility_pub.last_update_login
35: WHERE party_id = p_From_FK_id

Line 80: -- update ECX_TP_HEADERS for the merge

76: x_to_id := p_from_id;
77: return;
78: END IF;
79:
80: -- update ECX_TP_HEADERS for the merge
81: UPDATE ECX_TP_HEADERS
82: SET party_site_id = p_To_FK_id,
83: last_updated_by = hz_utility_pub.user_id,
84: last_update_login = hz_utility_pub.last_update_login

Line 81: UPDATE ECX_TP_HEADERS

77: return;
78: END IF;
79:
80: -- update ECX_TP_HEADERS for the merge
81: UPDATE ECX_TP_HEADERS
82: SET party_site_id = p_To_FK_id,
83: last_updated_by = hz_utility_pub.user_id,
84: last_update_login = hz_utility_pub.last_update_login
85: WHERE party_site_id = p_From_FK_id