DBA Data[Home] [Help]

APPS.HZ_MERGE_PKG dependencies on HZ_FINANCIAL_NUMBERS

Line 2222: 'HZ_FINANCIAL_NUMBERS','HZ_FINANCIAL_REPORTS',

2218:
2219: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2220: p_to_fk_id, p_par_entity_name,
2221: 'HZ_MERGE_PKG.financial_number_merge',
2222: 'HZ_FINANCIAL_NUMBERS','HZ_FINANCIAL_REPORTS',
2223: 'FINANCIAL_NUMBER_ID', 'FINANCIAL_REPORT_ID',x_return_status);
2224:
2225: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2226: l_dup_exists := HZ_MERGE_DUP_CHECK.check_financial_number_dup(

Line 4114: UPDATE HZ_FINANCIAL_NUMBERS

4110: BEGIN
4111:
4112: IF (x_to_id <> FND_API.G_MISS_NUM AND
4113: x_to_id <> p_from_id) THEN
4114: UPDATE HZ_FINANCIAL_NUMBERS
4115: SET
4116: STATUS = 'M',
4117: last_update_date = hz_utility_pub.last_update_date,
4118: last_updated_by = hz_utility_pub.user_id,

Line 4127: UPDATE HZ_FINANCIAL_NUMBERS

4123: program_update_date = sysdate
4124: WHERE financial_number_id = p_from_id;
4125: ELSE
4126: -- Update and set party_id = p_to_fk_id where pk = from_id
4127: UPDATE HZ_FINANCIAL_NUMBERS
4128: SET
4129: financial_report_id = p_to_fk_id,
4130: last_update_date = hz_utility_pub.last_update_date,
4131: last_updated_by = hz_utility_pub.user_id,