APPS.HZ_MERGE_PKG dependencies on HZ_SECURITY_ISSUED

Line 1533: 'HZ_SECURITY_ISSUED','HZ_PARTIES',

1529:
1530: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1531: p_to_fk_id, p_par_entity_name,
1532: 'HZ_MERGE_PKG.security_issued_merge',
1533: 'HZ_SECURITY_ISSUED','HZ_PARTIES',
1534: 'SECURITY_ISSUED_ID', 'PARTY_ID',x_return_status);
1535:
1536: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1537:

Line 3468: UPDATE HZ_SECURITY_ISSUED

3464: BEGIN
3465:
3466: IF (x_to_id <> FND_API.G_MISS_NUM AND
3467: x_to_id <> p_from_id) THEN
3468: UPDATE HZ_SECURITY_ISSUED
3469: SET
3470: STATUS = 'M',
3471: last_update_date = hz_utility_pub.last_update_date,
3472: last_updated_by = hz_utility_pub.user_id,

Line 3481: UPDATE HZ_SECURITY_ISSUED

3477: program_update_date = sysdate
3478: WHERE security_issued_id = p_from_id;
3479: ELSE
3480: -- Update and set party_id = p_to_fk_id where pk = from_id
3481: UPDATE HZ_SECURITY_ISSUED
3482: SET
3483: party_id = p_to_fk_id,
3484: last_update_date = hz_utility_pub.last_update_date,
3485: last_updated_by = hz_utility_pub.user_id,