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_IMP_MATCH_RULE_51 dependencies on HZ_DQM_DUP_ID_PKG

Line 524: x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;

520: -------------------- TCA JOIN BEGINS --------------------------
521: ---------------------------------------------------------------
522: PROCEDURE tca_join_entities(trap_explosion in varchar2, rows_in_chunk in number, inserted_duplicates out number)
523: IS
524: x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;
525: x_insert_threshold number := 60;
526: l_party_limit NUMBER := 50000;
527: l_detail_limit NUMBER := 100000;
528: BEGIN

Line 649: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);

645: (
646: ((s1.TX11 is null and s2.TX11 is null) or s2.TX11 = s1.TX11)
647: )
648: ) group by f,t ;
649: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);
650: close x_ent_cur;
651: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
652: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
653: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of PARTY_SITES');

Line 681: x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;

677: ---------------------------------------------------------------
678: PROCEDURE interface_tca_join_entities( p_batch_id in number, from_osr in varchar2, to_osr in varchar2,
679: p_threshold in number, p_auto_merge_threshold in number)
680: IS
681: x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;
682: x_insert_threshold number := 60;
683: BEGIN
684: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
685: FND_FILE.put_line(FND_FILE.log,'WU: '||from_osr||' to '||to_osr);

Line 810: HZ_DQM_DUP_ID_PKG.update_hz_imp_dup_parties(p_batch_id, x_ent_cur);

806: (
807: ((s1.TX11 is null and s2.TX11 is null) or s2.TX11 = s1.TX11 || ' ' )
808: )
809: ) group by f,t ;
810: HZ_DQM_DUP_ID_PKG.update_hz_imp_dup_parties(p_batch_id, x_ent_cur);
811: close x_ent_cur;
812: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
813: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
814: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of PARTY_SITES');

Line 854: HZ_DQM_DUP_ID_PKG.update_party_dqm_action_flag(p_batch_id, x_ent_cur);

850: select a.party_osr, a.party_os, a.auto_merge_flag
851: from hz_imp_dup_parties a
852: where a.batch_id = p_batch_id
853: and a.party_osr between from_osr and to_osr ;
854: HZ_DQM_DUP_ID_PKG.update_party_dqm_action_flag(p_batch_id, x_ent_cur);
855: ----------------------PARTY LEVEL DUPLICATE IDENTIFICATION ENDS --------------------
856:
857:
858: -------------CONTACT_POINTS LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------

Line 902: HZ_DQM_DUP_ID_PKG.update_detail_dqm_action_flag('CONTACT_POINTS',p_batch_id, x_ent_cur);

898: select distinct a.record_osr, a.record_os
899: from hz_imp_dup_details a
900: where a.batch_id = p_batch_id
901: and a.party_osr between from_osr and to_osr and a.entity ='CONTACT_POINTS';
902: HZ_DQM_DUP_ID_PKG.update_detail_dqm_action_flag('CONTACT_POINTS',p_batch_id, x_ent_cur);
903: -------------CONTACT_POINTS LEVEL DUPLICATE IDENTIFICATION ENDS ------------------------
904: FND_FILE.put_line(FND_FILE.log,'Ending insert of CONTACT_POINTS');
905: FND_FILE.put_line(FND_FILE.log,'Number of records inserted '||SQL%ROWCOUNT);
906: FND_FILE.put_line(FND_FILE.log,'End time to insert '||to_char(sysdate,'hh24:mi:ss'));

Line 961: HZ_DQM_DUP_ID_PKG.update_detail_dqm_action_flag('PARTY_SITES',p_batch_id, x_ent_cur);

957: select distinct a.record_osr, a.record_os
958: from hz_imp_dup_details a
959: where a.batch_id = p_batch_id
960: and a.party_osr between from_osr and to_osr and a.entity ='PARTY_SITES';
961: HZ_DQM_DUP_ID_PKG.update_detail_dqm_action_flag('PARTY_SITES',p_batch_id, x_ent_cur);
962: -------------PARTY_SITES LEVEL DUPLICATE IDENTIFICATION ENDS ------------------------
963: FND_FILE.put_line(FND_FILE.log,'Ending insert of PARTY_SITES');
964: FND_FILE.put_line(FND_FILE.log,'Number of records inserted '||SQL%ROWCOUNT);
965: FND_FILE.put_line(FND_FILE.log,'End time to insert '||to_char(sysdate,'hh24:mi:ss'));

Line 988: x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;

984: ---------------------------------------------------------------
985: PROCEDURE interface_join_entities(p_batch_id in number,
986: from_osr in varchar2, to_osr in varchar2, p_threshold in number)
987: IS
988: x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;
989: x_insert_threshold number := 60;
990: BEGIN
991: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
992: FND_FILE.put_line(FND_FILE.log,'WU: '||from_osr||' to '||to_osr);

Line 1116: HZ_DQM_DUP_ID_PKG.update_hz_int_dup_results(p_batch_id,x_ent_cur);

1112: (
1113: ((s1.TX11 is null and s2.TX11 is null) or s2.TX11 = s1.TX11)
1114: )
1115: ) group by f,t ;
1116: HZ_DQM_DUP_ID_PKG.update_hz_int_dup_results(p_batch_id,x_ent_cur);
1117: close x_ent_cur;
1118: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
1119: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
1120: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of PARTY_SITES');