APPS.HZ_MERGE_PKG dependencies on HZ_CONTACT_PREFERENCES

Line 2463: 'HZ_CONTACT_PREFERENCES','HZ_PARTIES',

2459:
2460: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2461: p_to_fk_id, p_par_entity_name,
2462: 'HZ_MERGE_PKG.contact_preference_merge',
2463: 'HZ_CONTACT_PREFERENCES','HZ_PARTIES',
2464: 'CONTACT_PREFERENCE_ID', 'PARTY_ID',x_return_status);
2465:
2466: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2467: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_preference_dup(

Line 2541: 'HZ_CONTACT_PREFERENCES','HZ_PARTY_SITES',

2537:
2538: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2539: p_to_fk_id, p_par_entity_name,
2540: 'HZ_MERGE_PKG.contact_preference_merge2',
2541: 'HZ_CONTACT_PREFERENCES','HZ_PARTY_SITES',
2542: 'CONTACT_PREFERENCE_ID', 'PARTY_SITE_ID',x_return_status);
2543:
2544: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2545: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_preference_dup(

Line 2620: 'HZ_CONTACT_PREFERENCES','HZ_CONTACT_POINTS',

2616:
2617: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2618: p_to_fk_id, p_par_entity_name,
2619: 'HZ_MERGE_PKG.contact_preference_merge3',
2620: 'HZ_CONTACT_PREFERENCES','HZ_CONTACT_POINTS',
2621: 'CONTACT_PREFERENCE_ID', 'CONTACT_POINT_ID',x_return_status);
2622:
2623: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2624: l_dup_exists := HZ_MERGE_DUP_CHECK.check_contact_preference_dup(

Line 3280: UPDATE HZ_CONTACT_PREFERENCES

3276:
3277: BEGIN
3278: IF (x_to_id <> FND_API.G_MISS_NUM AND
3279: x_to_id <> p_from_id) THEN
3280: UPDATE HZ_CONTACT_PREFERENCES
3281: SET
3282: status = 'M',
3283: last_update_date = hz_utility_pub.last_update_date,
3284: last_updated_by = hz_utility_pub.user_id,

Line 3293: UPDATE HZ_CONTACT_PREFERENCES

3289: program_update_date = sysdate
3290: WHERE contact_preference_id = p_from_id;
3291: ELSE
3292: -- Update and set contact_level_table_id = p_to_fk_id where pk = from_id
3293: UPDATE HZ_CONTACT_PREFERENCES
3294: SET
3295: contact_level_table_id = p_to_fk_id,
3296: last_update_date = hz_utility_pub.last_update_date,
3297: last_updated_by = hz_utility_pub.user_id,