953:
954: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
955: p_to_fk_id, p_par_entity_name,
956: 'HZ_MERGE_PKG.cust_account_merge',
957: 'HZ_CUST_ACCOUNTS','HZ_PARTIES',
958: 'CUST_ACCOUNT_ID', 'PARTY_ID',x_return_status);
959: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
960: l_dup_exists := HZ_MERGE_DUP_CHECK.check_cust_account_dup(
961: p_from_id,l_to_id, p_from_fk_id, p_to_fk_id,
1001:
1002: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
1003: p_to_fk_id, p_par_entity_name,
1004: 'HZ_MERGE_PKG.cust_account_merge',
1005: 'HZ_CUST_ACCOUNTS','HZ_PARTIES',
1006: 'CUST_ACCOUNT_ID', 'SELLING_PARTY_ID',x_return_status);
1007:
1008: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN
1009: UPDATE HZ_CUST_ACCOUNTS
1005: 'HZ_CUST_ACCOUNTS','HZ_PARTIES',
1006: 'CUST_ACCOUNT_ID', 'SELLING_PARTY_ID',x_return_status);
1007:
1008: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN
1009: UPDATE HZ_CUST_ACCOUNTS
1010: SET
1011: selling_party_id = p_to_fk_id,
1012: last_update_date = hz_utility_pub.last_update_date,
1013: last_updated_by = hz_utility_pub.user_id,
2749: BEGIN
2750:
2751: IF (x_to_id <> FND_API.G_MISS_NUM AND
2752: x_to_id <> p_from_id) THEN
2753: UPDATE HZ_CUST_ACCOUNTS
2754: SET
2755: STATUS = 'M',
2756: last_update_date = hz_utility_pub.last_update_date,
2757: last_updated_by = hz_utility_pub.user_id,
2765: p_init_msg_list => FND_API.G_FALSE,
2766: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
2767: p_old_owner_table_id => p_from_id,
2768: p_new_owner_table_id => x_to_id,
2769: p_owner_table_name =>'HZ_CUST_ACCOUNTS',
2770: p_orig_system => null,
2771: p_orig_system_reference => null,
2772: p_reason_code => 'MERGED',
2773: x_return_status => x_return_status,
2781: RETURN;
2782: END IF;
2783: ELSE
2784: -- Update and set party_id = p_to_fk_id where pk = from_id
2785: UPDATE HZ_CUST_ACCOUNTS
2786: SET
2787: party_id = p_to_fk_id,
2788: last_update_date = hz_utility_pub.last_update_date,
2789: last_updated_by = hz_utility_pub.user_id,