DBA Data[Home] [Help]

APPS.HZ_ORGANIZATION_BO_PUB dependencies on HZ_DUP_PVT

Line 1487: l_dup_batch_rec HZ_DUP_PVT.DUP_BATCH_REC_TYPE;

1483: l_automerge_threshold NUMBER;
1484: l_dup_batch_id NUMBER;
1485: l_dup_set_id NUMBER;
1486: l_request_id NUMBER;
1487: l_dup_batch_rec HZ_DUP_PVT.DUP_BATCH_REC_TYPE;
1488: l_dup_set_rec HZ_DUP_PVT.DUP_SET_REC_TYPE;
1489: l_dup_party_tbl HZ_DUP_PVT.DUP_PARTY_TBL_TYPE;
1490: l_party_name varchar2(360);
1491: l_overlap_merge_req_id NUMBER;

Line 1488: l_dup_set_rec HZ_DUP_PVT.DUP_SET_REC_TYPE;

1484: l_dup_batch_id NUMBER;
1485: l_dup_set_id NUMBER;
1486: l_request_id NUMBER;
1487: l_dup_batch_rec HZ_DUP_PVT.DUP_BATCH_REC_TYPE;
1488: l_dup_set_rec HZ_DUP_PVT.DUP_SET_REC_TYPE;
1489: l_dup_party_tbl HZ_DUP_PVT.DUP_PARTY_TBL_TYPE;
1490: l_party_name varchar2(360);
1491: l_overlap_merge_req_id NUMBER;
1492: l_object_version_number NUMBER;

Line 1489: l_dup_party_tbl HZ_DUP_PVT.DUP_PARTY_TBL_TYPE;

1485: l_dup_set_id NUMBER;
1486: l_request_id NUMBER;
1487: l_dup_batch_rec HZ_DUP_PVT.DUP_BATCH_REC_TYPE;
1488: l_dup_set_rec HZ_DUP_PVT.DUP_SET_REC_TYPE;
1489: l_dup_party_tbl HZ_DUP_PVT.DUP_PARTY_TBL_TYPE;
1490: l_party_name varchar2(360);
1491: l_overlap_merge_req_id NUMBER;
1492: l_object_version_number NUMBER;
1493: l_batch_id NUMBER;

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

2237: END IF;
2238:
2239: if l_num_matches > 0 then
2240:
2241: hz_dup_pvt.get_most_matching_party(p_search_ctx_id => l_search_ctx_id,
2242: p_new_party_id => x_organization_id,
2243: x_party_id => l_party_id,
2244: x_match_score => l_match_score,
2245: x_party_name => l_party_name);

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

2256: 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');
2257: 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');
2258: END IF;
2259:
2260: hz_dup_pvt.get_match_rule_thresholds(p_match_rule_id => l_match_rule_id,
2261: x_match_threshold => l_match_threshold,
2262: x_automerge_threshold => l_automerge_threshold);
2263:
2264: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

2268: END IF;
2269:
2270: if l_match_score >= l_match_threshold
2271: then
2272: hz_dup_pvt.validate_master_party_id(px_party_id => l_party_id,
2273: x_overlap_merge_req_id => l_overlap_merge_req_id);
2274:
2275:
2276:

Line 2323: HZ_DUP_PVT.create_dup_batch(

2319: l_dup_party_tbl(2).party_id := x_organization_id; -- newly created org id
2320: l_dup_party_tbl(2).score := 0;
2321: l_dup_party_tbl(2).merge_flag := 'Y';
2322:
2323: HZ_DUP_PVT.create_dup_batch(
2324: p_dup_batch_rec => l_dup_batch_rec
2325: ,p_dup_set_rec => l_dup_set_rec
2326: ,p_dup_party_tbl => l_dup_party_tbl
2327: ,x_dup_batch_id => l_dup_batch_id

Line 2348: hz_dup_pvt.submit_dup (

2344: if l_dup_set_id is not null
2345: then
2346: if l_match_score < l_automerge_threshold -- create merge request
2347: then
2348: hz_dup_pvt.submit_dup (
2349: p_dup_set_id => l_dup_set_id
2350: ,x_request_id => l_request_id
2351: ,x_return_status => x_return_status
2352: ,x_msg_count => x_msg_count