DBA Data[Home] [Help]

APPS.HZ_MERGE_PKG dependencies on HZ_PERSON_INTEREST

Line 1732: 'HZ_PERSON_INTEREST','HZ_PARTIES',

1728:
1729: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1730: p_to_fk_id, p_par_entity_name,
1731: 'HZ_MERGE_PKG.per_interest_merge',
1732: 'HZ_PERSON_INTEREST','HZ_PARTIES',
1733: 'PERSON_INTEREST_ID', 'PARTY_ID',x_return_status);
1734:
1735: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1736: l_dup_exists := HZ_MERGE_DUP_CHECK.check_per_interest_dup(

Line 3654: UPDATE HZ_PERSON_INTEREST

3650: BEGIN
3651:
3652: IF (x_to_id <> FND_API.G_MISS_NUM AND
3653: x_to_id <> p_from_id) THEN
3654: UPDATE HZ_PERSON_INTEREST
3655: SET
3656: STATUS = 'M',
3657: last_update_date = hz_utility_pub.last_update_date,
3658: last_updated_by = hz_utility_pub.user_id,

Line 3667: UPDATE HZ_PERSON_INTEREST

3663: program_update_date = sysdate
3664: WHERE person_interest_id = p_from_id;
3665: ELSE
3666: -- Update and set party_id = p_to_fk_id where pk = from_id
3667: UPDATE HZ_PERSON_INTEREST
3668: SET
3669: party_id = p_to_fk_id,
3670: last_update_date = hz_utility_pub.last_update_date,
3671: last_updated_by = hz_utility_pub.user_id,