DBA Data[Home] [Help]

APPS.HZ_MERGE_PKG dependencies on HZ_CREDIT_RATINGS

Line 1483: 'HZ_CREDIT_RATINGS','HZ_PARTIES',

1479:
1480: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1481: p_to_fk_id, p_par_entity_name,
1482: 'HZ_MERGE_PKG.credit_ratings_merge',
1483: 'HZ_CREDIT_RATINGS','HZ_PARTIES',
1484: 'CREDIT_RATING_ID', 'PARTY_ID',x_return_status);
1485:
1486: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1487: l_dup_exists := HZ_MERGE_DUP_CHECK.check_credit_ratings_dup(

Line 3421: UPDATE HZ_CREDIT_RATINGS

3417: BEGIN
3418:
3419: IF (x_to_id <> FND_API.G_MISS_NUM AND
3420: x_to_id <> p_from_id) THEN
3421: UPDATE HZ_CREDIT_RATINGS
3422: SET
3423: STATUS = 'M',
3424: last_update_date = hz_utility_pub.last_update_date,
3425: last_updated_by = hz_utility_pub.user_id,

Line 3434: UPDATE HZ_CREDIT_RATINGS

3430: program_update_date = sysdate
3431: WHERE credit_rating_id = p_from_id;
3432: ELSE
3433: -- Update and set party_id = p_to_fk_id where pk = from_id
3434: UPDATE HZ_CREDIT_RATINGS
3435: SET
3436: party_id = p_to_fk_id,
3437: last_update_date = hz_utility_pub.last_update_date,
3438: last_updated_by = hz_utility_pub.user_id,