APPS.HZ_BATCH_DUPLICATE dependencies on HZ_DUP_WORKER_CHUNK_GT

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

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

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

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

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

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

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

Line 784: FROM HZ_DUP_WORKER_CHUNK_GT ORDER BY PARTY_ID)

780: -- bug 5393863
781:
782: FOR EVALPARTY IN (
783: SELECT PARTY_ID
784: FROM HZ_DUP_WORKER_CHUNK_GT ORDER BY PARTY_ID)
785: LOOP
786: l_cur_party_id := EVALPARTY.PARTY_ID;
787: party_count := party_count + 1 ;
788: