APPS.HZ_DQM_DUP_ID_PKG dependencies on HZ_IMP_DUP_DETAILS

Line 1345: -- INSERT INTO HZ_DUP_SETS, ALL THE DISTINCT PARTY_IDs WHICH OCCUR IN HZ_IMP_DUP_DETAILS

1341: c_count number ;
1342: cp_count number ;
1343: BEGIN
1344:
1345: -- INSERT INTO HZ_DUP_SETS, ALL THE DISTINCT PARTY_IDs WHICH OCCUR IN HZ_IMP_DUP_DETAILS
1346: -- FOR THE GIVEN BATCH, PROVIDED THE FOLLOWING CONDITION IS MET:
1347: -- 1. ALL THE WINNER PARTIES SHOULD HAVE ATLEAST ONE DETAIL THAT HAS BEEN
1348: -- LOADED TO TCA.
1349:

Line 1351: from hz_imp_dup_details

1347: -- 1. ALL THE WINNER PARTIES SHOULD HAVE ATLEAST ONE DETAIL THAT HAS BEEN
1348: -- LOADED TO TCA.
1349:
1350: select count(1) into p_count
1351: from hz_imp_dup_details
1352: where batch_id = p_batch_id;
1353:
1354: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------------------');
1355: FND_FILE.put_line(FND_FILE.log,'Details ::: Number of parties in HZ_IMP_DUP_DETAILS before reporting'|| p_count );

Line 1355: FND_FILE.put_line(FND_FILE.log,'Details ::: Number of parties in HZ_IMP_DUP_DETAILS before reporting'|| p_count );

1351: from hz_imp_dup_details
1352: where batch_id = p_batch_id;
1353:
1354: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------------------');
1355: FND_FILE.put_line(FND_FILE.log,'Details ::: Number of parties in HZ_IMP_DUP_DETAILS before reporting'|| p_count );
1356: FND_FILE.put_line(FND_FILE.log,'Details ::: Begin time of insert '||to_char(sysdate,'hh24:mi:ss'));
1357:
1358: insert into hz_dup_sets ( winner_party_id, dup_set_id, dup_batch_id,
1359: status, merge_type, created_by, creation_date, last_update_login,

Line 1367: from hz_imp_dup_details h

1363: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
1364: hz_utility_pub.user_id
1365: from
1366: (select distinct h.party_id as win_party_id
1367: from hz_imp_dup_details h
1368: where h.batch_id = p_batch_id
1369: and
1370: (
1371: exists (select a.dup_record_id

Line 1372: from hz_imp_dup_details a, hz_party_sites b

1368: where h.batch_id = p_batch_id
1369: and
1370: (
1371: exists (select a.dup_record_id
1372: from hz_imp_dup_details a, hz_party_sites b
1373: where a.party_id = h.party_id
1374: and a.batch_id = p_batch_id
1375: and a.record_id = b.party_site_id
1376: and b.request_id = p_request_id

Line 1380: from hz_imp_dup_details a, hz_contact_points b

1376: and b.request_id = p_request_id
1377: )
1378: or
1379: exists (select a.dup_record_id
1380: from hz_imp_dup_details a, hz_contact_points b
1381: where a.party_id = h.party_id
1382: and a.batch_id = p_batch_id
1383: and a.record_id = b.contact_point_id
1384: and b.request_id = p_request_id

Line 1388: from hz_imp_dup_details a, hz_org_contacts b

1384: and b.request_id = p_request_id
1385: )
1386: or
1387: exists (select a.dup_record_id
1388: from hz_imp_dup_details a, hz_org_contacts b
1389: where a.party_id = h.party_id
1390: and a.batch_id = p_batch_id
1391: and a.record_id = b.org_contact_id
1392: and b.request_id = p_request_id

Line 1424: from hz_imp_dup_details a, hz_party_sites b

1420:
1421: -- Updating counts to Batch Summary
1422: -- Party Site Count
1423: select count(distinct a.dup_record_id) into ps_count
1424: from hz_imp_dup_details a, hz_party_sites b
1425: where a.batch_id = p_batch_id
1426: and a.record_id = b.party_site_id
1427: and b.request_id = p_request_id ;
1428: update hz_imp_batch_summary h

Line 1435: from hz_imp_dup_details a, hz_contact_points b

1431:
1432:
1433: -- Contact Point Count
1434: select count(distinct a.dup_record_id) into cp_count
1435: from hz_imp_dup_details a, hz_contact_points b
1436: where a.batch_id = p_batch_id
1437: and a.record_id = b.contact_point_id
1438: and b.request_id = p_request_id ;
1439: update hz_imp_batch_summary h

Line 1447: from hz_imp_dup_details a, hz_org_contacts b

1443:
1444:
1445: -- Contact Count
1446: select count(distinct a.dup_record_id) into c_count
1447: from hz_imp_dup_details a, hz_org_contacts b
1448: where a.batch_id = p_batch_id
1449: and a.record_id = b.org_contact_id
1450: and b.request_id = p_request_id ;
1451:

Line 1714: from hz_imp_dup_details

1710: update hz_imp_batch_summary h
1711: set potential_dup_addresses =
1712: (select count(1) from
1713: (select distinct record_id
1714: from hz_imp_dup_details
1715: where batch_id = p_batch_id
1716: and entity = 'PARTY_SITES'
1717: )
1718: )

Line 1728: from hz_imp_dup_details

1724: update hz_imp_batch_summary h
1725: set potential_dup_contacts =
1726: (select count(1) from
1727: (select distinct record_id
1728: from hz_imp_dup_details
1729: where batch_id = p_batch_id
1730: and entity = 'CONTACTS'
1731: )
1732: )

Line 1742: from hz_imp_dup_details

1738: update hz_imp_batch_summary h
1739: set potential_dup_contactpoints =
1740: (select count(1) from
1741: (select distinct record_id
1742: from hz_imp_dup_details
1743: where batch_id = p_batch_id
1744: and entity = 'CONTACT_POINTS'
1745: )
1746: )