DBA Data[Home] [Help]

APPS.HZ_MATCH_RULE_2 dependencies on HZ_UTILITY_PUB

Line 2881: hz_utility_pub.created_by,hz_utility_pub.creation_date,

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;

Line 2882: hz_utility_pub.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;
2886: END;

Line 2883: hz_utility_pub.last_update_date,

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;

Line 2884: hz_utility_pub.user_id,p_dup_batch_id);

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;

Line 3665: hz_utility_pub.created_by,hz_utility_pub.creation_date,

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;

Line 3666: hz_utility_pub.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;
3670: END;

Line 3667: hz_utility_pub.last_update_date,

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;

Line 3668: hz_utility_pub.user_id,p_dup_batch_id);

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;

Line 3853: 'PARTY_MERGE', hz_utility_pub.created_by, hz_utility_pub.creation_date,

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,

Line 3854: hz_utility_pub.last_update_login, hz_utility_pub.last_update_date,

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,

Line 3855: hz_utility_pub.user_id);

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)

Line 3861: 'Y',100,hz_utility_pub.created_by,hz_utility_pub.creation_date,

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;

Line 3862: hz_utility_pub.last_update_login,hz_utility_pub.last_update_date,

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;

Line 3863: hz_utility_pub.user_id,p_dup_batch_id);

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