APPS.HZ_BATCH_DUPLICATE dependencies on HZ_DUP_WORKER_CHUNK_GT

Line 756: 'insert /*+ APPEND */ into hz_dup_worker_chunk_gt

752: --will not be considered for duplicate idenfication.
753: -- bug 5393863
754: IF p_subset_defn IS NULL THEN
755: execute immediate
756: 'insert /*+ APPEND */ into hz_dup_worker_chunk_gt
757: SELECT /*+ INDEX(parties HZ_PARTIES_U1) */ parties.PARTY_ID FROM HZ_PARTIES parties WHERE parties.PARTY_TYPE <> ''PARTY_RELATIONSHIP''
758: AND NVL(parties.STATUS,''A'') = ''A'' AND mod(parties.PARTY_ID, :num_workers) = :worker_number '
759: USING l_num_workers, l_worker_number;
760: log('Number of parties inserted into HZ_DUP_WORKER_CHUNK_GT by worker '||l_worker_number||' is '||SQL%ROWCOUNT );

Line 760: log('Number of parties inserted into HZ_DUP_WORKER_CHUNK_GT by worker '||l_worker_number||' is '||SQL%ROWCOUNT );

756: 'insert /*+ APPEND */ into hz_dup_worker_chunk_gt
757: SELECT /*+ INDEX(parties HZ_PARTIES_U1) */ parties.PARTY_ID FROM HZ_PARTIES parties WHERE parties.PARTY_TYPE <> ''PARTY_RELATIONSHIP''
758: AND NVL(parties.STATUS,''A'') = ''A'' AND mod(parties.PARTY_ID, :num_workers) = :worker_number '
759: USING l_num_workers, l_worker_number;
760: log('Number of parties inserted into HZ_DUP_WORKER_CHUNK_GT by worker '||l_worker_number||' is '||SQL%ROWCOUNT );
761: ELSE
762: execute immediate
763: 'insert /*+ APPEND */ into hz_dup_worker_chunk_gt
764: SELECT /*+ INDEX(parties HZ_PARTIES_U1) */ PARTY_ID FROM HZ_PARTIES parties WHERE parties.PARTY_TYPE <> ''PARTY_RELATIONSHIP'' AND NVL(parties.STATUS,''A'') = ''A''

Line 763: 'insert /*+ APPEND */ into hz_dup_worker_chunk_gt

759: USING l_num_workers, l_worker_number;
760: log('Number of parties inserted into HZ_DUP_WORKER_CHUNK_GT by worker '||l_worker_number||' is '||SQL%ROWCOUNT );
761: ELSE
762: execute immediate
763: 'insert /*+ APPEND */ into hz_dup_worker_chunk_gt
764: SELECT /*+ INDEX(parties HZ_PARTIES_U1) */ PARTY_ID FROM HZ_PARTIES parties WHERE parties.PARTY_TYPE <> ''PARTY_RELATIONSHIP'' AND NVL(parties.STATUS,''A'') = ''A''
765: AND mod(parties.PARTY_ID, :num_workers) = :worker_number AND '||
766: p_subset_defn
767: USING l_num_workers, l_worker_number;

Line 768: log('Number of parties inserted into HZ_DUP_WORKER_CHUNK_GT by worker '||l_worker_number||' is '||SQL%ROWCOUNT );

764: SELECT /*+ INDEX(parties HZ_PARTIES_U1) */ PARTY_ID FROM HZ_PARTIES parties WHERE parties.PARTY_TYPE <> ''PARTY_RELATIONSHIP'' AND NVL(parties.STATUS,''A'') = ''A''
765: AND mod(parties.PARTY_ID, :num_workers) = :worker_number AND '||
766: p_subset_defn
767: USING l_num_workers, l_worker_number;
768: log('Number of parties inserted into HZ_DUP_WORKER_CHUNK_GT by worker '||l_worker_number||' is '||SQL%ROWCOUNT );
769: END IF;
770: log('End Time after insert to chunk ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
771: COMMIT;
772: log(' Commit to Chunk complete ');

Line 778: FROM HZ_DUP_WORKER_CHUNK_GT ORDER BY PARTY_ID)

774: -- bug 5393863
775:
776: FOR EVALPARTY IN (
777: SELECT PARTY_ID
778: FROM HZ_DUP_WORKER_CHUNK_GT ORDER BY PARTY_ID)
779: LOOP
780: l_cur_party_id := EVALPARTY.PARTY_ID;
781: party_count := party_count + 1 ;
782: