2880: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
2881: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
2882: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
2883: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
2884: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2885: hz_utility_pub.last_update_login,
2886: hz_utility_pub.last_update_date,
2887: hz_utility_pub.user_id,p_dup_batch_id);
2888: x_num_matches := x_num_matches+1;
2881: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
2882: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
2883: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
2884: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2885: hz_utility_pub.last_update_login,
2886: hz_utility_pub.last_update_date,
2887: hz_utility_pub.user_id,p_dup_batch_id);
2888: x_num_matches := x_num_matches+1;
2889: END;
2882: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
2883: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
2884: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2885: hz_utility_pub.last_update_login,
2886: hz_utility_pub.last_update_date,
2887: hz_utility_pub.user_id,p_dup_batch_id);
2888: x_num_matches := x_num_matches+1;
2889: END;
2890: END IF;
2883: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
2884: hz_utility_pub.created_by,hz_utility_pub.creation_date,
2885: hz_utility_pub.last_update_login,
2886: hz_utility_pub.last_update_date,
2887: hz_utility_pub.user_id,p_dup_batch_id);
2888: x_num_matches := x_num_matches+1;
2889: END;
2890: END IF;
2891: END IF;
3665: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3666: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3667: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3668: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3669: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3670: hz_utility_pub.last_update_login,
3671: hz_utility_pub.last_update_date,
3672: hz_utility_pub.user_id,p_dup_batch_id);
3673: x_num_matches := x_num_matches+1;
3666: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3667: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3668: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3669: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3670: hz_utility_pub.last_update_login,
3671: hz_utility_pub.last_update_date,
3672: hz_utility_pub.user_id,p_dup_batch_id);
3673: x_num_matches := x_num_matches+1;
3674: END;
3667: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
3668: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3669: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3670: hz_utility_pub.last_update_login,
3671: hz_utility_pub.last_update_date,
3672: hz_utility_pub.user_id,p_dup_batch_id);
3673: x_num_matches := x_num_matches+1;
3674: END;
3675: END IF;
3668: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,
3669: hz_utility_pub.created_by,hz_utility_pub.creation_date,
3670: hz_utility_pub.last_update_login,
3671: hz_utility_pub.last_update_date,
3672: hz_utility_pub.user_id,p_dup_batch_id);
3673: x_num_matches := x_num_matches+1;
3674: END;
3675: END IF;
3676: END IF;
3853: INSERT INTO HZ_DUP_SETS ( DUP_SET_ID, DUP_BATCH_ID, WINNER_PARTY_ID,
3854: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
3855: LAST_UPDATE_DATE, LAST_UPDATED_BY)
3856: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
3857: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
3858: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
3859: hz_utility_pub.user_id);
3860:
3861: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
3854: STATUS, MERGE_TYPE, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN,
3855: LAST_UPDATE_DATE, LAST_UPDATED_BY)
3856: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
3857: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
3858: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
3859: hz_utility_pub.user_id);
3860:
3861: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
3862: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3855: LAST_UPDATE_DATE, LAST_UPDATED_BY)
3856: VALUES (x_dup_set_id, p_dup_batch_id, p_party_id, 'SYSBATCH',
3857: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
3858: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
3859: hz_utility_pub.user_id);
3860:
3861: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
3862: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3863: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3861: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
3862: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3863: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3864: VALUES (p_party_id,x_dup_set_id,0,0,
3865: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
3866: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
3867: hz_utility_pub.user_id,p_dup_batch_id);
3868: ELSE
3869: x_dup_set_id := NULL;
3862: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3863: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3864: VALUES (p_party_id,x_dup_set_id,0,0,
3865: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
3866: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
3867: hz_utility_pub.user_id,p_dup_batch_id);
3868: ELSE
3869: x_dup_set_id := NULL;
3870: END IF;
3863: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3864: VALUES (p_party_id,x_dup_set_id,0,0,
3865: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,
3866: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,
3867: hz_utility_pub.user_id,p_dup_batch_id);
3868: ELSE
3869: x_dup_set_id := NULL;
3870: END IF;
3871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN