DBA Data[Home] [Help]

APPS.HZ_PERSON_BO_PUB dependencies on HZ_DUP_PVT

Line 713: l_dup_batch_rec HZ_DUP_PVT.DUP_BATCH_REC_TYPE;

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;

Line 714: l_dup_set_rec HZ_DUP_PVT.DUP_SET_REC_TYPE;

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;

Line 715: l_dup_party_tbl HZ_DUP_PVT.DUP_PARTY_TBL_TYPE;

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;

Line 1316: hz_dup_pvt.get_most_matching_party(p_search_ctx_id => l_search_ctx_id,

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);

Line 1334: hz_dup_pvt.get_match_rule_thresholds(p_match_rule_id => l_match_rule_id,

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

Line 1346: hz_dup_pvt.validate_master_party_id(px_party_id => l_party_id,

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');

Line 1397: HZ_DUP_PVT.create_dup_batch(

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

Line 1422: hz_dup_pvt.submit_dup (

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