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

Line 685: x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;

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

Line 833: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);

829: (
830: ((s1.TX11 is null and s2.TX11 is null) or s2.TX11 = s1.TX11)
831: )
832: ) group by f,t ;
833: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);
834: close x_ent_cur;
835: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
836: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
837: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of PARTY_SITES');

Line 867: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);

863: (s1.TX23 is not null and s2.TX23 like s1.TX23 || decode(sign(lengthb(s1.TX23)-3),1,'%',''))
864: )
865: )
866: ) group by f,t ;
867: HZ_DQM_DUP_ID_PKG.update_hz_dup_results(x_ent_cur);
868: close x_ent_cur;
869: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
870: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
871: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACTS');

Line 899: x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;

895: ---------------------------------------------------------------
896: PROCEDURE interface_tca_join_entities( p_batch_id in number, from_osr in varchar2, to_osr in varchar2,
897: p_threshold in number, p_auto_merge_threshold in number)
898: IS
899: x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;
900: x_insert_threshold number := 20;
901: BEGIN
902: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
903: FND_FILE.put_line(FND_FILE.log,'WU: '||from_osr||' to '||to_osr);

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

1042: (
1043: ((s1.TX11 is null and s2.TX11 is null) or s2.TX11 = s1.TX11 || ' ' )
1044: )
1045: ) group by f,t ;
1046: HZ_DQM_DUP_ID_PKG.update_hz_imp_dup_parties(p_batch_id, x_ent_cur);
1047: close x_ent_cur;
1048: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
1049: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
1050: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of PARTY_SITES');

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

1076: (s1.TX23 is not null and s2.TX23 like s1.TX23 || decode(sign(lengthb(s1.TX23)-3),1,'%',''))
1077: )
1078: )
1079: ) group by f,t ;
1080: HZ_DQM_DUP_ID_PKG.update_hz_imp_dup_parties(p_batch_id, x_ent_cur);
1081: close x_ent_cur;
1082: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
1083: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
1084: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACTS');

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

1120: select a.party_osr, a.party_os, a.auto_merge_flag
1121: from hz_imp_dup_parties a
1122: where a.batch_id = p_batch_id
1123: and a.party_osr between from_osr and to_osr ;
1124: HZ_DQM_DUP_ID_PKG.update_party_dqm_action_flag(p_batch_id, x_ent_cur);
1125: ----------------------PARTY LEVEL DUPLICATE IDENTIFICATION ENDS --------------------
1126:
1127:
1128: -------------CONTACT_POINTS LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------

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

1177: select distinct a.record_osr, a.record_os
1178: from hz_imp_dup_details a
1179: where a.batch_id = p_batch_id
1180: and a.party_osr between from_osr and to_osr and a.entity ='CONTACT_POINTS';
1181: HZ_DQM_DUP_ID_PKG.update_detail_dqm_action_flag('CONTACT_POINTS',p_batch_id, x_ent_cur);
1182: -------------CONTACT_POINTS LEVEL DUPLICATE IDENTIFICATION ENDS ------------------------
1183: FND_FILE.put_line(FND_FILE.log,'Ending insert of CONTACT_POINTS');
1184: FND_FILE.put_line(FND_FILE.log,'Number of records inserted '||SQL%ROWCOUNT);
1185: FND_FILE.put_line(FND_FILE.log,'End time to insert '||to_char(sysdate,'hh24:mi:ss'));

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

1236: select distinct a.record_osr, a.record_os
1237: from hz_imp_dup_details a
1238: where a.batch_id = p_batch_id
1239: and a.party_osr between from_osr and to_osr and a.entity ='PARTY_SITES';
1240: HZ_DQM_DUP_ID_PKG.update_detail_dqm_action_flag('PARTY_SITES',p_batch_id, x_ent_cur);
1241: -------------PARTY_SITES LEVEL DUPLICATE IDENTIFICATION ENDS ------------------------
1242: FND_FILE.put_line(FND_FILE.log,'Ending insert of PARTY_SITES');
1243: FND_FILE.put_line(FND_FILE.log,'Number of records inserted '||SQL%ROWCOUNT);
1244: FND_FILE.put_line(FND_FILE.log,'End time to insert '||to_char(sysdate,'hh24:mi:ss'));

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

1283: select distinct a.record_osr, a.record_os
1284: from hz_imp_dup_details a
1285: where a.batch_id = p_batch_id
1286: and a.party_osr between from_osr and to_osr and a.entity ='CONTACTS';
1287: HZ_DQM_DUP_ID_PKG.update_detail_dqm_action_flag('CONTACTS',p_batch_id, x_ent_cur);
1288: -------------CONTACTS LEVEL DUPLICATE IDENTIFICATION ENDS ------------------------
1289: FND_FILE.put_line(FND_FILE.log,'Ending insert of CONTACTS');
1290: FND_FILE.put_line(FND_FILE.log,'Number of records inserted '||SQL%ROWCOUNT);
1291: FND_FILE.put_line(FND_FILE.log,'End time to insert '||to_char(sysdate,'hh24:mi:ss'));

Line 1314: x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;

1310: ---------------------------------------------------------------
1311: PROCEDURE interface_join_entities(p_batch_id in number,
1312: from_osr in varchar2, to_osr in varchar2, p_threshold in number)
1313: IS
1314: x_ent_cur HZ_DQM_DUP_ID_PKG.EntityCur;
1315: x_insert_threshold number := 20;
1316: BEGIN
1317: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1318: FND_FILE.put_line(FND_FILE.log,'WU: '||from_osr||' to '||to_osr);

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

1456: (
1457: ((s1.TX11 is null and s2.TX11 is null) or s2.TX11 = s1.TX11)
1458: )
1459: ) group by f,t ;
1460: HZ_DQM_DUP_ID_PKG.update_hz_int_dup_results(p_batch_id,x_ent_cur);
1461: close x_ent_cur;
1462: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
1463: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
1464: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of PARTY_SITES');

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

1492: (s1.TX23 is not null and s2.TX23 like s1.TX23 || decode(sign(lengthb(s1.TX23)-3),1,'%',''))
1493: )
1494: )
1495: ) group by f,t ;
1496: HZ_DQM_DUP_ID_PKG.update_hz_int_dup_results(p_batch_id,x_ent_cur);
1497: close x_ent_cur;
1498: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
1499: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
1500: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACTS');