[Home] [Help]
858: -------------CONTACT_POINTS LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
859: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
860: FND_FILE.put_line(FND_FILE.log,'Beginning insert of CONTACT_POINTS');
861: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));
862: insert into hz_imp_dup_details(party_id, score, party_osr, party_os, batch_id, entity, record_id, record_osr, record_os, dup_record_id
863: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
864: select /*+ USE_CONCAT */ s1.party_id f,
865: decode(instrb(s2.TX5,s1.TX5),1,60,
866: 0
895:
896: --------UPDATE DQM ACTION FLAG IN CONTACT_POINTS INTERFACE/STAGING TABLES --------------
897: open x_ent_cur for
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 ------------------------
910: -------------PARTY_SITES LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
911: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
912: FND_FILE.put_line(FND_FILE.log,'Beginning insert of PARTY_SITES');
913: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));
914: insert into hz_imp_dup_details(party_id, score, party_osr, party_os, batch_id, entity, record_id, record_osr, record_os, dup_record_id
915: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
916: select /*+ USE_CONCAT */ s1.party_id f,
917: decode(instrb(s2.TX26,s1.TX26),1,100,
918: 0
954:
955: --------UPDATE DQM ACTION FLAG IN PARTY_SITES INTERFACE/STAGING TABLES --------------
956: open x_ent_cur for
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 ------------------------