APPS.HZ_MERGE_PKG dependencies on HZ_CERTIFICATIONS

Line 1434: 'HZ_CERTIFICATIONS','HZ_PARTIES',

1430:
1431: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1432: p_to_fk_id, p_par_entity_name,
1433: 'HZ_MERGE_PKG.certification_merge',
1434: 'HZ_CERTIFICATIONS','HZ_PARTIES',
1435: 'CERTIFICATION_ID', 'PARTY_ID',x_return_status);
1436:
1437: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1438: l_dup_exists := HZ_MERGE_DUP_CHECK.check_certification_dup(

Line 3372: UPDATE HZ_CERTIFICATIONS

3368: BEGIN
3369:
3370: IF (x_to_id <> FND_API.G_MISS_NUM AND
3371: x_to_id <> p_from_id) THEN
3372: UPDATE HZ_CERTIFICATIONS
3373: SET
3374: STATUS = 'M',
3375: last_update_date = hz_utility_pub.last_update_date,
3376: last_updated_by = hz_utility_pub.user_id,

Line 3385: UPDATE HZ_CERTIFICATIONS

3381: program_update_date = sysdate
3382: WHERE certification_id = p_from_id;
3383: ELSE
3384: -- Update and set party_id = p_to_fk_id where pk = from_id
3385: UPDATE HZ_CERTIFICATIONS
3386: SET
3387: party_id = p_to_fk_id,
3388: last_update_date = hz_utility_pub.last_update_date,
3389: last_updated_by = hz_utility_pub.user_id,