[Home] [Help]
24: | 12-JUL-2006 : Raj Bug 5393826: Made changed to procedure report_int_dup_party_osrs.
25: | Deleting the records from hz_imp_int_dedup_results for which
26: | no records exists in import party interface table.
27: | 18-JUL-2006 : Raj Bug 5393863: Made changes to tca_dup_id_worker procedure.
28: | Instead of opening a cursor on hz_parties,inserted all the parties in to
29: | HZ_MATCHED_PARTIES_GT table and then opened a cursor on HZ_MATCHED_PARTIES_GT table.
30: *=======================================================================*/
31: --check
32: -- Definitions:
182: IF p_within_subset = 'Y' and p_subset_sql is not null
183: THEN
184: EXECUTE IMMEDIATE 'delete from hz_dup_results a where ' ||
185: 'not exists ' ||
186: '(Select 1 from hz_dup_results b, hz_parties parties ' ||
187: 'where b.ord_tid = parties.party_id ' ||
188: 'and ' ||
189: p_subset_sql || ')' ;
190: END IF;
794: TYPE Nlist is table of number;
795: pidlist NList;
796:
797: begin
798: open pt_cur for 'select party_id from hz_parties where rownum<3';
799: fetch pt_cur bulk collect into pidlist;
800: close pt_cur;
801: return true;
802: exception
859: FND_FILE.put_line(FND_FILE.log,'Start Time before insert to hz_dqm_stage_gt ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
860: IF p_subset_sql IS NULL
861: THEN
862: /* OPEN pt_cur FOR
863: 'SELECT parties.PARTY_ID FROM HZ_PARTIES parties WHERE parties.PARTY_TYPE <> ''PARTY_RELATIONSHIP'' AND NVL (parties.STATUS,''A'') = ''A'' AND mod(parties.PARTY_ID, :num_workers) = :worker_number' */
864: execute immediate
865: 'insert /*+ APPEND */ into HZ_MATCHED_PARTIES_GT(party_id)
866: SELECT /*+ INDEX(parties HZ_PARTIES_U1) */ parties.PARTY_ID FROM HZ_PARTIES parties WHERE parties.PARTY_TYPE <> ''PARTY_RELATIONSHIP''
867: AND NVL(parties.STATUS,''A'') = ''A'' AND mod(parties.PARTY_ID, :num_workers) = :worker_number '
862: /* OPEN pt_cur FOR
863: 'SELECT parties.PARTY_ID FROM HZ_PARTIES parties WHERE parties.PARTY_TYPE <> ''PARTY_RELATIONSHIP'' AND NVL (parties.STATUS,''A'') = ''A'' AND mod(parties.PARTY_ID, :num_workers) = :worker_number' */
864: execute immediate
865: 'insert /*+ APPEND */ into HZ_MATCHED_PARTIES_GT(party_id)
866: SELECT /*+ INDEX(parties HZ_PARTIES_U1) */ parties.PARTY_ID FROM HZ_PARTIES parties WHERE parties.PARTY_TYPE <> ''PARTY_RELATIONSHIP''
867: AND NVL(parties.STATUS,''A'') = ''A'' AND mod(parties.PARTY_ID, :num_workers) = :worker_number '
868: USING p_number_of_workers, p_worker_number;
869: FND_FILE.put_line(FND_FILE.log,'Number of parties inserted into HZ_MATCHED_PARTIES_GT by worker '||p_worker_number||' is '||SQL%ROWCOUNT ); -- BUG 5351721
870: ELSE
868: USING p_number_of_workers, p_worker_number;
869: FND_FILE.put_line(FND_FILE.log,'Number of parties inserted into HZ_MATCHED_PARTIES_GT by worker '||p_worker_number||' is '||SQL%ROWCOUNT ); -- BUG 5351721
870: ELSE
871: /* OPEN pt_cur FOR
872: 'SELECT PARTY_ID FROM HZ_PARTIES parties WHERE parties.PARTY_TYPE <> ''PARTY_RELATIONSHIP'' AND NVL (parties.STATUS,''A'') = ''A'' AND mod(parties.PARTY_ID, :num_workers) = :worker_number AND '||
873: p_subset_sql */
874: execute immediate
875: 'insert /*+ APPEND */ into HZ_MATCHED_PARTIES_GT(party_id)
876: SELECT /*+ INDEX(parties HZ_PARTIES_U1) */ PARTY_ID FROM HZ_PARTIES parties WHERE parties.PARTY_TYPE <> ''PARTY_RELATIONSHIP'' AND NVL(parties.STATUS,''A'') = ''A''
872: 'SELECT PARTY_ID FROM HZ_PARTIES parties WHERE parties.PARTY_TYPE <> ''PARTY_RELATIONSHIP'' AND NVL (parties.STATUS,''A'') = ''A'' AND mod(parties.PARTY_ID, :num_workers) = :worker_number AND '||
873: p_subset_sql */
874: execute immediate
875: 'insert /*+ APPEND */ into HZ_MATCHED_PARTIES_GT(party_id)
876: SELECT /*+ INDEX(parties HZ_PARTIES_U1) */ PARTY_ID FROM HZ_PARTIES parties WHERE parties.PARTY_TYPE <> ''PARTY_RELATIONSHIP'' AND NVL(parties.STATUS,''A'') = ''A''
877: AND mod(parties.PARTY_ID, :num_workers) = :worker_number AND '||
878: p_subset_sql USING p_number_of_workers, p_worker_number;
879: FND_FILE.put_line(FND_FILE.log,'Number of parties inserted into HZ_MATCHED_PARTIES_GT by worker '||p_worker_number||' is '||SQL%ROWCOUNT ); -- BUG 5351721
880: END IF;
1250: (select distinct h.dup_party_id as win_party_id
1251: from hz_imp_dup_parties h
1252: where h.batch_id = p_batch_id
1253: and exists (select a.party_id
1254: from hz_imp_dup_parties a, hz_parties b
1255: where a.batch_id = p_batch_id
1256: and a.dup_party_id = h.dup_party_id
1257: and a.auto_merge_flag <> 'R'
1258: and a.party_id = b.party_id
1290: select b.party_id, a.dup_set_id, 0, p_batch_id, b.score , b.auto_merge_flag,
1291: hz_utility_pub.created_by,hz_utility_pub.creation_date,
1292: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
1293: hz_utility_pub.user_id,a.dup_batch_id --Bug No: 4244529
1294: from hz_dup_sets a, hz_imp_dup_parties b, hz_parties c
1295: where a.dup_batch_id = l_dup_batch_id
1296: and a.winner_party_id = b.dup_party_id
1297: and b.party_id = c.party_id
1298: and c.request_id = p_request_id