3184: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3185: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3186: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3187: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3188: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3189: hz_utility_pub.last_update_login,
3190: hz_utility_pub.last_update_date,
3191: hz_utility_pub.user_id,p_dup_batch_id);
3192: x_num_matches := x_num_matches+1;
3185: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3186: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3187: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3188: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3189: hz_utility_pub.last_update_login,
3190: hz_utility_pub.last_update_date,
3191: hz_utility_pub.user_id,p_dup_batch_id);
3192: x_num_matches := x_num_matches+1;
3193: END;
3186: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3187: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3188: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3189: hz_utility_pub.last_update_login,
3190: hz_utility_pub.last_update_date,
3191: hz_utility_pub.user_id,p_dup_batch_id);
3192: x_num_matches := x_num_matches+1;
3193: END;
3194: END IF;
3187: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3188: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3189: hz_utility_pub.last_update_login,
3190: hz_utility_pub.last_update_date,
3191: hz_utility_pub.user_id,p_dup_batch_id);
3192: x_num_matches := x_num_matches+1;
3193: END;
3194: END IF;
3195: END IF;
3974: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3975: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3976: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3977: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3978: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3979: hz_utility_pub.last_update_login,
3980: hz_utility_pub.last_update_date,
3981: hz_utility_pub.user_id,p_dup_batch_id);
3982: x_num_matches := x_num_matches+1;
3975: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3976: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3977: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3978: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3979: hz_utility_pub.last_update_login,
3980: hz_utility_pub.last_update_date,
3981: hz_utility_pub.user_id,p_dup_batch_id);
3982: x_num_matches := x_num_matches+1;
3983: END;
3976: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3977: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3978: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3979: hz_utility_pub.last_update_login,
3980: hz_utility_pub.last_update_date,
3981: hz_utility_pub.user_id,p_dup_batch_id);
3982: x_num_matches := x_num_matches+1;
3983: END;
3984: END IF;
3977: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3978: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3979: hz_utility_pub.last_update_login,
3980: hz_utility_pub.last_update_date,
3981: hz_utility_pub.user_id,p_dup_batch_id);
3982: x_num_matches := x_num_matches+1;
3983: END;
3984: END IF;
3985: END IF;
4162: INSERT INTO HZ_DUP_SETS ( DUP_SET_ID, DUP_BATCH_ID, WINNER_PARTY_ID,
4163: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
4164: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4165: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4166: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4167: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4168: hz_utility_pub.user_id);
4169:
4170: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4163: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
4164: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4165: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4166: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4167: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4168: hz_utility_pub.user_id);
4169:
4170: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4171: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4164: LAST_UPDATE_DATE, LAST_UPDATED_BY)
4165: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
4166: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
4167: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
4168: hz_utility_pub.user_id);
4169:
4170: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4171: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4172: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4170: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
4171: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4172: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4173: VALUES (p_party_id,x_dup_set_id,0,0,
4174: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4175: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4176: hz_utility_pub.user_id,p_dup_batch_id);
4177: ELSE
4178: x_dup_set_id := NULL;
4171: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
4172: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4173: VALUES (p_party_id,x_dup_set_id,0,0,
4174: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4175: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4176: hz_utility_pub.user_id,p_dup_batch_id);
4177: ELSE
4178: x_dup_set_id := NULL;
4179: END IF;
4172: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
4173: VALUES (p_party_id,x_dup_set_id,0,0,
4174: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
4175: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
4176: hz_utility_pub.user_id,p_dup_batch_id);
4177: ELSE
4178: x_dup_set_id := NULL;
4179: END IF;
4180: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN