APPS.HZ_MERGE_PKG dependencies on HZ_INDUSTRIAL_REFERENCE

Line 1682: 'HZ_INDUSTRIAL_REFERENCE','HZ_PARTIES',

1678:
1679: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1680: p_to_fk_id, p_par_entity_name,
1681: 'HZ_MERGE_PKG.org_ind_reference_merge',
1682: 'HZ_INDUSTRIAL_REFERENCE','HZ_PARTIES',
1683: 'INDUSTRY_REFERENCE_ID', 'PARTY_ID',x_return_status);
1684:
1685: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1686: l_dup_exists := HZ_MERGE_DUP_CHECK.check_ind_reference_dup(

Line 3609: UPDATE HZ_INDUSTRIAL_REFERENCE

3605: BEGIN
3606:
3607: IF (x_to_id <> FND_API.G_MISS_NUM AND
3608: x_to_id <> p_from_id) THEN
3609: UPDATE HZ_INDUSTRIAL_REFERENCE
3610: SET
3611: STATUS = 'M',
3612: last_update_date = hz_utility_pub.last_update_date,
3613: last_updated_by = hz_utility_pub.user_id,

Line 3622: UPDATE HZ_INDUSTRIAL_REFERENCE

3618: program_update_date = sysdate
3619: WHERE industry_reference_id = p_from_id;
3620: ELSE
3621: -- Update and set party_id = p_to_fk_id where pk = from_id
3622: UPDATE HZ_INDUSTRIAL_REFERENCE
3623: SET
3624: party_id = p_to_fk_id,
3625: last_update_date = hz_utility_pub.last_update_date,
3626: last_updated_by = hz_utility_pub.user_id,