DBA Data[Home] [Help]

APPS.AMS_PARTY_MERGE_PVT dependencies on AMS_EVENT_REGISTRATIONS

Line 83: UPDATE AMS_EVENT_REGISTRATIONS

79: IF p_from_fk_id <> p_to_fk_id THEN
80: BEGIN
81: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
82:
83: UPDATE AMS_EVENT_REGISTRATIONS
84: set REGISTRANT_PARTY_ID = p_to_fk_id,
85: last_update_date = hz_utility_pub.last_update_date,
86: last_updated_by = hz_utility_pub.user_id,
87: last_update_login = hz_utility_pub.last_update_login,

Line 96: UPDATE AMS_EVENT_REGISTRATIONS

92:
93: -- following part added by soagrawa on 17-jan-2003
94: -- for bug# 2696534. Also refer to bug# 1539211
95:
96: UPDATE AMS_EVENT_REGISTRATIONS
97: set REGISTRANT_CONTACT_ID = p_to_fk_id,
98: last_update_date = hz_utility_pub.last_update_date,
99: last_updated_by = hz_utility_pub.user_id,
100: last_update_login = hz_utility_pub.last_update_login,

Line 111: UPDATE AMS_EVENT_REGISTRATIONS

107: -- for bug# 2696534. Also refer to bug# 1539211
108:
109: /*
110: ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN -- merge org_contact
111: UPDATE AMS_EVENT_REGISTRATIONS
112: set REGISTRANT_CONTACT_ID = p_to_fk_id,
113: last_update_date = hz_utility_pub.last_update_date,
114: last_updated_by = hz_utility_pub.user_id,
115: last_update_login = hz_utility_pub.last_update_login,

Line 210: UPDATE AMS_EVENT_REGISTRATIONS

206:
207: IF p_from_fk_id <> p_to_fk_id THEN
208: BEGIN
209: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
210: UPDATE AMS_EVENT_REGISTRATIONS
211: set ATTENDANT_PARTY_ID = p_to_fk_id,
212: last_update_date = hz_utility_pub.last_update_date,
213: last_updated_by = hz_utility_pub.user_id,
214: last_update_login = hz_utility_pub.last_update_login,

Line 223: UPDATE AMS_EVENT_REGISTRATIONS

219:
220: -- following part added by soagrawa on 17-jan-2003
221: -- for bug# 2696534. Also refer to bug# 1539211
222:
223: UPDATE AMS_EVENT_REGISTRATIONS
224: set ATTENDANT_CONTACT_ID = p_to_fk_id,
225: last_update_date = hz_utility_pub.last_update_date,
226: last_updated_by = hz_utility_pub.user_id,
227: last_update_login = hz_utility_pub.last_update_login,

Line 238: UPDATE AMS_EVENT_REGISTRATIONS

234: -- following part removed by soagrawa on 17-jan-2003
235: -- for bug# 2696534. Also refer to bug# 1539211
236:
237: /* ELSIF p_parent_entity_name = 'HZ_ORG_CONTACTS' THEN -- merge org_contact
238: UPDATE AMS_EVENT_REGISTRATIONS
239: set ATTENDANT_CONTACT_ID = p_to_fk_id,
240: last_update_date = hz_utility_pub.last_update_date,
241: last_updated_by = hz_utility_pub.user_id,
242: last_update_login = hz_utility_pub.last_update_login,