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

Line 684: x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;

680: -------------------- TCA JOIN BEGINS --------------------------
681: ---------------------------------------------------------------
682: PROCEDURE tca_join_entities(trap_explosion in varchar2, rows_in_chunk in number, inserted_duplicates out number)
683: IS
684: x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;
685: x_insert_threshold number := 55;
686: l_party_limit NUMBER := 50000;
687: l_detail_limit NUMBER := 100000;
688: BEGIN

Line 823: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);

819: (s1.TX158 is not null and s2.TX158 like s1.TX158 || decode(sign(lengthb(s1.TX158)-3),1,'%',''))
820: )
821: )
822: ) group by f,t ;
823: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);
824: close x_ent_cur;
825: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
826: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
827: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACT_POINTS');

Line 857: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);

853: (s1.TX23 is not null and s2.TX23 like s1.TX23 || decode(sign(lengthb(s1.TX23)-3),1,'%',''))
854: )
855: )
856: ) group by f,t ;
857: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);
858: close x_ent_cur;
859: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
860: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
861: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACTS');

Line 889: x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;

885: ---------------------------------------------------------------
886: PROCEDURE interface_tca_join_entities( p_batch_id in number, from_osr in varchar2, to_osr in varchar2,
887: p_threshold in number, p_auto_merge_threshold in number)
888: IS
889: x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;
890: x_insert_threshold number := 55;
891: BEGIN
892: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
893: FND_FILE.put_line(FND_FILE.log,'WU: '||from_osr||' to '||to_osr);

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

1023: (s1.TX158 is not null and s2.TX158 like s1.TX158 || decode(sign(lengthb(s1.TX158)-3),1,'%',''))
1024: )
1025: )
1026: ) group by f,t ;
1027: HZ_DQM_DUP_ID_PKG.update_hz_imp_dup_parties(p_batch_id, x_ent_cur);
1028: close x_ent_cur;
1029: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
1030: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
1031: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACT_POINTS');

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

1057: (s1.TX23 is not null and s2.TX23 like s1.TX23 || decode(sign(lengthb(s1.TX23)-3),1,'%',''))
1058: )
1059: )
1060: ) group by f,t ;
1061: HZ_DQM_DUP_ID_PKG.update_hz_imp_dup_parties(p_batch_id, x_ent_cur);
1062: close x_ent_cur;
1063: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
1064: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
1065: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACTS');

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

1101: select a.party_osr, a.party_os, a.auto_merge_flag
1102: from hz_imp_dup_parties a
1103: where a.batch_id = p_batch_id
1104: and a.party_osr between from_osr and to_osr ;
1105: HZ_DQM_DUP_ID_PKG.update_party_dqm_action_flag(p_batch_id, x_ent_cur);
1106: ----------------------PARTY LEVEL DUPLICATE IDENTIFICATION ENDS --------------------
1107:
1108:
1109: -------------PARTY_SITES LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------

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

1156: select distinct a.record_osr, a.record_os
1157: from hz_imp_dup_details a
1158: where a.batch_id = p_batch_id
1159: and a.party_osr between from_osr and to_osr and a.entity ='PARTY_SITES';
1160: HZ_DQM_DUP_ID_PKG.update_detail_dqm_action_flag('PARTY_SITES',p_batch_id, x_ent_cur);
1161: -------------PARTY_SITES LEVEL DUPLICATE IDENTIFICATION ENDS ------------------------
1162: FND_FILE.put_line(FND_FILE.log,'Ending insert of PARTY_SITES');
1163: FND_FILE.put_line(FND_FILE.log,'Number of records inserted '||SQL%ROWCOUNT);
1164: FND_FILE.put_line(FND_FILE.log,'End time to insert '||to_char(sysdate,'hh24:mi:ss'));

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

1208: select distinct a.record_osr, a.record_os
1209: from hz_imp_dup_details a
1210: where a.batch_id = p_batch_id
1211: and a.party_osr between from_osr and to_osr and a.entity ='CONTACT_POINTS';
1212: HZ_DQM_DUP_ID_PKG.update_detail_dqm_action_flag('CONTACT_POINTS',p_batch_id, x_ent_cur);
1213: -------------CONTACT_POINTS LEVEL DUPLICATE IDENTIFICATION ENDS ------------------------
1214: FND_FILE.put_line(FND_FILE.log,'Ending insert of CONTACT_POINTS');
1215: FND_FILE.put_line(FND_FILE.log,'Number of records inserted '||SQL%ROWCOUNT);
1216: FND_FILE.put_line(FND_FILE.log,'End time to insert '||to_char(sysdate,'hh24:mi:ss'));

Line 1259: HZ_DQM_DUP_ID_PKG.update_detail_dqm_action_flag('CONTACTS',p_batch_id, x_ent_cur);

1255: select distinct a.record_osr, a.record_os
1256: from hz_imp_dup_details a
1257: where a.batch_id = p_batch_id
1258: and a.party_osr between from_osr and to_osr and a.entity ='CONTACTS';
1259: HZ_DQM_DUP_ID_PKG.update_detail_dqm_action_flag('CONTACTS',p_batch_id, x_ent_cur);
1260: -------------CONTACTS LEVEL DUPLICATE IDENTIFICATION ENDS ------------------------
1261: FND_FILE.put_line(FND_FILE.log,'Ending insert of CONTACTS');
1262: FND_FILE.put_line(FND_FILE.log,'Number of records inserted '||SQL%ROWCOUNT);
1263: FND_FILE.put_line(FND_FILE.log,'End time to insert '||to_char(sysdate,'hh24:mi:ss'));

Line 1286: x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;

1282: ---------------------------------------------------------------
1283: PROCEDURE interface_join_entities(p_batch_id in number,
1284: from_osr in varchar2, to_osr in varchar2, p_threshold in number)
1285: IS
1286: x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;
1287: x_insert_threshold number := 55;
1288: BEGIN
1289: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1290: FND_FILE.put_line(FND_FILE.log,'WU: '||from_osr||' to '||to_osr);

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

1419: (s1.TX158 is not null and s2.TX158 like s1.TX158 || decode(sign(lengthb(s1.TX158)-3),1,'%',''))
1420: )
1421: )
1422: ) group by f,t ;
1423: HZ_DQM_DUP_ID_PKG.update_hz_int_dup_results(p_batch_id,x_ent_cur);
1424: close x_ent_cur;
1425: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
1426: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
1427: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACT_POINTS');

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

1455: (s1.TX23 is not null and s2.TX23 like s1.TX23 || decode(sign(lengthb(s1.TX23)-3),1,'%',''))
1456: )
1457: )
1458: ) group by f,t ;
1459: HZ_DQM_DUP_ID_PKG.update_hz_int_dup_results(p_batch_id,x_ent_cur);
1460: close x_ent_cur;
1461: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
1462: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
1463: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACTS');