[Home] [Help]
1109: -------------PARTY_SITES LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1110: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1111: FND_FILE.put_line(FND_FILE.log,'Beginning insert of PARTY_SITES');
1112: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));
1113: 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
1114: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
1115: select /*+ USE_CONCAT */ s1.party_id f,
1116: decode(instrb(s2.TX26,s1.TX26),1,100,
1117: 0
1153:
1154: --------UPDATE DQM ACTION FLAG IN PARTY_SITES INTERFACE/STAGING TABLES --------------
1155: open x_ent_cur for
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 ------------------------
1168: -------------CONTACT_POINTS LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1169: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1170: FND_FILE.put_line(FND_FILE.log,'Beginning insert of CONTACT_POINTS');
1171: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));
1172: 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
1173: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
1174: select /*+ USE_CONCAT */ s1.party_id f,
1175: decode(instrb(s2.TX7,s1.TX7),1,20,
1176: 0
1205:
1206: --------UPDATE DQM ACTION FLAG IN CONTACT_POINTS INTERFACE/STAGING TABLES --------------
1207: open x_ent_cur for
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 ------------------------
1220: -------------CONTACTS LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1221: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1222: FND_FILE.put_line(FND_FILE.log,'Beginning insert of CONTACTS');
1223: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));
1224: 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
1225: ,created_by,creation_date,last_update_login,last_update_date,last_updated_by)
1226: select /*+ USE_CONCAT */ s1.party_id f,
1227: decode(instrb(s2.TX2,s1.TX2),1,20,
1228: decode(instrb(s2.TX23,s1.TX23),1,18,
1252:
1253: --------UPDATE DQM ACTION FLAG IN CONTACTS INTERFACE/STAGING TABLES --------------
1254: open x_ent_cur for
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 ------------------------