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_DQM_DUP_ID_PKG dependencies on HZ_IMP_INT_DEDUP_RESULTS

Line 25: | Deleting the records from hz_imp_int_dedup_results for which

21: | 18-OCT-2005 Ravi Epuri : Bug No: 4669400. Modified the 2 instances of OPEN pt_cur CURSOR, in tca_dup_id_worker
22: | Procedure, to make sure it does not consider Merged and Inactive Parties for duplicate
23: | identification, by adding the filter condition 'Status = A', in the where clause.
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.

Line 437: from hz_imp_int_dedup_results

433: update hz_imp_batch_summary h
434: set dup_parties_in_batch =
435: (select count(1) from
436: (select distinct winner_record_osr
437: from hz_imp_int_dedup_results
438: where batch_id = p_batch_id
439: and entity = 'PARTY'
440: union
441: select distinct dup_record_osr

Line 442: from hz_imp_int_dedup_results

438: where batch_id = p_batch_id
439: and entity = 'PARTY'
440: union
441: select distinct dup_record_osr
442: from hz_imp_int_dedup_results
443: where batch_id = p_batch_id
444: and entity = 'PARTY'
445: )
446: )

Line 455: from hz_imp_int_dedup_results

451: update hz_imp_batch_summary h
452: set party_dup_sets_in_batch =
453: (select count(1) from
454: (select distinct winner_record_osr
455: from hz_imp_int_dedup_results
456: where batch_id = p_batch_id
457: and entity = 'PARTY'
458: )
459: )

Line 468: from hz_imp_int_dedup_results

464: update hz_imp_batch_summary h
465: set dup_addresses_in_batch =
466: (select count(1) from
467: (select distinct winner_record_osr
468: from hz_imp_int_dedup_results
469: where batch_id = p_batch_id
470: and entity = 'PARTY_SITES'
471: union
472: select distinct dup_record_osr

Line 473: from hz_imp_int_dedup_results

469: where batch_id = p_batch_id
470: and entity = 'PARTY_SITES'
471: union
472: select distinct dup_record_osr
473: from hz_imp_int_dedup_results
474: where batch_id = p_batch_id
475: and entity = 'PARTY_SITES'
476: )
477: )

Line 486: from hz_imp_int_dedup_results

482: update hz_imp_batch_summary h
483: set address_dup_sets_in_batch =
484: (select count(1) from
485: (select distinct winner_record_osr
486: from hz_imp_int_dedup_results
487: where batch_id = p_batch_id
488: and entity = 'PARTY_SITES'
489: )
490: )

Line 499: from hz_imp_int_dedup_results

495: update hz_imp_batch_summary h
496: set dup_contacts_in_batch =
497: (select count(1) from
498: (select distinct winner_record_osr
499: from hz_imp_int_dedup_results
500: where batch_id = p_batch_id
501: and entity = 'CONTACTS'
502: union
503: select distinct dup_record_osr

Line 504: from hz_imp_int_dedup_results

500: where batch_id = p_batch_id
501: and entity = 'CONTACTS'
502: union
503: select distinct dup_record_osr
504: from hz_imp_int_dedup_results
505: where batch_id = p_batch_id
506: and entity = 'CONTACTS'
507: )
508: )

Line 517: from hz_imp_int_dedup_results

513: update hz_imp_batch_summary h
514: set contact_dup_sets_in_batch =
515: (select count(1) from
516: (select distinct winner_record_osr
517: from hz_imp_int_dedup_results
518: where batch_id = p_batch_id
519: and entity = 'CONTACTS'
520: )
521: )

Line 531: from hz_imp_int_dedup_results

527: update hz_imp_batch_summary h
528: set dup_contactpoints_in_batch =
529: (select count(1) from
530: (select distinct winner_record_osr
531: from hz_imp_int_dedup_results
532: where batch_id = p_batch_id
533: and entity = 'CONTACT_POINTS'
534: union
535: select distinct dup_record_osr

Line 536: from hz_imp_int_dedup_results

532: where batch_id = p_batch_id
533: and entity = 'CONTACT_POINTS'
534: union
535: select distinct dup_record_osr
536: from hz_imp_int_dedup_results
537: where batch_id = p_batch_id
538: and entity = 'CONTACT_POINTS'
539: )
540: )

Line 549: from hz_imp_int_dedup_results

545: update hz_imp_batch_summary h
546: set contactpoint_dup_sets_in_batch =
547: (select count(1) from
548: (select distinct winner_record_osr
549: from hz_imp_int_dedup_results
550: where batch_id = p_batch_id
551: and entity = 'CONTACT_POINTS'
552: )
553: )

Line 571: from hz_imp_int_dedup_results

567: IS
568: p_count number;
569: BEGIN
570: select count(1) into p_count
571: from hz_imp_int_dedup_results
572: where batch_id = p_batch_id
573: and entity <> 'PARTY' ;
574:
575: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------------------');

Line 576: FND_FILE.put_line(FND_FILE.log,'Details ::: Number of details in HZ_IMP_INT_DEDUP_RESULTS before sanitization '|| p_count );

572: where batch_id = p_batch_id
573: and entity <> 'PARTY' ;
574:
575: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------------------');
576: FND_FILE.put_line(FND_FILE.log,'Details ::: Number of details in HZ_IMP_INT_DEDUP_RESULTS before sanitization '|| p_count );
577: FND_FILE.put_line(FND_FILE.log,'Details ::: Begin time of delete '||to_char(sysdate,'hh24:mi:ss'));
578:
579:
580: delete from hz_imp_int_dedup_results a

Line 580: delete from hz_imp_int_dedup_results a

576: FND_FILE.put_line(FND_FILE.log,'Details ::: Number of details in HZ_IMP_INT_DEDUP_RESULTS before sanitization '|| p_count );
577: FND_FILE.put_line(FND_FILE.log,'Details ::: Begin time of delete '||to_char(sysdate,'hh24:mi:ss'));
578:
579:
580: delete from hz_imp_int_dedup_results a
581: where
582: (exists
583: (Select 1 from hz_imp_int_dedup_results b
584: where

Line 583: (Select 1 from hz_imp_int_dedup_results b

579:
580: delete from hz_imp_int_dedup_results a
581: where
582: (exists
583: (Select 1 from hz_imp_int_dedup_results b
584: where
585: (
586: -- DELETE DIRECT TRANSITIVE DETAIL OSRS FOR THIS BATCH
587: -- WE BASICALLY MAKE SURE THAT A DETAIL RECORD OSR

Line 600: FND_FILE.put_line(FND_FILE.log,'Details ::: Number of details deleted in HZ_IMP_INT_DEDUP_RESULTS '||SQL%ROWCOUNT);

596: )
597: );
598:
599: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------------------');
600: FND_FILE.put_line(FND_FILE.log,'Details ::: Number of details deleted in HZ_IMP_INT_DEDUP_RESULTS '||SQL%ROWCOUNT);
601: FND_FILE.put_line(FND_FILE.log,'Details ::: End time of delete '||to_char(sysdate,'hh24:mi:ss'));
602:
603: -- bug 5393826
604: FND_FILE.put_line(FND_FILE.log,'Details ::: Start time of insert of Winner Detail OSRS '||to_char(sysdate,'hh24:mi:ss'));

Line 605: insert into hz_imp_int_dedup_results

601: FND_FILE.put_line(FND_FILE.log,'Details ::: End time of delete '||to_char(sysdate,'hh24:mi:ss'));
602:
603: -- bug 5393826
604: FND_FILE.put_line(FND_FILE.log,'Details ::: Start time of insert of Winner Detail OSRS '||to_char(sysdate,'hh24:mi:ss'));
605: insert into hz_imp_int_dedup_results
606: (batch_id,
607: winner_record_osr,
608: winner_record_os,
609: dup_record_osr,

Line 623: from hz_imp_int_dedup_results a

619: winner_record_os,
620: detail_party_osr,
621: entity,
622: 0
623: from hz_imp_int_dedup_results a
624: where a.entity <> 'PARTY'
625: and a.batch_id = p_batch_id ;
626:
627: FND_FILE.put_line(FND_FILE.log,'Details ::: End time of insert of Winner Detail OSRs '||to_char(sysdate,'hh24:mi:ss'));

Line 639: update hz_imp_int_dedup_results a

635:
636: FND_FILE.put_line(FND_FILE.log,'Details ::: End time of update for getting import table dates '||to_char(sysdate,'hh24:mi:ss'));
637:
638: -- We take of the "PARTY SITES" entity here.
639: update hz_imp_int_dedup_results a
640: set (a.dup_creation_date, a.dup_last_update_date)
641: = (select b.creation_date, b.last_update_date
642: from hz_imp_addresses_int b
643: where b.batch_id = p_batch_id

Line 650: update hz_imp_int_dedup_results a

646: )
647: where a.entity = 'PARTY_SITES' and a.batch_id = p_batch_id ;
648:
649: -- We take of the "CONTACTS" entity here.
650: update hz_imp_int_dedup_results a
651: set (a.dup_creation_date, a.dup_last_update_date)
652: = (select b.creation_date, b.last_update_date
653: from hz_imp_contacts_int b
654: where b.batch_id = p_batch_id

Line 661: update hz_imp_int_dedup_results a

657: )
658: where a.entity = 'CONTACTS' and a.batch_id = p_batch_id ;
659:
660: -- We take of the "CONTACT POINTS" entity here.
661: update hz_imp_int_dedup_results a
662: set (a.dup_creation_date, a.dup_last_update_date)
663: = (select b.creation_date, b.last_update_date
664: from hz_imp_contactpts_int b
665: where b.batch_id = p_batch_id

Line 671: FND_FILE.put_line(FND_FILE.log,'Details ::: Number of duplicate details updated in HZ_IMP_INT_DEDUP_RESULTS '||SQL%ROWCOUNT);

667: and b.cp_orig_system = a.dup_record_os
668: )
669: where a.entity = 'CONTACT_POINTS' and a.batch_id = p_batch_id ;
670:
671: FND_FILE.put_line(FND_FILE.log,'Details ::: Number of duplicate details updated in HZ_IMP_INT_DEDUP_RESULTS '||SQL%ROWCOUNT);
672: FND_FILE.put_line(FND_FILE.log,'Details ::: End time of update for getting import table dates '||to_char(sysdate,'hh24:mi:ss'));
673:
674: EXCEPTION
675: WHEN OTHERS THEN

Line 1824: -- into hz_imp_int_dedup_results

1820: -- INTO ACCOUNT.
1821: -----------------------------------------------------
1822:
1823: -- first insert winner party osrs, with dup osrs being themselves
1824: -- into hz_imp_int_dedup_results
1825:
1826: /*
1827: insert into hz_imp_int_dedup_results ( batch_id, winner_record_osr, winner_record_os,
1828: dup_record_osr, dup_record_os, entity,

Line 1827: insert into hz_imp_int_dedup_results ( batch_id, winner_record_osr, winner_record_os,

1823: -- first insert winner party osrs, with dup osrs being themselves
1824: -- into hz_imp_int_dedup_results
1825:
1826: /*
1827: insert into hz_imp_int_dedup_results ( batch_id, winner_record_osr, winner_record_os,
1828: dup_record_osr, dup_record_os, entity,
1829: score, dup_creation_date, dup_last_update_date
1830: ,created_by,creation_date,last_update_login
1831: ,last_update_date,last_updated_by)

Line 1853: FND_FILE.put_line(FND_FILE.log,'Parties ::: Reporting winners to HZ_IMP_INT_DEDUP_RESULTS ');

1849: where mod(levelu, 2) = 1 ;
1850: */
1851:
1852: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------------------');
1853: FND_FILE.put_line(FND_FILE.log,'Parties ::: Reporting winners to HZ_IMP_INT_DEDUP_RESULTS ');
1854: FND_FILE.put_line(FND_FILE.log,'Parties ::: Begin time of insert '||to_char(sysdate,'hh24:mi:ss'));
1855:
1856:
1857:

Line 1860: insert into hz_imp_int_dedup_results ( batch_id, winner_record_osr, winner_record_os,

1856:
1857:
1858: -- we use the temporary table hz_int_dup_results_gt, instead of
1859: -- hz_int_dup_results
1860: insert into hz_imp_int_dedup_results ( batch_id, winner_record_osr, winner_record_os,
1861: dup_record_osr, dup_record_os, entity,
1862: score, dup_creation_date, dup_last_update_date
1863: ,created_by,creation_date,last_update_login
1864: ,last_update_date,last_updated_by)

Line 1885: FND_FILE.put_line(FND_FILE.log,'Parties ::: Number of winner parties inserted to HZ_IMP_INT_DEDUP_RESULTS '||SQL%ROWCOUNT);

1881: connect by prior ord_t_osr = ord_f_osr and prior batch_id = batch_id
1882: )
1883: where mod(levelu, 2) = 1 ;
1884:
1885: FND_FILE.put_line(FND_FILE.log,'Parties ::: Number of winner parties inserted to HZ_IMP_INT_DEDUP_RESULTS '||SQL%ROWCOUNT);
1886: FND_FILE.put_line(FND_FILE.log,'Parties ::: End time of insert '||to_char(sysdate,'hh24:mi:ss'));
1887:
1888: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------------------');
1889: FND_FILE.put_line(FND_FILE.log,'Parties ::: Reporting duplicate parties to HZ_IMP_INT_DEDUP_RESULTS ');

Line 1889: FND_FILE.put_line(FND_FILE.log,'Parties ::: Reporting duplicate parties to HZ_IMP_INT_DEDUP_RESULTS ');

1885: FND_FILE.put_line(FND_FILE.log,'Parties ::: Number of winner parties inserted to HZ_IMP_INT_DEDUP_RESULTS '||SQL%ROWCOUNT);
1886: FND_FILE.put_line(FND_FILE.log,'Parties ::: End time of insert '||to_char(sysdate,'hh24:mi:ss'));
1887:
1888: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------------------');
1889: FND_FILE.put_line(FND_FILE.log,'Parties ::: Reporting duplicate parties to HZ_IMP_INT_DEDUP_RESULTS ');
1890: FND_FILE.put_line(FND_FILE.log,'Parties ::: Begin time of insert '||to_char(sysdate,'hh24:mi:ss'));
1891:
1892:
1893: -- Take inserted winner party osrs from hz_imp_int_dedup_results , join with

Line 1893: -- Take inserted winner party osrs from hz_imp_int_dedup_results , join with

1889: FND_FILE.put_line(FND_FILE.log,'Parties ::: Reporting duplicate parties to HZ_IMP_INT_DEDUP_RESULTS ');
1890: FND_FILE.put_line(FND_FILE.log,'Parties ::: Begin time of insert '||to_char(sysdate,'hh24:mi:ss'));
1891:
1892:
1893: -- Take inserted winner party osrs from hz_imp_int_dedup_results , join with
1894: -- hz_int_dup_results_gt and insert the winner, dup pair to hz_imp_int_dedup_results
1895: insert into hz_imp_int_dedup_results ( batch_id, winner_record_osr, winner_record_os,
1896: dup_record_osr, dup_record_os, entity,
1897: score, dup_creation_date, dup_last_update_date

Line 1894: -- hz_int_dup_results_gt and insert the winner, dup pair to hz_imp_int_dedup_results

1890: FND_FILE.put_line(FND_FILE.log,'Parties ::: Begin time of insert '||to_char(sysdate,'hh24:mi:ss'));
1891:
1892:
1893: -- Take inserted winner party osrs from hz_imp_int_dedup_results , join with
1894: -- hz_int_dup_results_gt and insert the winner, dup pair to hz_imp_int_dedup_results
1895: insert into hz_imp_int_dedup_results ( batch_id, winner_record_osr, winner_record_os,
1896: dup_record_osr, dup_record_os, entity,
1897: score, dup_creation_date, dup_last_update_date
1898: ,created_by,creation_date,last_update_login

Line 1895: insert into hz_imp_int_dedup_results ( batch_id, winner_record_osr, winner_record_os,

1891:
1892:
1893: -- Take inserted winner party osrs from hz_imp_int_dedup_results , join with
1894: -- hz_int_dup_results_gt and insert the winner, dup pair to hz_imp_int_dedup_results
1895: insert into hz_imp_int_dedup_results ( batch_id, winner_record_osr, winner_record_os,
1896: dup_record_osr, dup_record_os, entity,
1897: score, dup_creation_date, dup_last_update_date
1898: ,created_by,creation_date,last_update_login
1899: ,last_update_date,last_updated_by)

Line 1905: from hz_imp_int_dedup_results a, hz_int_dup_results_gt b

1901: 'PARTY', b.score, hz_utility_pub.creation_date, hz_utility_pub.last_update_date
1902: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date
1903: ,hz_utility_v2pub.last_update_login,hz_utility_v2pub.last_update_date
1904: ,hz_utility_v2pub.last_updated_by
1905: from hz_imp_int_dedup_results a, hz_int_dup_results_gt b
1906: where a.batch_id = p_batch_id and b.batch_id = p_batch_id and a.entity = 'PARTY'
1907: and b.ord_f_osr = a.winner_record_osr ;
1908:
1909: FND_FILE.put_line(FND_FILE.log,'Parties ::: Number of duplicate parties inserted to HZ_IMP_INT_DEDUP_RESULTS '||SQL%ROWCOUNT);

Line 1909: FND_FILE.put_line(FND_FILE.log,'Parties ::: Number of duplicate parties inserted to HZ_IMP_INT_DEDUP_RESULTS '||SQL%ROWCOUNT);

1905: from hz_imp_int_dedup_results a, hz_int_dup_results_gt b
1906: where a.batch_id = p_batch_id and b.batch_id = p_batch_id and a.entity = 'PARTY'
1907: and b.ord_f_osr = a.winner_record_osr ;
1908:
1909: FND_FILE.put_line(FND_FILE.log,'Parties ::: Number of duplicate parties inserted to HZ_IMP_INT_DEDUP_RESULTS '||SQL%ROWCOUNT);
1910: FND_FILE.put_line(FND_FILE.log,'Parties ::: End time of insert '||to_char(sysdate,'hh24:mi:ss'));
1911:
1912:
1913:

Line 1918: update hz_imp_int_dedup_results a

1914: FND_FILE.put_line(FND_FILE.log,'Parties ::: Begin time of update for getting import table dates '||to_char(sysdate,'hh24:mi:ss'));
1915:
1916: -- Bug Fix 3588873 :: Need to report the import interface table dates for all the duplicates
1917: -- We take of the "PARTY" entity here.
1918: update hz_imp_int_dedup_results a
1919: set (a.dup_creation_date, a.dup_last_update_date)
1920: = (select b.creation_date, b.last_update_date
1921: from hz_imp_parties_int b
1922: where b.batch_id = p_batch_id

Line 1928: FND_FILE.put_line(FND_FILE.log,'Parties ::: Number of duplicate parties updated in HZ_IMP_INT_DEDUP_RESULTS '||SQL%ROWCOUNT);

1924: and b.party_orig_system = a.dup_record_os
1925: )
1926: where a.entity = 'PARTY' and a.batch_id = p_batch_id ;
1927:
1928: FND_FILE.put_line(FND_FILE.log,'Parties ::: Number of duplicate parties updated in HZ_IMP_INT_DEDUP_RESULTS '||SQL%ROWCOUNT);
1929: FND_FILE.put_line(FND_FILE.log,'Parties ::: End time of update for getting import table dates '||to_char(sysdate,'hh24:mi:ss'));
1930:
1931: --bug 5393826
1932: FND_FILE.put_line(FND_FILE.log,'Parties ::: Deleting Party Duplicate sets for which no records exist in import party interface table '||to_char(sysdate,'hh24:mi:ss'));

Line 1934: delete from hz_imp_int_dedup_results a

1930:
1931: --bug 5393826
1932: FND_FILE.put_line(FND_FILE.log,'Parties ::: Deleting Party Duplicate sets for which no records exist in import party interface table '||to_char(sysdate,'hh24:mi:ss'));
1933:
1934: delete from hz_imp_int_dedup_results a
1935: where a.entity = 'PARTY'
1936: and a.batch_id = p_batch_id
1937: and not exists
1938: ( select 1

Line 1990: -- 2. report detail dup results directly to hz_imp_int_dedup_results

1986:
1987: -- call the corresponding function in this match rule package, to join based on entities
1988: -- dictated by the match rule and do the following
1989: -- 1. report party dup results to hz_int_dup_results
1990: -- 2. report detail dup results directly to hz_imp_int_dedup_results
1991:
1992: anon_str := 'begin ' || l_pkg_name || '.interface_join_entities(:p_batch_id,' ||
1993: ':p_from_osr,:p_to_osr,:x_threshold); end;' ;
1994: