APPS.HZ_MERGE_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1104: 'HZ_CUST_ACCT_SITES_ALL','HZ_PARTY_SITES',

1100:
1101: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1102: p_to_fk_id, p_par_entity_name,
1103: 'HZ_MERGE_PKG.cust_account_site_merge',
1104: 'HZ_CUST_ACCT_SITES_ALL','HZ_PARTY_SITES',
1105: 'CUST_ACCT_SITE_ID', 'PARTY_SITE_ID',x_return_status);
1106:
1107: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
1108: l_dup_exists := HZ_MERGE_DUP_CHECK.check_cust_account_site_dup(

Line 4607: UPDATE HZ_CUST_ACCT_SITES_ALL

4603: BEGIN
4604:
4605: IF (x_to_id <> FND_API.G_MISS_NUM AND
4606: x_to_id <> p_from_id) THEN
4607: UPDATE HZ_CUST_ACCT_SITES_ALL
4608: SET
4609: STATUS = 'M',
4610: last_update_date = hz_utility_pub.last_update_date,
4611: last_updated_by = hz_utility_pub.user_id,

Line 4624: p_owner_table_name =>'HZ_CUST_ACCT_SITES_ALL',

4620: p_init_msg_list => FND_API.G_FALSE,
4621: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
4622: p_old_owner_table_id => p_from_id,
4623: p_new_owner_table_id => x_to_id,
4624: p_owner_table_name =>'HZ_CUST_ACCT_SITES_ALL',
4625: p_orig_system => null,
4626: p_orig_system_reference => null,
4627: p_reason_code => 'MERGED',
4628: x_return_status => x_return_status,

Line 4640: UPDATE HZ_CUST_ACCT_SITES_ALL

4636: RETURN;
4637: END IF;
4638:
4639: ELSE
4640: UPDATE HZ_CUST_ACCT_SITES_ALL
4641: SET
4642: party_site_id = p_to_fk_id,
4643: last_update_date = hz_utility_pub.last_update_date,
4644: last_updated_by = hz_utility_pub.user_id,