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