709: l_automerge_threshold NUMBER;
710: l_dup_batch_id NUMBER;
711: l_dup_set_id NUMBER;
712: l_request_id NUMBER;
713: l_dup_batch_rec HZ_DUP_PVT.DUP_BATCH_REC_TYPE;
714: l_dup_set_rec HZ_DUP_PVT.DUP_SET_REC_TYPE;
715: l_dup_party_tbl HZ_DUP_PVT.DUP_PARTY_TBL_TYPE;
716: l_party_name varchar2(360);
717: l_overlap_merge_req_id NUMBER;
710: l_dup_batch_id NUMBER;
711: l_dup_set_id NUMBER;
712: l_request_id NUMBER;
713: l_dup_batch_rec HZ_DUP_PVT.DUP_BATCH_REC_TYPE;
714: l_dup_set_rec HZ_DUP_PVT.DUP_SET_REC_TYPE;
715: l_dup_party_tbl HZ_DUP_PVT.DUP_PARTY_TBL_TYPE;
716: l_party_name varchar2(360);
717: l_overlap_merge_req_id NUMBER;
718: l_object_version_number NUMBER;
711: l_dup_set_id NUMBER;
712: l_request_id NUMBER;
713: l_dup_batch_rec HZ_DUP_PVT.DUP_BATCH_REC_TYPE;
714: l_dup_set_rec HZ_DUP_PVT.DUP_SET_REC_TYPE;
715: l_dup_party_tbl HZ_DUP_PVT.DUP_PARTY_TBL_TYPE;
716: l_party_name varchar2(360);
717: l_overlap_merge_req_id NUMBER;
718: l_object_version_number NUMBER;
719: l_batch_id NUMBER;
1312: END IF;
1313:
1314: if l_num_matches > 0 then
1315:
1316: hz_dup_pvt.get_most_matching_party(p_search_ctx_id => l_search_ctx_id,
1317: p_new_party_id => x_person_id,
1318: x_party_id => l_party_id,
1319: x_match_score => l_match_score,
1320: x_party_name => l_party_name);
1330: hz_utility_v2pub.debug(p_message=>'Most matching Party Name: '||l_party_name,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1331: hz_utility_v2pub.debug(p_message=>'Match score: '||l_match_score,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1332: END IF;
1333:
1334: hz_dup_pvt.get_match_rule_thresholds(p_match_rule_id => l_match_rule_id,
1335: x_match_threshold => l_match_threshold,
1336: x_automerge_threshold => l_automerge_threshold);
1337:
1338: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1342: END IF;
1343:
1344: if l_match_score >= l_match_threshold
1345: then
1346: hz_dup_pvt.validate_master_party_id(px_party_id => l_party_id,
1347: x_overlap_merge_req_id => l_overlap_merge_req_id);
1348:
1349: hz_utility_v2pub.debug(p_message=>'xx: Winner Party ID is changed. Overlapping Merge Req ID: '||l_overlap_merge_req_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1350: hz_utility_v2pub.debug(p_message=>'xx: Winner Party ID is changed. Party ID: '||l_party_id,p_prefix=>'DEBUG: ',p_msg_level=>fnd_log.level_statement, p_module=>'HZ_Module.enableDQ');
1393: l_dup_party_tbl(2).party_id := x_person_id; -- newly created person id
1394: l_dup_party_tbl(2).score := 0;
1395: l_dup_party_tbl(2).merge_flag := 'Y';
1396:
1397: HZ_DUP_PVT.create_dup_batch(
1398: p_dup_batch_rec => l_dup_batch_rec
1399: ,p_dup_set_rec => l_dup_set_rec
1400: ,p_dup_party_tbl => l_dup_party_tbl
1401: ,x_dup_batch_id => l_dup_batch_id
1418: if l_dup_set_id is not null
1419: then
1420: if l_match_score < l_automerge_threshold -- create merge request
1421: then
1422: hz_dup_pvt.submit_dup (
1423: p_dup_set_id => l_dup_set_id
1424: ,x_request_id => l_request_id
1425: ,x_return_status => x_return_status
1426: ,x_msg_count => x_msg_count