DBA Data[Home] [Help]

APPS.HZ_MERGE_PKG dependencies on HZ_FINANCIAL_REPORTS

Line 1583: 'HZ_FINANCIAL_REPORTS','HZ_PARTIES',

1579:
1580: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1581: p_to_fk_id, p_par_entity_name,
1582: 'HZ_MERGE_PKG.financial_reports_merge',
1583: 'HZ_FINANCIAL_REPORTS','HZ_PARTIES',
1584: 'FINANCIAL_REPORT_ID', 'PARTY_ID',x_return_status);
1585:
1586: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1587: l_dup_exists := HZ_MERGE_DUP_CHECK.check_financial_reports_dup(

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 3515: UPDATE HZ_FINANCIAL_REPORTS

3511: BEGIN
3512:
3513: IF (x_to_id <> FND_API.G_MISS_NUM AND
3514: x_to_id <> p_from_id) THEN
3515: UPDATE HZ_FINANCIAL_REPORTS
3516: SET
3517: STATUS = 'M',
3518: last_update_date = hz_utility_pub.last_update_date,
3519: last_updated_by = hz_utility_pub.user_id,

Line 3528: UPDATE HZ_FINANCIAL_REPORTS

3524: program_update_date = sysdate
3525: WHERE financial_report_id = p_from_id;
3526: ELSE
3527: -- Update and set party_id = p_to_fk_id where pk = from_id
3528: UPDATE HZ_FINANCIAL_REPORTS
3529: SET
3530: party_id = p_to_fk_id,
3531: last_update_date = hz_utility_pub.last_update_date,
3532: last_updated_by = hz_utility_pub.user_id,