APPS.HZ_MATCH_RULE_52 dependencies on HZ_DUP_SET_PARTIES

Line 2209: SELECT 1 INTO l_tmp FROM HZ_DUP_SET_PARTIES

2205: VALUES (l_search_ctx_id,H_SCORES(l_party_id).PARTY_ID,H_SCORES(l_party_id).TOTAL_SCORE);
2206: x_num_matches := x_num_matches+1;
2207: ELSE
2208: BEGIN
2209: SELECT 1 INTO l_tmp FROM HZ_DUP_SET_PARTIES
2210: WHERE DUP_PARTY_ID = H_SCORES(l_party_id).PARTY_ID
2211: AND DUP_SET_BATCH_ID = p_dup_batch_id
2212: AND ROWNUM=1;
2213: EXCEPTION

Line 2220: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,

2216: l_merge_flag := 'Y';
2217: ELSE
2218: l_merge_flag := 'N';
2219: END IF;
2220: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
2221: MERGE_BATCH_ID,SCORE,MERGE_FLAG, CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
2222: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
2223: VALUES (H_SCORES(l_party_id).PARTY_ID,p_dup_set_id,0,0,
2224: H_SCORES(l_party_id).TOTAL_SCORE, l_merge_flag,

Line 3066: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,

3062: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,
3063: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,
3064: hz_utility_pub.user_id);
3065:
3066: INSERT INTO HZ_DUP_SET_PARTIES (DUP_PARTY_ID,DUP_SET_ID,MERGE_SEQ_ID,
3067: MERGE_BATCH_ID,merge_flag,SCORE,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,
3068: LAST_UPDATE_DATE,LAST_UPDATED_BY,DUP_SET_BATCH_ID)
3069: VALUES (p_party_id,x_dup_set_id,0,0,
3070: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,