DBA Data[Home] [Help]

APPS.HZ_MERGE_PKG dependencies on HZ_REFERENCES

Line 1354: 'HZ_REFERENCES','HZ_PARTIES',

1350:
1351: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1352: p_to_fk_id, p_par_entity_name,
1353: 'HZ_MERGE_PKG.references_merge',
1354: 'HZ_REFERENCES','HZ_PARTIES',
1355: 'REFERENCE_ID', 'PARTY_ID',x_return_status);
1356:
1357: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1358: l_dup_exists := HZ_MERGE_DUP_CHECK.check_references_dup(

Line 3327: UPDATE HZ_REFERENCES

3323: BEGIN
3324:
3325: IF (x_to_id <> FND_API.G_MISS_NUM AND
3326: x_to_id <> p_from_id) THEN
3327: UPDATE HZ_REFERENCES
3328: SET
3329: status = 'M',
3330: last_update_date = hz_utility_pub.last_update_date,
3331: last_updated_by = hz_utility_pub.user_id,

Line 3340: UPDATE HZ_REFERENCES

3336: program_update_date = sysdate
3337: WHERE reference_id = p_from_id;
3338: ELSE
3339: -- Update and set party_id = p_to_fk_id where pk = from_id
3340: UPDATE HZ_REFERENCES
3341: SET
3342: referenced_party_id = p_to_fk_id,
3343: last_update_date = hz_utility_pub.last_update_date,
3344: last_updated_by = hz_utility_pub.user_id,