[Home] [Help]
1128: -------------CONTACT_POINTS LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1129: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1130: FND_FILE.put_line(FND_FILE.log,'Beginning insert of CONTACT_POINTS');
1131: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));
1132: 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
1133: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
1134: select /*+ USE_CONCAT */ s1.party_id f,
1135: decode(instrb(s2.TX5,s1.TX5),1,60,
1136: 0
1174:
1175: --------UPDATE DQM ACTION FLAG IN CONTACT_POINTS INTERFACE/STAGING TABLES --------------
1176: open x_ent_cur for
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 ------------------------
1189: -------------PARTY_SITES LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1190: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1191: FND_FILE.put_line(FND_FILE.log,'Beginning insert of PARTY_SITES');
1192: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));
1193: 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
1194: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
1195: select /*+ USE_CONCAT */ s1.party_id f,
1196: decode(instrb(s2.TX26,s1.TX26),1,100,
1197: 0
1233:
1234: --------UPDATE DQM ACTION FLAG IN PARTY_SITES INTERFACE/STAGING TABLES --------------
1235: open x_ent_cur for
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 ------------------------
1248: -------------CONTACTS LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1249: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1250: FND_FILE.put_line(FND_FILE.log,'Beginning insert of CONTACTS');
1251: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));
1252: 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
1253: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
1254: select /*+ USE_CONCAT */ s1.party_id f,
1255: decode(instrb(s2.TX2,s1.TX2),1,20,
1256: decode(instrb(s2.TX23,s1.TX23),1,18,
1280:
1281: --------UPDATE DQM ACTION FLAG IN CONTACTS INTERFACE/STAGING TABLES --------------
1282: open x_ent_cur for
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 ------------------------