eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_BATCH_DUPLICATE dependencies on HZ_DUP_SET_PARTIES

Line 64: from hz_dup_set_parties dsp, hz_dup_sets ds

60: -- start bug 4773387
61:
62: cursor am_candidates_exist_csr(cp_dup_batch_id NUMBER) is
63: select count(*)
64: from hz_dup_set_parties dsp, hz_dup_sets ds
65: where dsp.dup_set_id = ds.dup_set_id
66: and ds.dup_batch_id = cp_dup_batch_id
67: and ds.winner_party_id <> dsp.dup_party_id
68: and merge_flag = 'Y'

Line 101: from hz_dup_set_parties

97: l_staged_var VARCHAR2(1);
98:
99: CURSOR dup_dup_parties(cp_dup_batch_id NUMBER) IS
100: select dup_party_id
101: from hz_dup_set_parties
102: where dup_set_id in (select dup_set_id from hz_dup_sets where dup_batch_id=cp_dup_batch_id)
103: group by dup_party_id
104: having count(*)>1;
105:

Line 108: FROM hz_dup_set_parties dsp, hz_dup_sets ds

104: having count(*)>1;
105:
106: CURSOR dup_party_sets(cp_dup_batch_id NUMBER, cp_dup_party_id NUMBER) IS
107: select ds.dup_set_id
108: FROM hz_dup_set_parties dsp, hz_dup_sets ds
109: where dsp.dup_set_id=ds.dup_set_id
110: and ds.dup_batch_id=cp_dup_batch_id
111: and dsp.dup_party_id=cp_dup_party_id
112: order by ds.dup_set_id;

Line 331: DELETE from hz_dup_set_parties

327: EXIT when dup_party_sets%NOTFOUND;
328: log('Dup set id ' || l_dup_dup_set || ' has party '||l_dup_dup_id);
329: IF NOT FIRST THEN
330: log('Party ' || l_dup_dup_id || ' already found as a dup in another set. Deleting.');
331: DELETE from hz_dup_set_parties
332: WHERE dup_set_id=l_dup_dup_set
333: AND dup_party_id=l_dup_dup_id;
334: log('More than one occurence of party id ' ||l_dup_dup_id || ' in dup set '||l_dup_dup_set);
335:

Line 337: FROM hz_dup_set_parties

333: AND dup_party_id=l_dup_dup_id;
334: log('More than one occurence of party id ' ||l_dup_dup_id || ' in dup set '||l_dup_dup_set);
335:
336: SELECT count(1) INTO l_num_left
337: FROM hz_dup_set_parties
338: WHERE dup_set_id=l_dup_dup_set;
339: log('Total number of parties in dup set ' ||l_dup_dup_set || ' is '||l_num_left);
340: IF l_num_left=1 THEN
341: SELECT DUP_PARTY_ID INTO l_winner_id FROM HZ_DUP_SET_PARTIES

Line 341: SELECT DUP_PARTY_ID INTO l_winner_id FROM HZ_DUP_SET_PARTIES

337: FROM hz_dup_set_parties
338: WHERE dup_set_id=l_dup_dup_set;
339: log('Total number of parties in dup set ' ||l_dup_dup_set || ' is '||l_num_left);
340: IF l_num_left=1 THEN
341: SELECT DUP_PARTY_ID INTO l_winner_id FROM HZ_DUP_SET_PARTIES
342: WHERE dup_set_id = l_dup_dup_set;
343: log('Winner party '||l_winner_id||' is the only party in dup set '||l_dup_dup_set||' and this party will be deleted frm the current batch ');
344:
345: log('Delete dup sets with one party from hz_dup_set_parties, dup set id'||l_dup_dup_set);

Line 345: log('Delete dup sets with one party from hz_dup_set_parties, dup set id'||l_dup_dup_set);

341: SELECT DUP_PARTY_ID INTO l_winner_id FROM HZ_DUP_SET_PARTIES
342: WHERE dup_set_id = l_dup_dup_set;
343: log('Winner party '||l_winner_id||' is the only party in dup set '||l_dup_dup_set||' and this party will be deleted frm the current batch ');
344:
345: log('Delete dup sets with one party from hz_dup_set_parties, dup set id'||l_dup_dup_set);
346: DELETE from hz_dup_set_parties
347: WHERE dup_set_id=l_dup_dup_set;
348:
349: log('Delete dup sets with no parties from hz_dup_sets, dup set id'||l_dup_dup_set);

Line 346: DELETE from hz_dup_set_parties

342: WHERE dup_set_id = l_dup_dup_set;
343: log('Winner party '||l_winner_id||' is the only party in dup set '||l_dup_dup_set||' and this party will be deleted frm the current batch ');
344:
345: log('Delete dup sets with one party from hz_dup_set_parties, dup set id'||l_dup_dup_set);
346: DELETE from hz_dup_set_parties
347: WHERE dup_set_id=l_dup_dup_set;
348:
349: log('Delete dup sets with no parties from hz_dup_sets, dup set id'||l_dup_dup_set);
350: DELETE from hz_dup_sets

Line 363: AND NOT EXISTS (SELECT 1 FROM hz_dup_set_parties

359: END LOOP;
360: CLOSE dup_dup_parties;
361:
362: DELETE FROM hz_dup_sets d1 WHERE dup_batch_id = l_batch_id
363: AND NOT EXISTS (SELECT 1 FROM hz_dup_set_parties
364: WHERE dup_set_id = d1.dup_set_id);
365: log('Delete dup sets with no parties from hz_dup_sets'||SQL%ROWCOUNT);
366:
367: log('');

Line 634: from hz_dup_set_parties

630: ) IS
631:
632: /* CURSOR dup_dup_parties(cp_dup_batch_id NUMBER) IS
633: select dup_party_id
634: from hz_dup_set_parties
635: where dup_set_batch_id = cp_dup_batch_id --Bug No: 4244529
636: group by dup_party_id
637: having count(*)>1;
638:

Line 641: FROM hz_dup_set_parties dsp

637: having count(*)>1;
638:
639: CURSOR dup_party_sets(cp_dup_batch_id NUMBER, cp_dup_party_id NUMBER) IS
640: select dsp.dup_set_id
641: FROM hz_dup_set_parties dsp
642: where dsp.dup_set_batch_id = cp_dup_batch_id --Bug No: 4244529
643: and dsp.dup_party_id=cp_dup_party_id;*/
644:
645:

Line 871: --DELETE FROM hz_dup_set_parties WHERE dup_set_id IN (

867:
868: log(' All Parties processed successfully. Commencing Sanitization');
869:
870: /* Fix non-mutually exclusive sets if any */
871: --DELETE FROM hz_dup_set_parties WHERE dup_set_id IN (
872: --SELECT dup_set_id FROM hz_dup_sets d1
873: --WHERE dup_batch_id = l_batch_id
874: --AND EXISTS ( --Bug No: 4244529
875: --SELECT 1

Line 876: --FROM hz_dup_set_parties dp

872: --SELECT dup_set_id FROM hz_dup_sets d1
873: --WHERE dup_batch_id = l_batch_id
874: --AND EXISTS ( --Bug No: 4244529
875: --SELECT 1
876: --FROM hz_dup_set_parties dp
877: --WHERE dp.DUP_SET_BATCH_ID = d1.dup_batch_id
878: --AND dp.DUP_PARTY_ID = d1.winner_party_id
879: --AND dp.DUP_SET_ID <> d1.dup_set_id));
880:

Line 882: --AND NOT EXISTS (SELECT 1 FROM hz_dup_set_parties

878: --AND dp.DUP_PARTY_ID = d1.winner_party_id
879: --AND dp.DUP_SET_ID <> d1.dup_set_id));
880:
881: --DELETE FROM hz_dup_sets d1 WHERE dup_batch_id = l_batch_id
882: --AND NOT EXISTS (SELECT 1 FROM hz_dup_set_parties
883: --WHERE dup_set_id = d1.dup_set_id);
884:
885: log('');
886: log('Total Number of parties in subset '||l_num_subset);

Line 945: FROM hz_dup_set_parties dp

941: ) RETURN BOOLEAN IS
942:
943: CURSOR c_dupset_party IS
944: SELECT dup_party_id
945: FROM hz_dup_set_parties dp
946: WHERE dp.DUP_SET_BATCH_ID = p_batch_id --Bug No: 4244529
947: AND dp.DUP_PARTY_ID = p_party_id
948: AND dp.DUP_SET_ID <> p_dup_set_id;
949:

Line 981: DELETE FROM HZ_DUP_SET_PARTIES p

977: ) IS
978: winner_count NUMBER;
979: dupset_count NUMBER;
980: BEGIN
981: DELETE FROM HZ_DUP_SET_PARTIES p
982: WHERE p.dup_set_id = p_dup_set_id
983: AND p.dup_party_id <> p_cur_party_id
984: AND EXISTS (
985: SELECT 1 FROM HZ_DUP_EXCLUSIONS d

Line 994: SELECT COUNT(*) INTO dupset_count FROM HZ_DUP_SET_PARTIES

990: ) AND (d.FROM_DATE IS NULL OR d.FROM_DATE <= SYSDATE)
991: AND (d.TO_DATE IS NULL OR d.TO_DATE >= SYSDATE)
992: );
993:
994: SELECT COUNT(*) INTO dupset_count FROM HZ_DUP_SET_PARTIES
995: WHERE DUP_SET_ID = p_dup_set_id;
996:
997: IF (dupset_count=1) THEN
998: SELECT COUNT(*) INTO winner_count FROM HZ_DUP_SET_PARTIES

Line 998: SELECT COUNT(*) INTO winner_count FROM HZ_DUP_SET_PARTIES

994: SELECT COUNT(*) INTO dupset_count FROM HZ_DUP_SET_PARTIES
995: WHERE DUP_SET_ID = p_dup_set_id;
996:
997: IF (dupset_count=1) THEN
998: SELECT COUNT(*) INTO winner_count FROM HZ_DUP_SET_PARTIES
999: WHERE DUP_SET_ID = p_dup_set_id
1000: and dup_party_id in
1001: (select winner_party_id from hz_dup_sets where dup_set_id=p_dup_set_id);
1002:

Line 1004: DELETE FROM HZ_DUP_SET_PARTIES WHERE DUP_SET_ID=p_dup_set_id;

1000: and dup_party_id in
1001: (select winner_party_id from hz_dup_sets where dup_set_id=p_dup_set_id);
1002:
1003: if(winner_count=1) then
1004: DELETE FROM HZ_DUP_SET_PARTIES WHERE DUP_SET_ID=p_dup_set_id;
1005: DELETE FROM HZ_DUP_SETS WHERE DUP_SET_ID=p_dup_set_id;
1006: end if;
1007:
1008: END IF;

Line 1137: FROM HZ_DUP_SET_PARTIES

1133: RAISE FND_API.G_EXC_ERROR;
1134: ELSE
1135:
1136: FOR DUP IN (SELECT DUP_PARTY_ID
1137: FROM HZ_DUP_SET_PARTIES
1138: WHERE DUP_SET_ID = p_dup_set_id and dup_party_id <> l_winner_party_id) LOOP
1139: HZ_PARTY_SEARCH.get_score_details (
1140: FND_API.G_FALSE,p_rule_id, DUP.DUP_PARTY_ID,
1141: l_party_rec, l_party_site_list,l_contact_list, l_cpt_list,