DBA Data[Home] [Help]

APPS.HZ_MERGE_PKG dependencies on HZ_FINANCIAL_PROFILE

Line 1182: 'HZ_FINANCIAL_PROFILE','HZ_PARTIES',

1178:
1179: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1180: p_to_fk_id, p_par_entity_name,
1181: 'HZ_MERGE_PKG.financial_profile_merge',
1182: 'HZ_FINANCIAL_PROFILE','HZ_PARTIES',
1183: 'FINANCIAL_PROFILE_ID', 'PARTY_ID',x_return_status);
1184:
1185: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1186: l_dup_exists := HZ_MERGE_DUP_CHECK.check_financial_profile_dup(

Line 2931: UPDATE HZ_FINANCIAL_PROFILE

2927: BEGIN
2928:
2929: IF (x_to_id <> FND_API.G_MISS_NUM AND
2930: x_to_id <> p_from_id) THEN
2931: UPDATE HZ_FINANCIAL_PROFILE
2932: SET
2933: STATUS = 'M',
2934: last_update_date = hz_utility_pub.last_update_date,
2935: last_updated_by = hz_utility_pub.user_id,

Line 2944: UPDATE HZ_FINANCIAL_PROFILE

2940: program_update_date = sysdate
2941: WHERE financial_profile_id = p_from_id;
2942: ELSE
2943: -- Update and set party_id = p_to_fk_id where pk = from_id
2944: UPDATE HZ_FINANCIAL_PROFILE
2945: SET
2946: party_id = p_to_fk_id,
2947: last_update_date = hz_utility_pub.last_update_date,
2948: last_updated_by = hz_utility_pub.user_id,