APPS.HZ_MERGE_PKG dependencies on HZ_CITIZENSHIP

Line 1781: 'HZ_CITIZENSHIP','HZ_PARTIES',

1777:
1778: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1779: p_to_fk_id, p_par_entity_name,
1780: 'HZ_MERGE_PKG.citizenship_merge',
1781: 'HZ_CITIZENSHIP','HZ_PARTIES',
1782: 'CITIZENSHIP_ID', 'PARTY_ID',x_return_status);
1783:
1784: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1785: l_dup_exists := HZ_MERGE_DUP_CHECK.check_citizenship_dup(

Line 3701: UPDATE HZ_CITIZENSHIP

3697: BEGIN
3698:
3699: IF (x_to_id <> FND_API.G_MISS_NUM AND
3700: x_to_id <> p_from_id) THEN
3701: UPDATE HZ_CITIZENSHIP
3702: SET
3703: STATUS = 'M',
3704: last_update_date = hz_utility_pub.last_update_date,
3705: last_updated_by = hz_utility_pub.user_id,

Line 3714: UPDATE HZ_CITIZENSHIP

3710: program_update_date = sysdate
3711: WHERE citizenship_id = p_from_id;
3712: ELSE
3713: -- Update and set party_id = p_to_fk_id where pk = from_id
3714: UPDATE HZ_CITIZENSHIP
3715: SET
3716: party_id = p_to_fk_id,
3717: last_update_date = hz_utility_pub.last_update_date,
3718: last_updated_by = hz_utility_pub.user_id,